andysinclair
-
Posts
240 -
Joined
-
Last visited
-
Days Won
20
Content Type
Profiles
Forums
Blogs
Events
Community Tutorials
Store
Posts posted by andysinclair
-
-
All stock indices in positive territory today, S&P500 at all time high:
Built using https://www.excelpricefeed.com/
-
1
-
-
2 hours ago, HMB said:
t's about letting profitable trades run, and cutting losses early, so that you are with a low win rate still profitable
This is the key for me.
It doesn't matter if you have more losers than winners, what really matters is how you manage your risk.
-
2
-
-
This is a very good article explaining the what Covid-19 actually is and how we can fight it:
QuoteAlthough the virus behind covid-19 is less deadly than the one that causes SARS in a given single case, that does not mean that it is less dangerous on the whole. On the contrary, it harms many more people. To understand why, consider two pathogens. Imagine that for every 1,000 people, the first pathogen makes 20 seriously ill and kills two. The case fatality rate is 10%.
Now imagine a second pathogen that again makes 20 seriously ill and kills two for every 1,000 people, but also infects a further 180 people making them mildly or moderately ill, but not killing them. Perhaps some of them are left seriously disabled, too. But the case fatality rate gets calculated as two deaths out of 200, for a mere 1%. The second disease seems much milder. In reality it is far worse: no one would prefer to be in a group facing the second pathogen rather than the first—with ten times as many people infected.
The second situation partly characterises the current pandemic. Covid-19 encompasses a range of severity and a variety of symptoms (affecting not just our respiratory system, but also our gastrointestinal and neurological systems in some cases). Perhaps half of those infected are asymptomatic. Some who fall ill indeed suffer serious long-term health problems. But because, for many, the symptoms resemble a mild cold, there is a tendency for the public and politicians to take it less seriously. Thus, its protean nature makes controlling it harder.
-
1
-
-
Just now, jlz said:
I actually use sentiment from one of the algos.
https://labs.ig.com/rest-trading-api-reference/service-detail?id=551
So, it is a problem for me. Bigger than it seems and unfortunately as you said, because it is indicative it shouldn't be used to make any decision.
It's a problem for me also. IG just need to ensure the numbers are consistent, I don't know which number to believe as the API shows a different number to some of their webpages.
-
2 minutes ago, dmedin said:
Who trades off of a spreadsheet?
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.
-
-
Has anybody from IG had a chance to look into this?
I am still seeing mismatches, also between the dailyfx website and the IG website.
For example the S&P500:
59% short:
https://www.dailyfx.com/sp-500
50% long:
-
2 minutes ago, Caseynotes said:
oh ok, so is this IG example of a cfd trade on the Dax showing currency conversion not correct then?
ps, taken from Oz IG so uses AUD rather than GBP.
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.
-
5 hours ago, ChristianS said:
I have a GBP spreadbet account, if I open a position on NASDAQ which is a USD asset, is my money converted to USD and are all the calculations on how much equity and margin I have all done against the last exchange rate GBPUSD?
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:
-
1 hour ago, 786Trader said:
Your figures suggest no/negligible excess deaths this year for the UK,
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):
-
2
-
-
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.
-
1
-
-
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
-
-
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
-
1
-
-
46 minutes ago, blitzjoker said:
I have just logged in ok and downloaded some data successfully. Have not tried automated trading yet, but will have a go this afternoon.
It's working for me on Live but not on Demo.
-
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).
-
1
-
-
14 hours ago, ZR_ said:
What is the best way to connect with developers with IG API experience for a piece of work?
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.
-
1
-
-
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.
-
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
-
1
-
-
On 06/05/2020 at 20:07, Fib550 said:
Hi,
If i buy multiple positions, is it possible for the order's to be combined and show an average price?
Its time consuming for me to input my individual orders into excel to work out my average price.
Thanks
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!
-
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!
-
14 minutes ago, dmedin said:
You already forgot the outage when the markets tanked in March?
There was a major outage on February 24th, not sure about March although I do remember there being at least two fairly close together.
34 minutes ago, nit2wynit said:Yes there is, but I don't know how to direct you to it, sorry.
Check this page for the latest status:
US Election 2020 Thread
in Indices and Macro Events
Posted
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!