Below is a sample portfolio file. Note:

  1. Dates are in month, day, year format and years are yyyy.
  2. Records are in order from earliest to most recent date.
  3. The first record in this file is the first transaction for the portfolio. The market value is $0 and a deposit of $23,729.08 is made. This is only an example, the portfolio file does not have to start with a $0 market value.
  4. A record can show a $0 deposit. The second record indicates the $23,729.08 deposit made on 1/21/1991 has increased in value to $25,809.32. This increase could be from interest, dividends, realized gains, unrealized gains or any combination of the 4. Whatever, the source the increase is the result of investment gains not additional outside funds being added to the portfolio.
  5. The market value at 12/31/1992 of $90,162.17 drops to $87,061.35 by 1/13/1993. This decrease could be from realized or unrealized losses or investment related expenses, e.g. trustee fees, brokers commissions, etc. Whatever, the source the decrease is the result of investment losses not funds being withdrawn from the portfolio for other purposes.
  6. Time between records does not have to be evenly spaced. It is best to create a record for each date for which the market value for the portofolio is reported and each date on which a transaction occurs. If you do not have a market value for a transaction date estimate the market value.
1/21/1991 0 23729.08
5/10/1991 25809.32 0
6/3/1991 25592.89 44212.57
4/3/1992 70230.56 19931.61
12/31/1992 90162.17 0
1/13/1993 87061.35 8105
3/9/1993 107068.66 2000
8/10/1993 146326.85 10000
9/28/1993 153960.64 10000
12/29/1993 152846.20 0
12/31/1993 154370.09 0
3/31/1994 166256.43 0
5/13/1994 173723.49 2000
8/15/1994 184488.67 20000
9/30/1994 200363.32 0
12/31/1994 195254.55 0
3/6/1995 184368.68 2000
12/27/1995 203659.37 0
12/31/1995 202953.45 0
2/5/1996 205071.22 15667.89
7/29/1996 212799.41 10000
12/31/1996 210587.89 0
3/14/1997 188948.03 6273.60
3/31/1997 196225.21 0
6/30/1997 234104.13 0
9/30/1997 203883.79 0
10/27/1997 182356.97 15000
12/29/1997 170858.29 0
12/31/1997 174937.13 0
1/30/1998 184227.83 3494.60
3/31/1998 183549.13 0
4/30/1998 179162.42 21000
6/30/1998 186651.52 0