Symbology conversion for vessel IMOs
Hi,
I have a list of vessels for which I have the IMO numbers (more than 20,000 vessels) and I would like to get the RICs for these vessels. There seems to be no data item for Vessel RIC and hence Eikon Get Data functionality wont be helpful. RDP search for Vessel Physical assets can be one option but I am not sure how to pass a list as a filter within the arguments. Is that possible? Or is there a way to use symbology conversion to convert the IMOs to RICs.
Best Answer
-
You can use Refinitiv Data Library for Python.
IMO_List=['9619907', '7313652', '9131034']
filter_str = 'IMO in ('+' '.join(["'{}'".format(value) for value in IMO_List]) +')'
rd.discovery.search(
view = rd.discovery.Views.SEARCH_ALL,
top = 100,
filter = filter_str,
select = "IMO, RIC, AssetName"
)The code above creates a filter string from a list of IMO. Then, it calls the rd.discovery.search method to get the result.
The output is:
0
Answers
-
I used the Map app to find a vessel:
And used its number as a ric in the DIB:
Is this the kind of info you're after? It shows all the fields available in the RD Library (for Python or other languages) (which is the newer version of the Eikon Data API Library) for that one RIC.
0 -
You can use the /discovery/search/v1/ endpoint to find RICs from IMOs.
The query can look like this:
{
"View": "SearchAll",
"Filter": "IMO in ('9619907' '7313652' '9131034')",
"Select": "IMO, RIC, AssetName"
}The output is:
1 -
Hi. This works well but the question is how can I pass say a list of IMOs in the filter argument. Currently you have provided a fixed set of vessels. I tried to use an f-string to pass the required list of IMOs but the search query returns null0
-
The DIB was helpful to check for the RICs and I can see CF_NETCHNG provides the RIC when I pass an IMO. However when I try to use it in the get_data using rdp library I dont get any results. Currently not using the RD library.
0 -
This works perfectly fine. Thanks a lot.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 中文论坛