Skip to content
This repository has been archived by the owner on Mar 31, 2021. It is now read-only.

Take into account consumer price indices v0 #373

Closed
martincollignon opened this issue Apr 1, 2020 · 3 comments · Fixed by #382
Closed

Take into account consumer price indices v0 #373

martincollignon opened this issue Apr 1, 2020 · 3 comments · Fixed by #382
Assignees

Comments

@martincollignon
Copy link
Contributor

martincollignon commented Apr 1, 2020

EXIOBASE relies on numbers from the past. The data we're currently using is from 2011.

To improve the accuracy of our carbon equivalent numbers, we should take into account changes in prices since 2011, and then the currency exchange from 2011 as EXIOBASE is in €.

Steps to get the adjusted price:

  1. Use index from the proper country (fallback:OECD average data)
  2. Use index from the latest available date
  3. Use index from the most precise COICOP category (fallback: total CPI index)
  4. Convert the price adjusted by the indexes to EUROS

Development priority

  1. Convert prices to Euros
  2. CPI from the proper country from 2019

Structure of files:

exchangerate.yml:

  • currency pair
    --- year
    ---- month

consumerpriceindices.yml

  • country (ISO2)
    -- COICOP category
    --- year
    ---- month

Current data available:

@corradio corradio changed the title Take into account consumer price indices and exchange rates for EXIOBASE input-output models Take into account consumer price indices Apr 21, 2020
@corradio
Copy link
Member

corradio commented Apr 21, 2020

@pierresegonne: @martincollignon and I wrote a brief here to specify better the task:
https://www.notion.so/tmrow/CPI-brief-a125471890544282a657b42b11a2bf21

@martincollignon will follow up with you!

@pierresegonne
Copy link
Member

@martincollignon do you know from where exactly you obtained the OECD excel file? I'll add it to the PR once I have the link :)

@martincollignon
Copy link
Contributor Author

https://stats.oecd.org/Index.aspx?DataSetCode=PRICES_CPI#

Without knowing which numbers you have in the PR, I've pulled the latest ones just to make sure here.
6cbdd8cd-f015-448f-a1c4-54a9cb63c987.xlsx

@pierresegonne pierresegonne changed the title Take into account consumer price indices Take into account consumer price indices v0 May 1, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants