Back testing results to excel

• 06/13/2018 at 2:08 AM #73048
  ChrisNYE

  How do I transfer my results in the back test order list and closed positions list into excel?

  

  ChrisNYE

  Participant

  Topics: 27

  Replies: 125

  Been thanked: 4 times
  06/13/2018 at 7:27 AM #73051
  Vonasi

  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.

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  06/13/2018 at 8:00 AM #73055
  Dymjohn

  Have not found a 100 line limit on testing but one useful trick is to

  1. Drag the test into Word.
  2. Find and replace “currency”signs with a blank
  3. Drag resulting file into Excel.
  4. This procedure will get over the problem of numbers being in text format thus enabling analysis within Excel.

  2 users thanked author for this post.

  AlgoAlex, GraHal

  

  Dymjohn

  Participant

  Topics: 16

  Replies: 43

  Been thanked: 4 times
  06/13/2018 at 8:06 AM #73059
  Vonasi

  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.

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  06/13/2018 at 11:20 AM #73073
  ChrisNYE

  When you say 5 or so back tests you mean to say if over 5 years back test each year individually?

  

  ChrisNYE

  Participant

  Topics: 27

  Replies: 125

  Been thanked: 4 times
  06/13/2018 at 11:24 AM #73076
  Vonasi

  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.

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  06/13/2018 at 11:31 AM #73078
  ChrisNYE

  Ah yes i get it now

  

  ChrisNYE

  Participant

  Topics: 27

  Replies: 125

  Been thanked: 4 times
  06/15/2018 at 7:32 AM #73260
  ChrisNYE

  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.

  

  ChrisNYE

  Participant

  Topics: 27

  Replies: 125

  Been thanked: 4 times
  06/15/2018 at 8:21 AM #73270
  jebus89

  ChrisNYE wrote:

  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

  

  jebus89

  Participant

  Topics: 118

  Replies: 586

  Been thanked: 238 times
  06/15/2018 at 8:57 AM #73282
  Vonasi

  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.

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  06/15/2018 at 9:14 AM #73292
  ChrisNYE

  Ok thank you will try

  

  ChrisNYE

  Participant

  Topics: 27

  Replies: 125

  Been thanked: 4 times
• Author
  Posts