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 Rating Analyst Rating (Yahoo Historical Buy/Sell Recommendations) Analyst Previous Rating 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 add a trading indicator to a chart How to print a chart
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 How to Automatically Import Local Data Into QuantShare Different Types of Trading Indicators: Trend, Momentum, Volatilit... Select the best ETFs combination to maximize your return and redu...