1

Google Sheets has a very useful function called GoogleFinance.

GoogleFinance can produce a lot of information about a stock. For example, price, high, low, volume, etc.

Can this function be used to produce an analyst recommendation for stocks?

An example of an analyst recommendation can be seen here: https://www.marketwatch.com/investing/stock/goog/analystestimates

5
  • What do you think "analyst recommendation" means? do you think that Google has analysts who do this?
    – MD-Tech
    Feb 2 '18 at 14:45
  • 1
    If GoogleSheets has a random() function, it can probably be used to match most analysts' recommendations :-)
    – TripeHound
    Feb 2 '18 at 14:49
  • No idea what you mean. Analyst recommendation is just another Analytical data like price, volume. I used to work for Bloomberg and Bloomberg API provide this analysis for every ticker.
    – S Nash
    Feb 2 '18 at 14:50
  • 1
    An analyst recommendation is a recommendation provided by an analyst; a human being who works out statistically by various means whether the stock is under- over- or fairly priced. Most news sources' version of this is an average of a number of investment banks' and analytics companies recommendations.
    – MD-Tech
    Feb 2 '18 at 14:57
1

An analyst recommendation is a recommendation provided by an analyst; a human being who works out statistically by various means whether the stock is under- over- or fairly priced. Most news sources' version of this is an average of a number of investment banks' and analytics companies' recommendations.

Google finance neither has the analysts nor the aggregation to provide this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.