Is it possible to extract live vessel data from the interactive map to Excel?

Find more posts tagged with

eikon

excel

vessel

eikon-com-api

You can build a search request for the vessel identifiers, and then request the data.The output of the search function is limited to 2000 items.

For example:

Searching for Vessels in the Baltic Bulker Zone carrying Coal: =RSearch("PHYSICALASSET",{"RCSAssetTypeGenealogy","F:K";"RCSRegionGenealogy","M:1GB/G:2QK";"RCSCommodityTypeGenealogy","U:H"},"NBROWS:2000",,)
Using the identifiers from the search as an input to the TR function: =TR("C}BO7309635242","TR.AssetLocationDate;TR.AssetLocationLatitude;TR.AssetLocationLongitude",,)

Hope this helps.

You can build a search request for the vessel identifiers, and then request the data.The output of the search function is limited to 2000 items.

For example:

Searching for Vessels in the Baltic Bulker Zone carrying Coal: =RSearch("PHYSICALASSET",{"RCSAssetTypeGenealogy","F:K";"RCSRegionGenealogy","M:1GB/G:2QK";"RCSCommodityTypeGenealogy","U:H"},"NBROWS:2000",,)
Using the identifiers from the search as an input to the TR function: =TR("C}BO7309635242","TR.AssetLocationDate;TR.AssetLocationLatitude;TR.AssetLocationLongitude",,)

Hope this helps.