Can we pull up the consolidated RIC for Warrants using their CUSIP in API Codebook?
Hello team,
I'm using Python API. I use the below query to retrieve Consolidated RIC for Equities by their CUSIP. I need to retrieve consolidated RIC for other security types (Warrants, Bonds, Options). When I tried to use the same query for Warrants it did not work. Looks like Warrants do not have "ExchangeType" field available. Same issue with Options. Please advise how I can pull Consolidated RIC for Warrants and Options. Here is my query for equities:
1. Equity query:
df1 = rd.discovery.search(
view=rd.discovery.Views.SEARCH_ALL,
top=10,
filter=f"(AssetState ne 'DC' and ExchangeType eq 'Consolidated' and (RCSExchangeCountryLeaf eq 'Canada') and RCSCurrencyLeaf eq 'Canadian Dollar' and (CUSIP in ('929082105') or CinCUSIP in ('929082105')))",
select = "DTSubjectName,AssetState,ExchangeName,ExchangeType,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,RCSTRBC2012Leaf,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,CUSIP,CinCUSIP,SEDOL,RCSExchangeCountryLeaf"
)
df1
Returns:
2. Warrant query with ExchangeType eq 'Consolidated' filter:
df2 = rd.discovery.search(
view=rd.discovery.Views.SEARCH_ALL,
top=10,
filter=f"(AssetState ne 'DC' and ExchangeType eq 'Consolidated' and (RCSExchangeCountryLeaf eq 'Canada') and RCSCurrencyLeaf eq 'Canadian Dollar' and (CUSIP in ('09238B118') or CinCUSIP in ('09238B118')))",
select = "DTSubjectName,AssetState,ExchangeName,ExchangeType,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,RCSTRBC2012Leaf,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,CUSIP,CinCUSIP,SEDOL,RCSExchangeCountryLeaf"
)
df2
Returns: Nothing
3. Warrant query without ExchangeType eq 'Consolidated' filter:
df3 = rd.discovery.search(
view=rd.discovery.Views.SEARCH_ALL,
top=10,
filter=f"(AssetState ne 'DC' and (RCSExchangeCountryLeaf eq 'Canada') and RCSCurrencyLeaf eq 'Canadian Dollar' and (CUSIP in ('09238B118') or CinCUSIP in ('09238B118')))",
select = "DTSubjectName,AssetState,ExchangeName,ExchangeType,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,RCSTRBC2012Leaf,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,CUSIP,CinCUSIP,SEDOL,RCSExchangeCountryLeaf"
)
df3
Returns multiple rows. The Exchange Type column is missing. No way to identify which one is Consolidated RIC.
When I insert Warrant Cusip into "my_cusip" variable in the above query it doesn't return anything. I need to remove ExchangeType eq 'Consolidated' from the filter to retrieve Warrant data. However, it returns data for multiple exchanges and I need only "Consolidated" RIC. Please advise.
Thank you!
Best Answer
-
Thank you for reaching out to us.
You can try the IsConsolidated field.
df2 = rd.discovery.search(
view=rd.discovery.Views.SEARCH_ALL,
top=10,
filter=f"(AssetState ne 'DC' and IsConsolidated eq true and (RCSExchangeCountryLeaf eq 'Canada') and RCSCurrencyLeaf eq 'Canadian Dollar' and (CUSIP in ('09238B118') or CinCUSIP in ('09238B118')))",
select = "DTSubjectName,AssetState,ExchangeName,ExchangeType,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,RCSTRBC2012Leaf,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,CUSIP,CinCUSIP,SEDOL,RCSExchangeCountryLeaf"
)
df2The output is:
0
Answers
-
Hi @Jirapongse, thank you for replying back to me and the confirmation - this is indeed very helpful.
Can you please confirm if we have a documentation on all possible filter options in the below query under filter field:
f2 = rd.discovery.search(
view=rd.discovery.Views.SEARCH_ALL,
top=10,
filter=f"(AssetState ne 'DC' and IsConsolidated eq true and (RCSExchangeCountryLeaf eq 'Canada') and RCSCurrencyLeaf eq 'Canadian Dollar' and (CUSIP in ('09238B118') or CinCUSIP in ('09238B118')))",
select = "DTSubjectName,AssetState,ExchangeName,ExchangeType,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,RCSTRBC2012Leaf,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,CUSIP,CinCUSIP,SEDOL,RCSExchangeCountryLeaf"
)
df2Thank you so much!
0 -
Hi @Jirapongse, good day. May we follow up on the above query?
Do we have any documentation on all possible filter options in the below query under "filter" field (in bold):
f2 = rd.discovery.search(
view=rd.discovery.Views.SEARCH_ALL,
top=10,
filter=f"(AssetState ne 'DC' and IsConsolidated eq true and (RCSExchangeCountryLeaf eq 'Canada') and RCSCurrencyLeaf eq 'Canadian Dollar' and (CUSIP in ('09238B118') or CinCUSIP in ('09238B118')))",
select = "DTSubjectName,AssetState,ExchangeName,ExchangeType,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,RCSTRBC2012Leaf,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,CUSIP,CinCUSIP,SEDOL,RCSExchangeCountryLeaf"
)
df20 -
To get the completed lists of all possible valuse of fields, you need to contact the helpdesk support team via MyRefinitiv.
However, you can 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 example:
response = search.Definition(
view = search.Views.SEARCH_ALL,
top=0,
navigators="RCSExchangeCountryLeaf"
).get_data()
response.data.raw["Navigators"]["RCSExchangeCountryLeaf"]["Buckets"]The output is:
For more information, please rerfer to the Building Search into your Application Workflow article.
The examples are also on GitHub.
0 -
Thanks all! This is very helpful.
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 中文论坛