Maybe you'd like to make a mini heatmap of price and volume to gauge sentiment. You can do that. Volume heatmap Price heatmap
Perhaps you have a watchlist on another web site or source but it's lacking in some details. You want extra info, well you can copy and paste it into Sheets where you can add some further number crunching to it.
You want a moving average formula? Below is a 20 day MA formula =AVERAGE(INDEX(GoogleFinance(A3,"all",WORKDAY(TODAY(),-20),TODAY()),,3)) Note: MA formulas seem to gobble up lots of RAM, they slow down the sheet and can freeze it if you use too many. I don't use this formula in my Sheets, but I'm tracking stocks running into the hundreds, hence it becomes an issue.
You maybe want a Heikin-Ashi formula or any of hundreds of Excel formulas to do some crunching for you? You can do that.
Maybe you want to find the average of the last 5 entries. You can do that. You need a formula to do something useful, just use Google search.
Remember, Google Sheets updates stock codes automatically, once you have a sheet up and running with all your stock codes implanted, the values update themselves. They are not live prices, but delayed 15-30 minutes approx depending on the Stock Exchange.
Nice write up. Have you figured out how to get commodity futures or equity option prices into Google sheets?
Great thread, Mick. But the above comment cracked me up. C'mon man, idiots go where the action is, not where they will fall sleep.
I don't believe futures is available, neither Options (I don't think). Options I don't look at them so don't know. Currencies are too basic on the info available, Closing price only for today if I recall, no historical. So if you want basic currencies trends, what I do is use the data off the currency ETF, it's a good workaround imo.
Haven't used it - I use Excel - but from memory check the Market Data for Google Sheets app, then use =OPTIONDATA formula. Google that if necessary.