replicate Sector Revenue Growth Qtr YoY % in python

I have this excel formula, How do i replicate this in python=@RDP .Data(DK7:DK5000,"GRWAVG(TR.CompanyMarketCap,PERCENT_CHG(TR.F.TotRevenue(Period=FI0),TR.F.TotRevenue(Period=FI-4)),universe=""univ"")","Period=FI0 NULL=BLANK")DK7:DK5000 is the universe pulled up using

screen_expression = ( 'U(IN(Equity(active,public,primary))/*UNV:Public*/), ' f'IN(TR.HQCountryCode,"{country}"), ' f'IN(TR.GICSSectorCode,"{sector}"), ' 'CURN=USD'

Find more posts tagged with

python

eikon-data-api

#technology

Accepted answers

All comments

Jirapongse

@Hemant

Thank you for reaching out to us.

The code could be like this:

df = ld.get_data(
    universe = ["IBM.N","PTT.BK"],
    fields = ['GRWAVG(TR.CompanyMarketCap,PERCENT_CHG(TR.F.TotRevenue(Period=FI0),TR.F.TotRevenue(Period=FI-4)),universe="univ")'],
    parameters = {'Period':'FI0'})
df

Hemant

Thanks for the response @Jirapongse
I have 2 follow ups here
1) What is the reference for

,universe="univ"

when we already defined the universe above as

universe = ["IBM.N","PTT.BK"],

2) Is there a need to mention the period : FI0 when we clearly defined it in the fields section?

Jirapongse

@Hemant

It is the Universe parameter in the Group Analytic when using the Workspace Excel Formula Builder. Please contact the Workspace Excel support team directly for its description.

I removed the Period parameter from the Workspace Excel formula and it return the same result. However, it is better to confirm this with the Workspace Excel Support team.

You can contact the Workspace Support team directly via LSEG Support.

EXPLORE OUR SITES