Search Results for "dashboard visual basic"

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)...

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...

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,...

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...

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:...

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.

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.

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

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...