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 create histogram charts How to create trading rules based on Put and Call volume data
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 Create a stock index or a trading indicator using the composite t... The Ultimate Guide to Create Trading Systems in QuantShare Reading and Exporting Data from QuantShare to Excel Programmatica...