I'm using the example vb code downloaded from
however I can't seem to retrieve the Strike Price for an option. The option I'm trying to get the strike price.
I enter AAPLH051609500.U in the Instruments list, and STRIKE_PRC in the Fields list, but I get an Error stating "Error : STRIKE_PRC is not a valid request parameter."
However when I use RDATA in excel it works fine. What am I missing?
To retrieve STRIKE_PRC, you can use AdxRtList instead of RDATA. Please see Tutorial 2 in this example. The example is C#.
AdxRtList = eikonConnect.CreateAdxRtList(); AdxRtList.OnUpdate += new IAdxRtListEvents_OnUpdateEventHandler(adxRtList_OnUpdate); AdxRtList.OnStatusChange += new IAdxRtListEvents_OnStatusChangeEventHandler(adxRtList_OnStatusChange); AdxRtList.Source = "IDN"; AdxRtList.RegisterItems("AAPLH051609500.U", "STRIKE_PRC"); AdxRtList.StartUpdates(RT_RunMode.RT_MODE_ONUPDATE);
STIKE_PRICE is one of the fields on the real-time record AAPLH051609500.U, i.e. something you can view with the Quote app. The names for the real-time fields are capitalised, so it is easier for you to recognise them.
RData (or the =TR function) knows which database to query when you select the field in Formula Builder in Excel. The fields that require the use of AdfinX Real-time or the .NET Data API are kept in the Data Items of the Formula Builder under the Real-time category. Everything else in the Data Items can be accessed with DEX2.
Hope this helps!