This is the list of the available tables in our LNG excel add-in:
Trades
Allows you to have a comprehensive view of the cargo activities, including information such as quantity, loading or discharge location, loading and discharging dates as well as the players involved in the trades.
Filters
Our add-in allows you to filter trades using a variety of criteria. Here is an overview of the available filters:
Locations
Origins: Origin of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Destinations: Destination of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
· Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates
Origins: Start date of the trade. It is the end of the load if it occurred, or its Estimated Berth Departure if still to come.
Destination: End date of the port call. It is when the vessel is leaving the berth or the port/ anchorage/ canal if installation is unknown. If null, the port call is either yet to come or ongoing.
Vessels: Can be vessel names or vessel IMOs
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes XL (Upper Conventional), L (Lower Conventional), Q-Flex, XS (Pressure Gas), M (Med Max), S (Small Scale), and Q-Max
Players
Sellers: Seller of the cargo at the origin. It can be a list if multiple companies are potential sellers.
Buyers: Company buying the cargo on its delivery location.
· Booleans
Intra-Country: Takes into account the trades within the selected region.
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
With Forecast: Include trades predicted by our in-house model.
Flows
Allows you to have the aggregated the results of the table trades and gives a gives a global view of LNG flows.
Filters
Our add-in allows you to filter flows using a variety of criteria. Here is an overview of the available filters:
Locations
Origins: Origin of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Destinations: Destination of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Flows Directions : Import, Export, Net Volume
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Unit: Different units available in this table: Kt, Mt, MMbbl
Dates
Origins: Start date of the trade. It is the end of the load if it occurred, or its Estimated Berth Departure if still to come.
Destination: End date of the port call. It is when the vessel is leaving the berth or the port/ anchorage/ canal if installation is unknown. If null, the port call is either yet to come or ongoing.
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes XL (Upper Conventional), L (Lower Conventional), Q-Flex, XS (Pressure Gas), M (Med Max), S (Small Scale), and Q-Max
Splits: Allows you to breakdown the data by "Total", "Grades", "Products", "Origin Countries", "Destination Countries", "Origin Continents", "Destination Continents", "Origin Subcontinents", "Destination Subcontinents", "Origin Trading Regions", "Destination Trading Regions", "Origin Ports", "Destination Ports", "Origin Padds", "Destination Padds", "Origin Installations", "Destination Installations", "Vessel Type", "Vessel Type Oil", "Vessel Type Cpp", "Trade Status", "Sources", "Charterers", "Buyer", "Seller", "Routes".
Booleans
Intra-Country: Takes into account the trades within the selected region.
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
With Forecast: Include trades predicted by our in-house model.
Port Calls
Allows you to monitor the line up of vessels to do an operation at the port, country or regional level with their quantity and product information.
Filters
Our add-in allows you to filter port calls using a variety of criteria. Here is an overview of the available filters:
Zones: Zone of the port call. It can be a continent, a subcontinent, a region, a country, a port..
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the port calls.
Vessel: Can be vessel names or vessel IMOs
Booleans
Empty Volume: Provides access to the empty volume port calls. Only available via Freight subscription.
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
With Forecast: Include trades predicted by our in-house model.
Fleet Metrics
The fleet metrics table returns fleet data for a given zone.
Following metrics are available:
Floating storage
Commodity on water
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (daily, weekly, EIA-weekly basis ), and on a split level. With the ability to modify floating days for the floating storage query.
There is a micro level called “List of Vessels” where the user is able to retrieve data at the most granular level.
Filters
Our add-in allows you to filter fleet metrics using a variety of criteria. Here is an overview of the available filters:
Zones: Names of countries/geographical zones. Default to world if not specified.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Vessel: Can be vessel names or vessel IMOs
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes XL (Upper Conventional), L (Lower Conventional), Q-Flex, XS (Pressure Gas), M (Med Max), S (Small Scale), and Q-Max
Floating Days: Interval of the floating period duration.
Split: Allows you to breakdown the data by : "Total", "Grades", "Products", "Crude Quality", "Origin Countries", "Destination Countries", "Origin Continents", "Destination Continents", "Origin Subcontinents", "Destination Subcontinents", "Origin Trading Regions", "Destination Trading Regions", "Origin Ports", "Destination Ports", "Origin Installations", "Destination Installations", "Vessel Type", "Vessel Type Oil", "Vessel Type Cpp", "Trade Status", "Sources", "Charterers", "Buyer", "Seller", "Current Continents", "Current Subcontinents", "Current Countries", "Current Subregions", "Current Seas", "Floating Days"]. Default to Total if not specified.
Booleans
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
Ship-to-Ships
The ship-to-ships table allows to monitor direct transfer of cargo between two vessels.
Filters
Our add-in allows you to filter ship-to-ships using a variety of criteria. Here is an overview of the available filters:
Zones: Names of countries/geographical zones. Default to world if not specified.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Vessel: Can be vessel names or vessel IMOs
Booleans
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
Bills of Lading
The Bills of Lading table allows clients to access structured Import & Export Bill of Lading documents’ data obtained directly from the U.S. Customs and Border Protection agency.
Filters
Our add-in allows you to filter Bills of Lading using a variety of criteria. Here is an overview of the available filters:
Source: All, US Export Bill, US Import Bill
Dates:
Bill date: Start/End of the period when BL was issued
Movement date: Start/End of the period when export or import took place
Bill numbers: Bill of Lading Number
Port Calls IDs: Port Call IDs
Diversions
The diversions table allows to monitor historical and current diversions for all LNG vessels.
Filters
Our add-in allows you to filter diversions using a variety of criteria. Here is an overview of the available filters:
Zones: Names of the current countries/geographical zones. Default to world if not specified.
Future Zones: Names of the new expected zones after the diversion: countries/geographical zones. Default to world if not specified.
Cancelled Zones: Names of the cancelled destination: countries/geographical zones. Default to world if not specified.
Dates: An interval of the start and the end of the period.
Vessel: Can be vessel names or vessel IMOs. We can also filter by Vessel status: Loaded or Ballast.
Inventories
The Inventories table returns inland LNG stocks of a given point of interest, with a specific periodicity over a period. This is a macro level endpoint with aggregated values, where the user can aggregate the data through different periods (daily, weekly, EIA-weekly basis, monthly, yearly), and on a split level.
Filters
Our add-in allows you to filter inventories using a variety of criteria. Here is an overview of the available filters:
Zones: Names of countries/geographical zones. Default to world if not specified.
Installations: Name of installation
Dates: An interval of the start and the end of the period.
Split: Ability to break down the data by "byCountry", "byInstallation", "byOnshoreOffshoreStatus", "byPlayer", "byTankType", "total".
(- byInstallation is not usable if you are searching for World
-byOnshoreOffshoreStatus is usable only with addCommoditiesOnWater set to true. Otherwise you will get an error message.)
Booleans
Cargo Tracking: Use cargo tracking data to fill the blanks in between satellite images
Commodity on water: Provides total volume of inventories including offshore and offshore.
EIA Adjustments: Provides the ability to remove the EIA adjustment factor from inventory and capacity values.
Ballast Capacity
The ballast capacity table gives access to future vessel availability based on vessel future ETA towards a destination or our forecast model.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (daily, weekly, monthly ), and on a split level. With the ability to select a specific metric.
There is a micro level called “List of Port Calls” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter ballast vessels using a variety of criteria. Here is an overview of the available filters:
Metric: Vessel count or Deadweight for the aggregated value
Zones: Names of countries/geographical zones. Default to world if not specified.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Period: Daily, weekly, monthly
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes XL (Upper Conventional), L (Lower Conventional), Q-Flex, XS (Pressure Gas), M (Med Max), S (Small Scale), and Q-Max
Split: Ability to break down the data by country, source, vessel type and total
Booleans
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription
Congestion
The congestion table gives access to the congestion of vessels that are waiting to do an operation (Loading/Discharge) at port level, country, and regional level.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (daily, weekly, monthly and yearly) and on a split level. With the ability to select a specific metric.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter congestions using a variety of criteria. Here is an overview of the available filters:
Metric: Vessel count or Deadweight for the aggregated value
Zones: Names of countries/geographical zones. Default to world if not specified.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Period: Daily, weekly, monthly, yearly
Waiting Days: Time measured in days spent by vessels in the waiting zone
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes XL (Upper Conventional), L (Lower Conventional), Q-Flex, XS (Pressure Gas), M (Med Max), S (Small Scale), and Q-Max
Split: Ability to break down the data by port, country, installation, vessel type, vessel operations, waiting status, product, grade and total
Booleans
Include all vessels in waiting: Include vessels in the waiting zone not tagged as congestion (lays ups, open vessels, floating storage, distressed cargoes, etc)
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription
Fleet Development
The fleet development monitors fleet supply through available vessels, deliveries, scrapping method, contracting and compliance method.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (monthly, quarterly, and yearly) and on a split level. With the ability to select a specific aggregated metric.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter fleet development using a variety of criteria. Here is an overview of the available filters:
Metric: Active vessels, delivered vessels, demolished vessels or ordered vessels.
Aggregated Metric: To aggregate the data by vessel deadweight, vessel capacity or by vessel count.
Dates: An interval of the start and the end of the period.
Period: monthly, quarterly, and yearly
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes XL (Upper Conventional), L (Lower Conventional), Q-Flex, XS (Pressure Gas), M (Med Max), S (Small Scale), and Q-Max
Split: Ability to break down the data by compliance method, vessel type and total
Booleans
Order Book: Access vessels in fleet orderbook, scheduled for future delivery.
Fleet Utilization
The fleet utilization analyses the entire vessel fleet and determines at any given point in time, which polygons (mapped zones) are the vessels located in, how many are loaded with cargo and how many are empty.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (daily, weekly, monthly, quarterly, and yearly) and on a split level. With the ability to select a specific metric.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter fleet utilization using a variety of criteria. Here is an overview of the available filters:
Metric: Vessel count or Deadweight for the aggregated value
Previous Zones: Names of zones (port/region/country/continent) the vessel is coming from.
Current Zones: Names of zones (port/region/country/continent) the vessel is currently.
Next Zones: Names of zones (port/region/country/continent) the vessel is going to.
Direction: Cardinality of the direction.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Period: Daily, weekly, monthly, quarterly and yearly
Vessels: Can be vessel names or vessel IMOs
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes XL (Upper Conventional), L (Lower Conventional), Q-Flex, XS (Pressure Gas), M (Med Max), S (Small Scale), and Q-Max
Split: Ability to break down the data by product, state, vessel type, current zone, previous zone, next zone, direction and total.
Booleans
Distinct Aggregation: Show or hide distinct vessels.
Freight Metrics
The freight metrics table gives you access to shipping ton-mile demand and sources of demand volatility & review average speed and distance traveled by vessel fleets.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (monthly, quarterly, and yearly) and on a split level. With the ability to select a specific metric.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter freight metrics using a variety of criteria. Here is an overview of the available filters:
Metric: Ton Miles, Ton Days, Average Speed or Average Distance
Zones:
Origins: Origin of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Destinations: Destination of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Period: monthly, quarterly and yearly
Vessels: Can be vessel names or vessel IMOs
Vessel Status: Loaded or Ballast
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes XL (Upper Conventional), L (Lower Conventional), Q-Flex, XS (Pressure Gas), M (Med Max), S (Small Scale), and Q-Max
Split: Ability to break down the data by origin zones, destination zones, product, vessel type and total
Booleans
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
Contracts
The contracts table gives you access to a list of TUAs, LTAs, and Tenders for all LNG players, installations and zones.
Filters
Our add-in allows you to filter contracts using a variety of criteria. Here is an overview of the available filters:
Zones: It can be a continent, a subcontinent, a region, a country, a port or an installation.
Dates: An interval of the start and the end date of the beginning of the contract.
Players: Company buying or selling LPG. Actors of the contracts
Type: Type of the contract. It can be tenders, SPA, TUA or LTA
Outages
Access the full list of current, future, and historic outages, planned and unplanned, going back to 2016.
Filters
Our add-in allows you to filter outages using a variety of criteria. Here is an overview of the available filters:
Zones: Names of countries/geographical zones. Default to world if not specified.
Installation: Name of the installation.
Outage Type: Planned or Unplanned.
Dates: An interval of the start and the end of the period.
Installations
The table installation features the installation’s locations, types, ownerships and various characteristics.
Filters
Our add-in allows you to filter supply & demand using a variety of criteria. Here is an overview of the available filters:
Location: It can be a continent, a country, a port, an installation.
Players: Name of the owner of the installation.
Type: Exports or Import.