Get all futures contracts from ticker or isin
Hi all,
I'm trying to find the query to get all futures contract info from the underlying isin / ticker.
More specifically, i would like to input the isin/ticker of a security and get all the futures contract on that security. The final goal of this would be to get the RIC code of these contracts.
Does anyone have an idea ?
Thanks,
Best Answer
-
Thank you for reaching out to us.
I can search all future RICs with an organization PermID by using the Refinitiv Data Library for Python.
First, I need to find an organizarion PermID for an ISIN.
df = rd.get_data(universe=['US02079K1079'],fields=['TR.OrganizationID'])
dfThen, use the Organization PermID to search for future RICs.
df1 = rd.discovery.search(
view=rd.discovery.Views.EQUITY_QUOTES,
select="DocumentTitle,RIC,UnderlyingQuoteRIC,DerivedCategory,AssetState",
filter=f"UnderlyingIssuerOAPermID eq '{df['Organization PermID'][0]}' and DerivedCategory eq 'FUTURE' and AssetState eq 'AC' and IsChain eq false",
top=10000
)
df1The samples are on GitHub. For more information regarding the search API, please refer to the Building Search into your Application Workflow article.
0
Answers
-
Thank you for this answer.
Is there a documentation where all possible filters are listed ? I would like to filter not by "UnderlyingIssuerOAPermID" but by underlying RIC, for exemple list all futures on the OMXC25CAP index.
Thanks
0 -
Hi @adam.leroux ,
You can use Advanced Search application as a helper in finding the available filters, please check this article for more detail Find content and functionality using Refinitiv Data Library with Eikon Advanced Search
0 -
Thanks for your answer.
How can i see the available filter in advanced search ? From what I've seen not all filter are in the "columns" section in AS.
In the attached screenshot, you see all the columns available for equity futures, and there is no "UnderlyingIssuerOAPermID" or "AssetState" for exemple.
Isn't there a documentation somewhere that lists all avaiable filter for each discovery.views ?Thanks,
0 -
For questions regarding the advanced search, please contact the helpdesk team directly via MyRefinitiv.
You can list all available fields by using the search metadata, as shown in the EX-2.06.03-Search-Metadata.ipynb example on GitHub.
To get all possible fields's values, you may use the navigators which provide the ability to summarize the distribution of your results. They are particularly useful when you are interested in gathering the domain of values for a specific property.
For more information, please rerfer to the Building Search into your Application Workflow article.
The examples are also on GitHub.
1
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 中文论坛