Can I Download Chart Data Into Excel?

• 08/18/2019 at 4:35 PM #104999
  Tom Griffiths

  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

  

  Tom Griffiths

  Participant

  Topics: 1

  Replies: 0

  Been thanked: 0 times
  08/19/2019 at 7:59 AM #105046
  pableitor

  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

   

  

  pableitor

  Participant

  Topics: 20

  Replies: 127

  Been thanked: 47 times
  08/19/2019 at 9:42 AM #105056
  GraHal

  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/

  

  GraHal

  Participant

  Topics: 211

  Replies: 8760

  Been thanked: 2176 times
  08/21/2019 at 2:41 PM #105202
  Nicolas

  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

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
• Author
  Posts