Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

7 Neutral

About andysinclair

  • Rank
    Occasional Contributor

Recent Profile Visitors

206 profile views
  1. andysinclair

    invalid security token

    Hi, This is due to the token being invalidated, your code needs to handle instances where the token is invalidated and request a new one. More details on the IG Labs FAQ: https://labs.ig.com/faq ("Do the CST and X-SECURITY-TOKEN tokens expire") Hope this helps. Andy
  2. andysinclair

    Bear Bull Historical Chart

    Very interesting way of showing SP500 returns over time. I'd like to read more, @Caseynotes do you have a link to the original document/presentation?
  3. andysinclair

    UK stocks don’t seem to add up.

    It might sound obvious but are you looking at the correct price, i.e. buy or sell price? If you are long then are you looking at the sell price (to close) versus the buy price (to open)? Can you post a screenshot (with account details etc hidden)?
  4. andysinclair

    Interbank FX Dealers

    Also interesting, from the article, that XTX Markets accounts for 18.9% of all global FX order flow considering it was founded only a few years ago (2015).
  5. andysinclair

    Positions exracting

    Hi, I've built an Excel Add-in which includes the ability to download positions. Once you have setup your account you just specify which fields you require and press the download button, position data will then appear in your spreadsheet as below: The Add-in is available at: https://www.excelpricefeed.com It can also stream live prices to an Excel cell as well as help you easily download historic price data into an Excel spreadsheet. Contact me either via the website or private message and I can send you an Activation Code for a free 20 day trial. Hope you find it useful. Andy
  6. andysinclair

    IG US Startup

    Ah, that explains why they are the "Gold Sponsor" at an upcoming trading conference in New York, they are trying to crack the US market...
  7. andysinclair

    Econ Calendar

    Hi @JamesIG I would really like to see IG provide an API for calendar data. It would really help those of us working on trading tools or automating/semi-automating strategies.
  8. andysinclair

    Lookup Prices in Excel

    Hi, The Add-in is now available and can be downloaded at: http://www.excelpricefeed.com/userguide/download Contact me either via my website or private message and I can send you an Activation Code for a free 20 day trial. The Add-in currently provides live and streaming prices to Excel cells via simple formulas such as: =EPF.IG.Stream.Bid("CS.D.GBPUSD.TODAY.IP") I am looking at adding historical data access as well as other functionality depending on user feedback. Hope you find it useful. Andy
  9. andysinclair

    Lookup Prices in Excel

    Hi Michael, I'll try to send you a personal message. Cheers, Andy
  10. andysinclair

    Lookup Prices in Excel

    Hi Michael, I'm working on an Excel Add-in (http://www.excelpricefeed.com/) which enables streaming and retrieval of live prices from IG Index (as well as other data providers such as Yahoo/IEX). If you are interested I could send you a trial version so you can see if it can be useful to you. It's a work in progress so it's not quite finished and I haven't worked out pricing etc yet. Let you know if you are interested. Cheers, Andy
  11. andysinclair

    Calculate RSI

    I'm afraid it's not possible to download indicator values using the API. Like you say you will need to calculate the RSI values yourself which is fairly straightforward in Excel. If you are seeing different values ensure you are using the same timeframe and "number of periods" parameter. Hope this helps. Andy
  12. Thanks @PandaFace I really do hope a new forum is created here for the API/Developers...there is so much potential with the API but I think some people probably get put off by the lack of activity there.
  13. andysinclair

    Python3 Automated Trading App

    I'm a techie and used to be fairly active on the IG Labs forum, however in the past 6 months it has become very quiet. I agree with the comments here, create a new topic on this forum for the API, at least then it will get more visibility and hopefully more activity. I've been using the API for several years now and found it to be generally rock solid and fairly comprehensive, and maybe a new forum here will get more people to start using it.
  14. Just joined this community, was active on the IG Labs forum but that community is not very active now... Looking to continue building software interfacing with the IG API. I have built several Excel Add-ins and applications for semi-automated trading. Currently working on a new Excel Add-in to stream live IG prices into a spreadsheet. Looking forward to seeing how others are using the IG platform and get some new software ideas.