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

Nitti.Thapa

I want to get a snapshot of all the LPG VLGC vessels status at a certain time in history (for example, 31^st 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

…

…

…

…

…

jason.ramchandani01

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

chavalit-jintamalit

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.