For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
I am not able to get date for the field TR.FRNFormula while it is returned through excel. I try different parameter set with RH:D but it has no impact on the result return.
My C# code is the following:
IEikon eikon = EikonDataAPI.Eikon.CreateDataAPI(); eikon.SetAppKey("xxxx"); Frame<int, string> frnformula = eikon.GetData("XS1150673892", "TR.FRNFormula", new Dictionary<string, string>() { { "RH", "D" }, { "CH", "Fd" }, { "SDate", "2000-01-01" }, { "EDate", "2050-01-01" } }); frnformula.Print();
I tried to play a bit with different set of parameters but it does not change the outpu which is
Instrument FRN Formula 0 ->XS1150673892 4.2 1 ->XS1150673892 EURSWE5Y + 3.797 2 ->XS1150673892 EURSWE5Y + 4.047 3 ->XS1150673892 EURSWE5Y + 4.797
While in Excel I have this with the equivalent formula
Am I doing something wrong ?
Hello @remi.latombe,
What date are you looking for?
I am running:
df = ek.get_data(['XS1150673892'], ['TR.FRNFormula','TR.FIIssueDate','TR.FIMaturityDate'], {'RH':'D','CH':'Fd','sdate':'01/01/2000','edate':'01/01/2050'})
Getting:
Instrument FRN Formula Issue Date Maturity Date
0 XS1150673892 4.2 2014-12-10 2075-06-10
1 XS1150673892 EURSWE5Y + 3.797
2 XS1150673892 EURSWE5Y + 4.047
3 XS1150673892 EURSWE5Y + 4.797
To identify the available data fields via search use Eikon -> Data Item Browser
I want to get dates related to the FRN Formula as in the screen I showed (E column) which are differents of issue date and maturity date.