I try to translate excel formulas to code in C# COM API
AdxRtList.Source = "IDN";
primaryRIC = "GB063345849=RRPS";
AdxRtList.RegisterItems(primaryRIC, "CF_BID"); -- It works Ok
But when I call historical Bid for date
dayNum = 43409
In debug mode I see "AdxRtList invalid field", and update event brings NULL
The source excel formula is:=TR($B$3;"TR.BIDPrice(Sdate=#1)";;;CalcDate)
where $B$3 = "GB063345849=RRPS and CalcDate = 05.11.2018 (i suppose that it is 43409 translating #05.11.2018)
How does the right syntax look in C#, when I add parameter calling TR.BIDPrice?
To retrieve fields that start with "TR." using Eikon COM APIs you need to use a separate library named DEX2. See the link below for a tutorial.
Alternatively instead of Eikon COM APIs you may want to consider using Eikon Data APIs library for .NET, which is capable of retrieving both real-time fields and fundamental & reference data set (fields that start with "TR."), albeit at the moment it can only retrieve snapshot real-time data. The capability to retrieve streaming real-time data will be introduced in future versions.