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.

changelog for stockbacktest.xls

Added a box to always display the last opened position and price into a static cell. This allows the use of formula based trailing stops based on the entry price.

changelog for stockbacktest.xls

Added choice to use either percent of account balance (compounding), or set number of shares

Fixed issue where position was closed and reopened on the same day, which made it appear as if a position was opened without a prior postition being closed.

changelog for stockbacktest.xls

The changes apply to Stock Backtest and data downloader.

* each time data was downloaded a new embedded connection was created. These were building up and resulted in security warning messages (in Excel 2007).  All new connections are now removed immmediatly after data is downloaded.

*changed name from Stocksim.xls to Stockbacktest.xls since it’s not a simulator at all. It is just for backtesting.