How to get outrights at broken dates on Swap Points App (SPO)
In Swap Points App (SPO), I can get like EURUSD values in a curve and I can specify the broken dates to get points in the middle of that curve vertices. How can I do that in the API?
Best Answer
-
You can use Refinitiv Data Platform Library for this purpose. The library is not yet officially supported, but you can install a pre-release version from PyPI. You can find examples of using this library to price financial contracts in Codebook File Browser under Examples / 02 - Refinitiv Data Platform Library / 2.7.x - Content - Financial Contracts - ...
And you can find the documentation for contract definitions and output fields on Refinitiv Data Platform APIs page on this portal under Documentation - Manuals & Guides - IPA Financial Contracts - IPA Financial Contracts: FX Cross Contracts.
Here's a quick example returning mid swap points and outright for EURGBP forward ending 3 months and 10 days from spot.
import refinitiv.dataplatform as rdp
rdp.open_desktop_session(your_app_key)
from refinitiv.dataplatform.content.ipa.contracts import cross
from refinitiv.dataplatform.content.ipa import FinancialContracts as fc
fwd_contract = cross.Definition(fx_cross_code='EURGBP',
fx_cross_type='FxForward',
legs = [cross.LegDefinition(tenor='3M10D')])
response = fc.get_cross_analytics(fwd_contract,
fields = ['StartDate',
'EndDate',
'FxSwapsCcy1Ccy2',
'FxOutrightCcy1Ccy2'])
display(response.data.df)0
Answers
-
Hello Alex,
Good day!
The client is using similar formula as above to retrieve the FX Forward and Outrights for USDSGD for 1Y.
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('e6fae31d22dc4ffe8d72e8140f0df82412a8f248')
fwd_contract = cross.Definition(fx_cross_code='SGD',
fx_cross_type='FxForward',
legs = [cross.LegDefinition(tenor='1Y')])
response = fc.get_cross_analytics(fwd_contract,
fields = ['StartDate',
'EndDate',
'FxSwapsCcy1Ccy2',
'FxOutrightCcy1Ccy2'],
calculation_params = cross.CalculationParams(valuation_date='2023-01-03'))
response.data.df.iloc[0][1]
However, the client is trying to retrieve similar information for multiple tenors. Client is trying to retrieve similar to the attached sheet. They wish to retrieve the same data as excel using Python, one that can extract more than one tenor at a time.
See sample screenshot:
Once again, appreciate all the help.
Regards,
Kris Abigail Hilvano
Specialist, Desktop Trading
0 -
@kris.hilvano
The accepted question will not be monitored. Please post this question as a new question. Moreover, Alex has left the company.
0 -
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛