Hi Everyone, am trying develop a trading app in excel vba. Occasionally it disconnects, does anyone have an example of how I can get it to reconnect after a fixed time period. Many thanks - Mark
© 2003-2020
The products we provide are leveraged products. Trading with leverage may not be suitable for everyone and can result in losses that exceed your deposits, so please ensure that you fully understand the risks involved.
For more information about IG Group and our offices in the UK, across Europe, Australia, Japan, Singapore and South Africa please see IG.com.
The information on this site is not directed at residents of the United States and is not intended for distribution to, or use by, any person in any country or jurisdiction where such distribution or use would be contrary to local law or regulation.
Spread betting is only available from our UK entities.
* For CFDs, based on revenue excluding FX, published financial statements, October 2016
Spread bets and CFDs are complex instruments and come with a high risk of losing money rapidly due to leverage. XX% of retail investor accounts lose money when trading spread bets and CFDs with this provider. You should consider whether you understand how spread bets and CFDs work, and whether you can afford to take the high risk of losing your money. Professional clients can lose more than they deposit. Spread bets and CFDs are complex instruments and come with a high risk of losing money rapidly due to leverage.
If you are a Corporate please contact us to apply by emailing newaccounts.uk@ig.com
Unfortunately I've been unable to find a solution to this. As far as can see the IG RTD implementation uses ig.api.excel.rtd.igapirtdserver / mscoree.dll in an excel addin. This gets initialised when excel loads. It looks like its a custom COM implementation which does not expose the RTD IRTDServer interface methods (as far as I can see). For anyone interested these are ServerStart, ServerTerminate, ConnectData DisconnectData, HeartBeat and RefreshData. As such there is no way to restart streaming prices (as far as I can see) apart from shutting down excel and reloading it.
In practice this means any excel based automated trading system needs to be watched which dramatically reduces its usefulness. I would be enormously grateful if someone could comment/ provide a solution on this issue.
Many thanks and regards
Mark
Hi Mark,
One of our team have responded to the message you've sent via the Contact us page.
Thanks,
Chris
I have also suffered from this problem and I would love to get a solution. Is there any further information or any work around available.
Hi offthelib,
Our developers believe that this would involve updating the RTD library, possibly our implementation of IConnectionListener (see source provided with the Excel sample app) to handle LS disconnect events, in particular due to session / keepalive expiry (e.g. END message with status 48 or a LOOP message).
We have added a work item to our backlog to take a look at this and will let you know when this is available.
Chris
+1 vote for a solution, shutting down and restarting excel is a real annoyance
agree with markleeds; it really defies the purpose of building an automated system if one has to watch over it!
Are there similar connectivity issues with other SDK, i.e the one for Java or JavaScript?
I am thinking about using JavaScript; anyone familiar with the IG sample SDK ?