TR.FRNFormula field does not return date through eikondataapi

remi.latombe
remi.latombe Newcomer
in Eikon Data APIs

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

image


Am I doing something wrong ?


Tagged:

Best Answer

Answers

  • zoya faberov
    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

    image

  • remi.latombe
    remi.latombe Newcomer

    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
    remi.latombe Newcomer

    Hello @chavalit-jintamalit

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

    thanks a lot


Categories