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
random()
function, it can probably be used to match most analysts' recommendations :-)