Old ways of working with spreadsheets are giving way to online software that extend the capabilities of spreadsheet programs or to obviate the need for them. One app listed here gives you securities prices.
End-of-day prices for stocks, indexes, mutual funds and futures from 50 markets worldwide are available for just $99.95 a year from AnalyzerXL, which pulls the data right from Yahoo! Finance into a spreadsheet. A demo of the product shows how you can download data throughout the day and build an hour-by-hour chart.
DownloaderXL downloads free historical stock, index and mutual fund data from Yahoo! Finance, which can be a good way of creating charts of indexes or ETFs.
And that's just one of several spreadsheet apps listed in the post.
Please post a comment if you try and let us know what your experience is.