Back testing results to excel
06/13/2018 at 2:08 AM #7304806/13/2018 at 7:27 AM #73051
Just click, hold, drag and drop from one window to the other.
There is a 100 line limit in the backtest optimization window which means that getting more results than that can be a bit of a tiresome process.06/13/2018 at 8:00 AM #73055
Have not found a 100 line limit on testing but one useful trick is to
- Drag the test into Word.
- Find and replace “currency”signs with a blank
- Drag resulting file into Excel.
- This procedure will get over the problem of numbers being in text format thus enabling analysis within Excel.
1 user thanked author for this post.06/13/2018 at 8:06 AM #73059
The optimized results window will only show the top 100 results. So if you want to chart a variable in Excel from 1 to 500 then you have to do five backtests, 1 – 100, 2 – 200, 3 – 300 and so on to get all the results. This has been talked about a lot on here before – hopefully one day PRT will just let us have all the results.
I have never needed to use your PRT to Word to Excel idea but then I just drag across and create charts for analysis and it has always liked every number without a problem.06/13/2018 at 11:20 AM #7307306/13/2018 at 11:24 AM #73076
No I mean that if you have a variable x and you want to see results with values of x from 1 to 500 then PRT will do this and then only show you the top 100 results which might be 3,15,87,234,235 etc.
To see all 500 results you need to test 1 to 100 then 2 – 200 then 3 – 300 then 4 – 400 then 5 – 500 and drag and drop each result into excel in a column to analyse.06/13/2018 at 11:31 AM #7307806/15/2018 at 7:32 AM #7326006/15/2018 at 8:21 AM #73270
I cannot for the life of me get this to drag into word or excel. I cant even ctrl c and ctrl v the page in excel or word or try to highlight the whole thing. Nothing.
go to detailed report, go to the view of all the trades done in the backtest
click 1 trade
and ctrl C and paste it into excel. u should get all the trades. Works fine for me at least06/15/2018 at 8:57 AM #7328206/15/2018 at 9:14 AM #73292