I'm trying to find out how I can translate the following function found in our excel document.
=@RHistory(".MERF0C4","NDA_RAW.Nda_spread","START:"&$C$46&" END:"&$C$46&" INTERVAL:1D")
Into a request built within EikonDataAPI (C# library)?
Update:
1. I can get the current days value using
eikon.GetData(".MERF0C4", "GEN_VAL10")
but try as I might I can't get historical values. Everything I try returns missing as the only value.
2. This other excel functions retrieves the same info if it helps translate the function.
=@RHistory(".MERF0C4","ROAS.Timestamp;ROAS.Value","START:01-Oct-2020 END:19-Oct-2020 INTERVAL:1D",,"TSREPEAT:NO",W37)
I've tried to extrapolate what it could be but nothing seems to work. I pasted bellow my current attempt with a sample or alternatives I've tried.
var dictParam = new Dictionary<string, string>();
dictParam.Add("SDATE", "01-Oct-2020");
//dictParam.Add("NBROWS", "50");
dictParam.Add("SORT", "ASC");
dictParam.Add("INTERVAL", "1D");
var fields = new List<string>();
//fields.Add("GEN_VAL10");
//fields.Add("TR.ROAS");
fields.Add("TR.NDA_raw");
//fields.Add("FIELDS");
var instruments = new List<string>();
instruments.Add(".MERF0C4");
var abdc = eikon.GetDataRaw(instruments, fields, dictParam);
