TR.FRNFormula field does not return date through eikondataapi

remi.latombe

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 ?

chavalit-jintamalit

Hi @remi.latombe

Can you try adding "TR.FRNFormula.Date" field to your request?

zoya faberov

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

remi.latombe

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.

remi.latombe

Hello @chavalit.jintamalit

yes this is working with the field TR.FRNFormula.Date

thanks a lot