top of page

Google Sheets Look Up Stock Price

Updated: Jul 6, 2023

Are you tired of manually looking up stock prices? If so, you are in the right place. In this post, we will explain how you can use Google Sheets to look up stock prices.


Not only will this save you time, but it will also help you make more informed investment decisions. So, sit back, grab a cup of coffee, and let’s get started to unlock the full potential of Google Sheets for stock analysis and market data.



Look Up Stock Prices with GOOGLEFINANCE Formula


To look up stock prices in Google Sheets using the GOOGLEFINANCE formula, follow these six simple steps:

  1. List the ticker symbols in a column

  2. Add the dates as horizontal headers

  3. Enter the GOOGLEFINANCE formula in the cell where you want the stock price

    1. Ticker symbol: Add the ticker in the first column

    2. Attribute: Add “price”

    3. Start_date: Add the date in the header

  4. Wrap the INDEX formula around the GOOGLEFINANCE formula

    1. INDEX(GOOGLEFINANCE(),2,2)

  5. Press enter, and the stock price will appear in the cell

  6. Copy and paste the formula into other cells to look up stock prices for multiple companies and dates

By following these steps, you can easily retrieve real time stock prices in Google Sheets.


See how it can be done in the video here.


Try it yourself now!


Click here to copy paste the Google Sheet spreadsheet in the video.


Comments


bottom of page