Jump to content
  • 0

Request for Help re IG API Excel Sample RTD Function "progID", AccountID and RTD Documentation



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

There have been no answers to this question yet

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • General Statistics

    • Total Topics
    • Total Posts
    • Total Members
    • Most Online
      10/06/21 12:53

    Newest Member
    Joined 30/09/23 15:08
  • Posts

    • The crypto market appears to be showing signs of recovery, with significant improvements in the Sharpe Ratios of Bitcoin, BGB, and Ethereum, according to an article published on Friday.  The Sharpe Ratio, a measure used to understand the return of an investment compared to its risk, has seen a notable increase for both cryptocurrencies. Bitcoin's Sharpe Ratio has risen from -2.4 to 0.68, while Ethereum and BGB have also experienced a similar uptrend. This change signifies higher returns at lower risk, which is expected to attract more investors to the crypto market. In addition to the improved Sharpe Ratios, increased network activity and trading volume as shown on CEXs like Bitget, Binance, and a few DEXs are suggesting a healthier market state. The current trading prices of Bitcoin, reflect this overall positive market sentiment. As of Friday, Bitcoin was trading at $27,069.73, BGB at $0.454 and Ethereum at $1,677.89. These developments are significant as they indicate reduced risk in the crypto market. The increase in the Sharpe Ratios for Bitcoin, BGB, and Ethereum suggests that these cryptocurrencies are becoming less risky investments, which could potentially lead to an influx of new investors into the market.  Could this rise in Sharpe Ratios coupled with increased network activity and trading volume point towards a recovering and less risky crypto market?
    • Hi, That's great, thank you very much. Very helpful! Many thanks.
    • Texas Instruments Inc., Elliott Wave Technical Analysis Texas Instruments Inc., (TXN:NASDAQ): Daily Chart, 29 September 23 TXN Stock Market Analysis: We have been moving lower as expected from the previous forecast. Looking for continuation lower as there is an incomplete bullish sequence. Looking for extension lower in wave {iii}. Downside target stands below wave (W). TXN Elliott Wave Count: Wave {iii} of C. TXN Technical Indicators: Below al averages.   TXN Trading Strategy: Looking for shorts on the way down.   TradingLounge Analyst: Alessio Barretta Source : Tradinglounge.com get trial here!       Texas Instruments Inc., TXN: 4-hour Chart, 29 September 23 Texas Instruments Inc., Elliott Wave Technical Analysis TXN Stock Market Analysis: As we are getting an overlapping structure in what could be a wave {iii} there is a high chance we will see an acceleration lower to then see a series of fours and fives.   TXN Elliott Wave count:  Wave (iii) of {iii}. TXN Technical Indicators: 20EMA as resistance. TXN Trading Strategy: Looking for shorts on the way down.
  • Create New...