Can I Download Chart Data Into Excel?

Forums ProRealTime English forum ProRealTime platform support Can I Download Chart Data Into Excel?

This topic contains 3 replies, has 4 voices, and was last updated by avatar Nicolas 9 months, 3 weeks ago.

Currently, there are 0 users and 1 guest visiting this topic.
View all attachments
Viewing 4 posts - 1 through 4 (of 4 total)
  • #104999

    Hi,

    I find it easier to data mine in Excel. Is it possible to download the historical bar chart data into Excel? Lots of platforms allow you to export a chart as a .csv file and when you open it you get the open, high, low, close for each bar?

    I know with the DDE link you can download live price feeds but i’m looking for historical OHLC of each bar.

    I have attached an image in case you are unsure what it would look like.

    In theory it would be very easy for ProRealTime to do as all the data is there just needs an export to excel function. Hopefully they do.

    Thanks

    Tom

    BEST ANSWER
    #105046

    Hi,

    there’s no way to directly export market data from PRT to Excel or CSV but  its possible to download historical prices from IG Markets datafeed. It uses a free Excel spreadsheet from IG markets website.

    https://youtu.be/NtGV7VYb9cQ

    https://labs.ig.com/sample-apps

     

    This post has received 1 vote up.
    #105046 Score: 1

    Hi,

    there’s no way to directly export market data from PRT to Excel or CSV but  its possible to download historical prices from IG Markets datafeed. It uses a free Excel spreadsheet from IG markets website.

    https://youtu.be/NtGV7VYb9cQ

    https://labs.ig.com/sample-apps

     

    This post has received 1 vote up.
    #105056 Score: 1

    Is below you Tom?

    If No then maybe it may be useful for you … if the WYTrade gets an answer that is!?

    https://community.ig.com/forums/topic/7327-ig-excel-sample-modified-to-download-data-by-historical-range/

    This post has received 1 vote up.
    #105202 Score: 0

    or you can give a try with this workaround with OCR and a custom code in PRT: https://www.prorealcode.com/topic/how-to-extract-every-candles-data/#post-96205

Viewing 4 posts - 1 through 4 (of 4 total)

Create your free account now and post your request to benefit from the help of the community
Register or Login