Replies to post #209 on SEASONALITY STOCK REPORTS

[lostcowboy]

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

 
 	TMPW 
 2002	-20% 
 2001	3% 
 2000	34% 
 1999	30% 
 1998	34% 
 TOT	80% 

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