Price statistics
Product prices
Product price information originates from three different sources. When comparing and combining data, it should be remembered that the data are not always strictly comparable, as they are presented in different locations, e.g. the forest (EXW) or industry (DAP) and therefore differ e.g. in terms of transport costs. However, price trends are clearly visible.
- RMK (Estonia) – The average intermediate warehouse prices for products are displayed in the State Forest Management Centre. Prices are presented as roadside prices of roundwood (EXW) EUR/m3 net of VAT. Prices are automatically queried from the Excel file uploaded to the RMK website.
- Private Forest Centre (Estonia) – the final stockpile buying-in prices for the products, based on the buying-in prices offered by the Central Private Forest Cooperative and the Estonian Timbertrade Center), are displayed. Prices are presented as delivered to industry (DAP) EUR/m3 net of VAT. Prices are automatically queried from the Excel file uploaded to the RMK website.
- LUKE (Finland) – In Finland, the data is presented on a county-by-county basis. We requested the data for all of the represented counties, but grouped them ourselves into regions of Northern and Southern Finland. We assumed that prices in Northern Finland would be lower. According to the numbers, the difference seems to be minimal. Roundwood in Finland is measured together with the bark, while in Estonia it is measured without bark. Therefore, we also store the ‘adjusted’ Luke data in the data warehouse, for which we have adjusted the prices by -3% to make them comparable with prices in Estonia. Prices are shown as roadside prices of roundwood (EXW) EUR/m3 net of VAT. The data retrieval takes place via the API interface from the Luke website.
- LVM (Latvia) – In the future we will be adding…
Price information data collection process
Data sources typically upload up-to-date data themselves to their pages once a month, but the exact time of data publication varies somewhat from source to source and month to month. The robots of the EFWIA data warehouse check each data source every three hours (00:00, 03:00, 06:00, 09:00, 12:00, 15:00, 18:00, 21:00) to determine whether new data have been uploaded. When new data are found, they are processed according to the preset rules and stored in the EFWIA’s data warehouse. The data from the data warehouse are then instantly accessible by analytics software (Microsoft BI, Tableau, etc).
If a new file is added to the data warehouse or data are added (the number of rows increases), the data warehouse sends a corresponding notice to Kerli via e-mail. In order for fresh information to reach the EFWIA’s homepage (displayed in Tableau Publicus) Kerli must manually refresh the data. At present, the act of displaying data on the EFWIA’s website is solved in this way, since it does not require a costly licence that allows for automatic data updates.
The graph displays as the base value the average values of all selected (Private Forest, RMK, LUKE) data (average). From the menu on the right you can set filters and display, for example, only RMK price information.
Use the tabs ⬇️⬇️⬇️ to view different displays.
