Help with AdxRtList invalid field error calling TR.BIDPrice in C#

I try to translate excel formulas to code in C# COM API

I call

AdxRtList.Source = "IDN";

primaryRIC = "GB063345849=RRPS";

AdxRtList.RegisterItems(primaryRIC, "CF_BID"); -- It works Ok

But when I call historical Bid for date

dayNum = 43409

AdxRtList.RegisterItems(primaryRIC, string.Format("BIDPrice(Sdate:{0})",dayNum));


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?




Best Answer

Answers