How to get timeseries data of quarterly turnover (total turnover for a quarter) for a list of sto...

...ck ?

I have a list of RIC Codes corresponding to a list of stocks. I want to get the quaterly turnover data for each of them. I am aware of the function eikon.get_data(RicList, ['TR.TURNOVER], {'SDate':"2017-04-01", 'EDate':'2017-06-30'})

I was wondering if there is a way to specify the frequency parameter here as quarterly ? Or some other way that allows direct retrieval of quarterly turnover values?

Find more posts tagged with

python

eikon

data

interval

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Zhenya Kovalyov

Try this

df, e = tr.get_data(['AAPL.O'], 
                    ['TR.Turnover.periodenddate','TR.Turnover(CALCMETHOD=SUM).value'], 
                    {'SDate':"0", 'EDate':'-9', 'Frq':'CQ'})

Returns last accumulated turnover for each of the last ten calendar quarters (CQ):

screen-shot-2018-03-28-at-152731.png

All comments

Zhenya Kovalyov

Try this

df, e = tr.get_data(['AAPL.O'], 
                    ['TR.Turnover.periodenddate','TR.Turnover(CALCMETHOD=SUM).value'], 
                    {'SDate':"0", 'EDate':'-9', 'Frq':'CQ'})

Returns last accumulated turnover for each of the last ten calendar quarters (CQ):

screen-shot-2018-03-28-at-152731.png

EXPLORE OUR SITES