I have not yet been able to log on at the site selected. So, I decided (in dribs and drabs, when I had a few free moments) to create a spreadsheet to calculate everyone's returns. I was able to use the spreadsheet that Marc had previously created as the basic framework, which saved hours (thanks, Marc!).
Basically, I calculated each contestant's number of shares of each stock held in one sheet of an excel file. I have it semi-automated so that all I have to do is load current prices into the another sheet in the file (from two portfolios I have created in quote.com), which are multiplied by the shares held to get each contestant's current balance. I can do this periodically if everyone is interested. So my questions are --
1. Is everyone OK with me providing the listing of all contestants' balances or is it better to just show the highest performers (in the event that the laggards don't want their performance made public).
2. How often would an update be useful? At each month-end? Quarterly? Obviously, these are all points in time and are meaningless in the long run.
In any event, I am sure there are some kinks/errors that I have to work out, but just to test the spreadsheet I plugged in Friday's closing prices. Only five of us were in the black, with the best performer being BulbaMan, having a return of 6.5% (account balance is $106,522). The cumulative return for all contestants is currently -5.2%
Here are the prices I have used if anyone wants to check them out for accuracy. Please let me know if you see any errors. [For the two foreign stocks, I have used the exchange rates at 12/21/2004 and 1/21/2005 -- not sure what is the fairest way to approach this. Do we want foreign currency fluctuations to impact a contest like this? Either way, Nigel and Wilder should definitely check AOM.TO and BIO.L to make sure I did not completely bungle those.]
Ticker 12/31/2004 1/21/2005
ABGX $10.230 $8.890
ABI $20.910 $20.150
ACAD $6.770 $6.640
ADLR $9.920 $9.050
AEGN $1.960 $1.730
AEZS $6.260 $5.760
AFFX $36.550 $36.110
AGEN $10.120 $8.150
ALKS $14.090 $12.860
ALNY $7.470 $7.350
ALTH $2.400 $2.420
ALXN $25.200 $23.340
AMGN $64.150 $62.570
AMLN $23.660 $22.660
AOM.TO $4.691 $4.153
ARIA $7.430 $7.080
ARNA $6.700 $6.340
ARQL $5.790 $6.230
AVGN $3.260 $3.020
AVM $15.720 $16.970
AVN $3.410 $3.640
AXYX $6.200 $5.230
BIIB $66.610 $64.830
BIO.L $1.994 $1.920
BJCT $1.560 $1.532
BLSI $0.570 $0.560
BMRN $6.390 $5.670
CBST $11.830 $10.470
CELG $26.520 $28.760
CGPI $7.340 $5.790
CHIR $33.330 $34.090
CIPH $4.300 $3.250
CMN $37.420 $22.120
COR $2.710 $2.700
CORT $6.250 $5.450
CRA $13.750 $12.900
CRGN $7.160 $5.770
CRIS $5.220 $4.510
CRME $7.640 $7.160
CRXA $3.640 $3.930
CRXL $13.770 $14.880
CTIC $8.140 $9.120
CTRX $11.920 $9.790
CVTX $23.000 $20.790
CYTK $10.250 $8.250
DCGN $7.810 $6.870
DNDN $10.780 $6.240
DOVP $18.050 $16.300
DPII $4.710 $4.290
DRRX $3.280 $2.740
DSCO $7.930 $7.510
DYAX $7.220 $5.900
ELN $27.250 $26.680
ENCY $9.930 $9.450
ENMD $3.240 $3.930
EXEL $9.500 $7.850
GENR $3.420 $3.140
GENZ $58.070 $59.170
GERN $7.970 $8.580
GLFD $4.950 $5.100
GLGC $3.680 $3.210
GLGSD $2.200 $1.300
GNSC $2.130 $2.020
GNTA $1.760 $1.600
GNVC $1.630 $1.860
GPCG $14.210 $14.030
GTCB $1.520 $1.560
HGSI $12.020 $12.210
ICCC $7.160 $5.270
ICOS $28.280 $26.260
IDBE $14.950 $14.760
IDEV $5.960 $4.940
IDIX $17.150 $17.480
IMGN $8.840 $7.390
INCY $9.990 $8.970
INGN $8.440 $6.600
ITMN $13.260 $11.410
IVGN $67.130 $67.650
KDUS $1.530 $1.490
KOSN $6.930 $7.360
KOSP $37.640 $33.760
LEXG $7.760 $7.000
LGND $11.640 $10.650
MEDI $27.110 $24.630
MEDX $10.780 $9.000
MICU $17.410 $15.310
MLNM $12.140 $9.420
MNTA $7.060 $7.460
MOGN $28.010 $22.620
MSHL $8.950 $7.399
MUCL $0.190 $0.310
MYGN $22.510 $25.200
NABI $14.650 $12.350
NBIX $49.300 $44.630
NEOL $12.510 $10.460
NKTR $20.240 $17.940
NPSP $18.280 $16.820
NRGN $9.360 $9.140
NSTK $12.100 $10.390
NTII $4.420 $4.180
NUVO $9.850 $9.050
NVD $1.630 $1.530
NVS $50.540 $47.860
ONXX $32.390 $29.790
ORPH $9.020 $8.750
OSCI $3.650 $3.350
PCOP $5.970 $5.490
PDLI $20.660 $19.130
PGLAF $3.470 $3.100
PLRS $0.205 $0.280
POTP $5.360 $6.200
PPHM $1.170 $1.120
PTIE $7.210 $6.740
PTN $2.660 $2.030
REGN $9.210 $2.390
RIGL $24.420 $20.060
RITA $3.870 $3.480
SEPR $59.370 $56.225
SGEN $6.530 $5.260
SLXP $17.590 $15.100
SNUS $3.530 $3.800
SRA $16.320 $15.380
STEM $4.230 $5.920
TELK $19.140 $19.490
TTP $3.220 $2.330
UTHR $45.150 $43.550
VASC $10.020 $9.270
VNLS $3.200 $3.110
VPHM $4.000 $3.140
VRTX $10.570 $10.200
XNVA $1.300 $1.390
I am open to suggestions, questions, etc. |
