Fund Header

Item ID Item Name Definition Header
crsp_portno CRSP PORTNO Portfolio Number

Unique identifier for a security or a group of securities held in the fund’s portfolio. A portfolio may be held by one or many different funds.

Available for funds active any time since July 2003
CRSP Portno
crsp_cl_grp CRSP Class Group Code used to associate different share classes of a fund. Class Codes begin with 2000000.
Codes are created through a name parsing and clean-up exercise and follow these rules:
  • If a group of funds have the same resulting base after parsing and cleanup, for any overlapping time period, then they are considered to be sub-classes of the same fund during the overlapping range. If there is no overlap of date ranges, the funds are not considered part of the same group.
  • If two groups share one or more funds, then they are assigned the same CRSP Class Group code.
  • If a froup overlaps in time with another group with the same Class Group Code but a different base name, then one of the groups is assigned a different code. This accounts for cases where different funds with multiple subclasses are combined. Each fund will share the glass group when they share a base name, but a different group when they do not.

Data available beginning August 31, 1998
CRSP Class
ffund_name Fund Name The full name of the fund Name
fnasdaq NASDAQ Ticker NASDAQ ticker symbol. Available for NASDAQ listed funds only. NASD Sym
fncusip Fund Cusip Fund CUSIP. Available for internal use by client only. Click here for CUSIP licensing information.

Data available beginning 2001
CUSIP
ffirst_offer_dt Fund First Offer Date Date when the fund was first offered First Offer
fmgmt_name Management Company Name Name of the current Management Company

Data available beginning 1993
MgtName
fmgmt_cd Management Company Code Management Company Code. An identifier for the Management Company.

Data available beginning December 1999
MgtCode
fmgr_name Portfolio Manager Name Name of current Portfolio Manager

Data available beginning 1993
MgrName
fmgr_dt Manager Responsible Date Date that the current portfolio manager assumed responsibility for the portfolio

Data available beginning 1993
MgrDate
fadv_name Fund Advisor Name Fund Advisor Name

Data available beginning December 1999
Advisor
fopen_to_inv Open to Investment Flag Identifies if the fund is open to investors:
Y = Yes
N = No
Data available beginning December 1999
Open Flag
fretail_fund Retail Fund Flag Identifies if a fund is a retail fund or not:
Y = Yes
N = No
Data available beginning December 1999
Retail Flag
finst_fund Institutional Fund Flag Identifies if a fund is an institutional fund:
Y = Yes
N = No
Data available beginning December 1999
InstFlag
fm_fund M Fund Flag Identifies if a fund was originally a “M” fund:
Y = Yes
N = No
Note: “M” funds are “dead” funds that were introduced to the database when originally built by Mark Carhart in order to eliminate survivor bias.
Mfund Flag
findex_fund_flag Index Fund Flag Identifies if a fund is an index fund:
B = Index-based fund - utilizes indices as its primary filter for the purchase and sale of securities. This is accomplished by investing in the components of one or more indices, or by investing in a small percentage of securities within the index in an attempt to capture the best performers. In each case, the option to invest a portion of assets outside the securities held by the index is left open.

D = Pure Index fund - objective is to match the total investment performance of a publicly recognized securities market index. The fund will hold virtually all securities in the noted index with weightings equal to those in the index.

E = Index fund enhanced - objective is to exceed the total investment performance of a publicly recognized securities market. This is accomplished by investing primarily in derivatives based on the index itself and/or the securities within the index, or by utilizing different weightings for the securities held by the index
Data available beginning 2003
Index Flag
fvau_fund Variable Annuity Fund Flag Identified if a fund is an variable annuity fund:
Y = Fund is a variable annuity underlying fund
N = Fund is not a variable annuity underlying fund
VarAnn Flag
fet_flag ETF_ETN Fund Flag Identifies if a fund is an ETF or ETN:
F = ETF
N = ETN
ET Flag
fend_dt Latest NAV Date of latest NAV data End Date
fdead_flag Dead Fund Flag Identifies if a fund is dead or still active:
Y = Yes
N = No
Dead Flag
fdelist_cd Delist Reason Flag Identifies the reason for the fund delisting:
Delisting Codes (Post September 1998)
Code Description
L Liquidation
M Merged

Delisting Codes (Prior to September 1998)
Code Description
? Don’t know what happened to this fund
CE Converted to close-end
CLO Closed to new investment – not currently reporting
L Liquidated
L? Probably Liquidated
M Merged
M? Probably Merged
R Removed at fund request
RTO Fund or data for this fund was removed from the database (Data should not have been included)
TFE Tax Free Exchange Fund (data was from Wiesenberger)
VAS Variable annuity vehicle
Delist Code
fmerge_fundno Acquiring Fundno CRSP Fundno of the fund that acquired the assets of the delisted fund AcquirFundo