Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
I want to get a snapshot of all the LPG VLGC vessels status at a certain time in history (for example, 31st march 2020). So it will be something like:
Example:
No.
Time
VLGC
Latitude
Longitude
Draft
Status
1
31/03/2020
Gas Taurus
…
….
9.6m
Underway using Engine
2
31/03/2020
Gas Summit
…
…
…
…
3
31/03/2020
…
…
…
…
…
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
@Nitti.Thapa To do this you would need to use two of our APIs - firstly RDP Search API and then Eikon Data API.
import eikon as ek
import refinitiv.dataplatform as rdp
ek.set_app_key('Your App Key Here')
rdp.open_desktop_session('Your App Key Here')
dfRic = rdp.search(view = rdp.SearchViews.VesselPhysicalAssets, query = 'LPG Tanker and VLGC not yard',
top=10000)
display(dfRic)
then we take our list of RICs and pass them to the Eikon Data API get_data function:
fields =['TR.AssetName','TR.AssetType','TR.AssetSubType','TR.AssetSubSubType','TR.AssetImo','TR.AssetLocationDate','TR.AssetLocationLatitude','TR.AssetLocationLongitude']
df,err = ek.get_data(dfRic['RIC'].astype(str).values.tolist(),fields,{'SDate':'2020-03-18','VDT':'True'})
df
I hope this can help.
Hi @Nitti.Thapa
You need to know identifiers and fields.
Here is an example:
You can use "Data Item Browser" to search for the field name.
