Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by michele.malagoli · Jun 04, 2020 at 10:30 AM · datastreamPEbpdy

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?

People who like this

0 Show 5
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
jirapongse.phuriphanvichai ♦♦ · Jun 10, 2020 at 03:40 AM 0
Share

@michele.malagoli

Please share the code that you are using.

avatar image
michele.malagoli jirapongse.phuriphanvichai ♦♦ · Jun 12, 2020 at 03:21 PM 0
Share

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')



avatar image
REFINITIV
jirapongse.phuriphanvichai ♦♦ michele.malagoli · Jun 17, 2020 at 02:03 AM 0
Share

@michele.malagoli

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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jirapongse.phuriphanvichai · Jul 10, 2020 at 03:52 AM

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

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
7 People are following this question.

Related Questions

How do I get an identifier code through the deal screener?

Downloading Datastream data referring to varying dates in large dataset

How to get started building a dataset?

What happened to the datatype INDX

DataStream API service not avaialbel on 24 Jul?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges