In the previous version of Stockbacktest.xls, running the download and backtest in Excel 2000 resulted in an improperly scaled chart. This problem has now been fixed.
Excel Based Stock and Futures Trading tools.
Current S&P ES Chart
Excel Based Automated Channels. Updated every five minutes (9:05 EST to 4:15 EST). Click image for full size.
Like trading with excel, Interested in what you have made in Excel and are you interested in sharing your code
colin, there is a list of some of my recent excel based projects here. The files/code that I share is listed under free products. The code is not password protected.
ExcelTrader, the link for Stockbacktest.xls seems to point to StochasticVBA.xls for some reason.
Thanks Jake. I have updated the link stockbacktest.xls
Hello ExcelTrader,
I downloaded converter, run/press Convert but with no result.
It opens new workbook but it all blank.
What possible error could be?
Kazbek,
The source file should be opened in the same instance of excel. (first open data converter then open your data file from the file menu). Other possibilities would be misspelled workbook/worksheet names and/or incorrect data column settings.
Hello Exceltrader,
just to make it clear: I am allowed to use your code to implement it in other projects, right?
Thanks for your fabulous work on the backtest tool.
Florian, Thanks and I’m glad you have found the file useful. You are welcome to use the code for personal use.
Thanks