- 0
Request for Help re IG API Excel Sample RTD Function "progID", AccountID and RTD Documentation
Asked by
jhclctcrc,
-
General Statistics
-
Total Topics23,043
-
Total Posts95,434
-
Total Members43,656
-
Most Online7,522
10/06/21 12:53
-
-
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.
-
By tradinglounge · Posted
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.
-
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