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
- Open Google Sheets and create a new spreadsheet.
- Label Column A as "Ticker" and Column B as "Company Name."
Step 2: Retrieve Company Names
- In cell B2, enter the formula
=GOOGLEFINANCE(A2, "name"). - This formula fetches the company name corresponding to the ticker listed in cell A2.
- Press Enter to apply the formula.
Step 3: Get Real-Time Stock Prices
- In cell C2, enter the formula
=GOOGLEFINANCE(A2, "price"). - This formula retrieves the real-time stock price for the company listed in cell A2.
- Press Enter to apply the formula.
- Drag the formula down from cell C2 to fetch prices for other companies listed in Column A.
Step 4: Obtain Currency
- In cell D2, enter the formula
=GOOGLEFINANCE(A2, "currency"). - This formula retrieves the currency in which the stock price is quoted.
- Press Enter to apply the formula.
- Drag the formula down from cell D2 to fetch currencies for other companies listed in Column A.
Step 5: Calculate Price Change
- In cell E2, enter the formula
=GOOGLEFINANCE(A2, "changepct"). - This formula calculates the percentage change in stock price since the previous trading day's close.
- Press Enter to apply the formula.
- Drag the formula down from cell E2 to calculate price changes for other companies listed in Column A.
Step 6: Review and Customize
- Review the data in your spreadsheet to ensure accuracy.
- Customize the formatting and layout of your spreadsheet as needed.
- 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!