Biotech Charity Contest Historical Data Analysis:
For unknown reasons, I got the urge to give my brain a spreadsheet workout. This prompted me to do a bit of data analysis for the 7 prior Biotech Charity Contests for which I kept score (2006-2012).
Since some contestants changed their handles over the years, I had to make a few guesses as to who was who. For that reason, along with my aging brain being somewhat creaky, I surely made a few errors. So, please let me know if you have any corrections.
Considering the above caveat, below are the three tables I put together, plus my brief comments.
Peace & good health,
Bulba
Table I: The top three portfolios and the # of portfolio entries for each of the seven Contests.
Table I
Year 1st 2nd 3rd #Ports.
2006 RKRW WILDER CYRAN 40
2007 TECHNET FILO ROBERT 31
2008 ROBERT GENE JACKH 33
2009 RKRW NIGEL MIKEM 32
2010 RKRW ROCKY GHMM 32
2011 MCBIO JIBACOA ROCKY 38
2012 GENE RKRW BIOMAV 38
As indicated in Table I, the top contestant, no surprise, is RKRW, with three 1st places and one 2nd place. Three other contestants were able to win two medals in the 7 Contests: a 1st and 3rd place for ROBERT; a 1st and 2nd place for GENE; a 2nd and 3rd place for ROCKY.
Table II: The top five portfolios ranked by average performance for the seven Contests and the maximum and minimum percentage profit/loss over the seven Contests.
Table II
Name Avg% Max% Min%
RKRW 45.20% 133.81% -46.52%
ROBERT 13.93% 33.19% -3.20%
ROCKY 13.20% 60.92% -17.78%
BULBA 10.25% 56.38% -46.39%
FILO 7.75% 47.62% -27.52%
Table II only includes contestants who participated in all seven Contests. I limited inclusion to those contestants since performance in a given year is generally correlated with that of the overall biotech sector. So contestants who did not participate in a year when biotechs performed poorly would have a significant advantage. (My spreadsheet urge was not sufficiently strong to calculate and rank relative performance for all contestants for all years they participated.)
Once more RKRW comes out on top, with both the highest average percentage profit over the seven years and the highest single year profit. (The highest single year profit for any contestant, regardless of participating years, was 150.19%. It was achieved by GENE in 2012, who participated in six Contests.)
Although RKRW achieved top gains, it’s notable that an RKRW portfolio also got Table II’s worst loss honors. (RKRW’s big 46.52% loss came in 2008 with my own 2011 performance being a close second.) Notable as well in Table II, is the performance of ROBERT, who only had a small 3.20% loss in his worst year.
Table III: The average rank of contestants who participated for four or more years.
Table III
Name AvgRank #Yrs
RKRW 9.3 7
GENE 11.3 6
ROBERT 11.4 7
LJM 13.0 6
WILDER 13.3 6
BULBA 14.1 7
TECHNET 14.3 4
IJF 14.8 4
NIGEL 15.0 6
ROCKY 15.3 7
FILO 15.6 7
STEVEL 16.2 5
BIOJIM 16.5 6
PGO 16.7 7
ROBO 16.8 6
MIKEM 17.4 5
Table III only includes contestants who had an average rank below 17.43. Somewhat arbitrarily, I used the 17.43 cut-off point as it is less than half of the average number of contestants participating in each of the seven years (244 Contest portfolios divided by 7 equals 17.43).
RKRW again heads the list. But as was the case with RKRW’s average profit and loss, his portfolios had some bad years (ranking 24 of 33 in 2008 and 21 of 31 in 2007). |
