Web Trading API Excel Sample

[Highriskcap]

When I use the sample excel API, it fails to pull in bid / offer / high / low / change / change % data.  Cells just read ‘subscribed’.  Which is odd since the API online companion has no problem pulling the same data.  Anyone had similar issues or know how to fix?  

Much appreciated.  

 

[ArvinIG]

9 hours ago, Highriskcap said:

When I use the sample excel API, it fails to pull in bid / offer / high / low / change / change % data.  Cells just read ‘subscribed’.  Which is odd since the API online companion has no problem pulling the same data.  Anyone had similar issues or know how to fix?  

Much appreciated.  

 

Hi @Highriskcap,

For assistance on APis you can reach out to webapisupport@ig.com, they will be able to assist you.

All the best - Arvin

[andysinclair]

Just to let you know, I have built an Excel Add-in which provides easy to use formulas for accessing IG data, as well as other financial data providers.

I fully support it and regularly add new features so there is a small monthly charge to use it.

You can try it free for 10 days at: https://www.excelpricefeed.com/

Let me know if you have any questions. I hope you find it useful!

[zetolo]

I have the same problem and I suspect this happens as soon your positions increase in consistent number:

 

The excel is able to connect in bottom left corned showing the balance and account data with message "connected".

The file crash as soon I click on position button.

Anybody has resolved this somehow?