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 : Trend View Index from Silicon Investor

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: SI Bob who wrote (31)8/30/2006 3:33:53 PM
From: OldAIMGuy   of 33
 
Hi Bob, I'm taking the "score" times the number of "votes" for each of the top and bottom 50 (ascending and descending) and summing those. So, if there were only one vote per score and each score was a "10" then the total would be 500 (1x10 for each of the 50 then added up). I'm using the default NumDays of "10" as the time frame.

If there's 13 votes for one stock that's scored 3.5, then that item would be 45.5 by itself. It would be added to the other 49 on the list to get that quantity.

That's all for the "weighted" version. The unweighted is simple addition of the score column with no consideration of how many votes were received.

In the unweighted and weighted categories, I'm subtracting the "bullish" total from the "bearish" to get each week's value. (I consider the "Descending" list to be the "bullish", etc.) I record the results of both and then graph those. I think I can save the spreadsheet as an Excel and send it along. Don't think the imbedded graph will carry over but all the formulae should be there. I'll email it to you.

Best regards, Tom
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext