Enhancements to options back testing xls

Hi Athol,

I hope all is well.

I wanted to see if you could add an additional enhancement to the options backtesting spreadsheet that you built for me on vworker. When importing data from the RollingPuts! and clicking the "Load backtest range values" button, I get a "Number of data rows exceeds 1048576 and cannot be displayed" error message when importing data from 2005 - 2011. I normally ran back tests on one year time frames and wouldn't get this error.

Do you think you could figure out a work around for this error? It would be very helpful if I could do the entire back testing in one file to use the code that you most recently added that puts the trades on the portfolio level (portfolio!).

Could the import run on more than one tab to get around this error?



Evner: Excel

Se mere: excel frames, backtest portfolio, options, button to load data from, BackTest, excel portfolio, load excel, spreadsheet enhancements, portfolio spreadsheet excel, excel enhancements, portfolio backtesting excel, year portfolio spreadsheet, xls tab, enhancements excel, xls code, backtesting portfolio excel, portfolio backtesting spreadsheet, excel backtesting, excel backtest, options portfolio spreadsheet, frames excel, portfolio backtesting, excel testing, excel backtesting spreadsheet, excel portfolio backtesting

Om arbejdsgiveren:
( 20 bedømmelser ) Ridge, United States

Projekt ID: #4045045

Tildelt til:


Tim, extra info in a PMB regarding the Excel worksheet extension. Cheers Athol

$30 USD in 7 dage
(38 bedømmelser)