I'm using VBA and the COM API to retrieve closing prices (CL_CLOSE). Here is a code snippet:
With myRTList .ErrorMode = DialogBox .Source = "IDN" .RegisterItems ricString, "CF_CLOSE" .StartUpdates RT_MODE_ONUPDATE End With
The variable ricString is a string with many instrument RICs (e.g "DBKGn.DE,BMWG.DE,BMWG_p.DE")
It works fine until I have more than 244 RICs in the string. In that case I receive an error "#360f AdxRtList:invalid item". Though my RICs in the string are okay..
--------------------------------------------------
AdfinX Real Time Error Message
ERROR #360f - AdxRtList : invalid item
--------------------------------------------------
I would appreciate some help.
@hans-hermann.kiessig
To register a large number of RICs in RegisterItems method use an array of strings (each element representing a RIC) instead of a single string of comma separated RICs.
AdxRtList.RegisterItems - how can I use ISIN instead of RIC?
AdxRtList - what RT_ITEM_STALE means?
Can I Control Eikon For Excel's Real Time Refresh Rate With VBA?
VBA API - Fetch CF_CLOSE with DEX2 doesn't work
How can I open an Eikon QuoteApp Window from Eikon Excel VBA for a source different than Q IDN Data?