Data Definitions - H

Highest Close
Holding Period Total Return

Highest Close

Daily: Highest daily closing price within the selected output calendar.

Monthly: Highest month end closing price within the selected calendar. Appropriate to use with quarterly and annual output calendars.

Category Prices
Data Type Floating Point
Date Range Availability
Daily 1925
Monthly 1925
Database Availability and Product Types
Database Formats CRSPAccess, CRSPSift
Product Types STK
ts_print/TsQuery Usage
Daily ITEMID high
Monthly ITEMID mhigh
Header High
SUBNO 0
BACK TO THE TOP >

 

Holding Period Total Return

A return is the change in the total value of an investment in the security over some period of time per dollar of initial investment. Holding Period Total Return is the return for a sale on the given day. It is based on a purchase on the most recent time previous to this day when the security had a valid price. Usually, this time is the previous calendar period.

Daily: In daily databases, dividends are reinvested on the Ex-Distribution Date.

Monthly: In monthly databases, returns are holding period returns from month-end to month-end, not compounded from daily returns, and ordinary dividends are reinvested at month-end.

A series of special missing return codes specify the reason a return is missing.

Code Reason For Missing Return
-66.0 Valid current price but no valid previous price. Either first price, unknown exchange between current and previous price, or more than 10 periods between time t and the time of the preceding price t'.
-77.0 Not trading on the current exchange at time t.
-88.0 Outside the security's price range.
-99.0 Missing return due to missing price at time t; usually due to suspension in trading or trading on unknown exchange.
General Information
Primary Concepts Price, Volume, and Return Time Series Arrays
Data Type real number
Unit of Item Ratio
Date Range Availability
Daily 1925
Monthly 1925
Database Availability and Utility Usage
Database Formats CRSPAccess
Product Types STK
ts_print Daily Usage ret/0
ts_print Monthly Usage mret/0
stk_print Option(s) /pr, /dd, /dr, /dx
C Usage
Object ret_ts
Array ret[ ]
Element  
FORTRAN-95 Usage
Type or Subtype ret_ts
Member and/or Array ret()
Element  
BACK TO THE TOP >