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.

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 | #1

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

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

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

    • markgreenwood
      March 5, 2013 at 11:00 pm | #3

      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.

  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


Get every new post delivered to your Inbox.

Join 966 other followers