Jump to content

andysinclair

Community Member
  • Content Count

    132
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by andysinclair

  1. The question was about spreadbetting not CFDs. CFDs are quite different and like you point out do have an exchange rate factor if the instrument is quoted in a currency different to your account currency.
  2. The NASDAQ is not really a USD asset, it is an index. When you spreadbet on the NASDAQ you are betting an amount of GBP per point move in the index. There is no GBPUSD conversion to take into account. The amount of margin required is based on how much (GBP) per point you bet. See here for details: https://www.ig.com/uk/help-and-support/spread-betting-and-cfds/fees-and-charges/what-are-igs-indices-spread-bet-product-details
  3. This doesn't correspond to what is published on the ONS website. Excess deaths this year are much higher than the past 5 years average (top two lines): From https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/bulletins/deathsregisteredweeklyinenglandandwalesprovisional/weekending28august2020
  4. Hi, I've built an Excel Add-in which makes this very easy. You can also download your transaction and activity history: https://www.excelpricefeed.com/userguide/positions-trade-history-download-excel-ig-index Here is an example of live positions in Excel using the Add-in: I hope this helps.
  5. I've built an Excel Add-in which you can use to easily download watchlists as well as other account data, prices etc into Excel. For example, here is one of my watchlists that I have downloaded into Excel: It uses a simple Excel formula so each time I refresh the sheet the data is updated automatically. https://www.excelpricefeed.com/userguide/watchlists-ig-index I hope this helps!
  6. Hi, I've built an Excel Add-in which makes this very easy. You can also download your transaction and activity history, more details here: https://www.excelpricefeed.com/userguide/positions-trade-history-download-excel-ig-index Here is an example of live positions in Excel using the Add-in: I hope this helps.
  7. Equity indices all positive this morning, especially the DAX and CAC (I suspect following agreement on the EU support package). GBP stronger, EUR little changed: Powered by https://www.excelpricefeed.com
  8. It's working for me on Live but not on Demo.
  9. I am now seeing this problem as well (it was working for me last week). The /gateway/deal/accounts endpoint is returning a server 500 error: {"errorCode":"error.client.accounts.list.generic-error"} It is broken on both the demo and prod API. @CharlotteIG Can somebody at IG look into this as a matter of urgency? Thanks.
  10. I agree, a clock would be useful. However, I use the updated time on a liquid market in my watchlist to see the time. Prices in S&P500, DJIA etc are updated every second so the last update time is good enough for me (web platform only though as updated time is not an option in the mobile app).
  11. Hi, I'm a developer with experience of the IG API. Can you provide a quick overview of what you are trying to achieve? Cheers.
  12. You can get share prices, well at least for spread bet and CFD accounts, via the REST API (not streaming). I think the text you quoted is for share accounts. I have just tried UC.D.NFLX.CASH.IP and I can query the bid/offer via the API. I use the API for my Excel Add-in and that also works fine for retrieving stock prices into Excel.
  13. You could look at the historical data that IG provides as it includes their bid and ask prices. They provide various resolutions of data from 1 second upwards, for various time periods. I guess you could cross reference the time of your trades with a historical data request to give you the data you require.
  14. Stock indices positive this morning, FX flat and oil down. IG clients short the major indices and very bullish on gold: Built using https://www.excelpricefeed.com
  15. Hi, I've built an Excel Add-in which you can use to easily download your positions (as well as other account, price data etc.) into Excel. You could use it to quickly calculate average price as well as other parameters: https://www.excelpricefeed.com/userguide/positions-trade-history-download-excel-ig-index I hope this helps!
  16. I've built an Excel Add-in which you can use to easily download positions as well as other account data, prices etc into Excel: https://www.excelpricefeed.com/userguide/positions-trade-history-download-excel-ig-index Hope this helps!
  17. There was a major outage on February 24th, not sure about March although I do remember there being at least two fairly close together. Check this page for the latest status: https://status.ig.com/
  18. Yep, complete outage, details here: https://status.ig.com/
  19. Yes, I have built an Excel Add-in that you can use. Here, for example, is the IG daily timeseries 2002 for GBPUSD. More details on my website: https://www.excelpricefeed.com
  20. You need to take into account the premium you have paid. For example if you bought the put at say 30 then you would need to the index to close below 2830 to make a profit (strike 2860 minus 30 premium).
  21. Yep, it's ridiculous, it's full of conspiracy theories and links to dodgy websites, just ignore it.
  22. Hi @icarus666 I've built an Excel Add-in which connects to IG and enables you to download your trade history, positions, P&L etc into an Excel spreadsheet. You should be able to use it to collect the data you need, then add an Excel chart to visualise it. Give it a try and let me know how you get on, I'm keen to improve it so all feedback welcome: https://www.excelpricefeed.com
  23. andysinclair

    Oil

    I've built an Excel Add-in which enables you to easily download historic IG market data into Excel. You can specify the resolution of the data, minute/hour/etc: https://www.excelpricefeed.com/userguide/historic-data-download-ig-index Please be aware that due to IG restrictions you can only download 20,000 historic datapoints per week. Hope this helps.
  24. Hi, I have just been looking at two pages on the IG site and they show different client sentiment numbers for AUDUSD: https://www.ig.com/uk/marketanalysis/ig-forex/audusd1 : 67% long https://www.ig.com/uk/forex/markets-forex/aud-usd : 50% short The API is also returning 50% short so I presume the 67% figure is incorrect? Can somebody from Support check please? Thanks
  25. More than double the average number of deaths for week 16 compared to the 5 year average.
×
×