How to Get Live Stock Price in Google Spreadsheet

To learn how to fetch real-time stock prices in Google Sheets using the GOOGLEFINANCE function.

Prerequisites:
Basic understanding of Google Sheets and familiarity with using formulas.

Step 1: Set Up Your Google Spreadsheet

1. Open Google Sheets and create a new spreadsheet.
2. Label Column A as "Ticker" and Column B as "Company Name."

Step 2: Retrieve Company Names

1. In cell B2, enter the formula =GOOGLEFINANCE(A2, "name").
2. This formula fetches the company name corresponding to the ticker listed in cell A2.
3. Press Enter to apply the formula.

Step 3: Get Real-Time Stock Prices

1. In cell C2, enter the formula =GOOGLEFINANCE(A2, "price").
2. This formula retrieves the real-time stock price for the company listed in cell A2.
3. Press Enter to apply the formula.
4. Drag the formula down from cell C2 to fetch prices for other companies listed in Column A.

Step 4: Obtain Currency

1. In cell D2, enter the formula =GOOGLEFINANCE(A2, "currency").
2. This formula retrieves the currency in which the stock price is quoted.
3. Press Enter to apply the formula.
4. Drag the formula down from cell D2 to fetch currencies for other companies listed in Column A.

Step 5: Calculate Price Change

1. In cell E2, enter the formula =GOOGLEFINANCE(A2, "changepct").
2. This formula calculates the percentage change in stock price since the previous trading day's close.
3. Press Enter to apply the formula.
4. Drag the formula down from cell E2 to calculate price changes for other companies listed in Column A.

Step 6: Review and Customize

1. Review the data in your spreadsheet to ensure accuracy.
2. Customize the formatting and layout of your spreadsheet as needed.
3. Save your work and utilize the real-time stock price data for analysis or tracking purposes.

Conclusion:

Congratulations! You've successfully learned how to fetch live stock prices in Google Sheets using the GOOGLEFINANCE function. Keep exploring and experimenting with different functions to enhance your spreadsheet skills!