-
Posts
240 -
Joined
-
Last visited
-
Days Won
20
Content Type
Profiles
Forums
Blogs
Events
Community Tutorials
Store
Everything posted by andysinclair
-
US Election 2020 Thread
andysinclair replied to Ludwik Chodzko-Zajko IG's topic in Indices and Macro Events
Can't we keep this forum meme free? I come here for trading/markets discussion. It's turning into Facebook with all the conspiracy theories, memes etc! -
All stock indices in positive territory today, S&P500 at all time high: Built using https://www.excelpricefeed.com/
-
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
This is a very good article explaining the what Covid-19 actually is and how we can fight it: https://www.economist.com/by-invitation/2020/08/10/nicholas-christakis-on-fighting-covid-19-by-truly-understanding-the-virus -
I don't trade off it, I use it to compare markets, download and analyse my trades/positions etc. I would rather build my own view in Excel than use the watchlists on the web platform.
-
-
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.
-
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
-
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
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 -
Export Current Positions to Excel
andysinclair replied to zarathustra's topic in Feedback and Suggestions
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. -
IG Watchlists
andysinclair replied to hamsa's question in IG Technical Support - Platform and App Help
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!- 1 reply
-
- 1
-
Download my portfolio to excel or csv
andysinclair replied to hamsa's question in IG Technical Support - Platform and App Help
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. -
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
-
Eror with IG API?
andysinclair replied to blitzjoker's question in IG Trading Support - Dealing Questions
It's working for me on Live but not on Demo. -
Eror with IG API?
andysinclair replied to blitzjoker's question in IG Trading Support - Dealing Questions
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. -
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).
-
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.
-
API Share Prices
andysinclair replied to fxtrading's question in IG Technical Support - Platform and App Help
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. -
Historical Spread Size
andysinclair replied to Chirag_Patel's question in IG Technical Support - Platform and App Help
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. -
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
-
Combining orders to give average price
andysinclair replied to Fib550's question in IG Trading Support - Dealing Questions
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! -
Download positions into excel
andysinclair replied to JG11's question in IG Account Support - MyIG Help
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! -
System Errors, No support, what is going on?
andysinclair replied to MaxwellBond's topic in Shares and ETFs
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/