Exporting backtesting data to excel

• 01/19/2017 at 1:32 PM #21675
  sammi

  Hi guys

  Have a beginners question here.. I am wondering if I can export backtesting data into an excel sheet in the following format:

  Stock – Date of entry – Entry Price – Date of Exit – Exit Price

  (each trade on a separate line on excel)

  I’ve seen there is the DDE plug-in, but wasn’t sure it could do this.

  Thanks

  1 user thanked author for this post.

  buffster76

  

  sammi

  Participant

  Topics: 2

  Replies: 6

  Been thanked: 1 time
  01/19/2017 at 2:38 PM #21681
  jonjon

  Hi Sammi

  Whilst waiting for someone more experienced to reply to you, do you know that when you run the backtest and get the Detailed Report, you can export the “Orders List” and “Closed Positions List” tabs into excel simply by highlighting a row by left clicking and then dragging it into an excel sheet. It’s not exactly the format you requested but you could easily manipulate it to get what you wanted.

   

  Hope this helps

  3 users thanked author for this post.

  buffster76, MaoRai54, SergioMalaga

  

  jonjon

  Participant

  Topics: 5

  Replies: 64

  Been thanked: 4 times
  01/19/2017 at 3:21 PM #21698
  sammi

  ok, thanks. But would I have to do this 1 seperate row at a time?

  

  sammi

  Participant

  Topics: 2

  Replies: 6

  Been thanked: 1 time
  01/19/2017 at 4:19 PM #21704
  jonjon

  If I understand your question correctly, the answer is no. When you highlight just one row and drag it over, it will export all of the trades into excel.

  

  jonjon

  Participant

  Topics: 5

  Replies: 64

  Been thanked: 4 times
  01/19/2017 at 4:45 PM #21709
  sammi

  ah ok. Great. Thanks

  

  sammi

  Participant

  Topics: 2

  Replies: 6

  Been thanked: 1 time
  01/19/2017 at 8:12 PM #21749
  Big Hug

  Jonjon – Thank you for your tip. Well spotted.

  

  Big Hug

  Participant

  Topics: 6

  Replies: 48

  Been thanked: 10 times
  01/21/2017 at 9:55 AM #21941
  sammi

  Hey guys. Just to let you know I tried this and it worked perfectly. Exactly what I needed. Thanks again for the help

  

  sammi

  Participant

  Topics: 2

  Replies: 6

  Been thanked: 1 time
• Author
  Posts