For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
remi.latombe avatar image
3 ●0 ●0 ●2

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 ?


eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiformula-builder
excelfrnfrmula.png (15.0 KiB)
icon clock
10 |1500

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

4 Answers

Upvotes
Accepted
chavalit-jintamalit avatar image
18.1k ●21 ●12 ●21

Hi @remi.latombe

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


ahs.png (14.4 KiB)
icon clock
10 |1500

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

Upvotes
zoya faberov avatar image
32.2k ●40 ●11 ●19

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)
icon clock
10 |1500

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

Upvotes
remi.latombe avatar image
3 ●0 ●0 ●2

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.



icon clock
10 |1500

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

Upvotes
remi.latombe avatar image
3 ●0 ●0 ●2

Hello @chavalit.jintamalit

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

thanks a lot


icon clock
10 |1500

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