Did you know, you can use GoogleFinance function in Spreadsheets to automatically pull up-to-date information into your spreadsheet to create a one-stop shop for your stock data. “To use GoogleFinance, enter the formula into a desired cell: =GoogleFinance(“Symbol”, “Attribute”) where “symbol” represents stock symbol of the company or mutual fund you’re looking for and “attribute” represents type of market data that you want information about. If attribute is left blank, stock price is populated into the cell by default.”
You can also apply formula to a larger list of symbols and attributes in order to get data for multiple different stock/mutual fund listings across various types of data.
GoogleFinance also allows you to show historical stock data, allowing you to track the performance of any stock across a certain time period. To show historical data, type =GoogleFinance(“symbol”, “attribute”, “start_date”, “num_days|end_date”, “interval”) into a spreadsheet cell.