SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Picks of the quarter -- Ignore unavailable to you. Want to Upgrade?


To: Elroy who wrote (10598)12/6/2010 7:43:35 PM
From: Kirk ©  Read Replies (1) | Respond to of 20435
 
I didn't notice you fell so much in the end. We were neck and neck, often swapping positions, for a good part of the contest.

I have an idea on how to rank people that might make sense in addition to the stars..

See what you think.

Put all names in Column 1 of spreadsheet

Across the top do the contests where column #2 is the score for contest #1, etc.

Then enter the ending dollar amounts including for each cell including the S&P500

Then link that sheet to another where it calculates how much above or below the S&P500 each person did for each contest.

Thus if you matched the S&P, you get 1.00000... if you beat by 20% you get 1.20 for that box...

Then multiply them all together for an overall return.

eg 1.01 x 1.04 x 0.95

means someone beat by 1 and 4% first two contests then under performed by 5% in #3...

Then do a sort for all who have been in 50% or more of the contests... so someone can't jump in with risky picks and move to the top... unless they do it for many contests in a row..

I'd volunteer, but too much on my plate these days...