andysinclair
-
Posts
240 -
Joined
-
Last visited
-
Days Won
20
Content Type
Profiles
Forums
Blogs
Events
Community Tutorials
Store
Posts posted by andysinclair
-
-
1 hour ago, Caseynotes said:
Hi, depends on which platform you want it for. There are sites to download historic data but not IG's for the MT4 platform that's free. You can get some IG data for the web platform using the API from IG Labs or @andysinclair has a payfor download service.
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
-
1
-
-
8 hours ago, Spook1304 said:
I BUY a PUT with a strike price of 2860 with a daily expiry.
My understanding is that if at the end of the day, the US500 index is less than my strike price of 2860 then I should be in profit. Why does my account show a loss: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).
-
52 minutes ago, appress said:
i just wasted 3 minutes oof my life reading this horseshite
Yep, it's ridiculous, it's full of conspiracy theories and links to dodgy websites, just ignore it.
-
1
-
-
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
-
Oil
in Commodities
On 20/04/2020 at 12:06, Raytheon said:2. Is it possible to download IG Crude prices in (say) excel?
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.
-
1
-
-
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
-
1
-
-
More than double the average number of deaths for week 16 compared to the 5 year average.
-
US futures in the red just before US open, at session lows.
USD stronger, everything else red:
Powered by https://www.excelpricefeed.com
-
1
-
-
1 hour ago, Caseynotes said:
Fauci has close ties to Gates.👇
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!
-
1
-
-
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:
-
1
-
-
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:
-
1
-
-
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?
-
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):
-
1
-
-
25 minutes ago, Caseynotes said:
all the data from countries with extensive testing shows that 99% of confirmed cases don't get pneumonia (which is responsible for the deaths) and so only exhibit normal flu like symptoms if any at all.
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.
-
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!
-
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.
-
1
-
-
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
-
1
-
-
10 minutes ago, psycho said:
I concur - this is the only sound advice.
This is NOT the flu. If you think only 2% death rate is an acceptable figure, imagine the condition of the 18 year old's parents on a ventilator right now. Or the wife and child of the 32 year old doctor who was punished for bringing this to the world's attention. Is it acceptable? Just because you may survive it does not mean you won't KILL someone else by giving it to them. The facts are clear if we don't stop infection rates, there is NO way the NHS will cope. The experts have told us that - WE NEED TO COMPLY. The NHS staff are at maximum risk because they are being bombarded daily with the droplets from infected people. There is no cure and even the best minds in Science are working in a high degree of uncertainty.
I apologise if my language appears a bit strong but there is way too much complacency in the populous.
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.
-
1
-
-
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
-
1
-
-
2 hours ago, Caseynotes said:
I happily mingled with well over a hundred people doing our shopping but I'm not allowed to go to the local pub (avg 20 people) or the local gym (avg 20 people).
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.
-
3
-
-
43 minutes ago, HPbrand said:
A big move is brewing.....
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
-
1
-
-
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
-
1
-
No PC or mobile platform ??
in IG Account Support - MyIG Help
Posted · Edited by andysinclair
Yep, complete outage, details here: https://status.ig.com/