TR.FRNFormula field does not return date through eikondataapi

Question

Question by remi.latombe · Oct 15, 2019 at 03:38 PM · eikon python eikon-data-api workspace refinitiv-dataplatform-eikon workspace-data-api formula-builder

TR.FRNFormula field does not return date through eikondataapi

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 ?

excelfrnfrmula.png (15.0 KiB)

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-10-16T09:23:20Z

REFINITIV

Best Answer

Answer by chavalit.jintamalit · Oct 16, 2019 at 09:23 AM

Hi @remi.latombe

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

ahs.png (14.4 KiB)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2019-10-15T19:32:41Z

REFINITIV

Answer by zoya.farberov · Oct 15, 2019 at 07:32 PM

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

capture.gif (301.6 KiB)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2019-10-16T07:24:59Z

Answer by remi.latombe · Oct 16, 2019 at 07:24 AM

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.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 4 · 2019-10-17T08:03:38Z

Answer by remi.latombe · Oct 17, 2019 at 08:03 AM

Hello @chavalit.jintamalit

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

thanks a lot

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TR.FRNFormula field does not return date through eikondataapi

4 Replies

Watch this question

Related Questions