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.
Best Answer
-
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.
0
Answers
-
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.
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/
0 -
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?
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛