Update 2022-08-01 – We improved the shipment detection algorithm, leading to an increased amount of detected shipments, adding another EUR 3.5 billion to the counter.
Update 2022-07-11 – Estimates of June pipelined oil data was missing for Europe. We fixed it, adding another EUR 2.8 billion to the counter.
Update 2022-06-26 – We have included February and March 2022 trade data in our pricing model. This may have impacted prices retroactively.
Update 2022-06-16 – Two important improvements were implemented:
- Oil leaving from Novorossiysk CPC terminal is now attributed to Kazakhstan rather than Russia;
- Pipelined gas entering Greece from Turkey at Kipi/Kipoi transmission point is now assumed to come from Azerbaidjan rather than Russia.
Additionally, we fixed a limitation that was excluding some of the shipments that took longer than a month to reach their destination.
Update 2022-05-13 – This is a significant update, with four majour changes:
- we have fixed a mistake that led us to overestimate pipelined gas imports from Russia (read more here);
- we have implemented a new methodology to attribute pipelined gas to individual European countries (read more here);
- we have added shipments loading at anchorage; and
- we have included January 2022 trade data in our price modeling.
Update 2022-05-04 – We fixed a bug pertaining to ship IMO / MMSI correspondance. As a result, several shipments that were not accounted for before were added to the counter.
Update 2022-04-25 – We improved the shipment detection methodology, allowing us to detect more shipments than previously. The counter data has therefore increased faster than usual over the past dew days, progressively integrating previously missing shipments.
Update 2022-03-17 – We now estimate the volume of crude oil, oil product and LNG shipments based on the aggregate cargo capacity (deadweight tonnage) of ships of different types leaving Russian ports to a European Union port, extracted from MarineTraffic.com.
We track ship voyages between Russian ports and ports in other countries using data from MarineTraffic.com and Datalastic, derived from ship location (AIS) data.
A voyage consists of a ship taking on cargo and departing from a Russian port, arriving in a non-Russian port and discharging cargo. More complex trips such as loading cargo from both a Russian and a non-Russian port are excluded. For crude oil tankers and LNG tankers, the type of cargo is known. We assume that oil products tankers and oil/chemical tankers carry oil products. Coal is transported by bulk carrier and general cargo ships which also carry many other types of cargo. We identified 25 “coal export terminals” within Russian ports that export coal. These are specific port locations that are associated with loading coal. When a vessel takes on cargo at one of these locations, we assume that the shipment is a coal shipment.
The amount of fuel transported in a shipment is estimated based on the cargo capacity (deadweight tonnage) of the ships, adjusted by the average ratio of ship capacity to reported customs volume. We validated this approach by aggregating the cargo capacity of shipments in the latest month with complete trade data (December 2021), and comparing these values to reported export volumes.
Trade volumes and pricing of fossil fuels (i.e. oil, coal, and gas) are often not available on hourly or daily basis, and neither are the terms for long-term contracts. To develop this counter, we therefore relied on some assumptions, as detailed below.
Other physical flows
For Europe, including Turkey, two main sources are being used for the following flows:
|Crude oil||Oil products||Fossil gas||Coal|
|Seaborne||AIS data||AIS data||AIS data||AIS data|
ENTSOG data is available on a daily and near real-time basis. Eurostat data, however, is only available on a monthly basis with a couple months of latency. We assume constant flows from the latest available data point til today.
Pipeline data for China is estimated by deducting seaborne shipments (estimated from AIS) from total imports as reported by Chinese customs.
Attribution of pipelined gas to individual European countries
Starting from 16 May 2022, we have implemented a new methodology to estimate pipeline gas imports from Russia to various European countries. We collect data from ENTSOG on flows between countries, at transmission interconnections for every single day. We then assume that on any given day, a country is a perfect ‘gas mixer’, that is, that all gas gets mixed before being consumed and/or re-exported. This allows us to attribute Russian gas consumption to countries that do not have direct connection with Russia. Read more about it here.
Fossil fuels are sold on a variety of contracts including fixed-price, indexed to average oil prices and indexed to other spot prices. This means that the revenue to the exporter is not directly proportional to the current spot price.
To estimate prices of fossil fuel trades in 2022, we first derive historical monthly average prices for imports from Russia to the EU from Eurostat, and to the rest of the world from UN COMTRADE, since the trade values are indicated both in physical and monetary terms. We then fit models between these historical prices and average monthly spot prices for the current month and with lags (Brent crude oil, TTF gas, Newcastle steam coal, Asian LNG, ARA coal). Models are built for main trading partners individually, and for the rest of the world as a whole.
After the start of the invasion, the reluctance of many traders to take cargoes from Russia has driven discounted pricing of Russian oil. We apply the discount between Brent and Urals crude prices to crude oil exports to Europe and the discount between Brent and ESPO to exports to Asia.
From December 5, 2022 onwards, we cap the price of crude oil carried aboard tankers owned or insured in the price cap coalition countries to the level of the price cap. From February 5, 2023, we will apply the cap respectively to oil products shipments.
Oil-indexed gas contracts have become less common over time, so we include a time interaction term in the model for pipeline gas prices. These models are then applied to current spot prices to estimate contract prices.
- Eurostat: https://ec.europa.eu/eurostat/databrowser/
- ENTSOG transparency platform: https://transparency.entsog.eu/
- UN COMTRADE: https://comtrade.un.org/Data/