Thanks 闯ü谤驳别苍. Where can I edit the list of ticks? Is that possible within the RTD client or something it calls? I merely ask for 1 tick value (Last or Close depending on Stock/Fund) in my cell formula, I assume a process making the request for all tick types and something in the RTD is filtering for just what I asked for. Or am I stuck with reverting back to the older version of TWS? Jim On Sun, May 12, 2024 at 4:10?PM 闯ü谤驳别苍 Reinold via groups.io <TwsApiOnGroupsIo@...> wrote:
Your problem is very likely not related to the Excel/RTD integration but all languages will experience this.
Over the years, the legitimate lists of generic ticks for each SecType changed occasionally. In many cases, new ticks were added, but in others, ticks were retired. If you have such retired ticks in your genericTickList upon reqMktData() subscription, the request will fail with the error message you describe.
I found that the error message and the API documentation were never quite accurate as to which ticks are legitimate and which ones aren't. A long time ago I wrote a small utility that that simply, in a brute force way, tries out all integer values between 100 and 699 for all SecTypes and displays the legitimate ones.
Apparently the "stable" TWS 10.19 allows two more tick types than the "latest" TWS 10.29. Those are 576 and 578 that you seem to have in your genericTickList. So I'd expect your spreadsheet should work with TWS/IBGW 10.19 but fail on 10.29 (and maybe others). Or just remove them from your list.
闯ü谤驳别苍
TWS 10.19 STK 100, 101, 104, 105, 106, 165, 220, 221, 225 232, 233, 236, 258, 292, 293, 294, 295, 318, 375, 411, 456, 460, 576, 577, 578, 586, 587, 588, 595, 614, 619, 623
TWS 10.29 STK 100, 101, 104, 105, 106, 165, 220, 221, 225, 232, 233, 236, 258, 292, 293, 294, 295, 318, 375, 411, 456, 460, 577, 586, 587, 588, 595, 614, 619, 623
On Sun, May 12, 2024 at 12:50 PM, JimInNeavitt wrote:
All,
I have a spreadsheet that has worked for years and updates a set of
stock, fund, and option prices. A week or so ago, it stopped updating
and gave me an error message as shown below.
I have an if condition in the cells that forms the RTD statement
according to whether the symbol is a stock or a fund as shown below.
The cell reference A269 is for the stock/fund symbol
STOCK
=RTD(RTD_SERVER,,A269,"Last")
FUND
=RTD(RTD_SERVER,,"sym="&A269,"cur=USD","exch=FUNDSERV","sec=FUND","qt=CLOSE")
I uninstalled both TWS as well as the API and reinstalled both. I had
been using the 9.81 API and am now on the new one. But, it didn't make
any difference. I get the same error. I also tried starting over again
with a brand new spreadsheet, but that didn't fix the problem. Anyone
have any suggestions?
Regards,
Jim
--------------------------------- ERROR MESSAGE
-------------------------------------------------------
"TwsRtdServer error: Error validating request.-'bP' : cause -
Incorrect generic tick list of
100,101,106,165,221,225,232,236,258,293,294,295,318,460,619,104,411,456,595,105,576,577,578,614,623,586.
Legal ones for (STK) are: 100(Option Volume),101(Option Open
Interest),105(Average Opt Volume),106(impvolat),165(Misc.
Stats),221/220(Creditman Mark Price),225(Auction),232/221(Pl
Price),233(RTVolume),236(inventory),258/47(Fundamentals),292(Wide_news),293(TradeCount),294(TradeRate),295(VolumeRate),318(LastRTHTrade),375(RTTrdVolume),411(rthistvol),456/59(IBDividends),460(Bond
Factor Multiplier),577(EtfNavLast(navlast)),586(IPOHLMPRC),587(Pl
Price Delayed),588(Futures Open Interest),595(Short-Term Volume X
Mins),614(EtfNavMisc(high/low)),619(Creditman Slow Mark
Price),623(EtfFrozenNavLast(fznavlast))"
|
