On repeated dates inside a request
Hello everyone,
I've noticed that for some TR formulas, some values are consistently being repeated, but I'd like to know the criteria (if possible of course) to choose which dates to repeat.
I'll use as example the following code, that produces the data in the screenshot:
import eikon as ek
ek.set_app_id('xxxxxx')
out2 = ek.get_data(['AA.N'], ['TR.FCFMean', 'TR.FCFMean.date'],{'SDate':'-24M','EDate':'-10M','Frq':'M','Curn':'USD', 'Period':'FY1'})
print(out2)
captura.jpg
Same thing in Excel, notice the repeated dates on the end.
My assumption is that, to fill the vacant slot of data for this company, it just repeats one of the values to complete the request. The same happens for other companies, but other dates are repeated, such is the case for companies like AAN.N.
How can we understand better this behavior? Would using .calcDate instead of date solve this more properly?
Thanks in advance.
Best Answer
-
I believe your understanding is correct. TR.FCFMean.date represents the date the estimate was published, which can be repeated when the sampling period defined by Frq parameter is more granular than the interval between two consecutive estimates. Using your example that would be the case when there was no estimate update published within a month and the number from the previous month is repeated in the monthly series. TR.FCFMean.calcdate corresponds to the end of the sampling period (end of the month in your example), and therefore shouldn't have any repeat values.
This said to get an authoritative explanation on what these dates represent I suggest you contact Refinitiv Helpdesk and use Excel example to illustrate your question. The moderators on this forum do not have the deep content expertise required to provide an authoritative answer to your question. The Helpdesk on the other hand will either have this expertise ready available or can reach out to content experts for the specific type of content you're interested in.1
Answers
-
Thanks Alex!
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 5 Bot Platform
- 17 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
- 370 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛