question

Upvotes
Accepted
1 0 1 2

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

eikoneikon-com-apiexcelvesselinteractive-provider
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
4.6k 26 7 22

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.