Function FxCalcPeriod() in Eikon API (Codebook)

Good afternoon,
I found many Functions and contents in Eikon API (Codebook) (/_Examples_/02 - Refinitiv Data Platform Library), however, there is no Function FxCalsPeriod() in Eikon API (Codebook).
Could you please suggest me how to use Function FxCalsPeriod() in Eikon API (Codebook) or could you please provide code for use this function in python codebook?
Best Answer
-
Hi @donnapa.limvipuwat ,
I'd like to add the answer from my colleague,
Here's an example of the code you can use
From this Excel Formular
=FxCalcPeriod("20MAR2021","EURUSD","1M")
To this Python code (using RDP library, executed in Eikon/Workspace Codebook)
import refinitiv.dataplatform as rdp
from refinitiv.dataplatform.content.ipa.contracts import cross
from refinitiv.dataplatform.content.ipa import FinancialContracts as fc
rdp.open_desktop_session('DEFAULT_CODE_BOOK_APP_KEY')
fwd_contract = cross.Definition(fx_cross_code='EURGBP',
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='2021-03-20'))
display(response.data.df)Compare the results
0
Answers
-
You can calculate start/end dates for an FX fwd or swap using RDP Library. See an example in the accepted answer on the following thread: https://community.developers.refinitiv.com/questions/66758/how-to-get-outrights-at-broken-dates-on-swap-point.html
0 -
Please may you advise how I can use the same code or similar to also clone the
=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.df0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 250 ETA
- 555 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛