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))"
