Datastream – Price variables: P, P#S, P#T
The 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
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)