Hi Ken, all this debate on how to calculate percentage, rang a bell. I went and took a closer look at your spreadsheet. You are calculating total percentage wrong. You are summing the percentages, you can not do that, you end up with a incorrect total. Example the June stocks spread sheet, for TMPW you had these percentages
What you need to do is 1.34*1.30*1.34*1.03*.80= 1.9234 You now subtract one and get a total of 92.34%. So you see you have a higher percentage than you thought! It looks like BRCM is the June winner at 266.07%! I used this code to calculate total percent. =((B8+1)*(B7+1)*(B6+1)*(B5+1)*(B4+1))-1
Come see me at Systematic Investing group #board-966 lets talk formula plans.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.