fx swap maturity

Hi,

I'm trying to get historical data for fx swaps in jupyter notebook (date, close , days_maturity). ek.get_timeseries only seems to show OHLC and volume.

I'm not quite sure on how to use the ek.get_date.

sd = "2020-06-01"

ed = "2020-06-05"

df,err= ek.get_data(["JPY1M=","JPY2M="],

['CF_DATE','CF_Last',"DAYS_MAT"],

{"SDate":sd, "Edate":ed})

Find more posts tagged with

python

eikon

maturity

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

swaps

Accepted answers

chavalit-jintamalit

Hi @gchiam

I am not Eikon Excel expert, but I can confirm that the "DAYS_MAT" and "MID_PRICE" fields that are exposed to Eikon Data API(Python) do not support timeseries.

However, I found these fields (I was hoping that Refinitiv Content Helpdesk would be able to give you these fields)

['TR.MIDPRICE.Date','TR.MIDPRICE','TR.DAYSTOMATURITY.Date','TR.DAYSTOMATURITY'],

All comments

pimchaya.wongrukun01

Hello @gchiam

To use get_data() function, you can refer to "Data Item Browser" which lists all fields and their parameters that you can set in this function.

Please refer to Using DIB as Reference section in this tutorial for more details of "Data Item Browser"

chavalit-jintamalit

Hi @gchiam

These fields (['CF_DATE','CF_Last',"DAYS_MAT"], ) are from a Realtime database, so they do not support SDate, EDate, and historical data retrieval.

I tried to locate the close, date, and days_maturity using "Data Item Browser" but I could not locate them. (I am not a content expert)

You can try using "Data Item Browser" following this tutorial.

Or you can contact Refinitiv Content Helpdesk to clarify if there are any fields carrying the information you are looking for.

I do have a quick question here.

From the data you can retrieve:

Can you calculate the data you need following this code:

df1,e = ek.get_data('JPY1M=','MATUR_DATE')
df1

df2 = ek.get_timeseries('JPY1M=', fields='Close', start_date='2020-06-01', end_date='2020-06-05')
df2

import datetime

date_time_obj = datetime.datetime.strptime(df1['MATUR_DATE'][0], '%Y-%m-%d')
date_time_obj

df2['days_maturity'] = date_time_obj- df2.index
df2

gchiam

Hi,

Thanks for the reply. I looked through the examples shown on the tutorial, it doesn't touch on FX swaps, and hence am not too sure about the DIB or the correct formatting. The problem with subtracting from df1 index is that the maturity dates are incorrect.

Df1 shows you today's 1m FX Swap maturity date. A 1June 1m FX swap will not have the same maturity date as the 8th june swap. Hence subtracting 8-jun fx swap from the historical data will not reflect the actual days to maturity. As shown in the df2 where days to maturity increase by 1 day each timestamp. When days to maturity should actually stay approx 30 days.

Regards,

Gerald

gchiam

Did this in excel using the function builder. Not excatly sure what NDA_RAW means. But seems to be the excel solution.

=RHistory("JPY1M=","NDA_RAW.Nda_date;NDA_RAW.Nda_days_maturity;NDA_RAW.Nda_mid","INTERVAL:1D",,"CH:Fd",D29)

But I can't find this fields in python using get_data ()

Regards,

Gerald

chavalit-jintamalit

Hi @gchiam

I am not Eikon Excel expert, but I can confirm that the "DAYS_MAT" and "MID_PRICE" fields that are exposed to Eikon Data API(Python) do not support timeseries.

However, I found these fields (I was hoping that Refinitiv Content Helpdesk would be able to give you these fields)

['TR.MIDPRICE.Date','TR.MIDPRICE','TR.DAYSTOMATURITY.Date','TR.DAYSTOMATURITY'],

EXPLORE OUR SITES