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.
´³¨¹°ù²µ±ð²Ô
On Sun, May 12, 2024 at 03:47 PM, JimInNeavitt wrote:
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
|
