Jump to content


Community Member
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by andysinclair

  1. I've built an Excel Add-in that makes it very easy to connect to IG and stream live prices, download historical data, account data (positions) etc. https://www.excelpricefeed.com/ It requires an IG API key to work, and you can use it with your demo or live account. Let me know if you have any questions or need any help.
  2. I suggest you build something in Excel to keep track of your portfolio. You can use an Add-in that I have built that connects to both Yahoo Finance and IG Index (spread betting and CFD, not shares as it uses the IG API): https://www.excelpricefeed.com/ The Add-in provides formulas, such as =EPF.Yahoo.Sector("AAPL") which will populate a cell with the industry sector for Apple stock. I hope this helps. Let me know if you have any feedback or need any help.
  3. 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!
  4. What is a long or short positioning tool? Can you provide an example?
  5. Yes, I am not seeing my Twitter feed update. It was working fine last week.
  6. It looks like the positions are daily "cash" positions, not futures, therefore they will be closed automatically at end-of-day. You can, however, enable automatic roll-over of cash positions in the settings section of the dashboard.
  7. I use the transactions endpoint in my Excel Add-in and it works well. However, as you say it need to be set to API V2 as V1 is no longer supported. The API version needs to be set on the request header, for example: I would check the code where the actual request is made and make sure this is being set correctly. I hope this helps.
  8. It just opened, currently up 70% at $420.
  9. Yes, you should definitely use the ask/bid price when backtesting. Spreads change constantly based on market conditions, time of day etc. and can have a significant impact on the profitability of any system.
  10. Yeah I agree, for the last few months it attracted lots of spammers for some reason (I presume it was not being moderated and had always attracted spam). However, it did have lots of useful content, often I would search on Google for a question/issue and would see a useful forum post in the results. Over the years it became a decent knowledge base, which I guess is all lost now.
  11. Hi @CharlotteIG or anybody at IG. Can you explain what is happening with the IG Labs forum? It was a great resource for help/discussion with anything related to the API, and now all that info has gone. Thanks.
  12. The Coinbase "IPO" is not really an IPO it's a direct listing so no new shares will be made available to the public: https://blog.excelpricefeed.com/2021/02/25/coinbase-ipo/
  13. Coinbase today announced its intention to IPO by filing an S1 with the US SEC. How does Coinbase compare with traditional financial exchanges and what are its prospects? Some thoughts here after digging into the S1: https://blog.excelpricefeed.com/2021/02/25/coinbase-ipo
  14. As I understand it you can only use the API with a spread bet or CFD account not a share dealing account. It looks from your partial screenshot that you have a share dealing account so I suspect this is why you cannot see the API option.
  15. So you can't see the API Keys option on the left (when you have Settings selected at the top)? Try this link: https://www.ig.com/uk/myig/settings/api-keys
  16. Pre-market: -40% after a -30% drop yesterday:
  17. This has happened multiple times over the past 12 months. I understand that there can be technical issues but what is not acceptable is there is never any analysis published afterwards: what happened and what work is being done to address it so it doesn't happen again. Is it purely a technical issue, i.e. too many users and the servers can't handle it? or something else?
  18. The price is all over the place today with a high of $482 and a low of $114 !!! "no one makes money until they sell" and I do fear that many of those on Reddit are sitting on large paper profits that can disappear as quickly as they appeared. The move back down can be as abrupt as the move up once sentiment changes and reality sets in...let's see what happens...
  19. I thought I would write up an explanation of what is currently going on with GameStop in what could be a defining moment for the world of finance. I hope some of you find it interesting and informative: https://blog.excelpricefeed.com/2021/01/28/gamestop-wall-st-vs-main-street/ (here's the price/volume chart since the start of the year!)
  20. Pre-market now at +160% at 380. Who knows where this is going to open...
  21. Pre-market showing it up 68% since the close yesterday, currently at 248. Some US stocks you can trade pre-market but not GME. Be careful around the open though, spreads will be very wide...
  22. Breaking News: COVID-19: 'Major incident' declared in London due to hospital pressure https://news.sky.com/story/covid-19-major-incident-declared-in-london-due-to-hospital-pressure-12182329 Mayor of London Sadiq Khan has declared a "major incident" in the capital due to rising coronavirus cases threatening to overwhelm hospitals. City Hall said growing infection rates are "putting immense pressure on an already stretched NHS", with the number of people on mechanical ventilators up by 42% - from 640 to 908 - in the week up to 6 January.
  23. I'm seeing problems with the Demo API in fact I can't even logon, either through my own application or on the API Companion. I have reset my username and password and created a new API Key, all to no avail. I suspect the demo systems is experiencing some sort of outage, can somebody from IG check please? cc @CharlotteIG
  24. Where is the evidence for this? Just because the value of Bitcoin has risen recently does not mean it's a bona fide currency. I think it's a speculative bubble, the price is going up because people are bidding prices up simply because they think it will go higher.
  • Create New...