-
Posts
240 -
Joined
-
Last visited
-
Days Won
20
Content Type
Profiles
Forums
Blogs
Events
Community Tutorials
Store
Everything posted by andysinclair
-
No PC or mobile platform ??
andysinclair replied to vietlen's question in IG Account Support - MyIG Help
-
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
-
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).
-
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
Yep, it's ridiculous, it's full of conspiracy theories and links to dodgy websites, just ignore it. -
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
-
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.
-
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
-
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
-
US futures in the red just before US open, at session lows. USD stronger, everything else red: Powered by https://www.excelpricefeed.com
-
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
The world has gone crazy. Bill Gates being attacked by conspiracy theorists, no evidence for any of this other than "it's on Twitter". This used to be a reasonable discussion forum....Maybe I should post some screenshots from Twitter arguing that that earth is flat! -
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
The ONS have just published registered deaths up to 3 April: https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/bulletins/deathsregisteredweeklyinenglandandwalesprovisional/weekending3april2020 I'm afraid it looks like the death rate from COVID-19 is going to be a lot higher than currently projected. The interesting comparison is the variation from the 5 year average (the top two lines) as this removes uncertainty about testing, deaths at home/hospital etc: -
Multiple spread bet accounts ?
andysinclair replied to smithj's question in IG Account Support - MyIG Help
Yes, you can set it up yourself on the My IG page: https://www.ig.com/uk/myig/dashboard There is an "Add an account" button: -
Exporting Price Data on to excel
andysinclair replied to Wizi's topic in New Client Trading Questions
I've built an Excel Add-in which enables you to download historic IG market data into Excel. You can use 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. -
I've built an Excel Add-in which enables you to download historic IG market data: 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.
-
Yes, it is still working, I use it via my Excel Add-in every day. Can you post some code and I will take a look?
-
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
Thought I would spend some time looking at the actual stats (from UK Government websites only) for UK flu versus COVID-19. The official stats for flu are 312 deaths and 3,157 hospital admissions for the 2018/2019 flu season (over 6 months). For COVID-19 there are today 9,000 patients in hospital beds and there were 159 deaths yesterday. There are currently approx. 140,000 hospital beds in the UK and at any one time approx. 10% are empty. Plotting these figures in Excel produces the charts below (I have used yesterdays COVID-19 death figure as an average is not yet available versus an average day during the flu season): -
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
Not sure where that stat comes from....from the WHO website: 20% of cases need hospital treatment. Around 1 out of every 6 people who gets COVID-19 becomes seriously ill and develops difficulty breathing. Also nobody is sure about the long term effects of having the virus, i.e. lung damage etc. -
IG App - Switch between CFD and Spread Betting
andysinclair replied to Kadabra's question in IG Technical Support - Platform and App Help
Press the "More" tab, then select "Accounts", you should then see a list of your accounts. Select one then press "Switch Account" and the default will change. Hope this helps! -
Put option trading
andysinclair replied to a question in IG Technical Support - Platform and App Help
The value of the put option has declined from 406 to 260, therefore your P&L has also declined (as you bought the option). I suggest you find some articles/videos online that explain how options work, or even better buy yourself a book, I have "Options Plain and Simple" by Lenny Jordan which I recommend. -
Lots of big moves today, stock indices positive and around intraday highs. Gold also near intraday highs, up over 4%: Powered by https://www.excelpricefeed.com
-
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
Well said. I also object to the title of this thread, it is not the WuFlu, it is COVID-19. The lockdown is to prevent the NHS from being swamped with patients leading to a potential situation where we have medical staff having to decide who lives and who dies. This is serious and we need to take it seriously, saying it is "just the flu" is extremely irresponsible and potentially dangerous. -
Britain’s Office for National Statistics (ONS) said it would will publish market-sensitive releases such as economic growth, employment and inflation data at 0700 GMT rather than the usual time of 0930 GMT in response to the coronavirus pandemic https://uk.reuters.com/article/uk-health-coronavirus-britain-ons/britains-ons-to-publish-market-sensitive-releases-at-0700-gmt-idUKKBN21B150
-
Covid and the Economy
andysinclair replied to Caseynotes's topic in General Trading Strategy Discussion
Please, please, please STAY AT HOME. Only visit the supermarket if absolutely necessary and keep your distance from other people. We all need to work together to stop this virus spreading and overloading our health system. -
Yep, I agree... Up until late February the S&P500 was trading in a 30/40 point range with similarly small daily moves. Now we are looking at 200-300 point ranges with 100-200 point moves...until this week. The last 3 days (including today) have seen large ranges (200 points) but small moves (less than 50 points). This signifies that the market is pulling up and down with no clear direction... Orange: Daily Move Blue: Daily Range Powered by https://www.excelpricefeed.com
-
Indices heading back down; Oil up nearly 10%; GBP back down again towards yesterdays low. IG clients still long most markets apart from the Euro... Powered by https://www.excelpricefeed.com