For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 1 1 3

How do I get the countries CPI values from Thomson Reuters Eikon api via python/spyder? or excel?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvote
Accepted
13k 32 12 18

When you type in Economic Indicators in Eikon search bar, it will bring up the app where you can choose the country and CPI from the dropdown list. This will get you a RIC which can be used in the get timeseries call shown by @chavalit.jintamalit. See example showing Poland and Russia.



>>> ek.get_timeseries('PLGDPY=ECI', start_date='2003-01-01', end_date='2020-01-01', interval='yearly')
PLGDPY=ECI  VALUE
Date
2003-12-31    3.6
2004-12-31    5.1
2005-12-31    3.5
2006-12-31    6.2
2007-12-31    7.0
2008-12-31    4.2
2009-12-31    2.8
2010-12-31    3.6
2011-12-31    5.0
2012-12-31    1.6
2013-12-31    1.4
2014-12-31    3.3
2015-12-31    3.8
2016-12-31    3.1
2017-12-31    4.8
2018-12-31    5.1
>>> ek.get_timeseries('RUBUD=ECI', start_date='2003-01-01', end_date='2020-01-01', interval='yearly')
RUBUD=ECI      VALUE
Date
2003-12-31  2.616667
2004-12-31  5.025000
2005-12-31  9.866667
2006-12-31  9.533333
2007-12-31  7.400000
2008-12-31  8.066667
2009-12-31 -1.800000
2010-12-31 -2.066667
2011-12-31  2.241667
2012-12-31  0.300000
2013-12-31  0.066667
2014-12-31  2.091667
2015-12-31 -3.133333
2016-12-31 -2.233333
2017-12-31 -1.008333
2018-12-31  2.491667
2019-12-31  3.266667

ahs.png (56.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvote
18k 21 12 20

Hi @selenbb

1. Find a RIC code.

Type in "Turkey CPI" in the Eikon Search bar and select from there.


2. Use Python to retrieve the data.


ahs.png (118.1 KiB)
ahs2.png (16.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
3 1 1 3

I tried that but all coming Nan for other countries too.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea