Here is a video tutorial which explains how to make use of your Amibroker backtesting report by building simple metrics and visualize your trading strategy with MS Excel Pivot tables. Some of the metrics built in this video include total profitable months, total losing months, Max Profitable Month, Max Profitable Loss and the visualization of the month on month profitability using condition-based coloring and pivot table charts for a better understanding of risk-reward ratio involved in your trading strategy.
Here is a initiative from me to automate the NSE EOD data in ASCII format using simple VBA Scipts in MS Excel. The following MS Excel VBA macro copies the Getbhavcopy zip file corresponding to 02Nov2010 from NSE India portal into your local drive(c:\eoddata) and then extracts the Zip file and shows you the content in the csv file.
Excel Web Query – What in the world is that? If you are like the other 99.9% of MS Excel users, you probably have never heard of microsoft excel web queries Excel web queries are powerful! Web queries strips web pages of useless stuff and gives you access to the essential information. You can then […]