Function FxCalcPeriod() in Eikon API (Codebook)

Question

question

william.smith01

1 ●1 ●1 ●2

Function FxCalcPeriod() in Eikon API (Codebook)

Please may you advise how I can use the same code from another question "https://community.developers.refinitiv.com/questions/83964/function-fxcalcperiod-in-eikon-api-codebook.html?" or similar to also clone the FX Calc period for a future valuation date?

=FxCalcPeriod("21MAR2022","USDKRW","1M") formula that works correctly in excel with future valuation dates "21MAR2022" (Assume todays actual date is 18th Mar 2022)

top dataframe returned is for todays date 18th Mar 22,

Bottom df is for future date since that works in Excel but seemingly not in python.

Formula works with future valuation_date that works (44641=21st March 2022)

import refinitiv.dataplatform as rdp

import refinitiv.dataplatform.eikon as rdp_ek
from refinitiv.dataplatform.content.ipa.contracts import cross
from refinitiv.dataplatform.content.ipa import FinancialContracts as fc

#%%
#%%

rdp.open_desktop_session(appkey)


fwd_contract = cross.Definition(fx_cross_code='USDKRW', 
                                fx_cross_type='FxForward',
                                legs = [cross.LegDefinition(tenor='1M')])
response = fc.get_cross_analytics(fwd_contract, 
                                  fields = ['StartDate',
                                            'EndDate',
                                            'FxSwapsCcy1Ccy2', 
                                            'FxOutrightCcy1Ccy2'],
                                 calculation_params = cross.CalculationParams(valuation_date='2022-03-21'))

response.data.df

eikon eikon-data-api python workspace refinitiv-dataplatform-eikon forwards

13828-capture.png (3.8 KiB)

13848-capture.png (24.9 KiB)

Mar 21, 2022 at 03:00 PM

10 |1500

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 · 2022-05-20T08:52:00Z

wasin.w

27.1k ●65 ●17 ●14

Hello @william.smith01

Please be informed that you can reopen cases 11059746 and 11059661 by sending an email to the support team with the intact subject. Then, the case will be reopened and the support team will take care of any further questions.

According to the Eikon support team, a solution for the original question is as follows:

Adfin function DfAddPeriod calculates start and maturity date based on valuation date and chosen currency rules that is why eg in case of USD when the valuation date is 23/03, start date will be 25/03 end date will be 25/04.
Do you need to calculate only the maturity date or swap points and outrights as well?

The FWD rates can be valuated as of today (tomorrow works as well) or any historical date.
So, for example if on Friday (25/03) you want to valuate contract as of Monday (28/03) it won't work because the valuation date in this case is today + 3D.
My suggestion is to keep current (today's) valuation date and just add StartDate parameter to force contract starting as of any future date you wish. EndDate will be calculated from StartDate automatically.

If you and to have Python equivalent of DfAddPeriod, we have API endpoint for this (script attached)
https://apidocs.refinitiv.com/Apps/ApiDocs#/details/L2RhdGEvcXVhbnRpdGF0aXZlLWFuYWx5dGljcy1kYXRlcy1hbmQtY2FsZW5kYXJzL3Yx/L2FkZC1wZXJpb2Rz/POST/PLAYGROUND

May 20, 2022 at 08:52 AM

10 |1500

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 · 2022-03-21T15:04:59Z

william.smith01

1 ●1 ●1 ●2

- Top dataframe returned is for todays date 18th Mar 22,

Bottom df is for future date since that works in Excel but seemingly not in python. Especially when todays date is before a weekend.

13848-capture-1.png (24.9 KiB)

Mar 21, 2022 at 03:04 PM

10 |1500

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 · 2022-03-21T16:32:38Z

nick.zincone

19k ●85 ●39 ●63

Hi @william.smith01

Yes, it appears the above code does not work for future valuation dates. You can actually confirm issues by introducing the field 'ErrorMessage' within the output. For example:

fwd_contract = cross.Definition(fx_cross_code='USDKRW', 
                                fx_cross_type='FxForward',
                                legs = [cross.LegDefinition(tenor='1M')])
response = fc.get_cross_analytics(fwd_contract, 
                                  fields = ['StartDate',
                                            'EndDate',
                                            'FxSwapsCcy1Ccy2', 
                                            'FxOutrightCcy1Ccy2',
                                            'ErrorMessage'],
                                 calculation_params = cross.CalculationParams(valuation_date='2022-03-23'))
 
response.data.df

response.data.df['ErrorMessage'][0]
"Invalid Date. Valuation date should be less or equal to '2022-03-21'"

I would suggest you reach out to Refinitiv support to confirm the service provides a way to compute based on a future date.

Mar 21, 2022 at 04:32 PM

10 |1500

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

raksina.samasiri Mar 21, 2022 at 04:43 PM

Hi @william.smith01 ,

ticket number 11059746 was raised for this case, the support team will contact you soon to assist on this.

william.smith01 Mar 21, 2022 at 05:31 PM

thank you @nick.zincone for your help checking out the cause /error. much appreciated

william.smith01 Mar 29, 2022 at 02:46 PM

I have tried like this, I am however still trying to get the below working:

=FxCalcPeriod(A55,"CNY IGNHOL:NO","1M","FROM:FXTRADE RET:2")

I am unable to get this to work in python, please may you assist?

a55 = 30/Mar/22 "2022-03-30"

it should return:

05/May/22

 eti_request_body_1m = [
  {
    "tag": "my request",
    "startDate": start_date_1m,
    "period": "1M",
    "calendars": [
      f"{ccy},USA"
    ],
    "dateMovingConvention": "NextBusinessDay",
    "endOfMonthConvention": "Same"
  }
]

eti_response_1m = vs_endpoint.send_request(method = rdp.Endpoint.RequestMethod.POST,
                                        body_parameters = eti_request_body_1m)

eti_response_1m.data.raw[0]['date']

Answer 4 · 2022-03-29T07:08:04Z

wasin.w

27.1k ●65 ●17 ●14

Hello @william.smith01

I have checked cases 11059746 and 11059661, the support team has provided a solution for you. Does it resolve the issue?

Mar 29, 2022 at 07:08 AM

10 |1500

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

william.smith01 Mar 29, 2022 at 02:40 PM

Hi there,

I will please require assistance on the remaining matter of deriving an equivalent of

=FxCalcPeriod(A55,"CNY IGNHOL:NO","1M","FROM:FXTRADE RET:2")

I am unable to get this to work in python, please may you assist?

a55 = 30/Mar/22 "2022-03-30"

it should return:

05/May/22

william.smith01 Mar 29, 2022 at 02:48 PM

I will please require assistance on the remaining matter of deriving an equivalent of

=FxCalcPeriod(A55,"CNY IGNHOL:NO","1M","FROM:FXTRADE RET:2")

I am unable to get this to work in python, please may you assist?

a55 = 30/Mar/22 "2022-03-30"

should output as per excel:

05/May/22

Jirapongse May 06, 2022 at 03:54 AM

@william.smith01

You can reopen case 11059661 by sending an email to the support team with the intact subject. Then, the case will be reopened and the support team will take care of any further questions.

Q&A Forum

question

Function FxCalcPeriod() in Eikon API (Codebook)

4 Answers

Write an Answer

question

Function FxCalcPeriod() in Eikon API (Codebook)

4 Answers

Write an Answer

Related Questions