Hi team! I have been asked to reach out to you guys from the helpdesk for a query for my client t...

Nitti.Thapa
Nitti.Thapa LSEG
in Eikon Data APIs

...hey need to get a snapshot of all the LPG VLGC vessels status at a certain time in history (for example, 31st march 2020). Can it done by Eikon Data API?

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

…

…

…

…

…


Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    @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)

    image

    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

    image

    I hope this can help.

Answers

Categories