Jump to content
  • 0

Web Trading API Excel Sample


Highriskcap

Question

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.  

 

  • Like 1
Link to comment

3 answers to this question

Recommended Posts

  • 0
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

Link to comment
  • 0

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!

Link to comment
  • 0

I have the same problem and I suspect this happens as soon your positions increase in consistent number:
image.png.729147b7b4e3aa9bd1fb4ba3d5c95bfc.png

 

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?

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...
us