Use screener with get_timeseries?

zzhao

Hi all,

I am trying to get time series data on close price for a given country.

dt=ek.get_timeseries(rics='SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode, "NZ"))', fields='CLOSE', start_date="2016-03-01", end_date = "2017-03-01", interval = "monthly")

But it's not working, it gives an error saying something like

eikon.eikonError.EikonError: Error code -1 | SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode, "NZ")): Invalid RIC | 

Is the SCREEN command only works with get_data?

Is there a way to get data for all stocks from a given country?

Thanks in advance!

chavalit-jintamalit

Hi @zzhao

Is the SCREEN command only works with get_data?

You cannot use SCREENER with get_timeseries.

You can use it with get_data to build a RIC list first then pass this RIC list in your get_timeseries API call.

Here is the sample:

df,e = ek.get_data('SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode, "NZ"))', 'TR.RIC')
ric_list = df['RIC'].tolist()

dt=ek.get_timeseries(rics=ric_list, fields='CLOSE', start_date="2016-03-01",
                     end_date = "2017-03-01", interval = "monthly")
dt

Is there a way to get data for all stocks from a given country?

You can use the SCREENER app to define a SCREENER formula which contains only country criteria.

Then follow the sample process to get the RIC list and retrieve data accordingly.