Exporting backtesting data to excel

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • 01/19/2017 at 1:32 PM #21675 quote
    sammi
    Participant
    New

    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

    buffster76 thanked this post
    01/19/2017 at 2:38 PM #21681 quote
    jonjon
    Participant
    Average

    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

    SergioMalaga, MaoRai54 and buffster76 thanked this post
    01/19/2017 at 3:21 PM #21698 quote
    sammi
    Participant
    New

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

    01/19/2017 at 4:19 PM #21704 quote
    jonjon
    Participant
    Average

    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.

    01/19/2017 at 4:45 PM #21709 quote
    sammi
    Participant
    New

    ah ok. Great. Thanks

    01/19/2017 at 8:12 PM #21749 quote
    Big Hug
    Participant
    Average

    Jonjon – Thank you for your tip. Well spotted.

    01/21/2017 at 9:55 AM #21941 quote
    sammi
    Participant
    New

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

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.

Exporting backtesting data to excel


ProOrder: Automated Strategies & Backtesting

New Reply
Author
author-avatar
sammi @sami_yusuf Participant
Summary

This topic contains 6 replies,
has 3 voices, and was last updated by sammi
9 years, 1 month ago.

Topic Details
Forum: ProOrder: Automated Strategies & Backtesting
Language: English
Started: 01/19/2017
Status: Active
Attachments: No files
Logo Logo
Loading...
Do you like cookies? 🍪 We use cookies to ensure you get the best experience on our website. (Learn more)
©2026 ProRealCode - Trading & Coding with ProRealTime™