Date for total revenue

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.

Find more posts tagged with

python

eikon

date

data

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Jirapongse

@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.

All comments

chavalit-jintamalit

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:

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

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 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?

Jirapongse

@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.

EXPLORE OUR SITES