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

Upvote
Accepted
jonabl avatar image
18 ●3 ●5 ●5

Python API retrieve stock fundamental data specificly to include OriginalAnnouncementDate

Hi, I would like to retrieve the a whole list of stock fundamental data such as Net income, EBIT, Revenue from the HSI constituents. Also, I would like to include the <TR.ISOriginalAnnouncementDate> of each of the historical data from each fiscal year or quarterly data. The below is my code but it wasn't stable: 

field_list = [
    {'TR.NetProfitActValue.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.NetProfitActValue': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.EBIT.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.EBIT': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.TotalRevenue.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.TotalRevenue': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.TotalAssetsReported.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.TotalAssetsReported': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.TotalLiabilities.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.TotalLiabilities': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.CashFromOperatingAct.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.CashFromOperatingAct': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.CashDividendsPaidCommon.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.CashDividendsPaidCommon': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.RetainedEarnings.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.RetainedEarnings': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.TtlCmnSharesOut.calcdate': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    {'TR.TtlCmnSharesOut': {'params': {
        'Period': 'FY0',
        'frq': freq,
        'scale': '3',
        'SDate': '1D',
        'EDate': '-20',
        'curn': 'CNY',
        }}},
    ]

Thank you

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiapidata
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.

zoya faberov avatar image   zoya faberov

Hello @jonabl,

Thank you for your participation in the forum.

Does the reply below answer your question?

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

Otherwise please post again offering further insight into your question.

Thanks,

-AHS

zoya faberov avatar image   zoya faberov

Hello @jonabl,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

1 Answer

· Write an Answer
Upvote
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

Try this:

r, e = tr.get_data(["0#.HSI"], fields=['TR.ISOriginalAnnouncementDate',
                                       'TR.NetProfitActValue.calcdate',
                                       'TR.NetProfitActValue', 
                                       'TR.EBIT.calcdate', 
                                       'TR.EBIT', 
                                       'TR.TotalRevenue.calcdate', 
                                       'TR.TotalRevenue', 
                                       'TR.TotalAssetsReported.calcdate', 
                                       'TR.TotalAssetsReported', 
                                       'TR.TotalLiabilities.calcdate', 
                                       'TR.TotalLiabilities', 
                                       'TR.CashFromOperatingAct.calcdate', 
                                       'TR.CashFromOperatingAct', 
                                       'TR.CashDividendsPaidCommon.calcdate', 
                                       'TR.CashDividendsPaidCommon', 
                                       'TR.RetainedEarnings.calcdate', 
                                       'TR.RetainedEarnings', 
                                       'TR.TtlCmnSharesOut.calcdate', 
                                       'TR.TtlCmnSharesOut' ], 
                   parameters={'SDate':0,'EDate':-20,'Period':'FY0', 'Frq':'FY', 'scale':3, 'curn':'CNY'})
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.

jonabl avatar image jonabl

@Zhenya Kovalyov Thanks for you reply, it works! But how can I get past 20 years data ? Your code only get the recent data.

Zhenya Kovalyov avatar image Zhenya Kovalyov jonabl

@jonabl, try requesting each company individually and see if it helps. EDate:-20 and FRQ:FY implies that the request goes back 20 fiscal years from todays date.

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.