I somehow managed to buy two computers without Excel, so I'm stuck with Microsoft Spreadsheet. To make matters worse, Stockwatch Pro, which is what I use for backtesting, is severly lacking on system statistics (max dd., sharpe ratio, etc.) So....Does anyone know how to plug in formulas in MSFT spreadsheet for max dd. and other backtesting stats? Thanks for the help.
Here's a shortcut to your problem and possibly a long term solution as well: 1. Buy Excel (MSOFFICE) 2. Alternatively, get Kazaa. Search--> "Office 2000" or "Office XP." Wait about an hour or so. Done!
if you are writing your macros anyway, why not take a look at http://www.openoffice.org/ it certainly reads/writes excel files all right