The GoogleFinance function can be used to retrieve both current and historical information about the securities. In this sheet I'll store every day at 00:00 the value of the cell A3 with the date in order to build a graph of the daily values. In a cell type GoogleFinance ('AAPL','price') The above function will fetch the current price for Apple stock from Google Finance.

Now I create a new sheet and I put the header of two columns, date, and value. In cell A2: =GOOGLEFINANCE('NASDAQ:AMZN' 'price')Īnd I want to keep track of the average of those two values, so A3: =AVERAGE(A1:A2) In cell A1: =GOOGLEFINANCE('NASDAQ:GOOG' 'price') To keep things simple for this question, let's say I have the following values: To do that I have my google Spreadsheet with many formulas calculating the profits or losses ratios taking into account the price I bought them, broker costs and the price right now calculated with: =GOOGLEFINANCE('MARKET:COMPANY' 'price') Hello, I want to keep track of the profit of the combination of many stock values.

Download googlefinance