Economic timeseries in the Eikon Data API

I can get historical CPI levels in Excel via RtHistory using calls such as =RHistory("aAUCCPIE/CA","ECONOMIC.Timestamp;ECONOMIC.Value","START:22-Feb-2009 END:22-Feb-2019 INTERVAL:1MO",,"TSREPEAT:NO")

How do I do the equivalent call in the Eikon Data API? I've tried requesting via get_timeseries (e.g. df = eikon.get_timeseries('aAUCCPIE/CA', interval='monthly', fields='*')), and that fails with Error code -1. I've also tried using get_data (e.g. df = eikon.get_data('aAUCCPIE/CA',
["ECONOMIC.Timestamp", "ECONOMIC.Value"],
{'SDate':'2-22-2009', 'EDate':'2-22-2019'}), but that fails as well.

Is there any other way to get historical CPI (or other economic data) of various countries via the Eikon Data API, or does this require Excel?

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    Thanks @davidk
    It looks like it can be related. The strange thing is that I'm not reproducing this while you've experienced it more than once (probably even consistently) at roughly the same time I tried. Since the backend is the same for you and me I would expect to see the same behavior you do. Does the issue persist? Are you still able to reproduce it? If yes, it would be great to generate the log file:

    eikon.set_log_path(r'C:\Temp')
    eikon.set_log_level(10)
    The log file name will be pyeikon.%Y%m%d.%H-%M-%S.log
    If this is the same backend problem @igorg experienced yesterday, you should see the same error in the log file as posted on the thread you referenced.

Answers