question

Upvotes
Accepted
1 0 1 1

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?

datastream-apidsws-apipe-code
icon clock
10 |1500

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

@michele.malagoli

Please share the code that you are using.

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



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

Show more comments
Show more comments

1 Answer

Upvotes
Accepted
38.1k 71 35 53

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. 
icon clock
10 |1500

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

Click below to post an Idea Post Idea