# https://economy-finance.ec.europa.eu/economic-research-and-databases/economic-databases/ameco-database_en

set verbose off
clear

# ΒΑΣΗ ΔΕΔΟΜΕΝΩΝ AMECO, ετήσια δεδομένα μεν, πολλές σειρές δε.
# Provider: AMECO

# ZUTN (Unemployment rate: total :- Member States: definition EUROSTAT)
# PCPH (Price deflator private final consumption expenditure)
# ZCPIH (Harmonised consumer price index (All-items))
# PCNT (Price deflator total consumption)
# PUTT (Price deflator final demand)
# ZCPIN (National consumer price index (All-items))
# ISN (Nominal short-term interest rates)
# ILN (Nominal long-term interest rates)

open dbnomics

data AMECO/OVGD/GRC.1.1.0.0.OVGD --name=GRC1100OVGD
data AMECO/ZUTN/GRC.1.0.0.0.ZUTN --name=GRC1000ZUTN
data AMECO/PCPH/GRC.3.1.99.0.PCPH --name=GRC31990PCPH
data AMECO/ZCPIH/GRC.1.0.0.0.ZCPIH --name=GRC1000ZCPIH
data AMECO/PCNT/GRC.3.1.99.0.PCNT --name=GRC31990PCNT
data AMECO/PUTT/GRC.3.1.99.0.PUTT --name=GRC31990PUTT
data AMECO/ZCPIN/GRC.3.0.0.0.ZCPIN --name=GRC3000ZCPIN
data AMECO/ISN/GRC.1.1.0.0.ISN --name=GRC1100ISN
data AMECO/ILN/GRC.1.1.0.0.ILN --name=GRC1100ILN

rename GRC1100OVGD rgdp
setinfo rgdp --description="real GDP"
setinfo rgdp --graph-name="real GDP"
rename GRC1000ZUTN unrateGR
setinfo unrateGR --description="Unemployment rate: total :- Member States: definition EUROSTAT"
setinfo unrateGR --graph-name="Unemployment rate"

series lrgdp = log(rgdp)
setinfo lrgdp --description="log real GDP"
setinfo lrgdp --graph-name="ln(real GDP)"
series dlrgdp = 100*diff(lrgdp)
setinfo dlrgdp --description="growth rate"
setinfo dlrgdp --graph-name="% annual growth rate"

# Inflation series MANY
series infl = 100*ldiff(GRC31990PCPH)
series infl_1 = 100*ldiff(GRC1000ZCPIH)
series infl_2 = 100*ldiff(GRC31990PCNT)
series infl_3 = 100*ldiff(GRC31990PUTT)
series infl_4 = 100*ldiff(GRC3000ZCPIN)

setinfo infl --description="PCPH (Price deflator private final consumption expenditure)"
setinfo infl_1 --description="ZCPIH (Harmonised consumer price index (All-items))"
setinfo infl_2 --description="PCNT (Price deflator total consumption)"
setinfo infl_3 --description="PUTT (Price deflator final demand)"

setinfo infl_4 --description="ZCPIN (National consumer price index (All-items))"
setinfo infl_4 --graph-name="Inflation (CPI)"

rename GRC1100ISN sr
rename GRC1100ILN lr
setinfo sr --description="Nominal short-term interest rates"
setinfo lr --description="Nominal long-term interest rates"

store Greece_Annual.gdt