In this tutorial, you will learn how to get stock prices in google sheets.
Google Sheets is a common choice for tracking stock prices and portfolio metrics due to the many relevant functions and charts that can be used to analyze trends over time, but did you know you can actually use Google Sheets to get stock prices? Instead of taking the time to find the prices of the stocks you’re interested in on the internet and copy/pasting them into your stock tracking Google Sheet, you can use the built in Google Finance function to pull financial data directly into Google Sheets. Here’s how:
Getting Stock Price Using GOOGLEFINANCE()
Let’s say we want to get the stock price of a given stock daily for a date range. Here’s how to use the GOOGLEFINANCE() function to do this:
Select a cell at the top of a blank column to enter the formula, making sure the following column is also blank to make room for the stock data
For this example, we’ll get the stock prices of Alphabet Inc (Google’s parent company), using the GOOG ticker symbol. GOOGLEFINANCE() allows us to choose a date range and a frequency. We’ll pull the data for the year 2022 daily
Type the following formula into the selected cell: “=GOOGLEFINANCE(“GOOG”, “price”, DATE(2022,1,1), DATE(2022,12,31), “DAILY”)”. The first parameter is the ticker symbol, which is the only required parameter. The other parameters specify what information about the stock we want to pull (in this case price, the start and end dates to pull, and whether to pull the data daily or weekly.
Hit enter and the stock data will populate for all dates in the range that are in the past
In addition to getting stock prices for a date range, you can also get the current stock price by including only the ticker symbol as a parameter: “=GOOGLEFINANCE(“GOOG”)”
Note that a disclaimer will appear stating that the stock prices are for informational purposes only and may be delayed
If you’re interested in other metrics of the stock aside from the price, Google Finance supports a number of other different metrics. Just replace the “price” parameter with the metric you’re interested in. For example, you could replace it with “priceopen” (The price as of market open.), “high” (The current day’s high price.), “low” (The current day’s low price.), “volume” (The current day’s trading volume.), “marketcap” (The market capitalization of the stock.), to name a few of the many available options.
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to get stock prices in google sheets. Want more? Check out all the Google Sheets Tutorials.