symbology conversion for ATM Implied volability RICs
Hello I am wondering if it is possible to convert a stock/etf RIC into the corresponding at the money implied volatility RIC.
the following code will not provide an answer:
df,e = ek.get_data('ASML.AS',
['TR.30DAYATTHEMONEYIMPLIEDVOLATILITYINDEXFORPUTOPTIONS.Date',
'TR.30DAYATTHEMONEYIMPLIEDVOLATILITYINDEXFORPUTOPTIONS'
],
{'SDate':'20200903','EDate':'20210902','Frq':'D'})
this will result into the following error
code col message row
1 412 1 Unable to resolve all requested identifiers. 0
2 412 2 Unable to resolve all requested identifiers. 0
However the following code will reply the correct answer:
df,e = ek.get_data('ASMLATMIV.EX',
['TR.30DAYATTHEMONEYIMPLIEDVOLATILITYINDEXFORPUTOPTIONS.Date',
'TR.30DAYATTHEMONEYIMPLIEDVOLATILITYINDEXFORPUTOPTIONS'
],
{'SDate':'20200903','EDate':'20210902','Frq':'D'})
Of course for a single stock this can be sorted out by hand. Bur for managing a portfolio this can become quite cumbersome.
Moreover when I search in the terminal for ASMLATMIV I get the following results:
This means that there are multiple options and that a guessing an ATM IV RIC can be quite dangerous.
For ASML this is the case because ASML is traded at two exchanges (ASML.AS (EUR, Amsterdam) and ASML.O(USD, N.Y.)). Why the search results shows the RIC of Allianz a german insurance company (ALVG.DE) is a complete mystery to me.
There I am wondering if and how it is possible to do a conversion from a stock or option RIC to an ATM implied volability RIC in either eikon or RDP.
thanks,
Laurens
Best Answer
-
Hi Laurens,
I am not aware of a direct way of conversion, but it seems the structure of at the money implied volatility RIC is as following (you can confirm this from the Content team as well):
1. First part of the Asset RIC, such as ASML, IBM etc.
2. ATMIV - standing for At The Money Implied Volatility
3. Exchange Identifier. This seems the most challenging one, because as you already noticed a stock can be traded in multiple exchanges.
Taking into consideration all this, I would suggest, first retrieving all ATMIV RICs for a given asset using RDP search. Please see below examples for ASML and IBM:
response = rdp.search(
query = 'ASMLATMIV*',
select = 'RIC')
responseresponse = rdp.search(
query = 'IBMATMIV*',
select = 'RIC')
responseNow as you have all possible ATMIV RICs for a given asset, you can then loop over all ATMIV RICs or use only the one you are interested in and request the volatility data using your code.
Hope this was helpful, please let me know should you have any further questions
0
Answers
-
I have added UnderlyingQuoteRIC property as well, which shows the corresponding RIC. Additionally, I changed the filter value a bit, from 'ASMLATMIV*' to 'ASML*ATMIV*' . This allows to get weekly options as well (Feel free to use the 'ASMLATMIV*' filtering criteria if you don't need them).
Here is the code and the output
response = rdp.search(
query = 'ASML',
filter = "RIC eq 'ASML*ATMIV*'",
select = 'RIC, DocumentTitle, UnderlyingQuoteRIC'
)
responseHere again, you can notice that underlying for 'ASMLATMIV.EX' is ALVG.DE instead of ASML.AS. This is a content related issue I believe and I would advice submitting a query to content team via my.refinitiv.com.
Other than that, the code is working and you can scale that to other equities/assets.
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 中文论坛