fundamental data
Hi,
We have downloaded some fundamental metrics (BP,DY,PE) on a list of total market indexes ( TOTMKUS(BO) for example ). via Python API.
But if we look at the values of these metrics downloaded one month ago, we see different values for the same date. We are aware that for these metrics, you provide two type of series:Fixed weights ( the ones we selected) and Recalculated weights(DY.R,PE.R for example) . So, why the Fixed Weights series change values backwards?
Best Answer
-
Please see response from the DataStream support team below.
We have Recalculated index datatypes only for MV.R, PI.R, PE.R, DY.R and RI.R. Further, we do recalculate the historical MV, PI, PE, DY and RI from last index review date only if there is any correction to the underlying constituents historical data like price, shares, dividends, earnings etc.
In this case, we see TOTMKUS values were recalculated multiple times in last few months and there were correction to constituents. Now we re-validated the index value and it’s looking fine.0
Answers
-
Please share the code that you are using.
0 -
hi,
below you can see the code ( we download these data for 15 equity indexes. I reported only the tickers for the US total return market as example. I can give you the full list if necessary.
lastdate_PE='1990-01-02' lastdate_DY='1990-01-02' lastdate_PB='1990-01-02'
enddate='-0D'
tick_PE_FWD=['TOTMKUS(DIPE)']
tick_DY=['TOTMKUS(DY)']
tick_PB=['TOTMKUS(BP)']
pe_eq=ds.get_data(tickers=tick_PE_FWD,fields=[] , start=lastdate_PE, end=enddate, freq='D')
dy_eq=ds.get_data(tick_DY,fields=[] , start=lastdate_DY, end=enddate, freq='D')
pb_eq=ds.get_data(tick_PB,fields=[] , start=lastdate_PB, end=enddate, freq='D')
0 -
Thank you so much. I can get the data properly but I couldn't see the differences right now.
Could you please share the data that was different and the date that the data was retrieved?
Next, I will contact the DataStream team to verify it.
0 -
Otherwise, you may directly contact the DataStream support team via MyRefinitiv to verify the problem.
0 -
Yes, of course.
Can I reach you via an email address? So I can attach some files and show you the issue.
M.
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 中文论坛