Conditional count countif to determine avg analyst rating

Conditional count countif to determine avg analyst rating

Kiran
2016-05-06 16:49:07

I'm trying to determine the average Analyst rating over last 60 days using the Analyst Rating database, and configured the AnalystRating function to
return the rating only on the day it's published (i.e. 1-5 scale) - other days, it's 0.

How do i calculate average rating? I tried this code below but there's no countif function.

a = AnalystRating("", 1, "");
b = sum(a, 60);
c = countif(b>0, 60); //This function doesn't exist
avgRating = iff(c ==0, 0, b/c);

thanks,
Kiran

QuantShare
2016-05-07 04:57:57

Use the "AvgIf" function.

Get more messages

No more messages

Back


Trading Items Analyst Days Since Last Rating Analyst Previous Rating Analyst Rating Analyst Rating (Yahoo Historical Buy/Sell Recommendations) Analyst downgrades & upgrades	How-to Lessons How to automatically arrange charts? How to change volume bar colors when the price closes down How to use the Fibonacci retracement drawing tool How to plot two different time frames in the same chart How to optimize a neural network using a genetic algorithm
Related Forum Threads Downlad data Yahoo Analyst Rating Component count How to determine if the a given day is a trading day? Count Down Days Conditional Buy/Sell	Blog Posts Create Your Own Technical Stock Rating System Introduction to sentiment analysis applied to the stock market Limit and Market orders Reading and Exporting Data from QuantShare to Excel Programmatica... Backtesting Your Trading Systems: Symbol Segmentation