- 0
Asked by
jhclctcrc,
By AhmedMarsh · Posted
By AhmedMarsh · Posted
By Billionaire1 · Posted
IG | Sitemap | Terms and agreements | Privacy | How to fund | Cookies | About IG
Spread bets and CFDs are complex instruments and come with a high risk of losing money rapidly due to leverage. 69% 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. All trading involves risk.
The value of shares, ETFs and ETCs bought through a share dealing account, a stocks and shares ISA or a SIPP can fall as well as rise, which could mean getting back less than you originally put in. Past performance is no guarantee of future results.
CFD accounts provided by IG Markets Ltd, spread betting provided by IG Index Ltd and share dealing and stocks and shares ISA accounts provided by IG Trading and Investments Ltd. IG is a trading name of IG Markets Ltd (a company registered in England and Wales under number 04008957), IG Index Ltd (a company registered in England and Wales under number 01190902) and IG Trading and Investments Ltd (a company registered in England and Wales under number 11628764). Registered address at Cannon Bridge House, 25 Dowgate Hill, London EC4R 2YA. IG Markets Ltd (Register number 195355), IG Index Ltd (Register number 114059) and IG Trading and Investments Ltd (Register number 944492) are authorised and regulated by the Financial Conduct Authority.
The information on this site is not directed at residents of the United States, Belgium or any particular country outside the UK 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.
Question
jhclctcrc
hi everyone
I have downloaded the IG API (per "api-sample-excel-1.0.7-64bit.zip") and managed to install and got to the create relevant "IG API Excel Sample" (per "ig-api-sample.xlsm") after installation
+ I have also played around with it and managed to download historical OHLC data
I am hoping to be able to download live data using RTD Functions, but I have not been able to do so
+ I have learnt, I believe, that IGMarkets has partnered with LightStreamer.com, and the following are relevant live samples
I have managed to install the above "Basic Stock - List Demo Microsoft (Excel, RTD) Client"
+ but the sample Excel did not seem to be able to import Live Data from the IGMarkets data servers
Essentially, my objective is to be able to have an Excel file (let us call this "MyExcelRTD Spreadsheet") to download the following data:
+ historical OHLC Prices up to the last 500 minutes
+ live OHLC Prices per the current minute
- I am planning to build this "MyExcelRTD Spreadsheet" using the "IG API Excel Sample" (is this possible?)
may I ask if a fellow forum member can help with guiding as to how I can achieve the preceding objective?
I have the following questions:
+ can I use the "IG API Excel Sample" (as installed per IG API (per "api-sample-excel-1.0.7-64bit.zip")) to do both the following?
- download historical OHLC Prices up to the last 500 minutes
- - this obviously can be done, as I have done so already
- download live OHLC Prices per the current minute
- - ie am I able to use RTD Functions within this IG API Excel Sample to import live data?
+ from relevant Lightstreamer.com webpages (ie https://demos.lightstreamer.com/?p=lightstreamer&t=client&sclientmicrosoft=excel), or rather from the "Basic Stock - List Demo Microsoft (Excel, RTD) Client which I have managed to install, I was able to see that the "progID" used is actually "lightstreamer.rtdexceldemo"
- per the following RTD Function: =RTD("lightstreamer.rtdexceldemo",,"item30","bid")
- can I used this progID in "MyExcelRTD Spreadsheet"?
- or is there another 'progID" which I need to use, and if so, what is the name of the "progID"?
+ I have entered the following RTD Function into a new worksheet of the "IG API Excel Sample"
- "=RTD("lightstreamer.rtdexceldemo",,Z....P,"bidGBPUSD")", but "#NAME?" is returned?
- "Z....P" is my IG AccountID, do I use this AccountID, or is there another AccountID which I have to use so tha this RTD Function will work?
+ also, does IGMarkets and/or Lightstreamer have any kind of RTD documentation (in the same manner eg other brokers have for their ExcelRTD documentation)?
- please see an example here: https://www.jfdbrokers.com/documents/JFD_Excel_RTD_User-guide_EN.pdf
- if so, can please share the documentation here?
sincerely hope that someone can help
+ I have spent easily at least a week on this (including on IGMarkets MT4 Excel RTD ExpertAdvisor) and cannot go forward
thank you
Link to comment
0 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now