Open Source Visual Basic .NET Spreadsheet Software

Useful Excel sheet for Stock Option Traders. This Excel sheet can fetch the Live NSE Option Chain Data for Stocks. Fetch the live Stock Option Chain data such as Open Interest and Price at differentStrike prices, specifically few Strike Price ranges near to ATM in Excel sheet. It can be used to compare and analyze Open Interest and Price Changes at different Strike Prices. This Excel sheet collects the following data at a given Strike Price, for both Calls (CE) and Puts (PE) and at different Expiry Dates. > Open Interest (OI) > Change in Open Interest (in %), > Last Traded Price for NSE Stock option (in INR) > Change in Last Traded Price (%) It narrows down and fetches few selective Strike Price ranges only at Out of Money (OTM) near to ATM (At the Money) and not fetches from deep far Out of Money Strike Price data. So, it gives a simplified view on OI and Price changes. Homepage : https://www.enote.page/2022/08/stock-option-chain.html

A set of User Defined Functions for Excel to create in-cell charts : Sparklines. Sparklines are the simple, intense, word-sized graphics invented by Edward Tufte. Coded in Visual Basic for Applications.

Fetch the last traded price (LTP) as well as Price Change (%) for NIFTY 50 and Bank NIFTY stocks in Excel sheet. With this, the fetched data can be analyzed to predict the price movements of both NIFTY 50 as well Bank NIFTY in Excel. ERRORS These works are in beta stage, so there are many unexpected errors. Due to the lag to fetch the data from the NSE server, Run-Time Error can occurs. Close the Excel. Open after some time and Refresh. DISCLAIMER These Excel files are designed for purely educational purposes not for commercial purposes. Either Dr. M Kanagasabapathy (Owner) or the website (www.enote.page) is not responsible for any losses incurred based on this data. Designed by, Dr. M Kanagasabapathy, Associate Professor Coordinator, Incubation Centre Rajapalayam Rajus' College, Rajapalayam (TN) India 626117 For more details, please visit to the project Homepage: https://www.enote.page/2024/08/NIFTY-Bank-NIFTY-Live-Price-in-Excel-Sheet.html

DOCX, XLSX and PPTX files are collections of conventionally zipped mostly XML sub-files. This program first attempts repair any zip based corruption. From there it engages in four different algorithmic attempts at repair or recovery. With the first method using validation, the location of the first XML error is sought. At that point the sub-files are truncated and repaired. The second method works the same way except the XML validation is more lax. With the third, the strict XML validation is returned to and corrupt XML sub-files are truncated and repaired as before however, missing XML sub-files are brought in from blank full healthy docx, xlsx or pptx of the respective correct extension. The fourth method uses SilverCoder's DocToText to salvage text or data after which the file is opened as an old style MS Office 97 - 2003 format file including the naked recovered text or data. See my other projects here on Sourceforge for other ways to recover corrupt MS and Open Office files.

Microsoft recommends several methods for recovering Excel data from corrupt spreadsheets. S2 Recovery Tools for Microsoft Excel makes it easy to follow these recommended routines by just pressing buttons. The application also adds five methods of its own for recovery. Additionally it has its own native previous file version recovery tool which works in any version of Vista, Windows 7 and Windows 8. Another feature of the program is a preloaded search interface for finding temporary, deleted and lost versions of your corrupt file. For completeness sake the program has shortcuts to 2 major commercial solution providers for corrupt Excel files including providing the coupon "S2SERVICES" for using Recoveronix' online corrupt file recovery service for free until Nov 1, 2014, a $39 value. This program was formerly known as Excel Recovery and more recently, S2 Services Excel Recovery.

Enables you to add formula support to your application. Provides functionality for parsing/evaluating formulas, tracking their dependencies, and recalculating in natural order. The formula syntax and many other features are direct replicas of Excel.

The project is used to design Excel and HTML report. The new idea it brings to us is that we can develop reports with VBA macros, just as the importance of css to html. And we and change the report without compile the projects...

Update: It is probably wise to try to do a zip repair step on corrupt xlsx files as a first step before trying to invoke other methods. Microsoft recommends several methods for recovering from Excel corruption. This Excel add-in brings into one toolbar these methods while adding four data recovery methods of its own. For MS methods for recovering from Excel file corruption, see: http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx or here: http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx. Requires at least Excel 2003 and Windows XP.

This project adds a ribbon to excel with a number of statistical buttons. This is not intended to be a full statistical analysis package (like R), but only a source for quick visualizations and calculations. For Excel2007 and up

Very lightweight and minimalist spreadsheet application. Through a notepad-style interface, you create informal spreadsheets with formulas as powerful as any full-sized spreadsheet program. It can also serve as a calculator with revisable history.