Time series for normal implied vol for swaptions.
Hi,
I'm trying to retrieve time series for normal vol for swaptions (as a default eikon gives lognormal vol); using excel api, the following retrieves the desired data, but how to do this in the python api? thanks
=RHistory("USD3MX10YATM=R","NORMALIZED VOLATILITY.Timestamp;NORMALIZED VOLATILITY.Value","INTERVAL:1D",,"TSREPEAT:NO CH:Fd",K9)
Best Answer
-
Hi @miguel.costa,
I don't see where the helpdesk indicated the timeseries data was available. I can certainly see the FIDs 393 and 1032 when using the get_data() API call, but only the latest values.
Can you provide the code you are trying to use to "retrieve normal vols"? FYI, the Eikon Data API cannot retrieve all data within Eikon. For example, the get_timeseries() is presently limited to a single view of data, i.e. HIGH, LOW, OPEN, CLOSE, VOLUME.
0
Answers
-
Hi @miguel.costa,
Looking within the DIB (Data Item Browser), I don't see any timeseries data available for: USD3MX10YATM=R using the get_data() API call. There are some daily data points such as OPEN, CLOSE, HIGH, LOW available, but there is no timeseries view available to retrieve the Normalized Volatility:
Please reach out to the Refinitiv Helpdesk to confirm whether or not this content is available.
0 -
Thanks for your answer. I spoke with the helpdesk and they suggested that I follow this up with the community forum. The time series data is indeed available, this is what they said:
"For USD, normal vol is the input but lognormal vol is calculated and published to the same RICs. If you are referring to FID usage or any other mapping, we always use FID393 for lognormal and 1032 for normal vol which are the same for all currencies regardless of the inputs."
Is there any way to use this info to retrieve normal vols via the api? I have tried and failed; I do hope that it is not the case that only a subset of eikon data is available via the eikon api.
Thanks for your time.
0 -
Thanks for your answer. I spoke with the helpdesk and they suggested that I follow this up with the community forum. The time series data is indeed available, this is what they said:
"For USD, normal vol is the input but lognormal vol is calculated and published to the same RICs. If you are referring to FID usage or any other mapping, we always use FID393 for lognormal and 1032 for normal vol which are the same for all currencies regardless of the inputs."
Is there any way to use this info to retrieve normal vols via the api? I have tried and failed; I do hope that it is not the case that only a subset of eikon data is available via the eikon api.
0 -
The only was I was able to retrieve the time series was with the excel API call I posted above - not with the data api. again, it is disappointing that only a subset of the data is available with the data api. certainty a new feature you guys should be adding. In any case, thanks for your time.
0 -
Hello,
@miguel.costa
@nick.zincone !Please do you have any news of normal Vol via python api?
thanks!0 -
You should be able to retrieve this historical data via the Data Library for Python:
rd.get_history(universe="USD3MX10YATM=R", fields=["NORMV_OMID"], start="2019-10-31")
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 中文论坛