Date for total revenue

christoph.b
christoph.b Newcomer
in Eikon Data APIs

When retrieving the total revenue via the Eikon API Proxy (Mac), the API doesn't return any date for total revenues of companies that have no data in the financial tab in the Eikon webtool.

I retrieve the total revenue via TR.PCTotRevenueFromBizActv(Period=FY0) & the date via TR.PCTotRevenueFromBizActv.date (timestamp) and TR.PCTotRevenueFromBizActv.periodenddate (date).

I use the eikon python library to retrieve the data:

ret, err = ek.get_data([str(i) for i in instrument_ids], search_params, {})

It seems logical that every total revenue should have a date attached to it. Is there any way to retrieve the dates or do they not exist for all companies without data in the financial tab in the Eikon webtool.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @christoph.b

    For this issue, you can directly contact the Eikon support team via MyRefinitiv and ask for the =TR formula which can be used in Eikon Excel to retrieve the required data.

    If the =TR formula is available to retrieve the data, then we can apply it to the get_data method in Eikon Data API.

    image

Answers

  • chavalit-jintamalit
    chavalit-jintamalit admin

    Hi @christoph.b

    I do not have Mac to test the proxy.

    I can get the data fields in your question with Eikon Desktop(Window).

    Please try this code:

    image

    If the same code does not work on Eikon Data API Proxy(Mac), please try it on Eikon Web >> Codebook.

    https://developers.refinitiv.com/en/article-catalog/article/use-eikon-data-api-or-rdp-library-python-codebook-web-browser

    If it does work on Eikon Web >> Codebook but does not work with Eikon Data API Proxy(Mac), you can submit a ticket to Refinitiv Helpdesk at https://my.refinitiv.com/

  • christoph.b
    christoph.b Newcomer
    Hi @chavalit.jintamalit,

    thank you for your answer. I'm able to retrieve the periodenddate as well. The issue is the following:

    Companies A) Here are 5 companies with data in the financial tab: 4295881204, 4295881776, 5000589792, 4295912296, 4295859347

    Companies B) Here are 5 companies with no data in the financial tab but a total revenue figure: 5034815127, 4298109401, 5071362237, 5037852035, 5044730724

    For companies A, I'm able to retrieve the period end data due, likely to the fact that the financial data in the financial tab of the webtool is dated and the last revenue figure plus it's period end data is used as total revenue in the overview.

    For companies B, I'm able to retrieve the total revenue, but not the period end date of the total revenue. Likely this data point doesn't exist. Can you confirm that or do can I retrieve the period end date of the total revenue for companies which have no financials tab in the webtool using some other query?

Categories