Request for Help re IG API Excel Sample RTD Function "progID", AccountID and RTD Documentation
Joined 20/03/23 07:48
By tradinglounge · PostedDexCom Inc., Elliott Wave Technical Analysis DexCom Inc., (DXCM:NASDAQ): Daily Chart, 20 March 23, DXCM Stock Market Analysis: Looking for an overall long term correction to take place as we could be correcting the entire upmove from 2008.Looking for another leg higher before potential downside resumption. DXCM Elliott Wave Count: Wave (B) of B. DXCM Technical Indicators: Above all averages. DXCM Trading Strategy: We could look for longs with a stop below 104$. TradingLounge Analyst: Alessio Barretta Source : Tradinglounge.com get trial here! DexCom Inc., DXCM: 4-hour Chart, 20 March 23, DexCom Inc., Elliott Wave Technical Analysis DXCM Stock Market Analysis: Here the three wave move to the upside appears clearer. Looking for sideway continuation as long as we stay above the 200EMA to then resume higher. DXCM Elliott Wave count: Wave (B) of B. DXCM Technical Indicators: In between averages. DXCM Trading Strategy: Looking for sideways continuation in wave (B).Enterwave (B).
By tradinglounge · PostedCommodity Futures Market Technical Analysis Elliott Wave and Trading Strategies Content: US Bond Yields, Dollar DXY, US Gold, Silver, Copper, Lithium, Nickel, Crude Oil, Natural Gas Commodities Market Summary: Commodities are generally moving lower. Trading Strategies: Another buying opportunity may unfold across 2000 for Gold, however we need to wait for the set up, see the video. Video Chapters 00:00 US Gov Bonds 10 Yr Yields 03:58 US Dollar Index DXY 14:04 US Spot Gold 23:47 US Spot Silver 27:52 US Copper / Lithium / Nickel 38:24 Crude Oil 42:19 Natural Gas 44:38 Thanks for watching! Analyst Peter Mathers TradingLounge™ Australian Financial Services Licence - AFSL 317817 Source: tradinglounge com Level Up - Test the Trial Service!
By tradinglounge · PostedElliott Wave Analysis TradingLounge Daily Chart, 19 March 23, Theta Token/U.S.dollar(THETAUSD) THETAUSD Elliott Wave Technical Analysis Function: Follow trend Mode: Motive Structure: Impulse Position: Wave III Direction Next higher Degrees: wave (I) of Impulse Wave Cancel invalid Level: 0.706 Details: Wave II is likely to end at the level of 0.85 and a five-wave rise from this level will confirm it. Theta Token/U.S.dollar(THETAUSD)Trading Strategy: Theta Token price has recovered well from the 0.850 level but the price is still in a downtrend as it is below the MA200 line, but even then we have completed the second wave retracement and the retracement of the 0.850 level. A five-wave rally confirms this idea, making the price likely to trade above 1.302 and potentially leading to 1.784. Theta Token/U.S.dollar(THETAUSD)Technical Indicators: The price is below the MA200 indicating a DownTrend. The wave oscillators below Zero-Line momentum are bearish. TradingLounge Analyst: Kittiampon Somboonsod, CEWA Source : TradTradinglounge.com get trial here! Elliott Wave Analysis TradingLounge 4H Chart, 19 March 23, Theta Token/U.S.dollar(THETAUSD) THETAUSD Elliott Wave Technical Analysis Function: Follow trend Mode: Motive Structure: Impulse Position: Wave III Direction Next higher Degrees: wave (I) of Impulse Wave Cancel invalid Level: 0.706 Details: Wave II is likely to end at the level of 0.85 and a five-wave rise from this level will confirm it. Theta Token/U.S.dollar(THETAUSD)Trading Strategy: Theta Token Well recovered from the level of 0.850 and managed to cross the MA200 line, so the trend has a chance to turn bullish again. We also predicted the end of the second wave reversal and the five-wave rise confirming this idea. The price is likely to trade above 1.302 and could lead to 1.784. Theta Token/U.S.dollar(THETAUSD)Technical Indicators: The price is above the MA200 indicating an UpTrend. The wave oscillators above Zero-Line momentum are bullish.
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
Link to comment
0 answers to this question
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
Already have an account? Sign in here.Sign In Now