Status 08/01.
I set up formulas and a macro in the Z Portfolio Excel Spreadsheet that establishes a DDE link to esignal (my quote provider). This will save me a lot of time because the prices will update automatically when the spreadsheet is opened. The other advantage is that I can easily create new fields in the spreadsheet that may be useful. For example, we might add a column for the point or dollar change for each stock. All the usual fields are available such as open, high, low, change, market cap, 52 week high/low, up/down ticks, number of news headlines, etc. I can also make simple calculations in the spreadsheet that use these fields. Please let me know if you want to add anything. The only constraint is that the information for each symbol must fit on one line. Also, please take extra care tonight to see if you see anything wrong in the spreadsheet because this is the first time I have used the automatic update. Thanks.
Status 08/01.
Z PORTFOLIO
Stock DATE SPONS. # Cost Cost $ % Close Close G/L G/L Days
Port $ $ % Held
ABIZ 6/26 ron 500 24.375 12188 0.5% 13.000 6500 -5688 -47% 35
ABIZ 6/29 ron 500 21.750 10875 0.5% 13.000 6500 -4375 -40% 32
ABIZ 7/24 ron 1000 17.125 17125 0.9% 13.000 13000 -4125 -24% 7
ACRI 7/17 kelvin 2000 31.250 62500 4.2% 29.188 58375 -4125 -7% 14
AGIL 7/13 kelvin 1000 71.000 71000 3.7% 50.500 50500 -20500 -29% 18
AMES 6/30 ron 5000 7.750 38750 2.4% 6.719 33594 -5156 -13% 31
AMES 7/31 ron 5000 6.625 33125 2.4% 6.719 33594 469 1% 1
ANAD 7/19 kelvin 1000 40.125 40125 1.8% 25.438 25438 -14688 -37% 12
ANAD 7/27 ron 1000 23.875 23875 1.8% 25.438 25438 1563 7% 4
ARIA 7/14 dan 2000 11.688 23375 1.4% 9.875 19750 -3625 -16% 17
CELL 7/17 kelvin 5000 9.000 45000 2.0% 5.469 27344 -17656 -39% 14
CLEC 6/29 sue 1000 15.125 15125 0.9% 12.875 12875 -2250 -15% 32
CRFH 7/19 sue 3000 8.625 25875 1.4% 6.250 18750 -7125 -28% 12
CRN 6/15 paul z 5000 6.938 34688 2.3% 6.250 31250 -3438 -10% 46
FNV 7/27 ron 2000 10.500 21000 1.5% 10.500 21000 0 0% 4
GUMM var dan 10000 13.678 136775 9.3% 12.875 128750 -8025 -6%
INCY 2/10 john s 100 170.000 17000 0.6% 85.000 8500 -8500 -50% 171
INTV 4/19 dan 2000 16.500 33000 1.0% 6.953 13906 -19094 -58% 102
INTV 5/17 dan 2000 15.063 30125 1.0% 6.953 13906 -16219 -54% 74
INTV 6/6 dan 2000 14.000 28000 1.0% 6.953 13906 -14094 -50% 55
INTV 6/7 dan 5000 6.875 34375 2.5% 6.953 34766 391 1% 54
LMG.A 5/12 larry 3000 22.031 66094 4.7% 21.688 65063 -1031 -2% 79
MLNM var john s 400 121.250 48500 2.8% 97.438 38975 -9525 -20%
MUEI 7/25 dan 2000 10.625 21250 1.5% 10.250 20500 -750 -4% 6
MUEI 7/31 dan 2000 9.750 19500 1.5% 10.250 20500 1000 5% 1
NEON 7/13 john s 1000 36.000 36000 1.7% 24.000 24000 -12000 -33% 18
NEON 7/17 paul m 1000 33.500 33500 1.7% 24.000 24000 -9500 -28% 14
NEON 7/24 paul m 1000 28.688 28688 1.7% 24.000 24000 -4688 -16% 7
ODP 7/18 bill 5000 6.575 32875 2.4% 6.500 32500 -375 -1% 13
PUMA 6/26 kelvin 1000 27.625 27625 1.3% 18.313 18313 -9313 -34% 35
PUMA 6/30 kelvin 1000 25.625 25625 1.3% 18.313 18313 -7313 -29% 31
QCOM 7/18 paul m 500 65.625 32813 2.3% 62.938 31469 -1344 -4% 13
QLGC 7/18 paul m 500 87.375 43688 2.5% 67.688 33844 -9844 -23% 13
RMDY 7/28 ron 2000 20.500 41000 3.1% 21.063 42125 1125 3% 3
SHLL 1/14 rick 15000 2.250 33750 1.7% 1.563 23438 -10313 -31% 197
SNDK 7/21 paul m 500 67.625 33813 2.2% 61.063 30531 -3281 -10% 10
SNDK 7/28 paul m 500 62.750 31375 2.2% 61.063 30531 -844 -3% 3
SRV 5/22 bill 6000 3.250 19500 1.1% 2.500 15000 -4500 -23% 69
SRV 7/14 bill 6000 2.875 17250 1.1% 2.500 15000 -2250 -13% 17
SV 7/24 larry 2000 50.063 100125 6.9% 47.875 95750 -4375 -4% 7
TERN 8/1 larry 1000 52.750 52750 3.7% 51.188 51188 -1563 -3% 0
TRAC 5/11 sue 5000 1.813 9063 0.4% 1.063 5313 -3750 -41% 80
VISX 7/14 sue 1000 29.563 29563 1.6% 22.500 22500 -7063 -24% 17
VPHM 7/14 dan 1000 21.250 21250 1.3% 17.500 17500 -3750 -18% 17
VSH 7/25 paul m 1000 35.250 35250 2.2% 30.000 30000 -5250 -15% 6
*** *** *** *** *** 1594744 96.3% 1327991 -266753 -17% 32.3
Portfolio Summary
Beg Balance 1/1/00 1319059
Plus Gains Realized 326906
Less Holdings at Cost 1594744
Equals Cash Balance 51222 3.7%
Plus Holdings At Close 1327991
Portfolio Balance 1379212
Portfolio Change YTD 4.56%
Beg Balance 1/1/99 500000
Change since 1/1/99 175.84%
YTD Change in Market Indices
DJIA -7.74%
Nasdaq -9.43%
S&P 500 -2.12%
Russell 2000 -1.38%
|
