How do I transfer my results in the back test order list and closed positions list into excel?
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.
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.
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.
When you say 5 or so back tests you mean to say if over 5 years back test each year individually?
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.
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.
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 least
Hover over the results window contents and then click and hold the left mouse button and keep holding and drag it into Excel and then release the left mouse button.
