开云体育

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

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

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

I am not familiar with the Excel and RTD Server integration details. Maybe someone who is would know how to specify a genericTickList from within the spreadsheet. According to the "" page, no special "generic ticks" need to be specified during data subscription to get Last and Close prices.

The RTD Server source code contains some hard wired genericTick lists in file TwsRtdServerData.cs. The two types 576 and 578 are included in the list for STOCK market data requests even for TWS API 10.29. So for now, the only immediate workaround I can see is to use TWS 10.19.

And I would not call 10.19 an "old" version. It is the most stable TWS version available and while the "latest" 10.29 may have a few more features, it is the bleeding edge, very likely contains somewhat serious bugs, and definitely code that has not been battle tested yet. In fact the rejection of ticks 576 and 578 may actually be a bug since the TWS 10.29 release notes do not mention any generic tick retirement. Zou should file a ticket with IBKR.

I exclusively use TWS "standalone stable" versions in production.

闯ü谤驳别苍

Reverting to the 10.19 version did fix it. I typically use the online version and the automated updates seems to have got me in this case. IB seems to be pretty lax in their regression testing.
Thanks very much 闯ü谤驳别苍.

Jim

I just got warnings about 10.19 no longer being supported also, so I
installed the new 10.33.1e version (Latest Version) and all of my
stuff is working. But, I am using TWS and not the Gateway.
Best of luck!
Jim

On Fri, Jan 17, 2025 at 12:28?PM nfhill11 via groups.io
<nfhill11@...> wrote:

Hi Jim

I'm having the same issue when attempting to upgrade from IB Gateway v10.19 to v10.30 (as v10.19 will stop functioning in March). Did you ever find a longer fix to this issue or are are still using the older TWS/Gateway versions?

Any pointers would be great!

Thanks
Nick

Sorry, I forgot to look at my API version. I am running 10.30.01 for
my TWS_API. I had updated that when I had to replace my laptop and
found that the newer version was working fine with my older version of
the workstation.

On Fri, Jan 17, 2025 at 1:02?PM nfhill11 via groups.io
<nfhill11@...> wrote:

Thanks.

I just fixed it by downloading and installing the latest TWS API. Apparently you should download the latest version of the API along with TWS/IB Gateway to ensure everything works together. Weekend saved!