Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
pyquant avatar image
26 ●4 ●3 ●4

How to get Total Revenue with Dates?

I am trying to get the FY2019 Revenue data for the below list of stocks. I used the following code.

data,er = ek.get_data(ric_code, ['TR.Revenue(SDate=2019-05-03,EDate=2020-02-07).Date',

'TR.Revenue'], {'SDate':'2019-05-01','EDate':'2020-08-04'})


I am getting NA values back.

Can you also direct me to the docs/tutorials where I can learn more on how to pull fundamental data for the stock listings.


["UNH.N, CI.N, JPM.N, ANTM.N, BAC.N, WFC.N, C.N, HUM.N, AIG.N, PGR.N, ALL.N, CB.N, TRV.N, COF.N, USB.N, HIG.N, FLR.N, PNC.N, BK.N, RGA.N, SYF.N, TFC.N, DTE.N, CNP.N, UNM.N, VST.N, STT.N, DFS.N, SRE.N, OKE.N, AIZ.N, RE.N, WRB.N, PPL.N, VOYA.N, FITB.O, UGI.N, ALLY.N, CFG.N, KEY.N, MTB.N, RF.N, ACGL.O, ATH.N, EVRG.N, AXS.N, KMPR.N, HBAN.O, RNR.N, FRC.N, CMA.N, SIVB.O, ZION.O, GEL.N, PFG.O, FHN.N, PBCT.O, CIT.N, TCF.N, EWBC.O, WTFC.O, SBNY.O, WBS.N, WAL.N, TCBI.O, PNFP.O, NYCB.N, OZK.O, AGO.N, BKU.N, JRVR.O, FHB.O, FBK.N, APLT.O, RAPT.O"]

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apidatafundamentals
eikon-revenue.png (46.7 KiB)
icon clock
10 |1500

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

Jirapongse avatar image   Jirapongse

@pyquant

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @pyquant

You can use "Data Item Browser" to explore the fields.

Please review this tutorial for "Data Item Browser" tutorial(scroll down to Data Item Browser section)


I think maybe you can use TR.RevenueActValue field.


rics = ["UNH.N, CI.N, JPM.N, ANTM.N, BAC.N, WFC.N, C.N, HUM.N, AIG.N, PGR.N,ALL.N, CB.N, TRV.N, COF.N, USB.N,\
HIG.N, FLR.N, PNC.N, BK.N, RGA.N, SYF.N, TFC.N, DTE.N, CNP.N, UNM.N, VST.N, STT.N, DFS.N, SRE.N, OKE.N, AIZ.N,\
RE.N, WRB.N, PPL.N, VOYA.N, FITB.O, UGI.N, ALLY.N, CFG.N, KEY.N, MTB.N, RF.N, ACGL.O, ATH.N, EVRG.N, AXS.N, KMPR.N,\
HBAN.O, RNR.N, FRC.N, CMA.N, SIVB.O, ZION.O, GEL.N, PFG.O, FHN.N, PBCT.O, CIT.N, TCF.N, EWBC.O, WTFC.O, SBNY.O,\
WBS.N, WAL.N, TCBI.O, PNFP.O, NYCB.N, OZK.O, AGO.N, BKU.N, JRVR.O, FHB.O, FBK.N, APLT.O, RAPT.O"]

fields = ['TR.RevenueActValue.Date','TR.RevenueActValue.periodenddate','TR.RevenueActValue']


data,err = ek.get_data(rics, fields, {'Frq':'FY','Period':'FY2019'})
data

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

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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