Home > Business Databases > Datastream – Price variables: P, P#S, P#T

Datastream – Price variables: P, P#S, P#T

Thomson ReutersThe default datatype (variable) for equities in Thomson Reuters  Datastream is adjusted price (P).

You have to be careful when using adjusted price (P) with dead equities as Datastream will continue to give the last price for dates where the equity has been delisted and is no longer being traded. The time series is padded with the last known value.

Datastream offers additional datatypes that do not perform this padding:

  • P – price adjusted – padded when there is no trading
  • P#S – price adjusted unpadded – always displays NA rather than padding with latest value
  • P#T – price adjusted unpadded – displays NA rather than padding after the series/equity goes dead but still pads for non-trading days

Example of differences between P, P#S and P#T

Datastream Excel sheet showing P, P#T and P#S

Datastream demo P, P#T, P#S (click to expand)

The Datastream spreadsheet above shows the padding for non-trading days over Easter 2010 (London Stock Exchange closed Fri 6th and Mon 9th April) and for the dead equity Autonomy Corp, which was taken over by Hewlet Packard in November 2011.

Currency conversion

If you want to combine the P#S or P#T with currency conversion then you need to use the full expression.

  • X(P)~U$ – price adjusted converted into US dollars – padded when there is no trading
  • X(P#S)~U$ – price adjusted unpadded converted into US dollars – always displays NA rather than padding with latest value
  • X(P#T)~U$ – price adjusted unpadded converted into US dollars – displays NA rather than padding after the series/equity goes dead but still pads for non-trading days

Returns

There is no equivalent RI#S or RI#T for the return index datatype but you can use an expression

  • X(RI)*(X(P#T)/X(P#T)) – will display NA, after the equity series goes dead, when P#T is NA and X(RI) otherwise
  • DPL#((PCH#(X(RI),1D)*X(P#S)/X(P#S)),4) – Percentage total return to 4 decimal places (using Datastream) but NA on days that exchange is closed or after the equity series goes dead.

For more on the percentage total return expression see Total shareholder return (posted July 2011)

Select Datastream tag below for related posts or Datastream for related FAQs (Frequently Asked Questions)

About these ads
Categories: Business Databases Tags:
  1. markgreenwood
    April 18, 2012 at 4:14 pm

    On Yahoo Finance non-trading days are just omitted – http://screencast.com/t/VNBCimz6xw

  2. Niall
    March 4, 2013 at 3:15 pm

    Does RI#S provide analogous results for total return indices?

    • markgreenwood
      March 5, 2013 at 11:00 pm

      A very good question. There is certainly no RI#S in the Datastream key datatypes like P#S and P#T so I suspect RI#S will just give a “data unavailable” error. I will check this out more thoroughly.

    • markgreenwood
      May 27, 2014 at 11:52 am

      Post updated unable to get RI#S directly, but you can use the expression X(RI)*(X(P#S)/X(P#S))

  3. Tahir
    May 25, 2014 at 10:33 pm

    Thanks
    Does this (P#S and P#T) for the dollar returns rather than local currency returns

    • markgreenwood
      May 27, 2014 at 11:45 am

      Use X(P#S)~U$ or X(P#T)~U$ to get unpadded prices converted into dollars – post updated to include this

  4. markgreenwood
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,037 other followers