IG Historical Price Data Download on Mac Using API

[Guest RichB-Trader]

Hello,

 

I am trying to use API to download historical data from IG. I have seen a video on how to use Microsoft Excel to do this on a Windows machine. However I am running a Mac, and really don't want to install Windows as it will cost a lot of money and be in efficient switching between OS. I have even tried running Excel for Mac however because it is a .msi file my Mac will not open it.

 

Has anybody had any joy downloading historical data from IG using a Mac? 

 

Any hep would be greatly appreciated.

[Guest RichB-Trader]

Hello,

 

Just wondering if anybody can help?

[Caseynotes]

Hi @RichB-Trader did you try to convert the .msi file to a mac friendly one?

[Guest RichB-Trader]

Hello,

I have had a look into this, seems I need a Windows machine to do the conversion ☹️

[Caseynotes]

Hi @RichB-Trader,  take a look at this file extractor for mac, in the extended list of supported archive formats it lists msi.

https://theunarchiver.com/

 

[Guest RichB-Trader]

Hi,

 

Thanks, just tried doing that but you need a windows machine to do it (typical). Going to try Python, see if I can get anywhere with that. Thanks for all your help. 

[Caseynotes]

That is a let down, I thought the whole programme was written specifically for Mac.

[Guest RichB-Trader]

Hello,

 

Just posting on the community a follow up to help other people. Having spent, far too much, time on this, I can confirm IG do not let you get their data for equities through any API. This is because they do not own the data, Reuters do. You can get the IG data for currencies however. FYI Reuters basic HLOC, Volume etc. data is around £350 per month having spoken to them if it helps. 

 

However in Apple Numbers you can use a formal to search a stock price which is pretty accurate. Doesn't include pre and post market (which I will be asking a question about in another post). Thanks.