Google Finance is a free tool that lets you track stock prices, build investment portfolios, compare securities, and pull live market data directly into Google Sheets. You can access it at google.com/finance from any browser, and most features work without any account, though you’ll need to sign in with a Google account to save portfolios. Here’s how to get the most out of each feature.
Navigate the Google Finance Homepage
When you visit google.com/finance, the homepage shows a snapshot of major market indices, trending stocks, and financial news. Across the top, you’ll see performance summaries for indices like the S&P 500, Dow Jones, and Nasdaq. Below that, Google surfaces stocks that are gaining attention based on search activity and market movement.
To look up any individual stock, mutual fund, or cryptocurrency, use the search bar at the top. Type a company name or ticker symbol, and Google will pull up a dedicated page with the current price, a performance chart, and key financial data. This is your starting point for deeper research.
Create and Manage a Portfolio
Google Finance lets you build portfolios that track the real-world performance of your investments. This isn’t a brokerage account; you’re manually entering your holdings so you can monitor them in one place.
To create a portfolio, go to google.com/finance, look to the right side of the page, and click “New portfolio.” Give it a name and click “Done.” From there, click “Add investments” and search for a stock, mutual fund, or cryptocurrency. When you select it, you’ll be prompted to enter three pieces of information: the number of shares you own, the date you purchased them, and the price you paid per share at the time. If you bought the same stock on different dates at different prices, click “More purchases” to add each transaction separately. Once everything looks right, click “Save.”
After you’ve added your holdings, the portfolio page shows two key return figures. “1 Day” tells you how much your portfolio gained or lost over the previous trading day. “Total” shows your overall return since you bought each position, calculated as the difference between the current market value and the cost basis you entered. This gives you a quick read on whether your investments are up or down without logging into a brokerage.
You can create multiple portfolios if you want to separate different accounts or strategies. Some people keep one for their retirement holdings and another for individual stock picks they’re watching.
Research Individual Stocks
Searching for a ticker on Google Finance pulls up a detail page packed with useful data. At the top, you’ll see the current share price and a chart showing performance over various time frames, from one day out to five years or more.
Below the chart, you’ll find key financial metrics that help you evaluate whether a stock is priced fairly relative to its earnings and growth. The most commonly referenced include:
- P/E ratio (price-to-earnings): This divides the stock price by earnings per share. A P/E of 25 means investors are paying $25 for every $1 of annual profit. Higher ratios suggest investors expect strong future growth, while lower ratios may signal a bargain or slower growth prospects.
- Market cap: The total value of all outstanding shares. This tells you whether you’re looking at a large, established company or a smaller one.
- Dividend yield: The annual dividend payment as a percentage of the stock price, useful for income-focused investors.
- 52-week high and low: The highest and lowest prices the stock has traded at over the past year, giving you a sense of its recent range.
Google Finance also links to related news articles and shows how analysts rate the stock. For deeper fundamental analysis, like reviewing income statements or balance sheets, you’ll typically need to click through to the company’s investor relations page or a dedicated financial data site. Google Finance provides the quick-glance metrics well but doesn’t offer the full financial statement breakdowns that more specialized platforms do.
Compare Stocks and Market Performance
One of Google Finance’s most practical features is the ability to overlay multiple securities on a single chart. To use it, search for a stock and open its detail page. Below the chart, you’ll see a few recommended securities to compare against. Click any of them to add their performance line to the same chart. If you want to compare against something specific, click “Compare” and search for any other ticker or index.
This is particularly useful when you want to see how a stock has performed relative to the broader market. Comparing a tech stock against the Nasdaq or S&P 500 over the past year, for example, quickly shows whether it’s outperforming or lagging behind. To remove a security from the comparison, click the remove icon next to its name.
You can also compare entire markets. From the Google Finance homepage, click “Compare Markets” at the top of the screen and pick a region or asset class, such as Europe or Currencies. This expands a chart showing how different markets have moved over time, which is helpful if you’re considering international diversification.
Pull Live Data Into Google Sheets
The GOOGLEFINANCE function in Google Sheets is one of the most powerful features for anyone who wants to build custom trackers or dashboards. It lets you pull real-time and historical stock data directly into a spreadsheet cell.
The basic syntax is straightforward. To get the current price of a stock, type this into any cell:
=GOOGLEFINANCE(“NASDAQ:GOOG”, “price”)
Replace the ticker with whatever you want to track. The second part, called the attribute, tells the function what data to return. Common attributes include “price” for the current share price, “volume” for trading volume, “marketcap” for market capitalization, “pe” for the price-to-earnings ratio, “high” for the day’s high, and “low” for the day’s low.
For the most accurate results, include both the exchange symbol and the ticker, like “NASDAQ:GOOG” rather than just “GOOG.” If you use only the ticker, Google will guess which exchange you mean, and it doesn’t always guess correctly.
You can also pull historical data by adding date parameters. For example:
=GOOGLEFINANCE(“NASDAQ:GOOG”, “close”, “1/1/2024”, “12/31/2024”, “DAILY”)
This returns a table of daily closing prices for the specified date range. You can change “DAILY” to “WEEKLY” for less granular data. The function also works for currency exchange rates. Typing =GOOGLEFINANCE(“CURRENCY:USDEUR”) returns how many euros one U.S. dollar buys.
A few limitations worth knowing: quotes may be delayed up to 20 minutes, the function is only available in English, and not all international exchanges are fully supported. Some exchanges have known reliability issues where certain tickers don’t return data consistently. Google also restricts professional financial industry use of this data, so it’s designed for personal tracking rather than commercial applications.
Build a Custom Watchlist
If you don’t want to enter purchase details but still want to keep an eye on specific stocks, you can use Google Finance portfolios as simple watchlists. Create a portfolio and add investments without filling in share quantities or purchase prices. This gives you a list of securities you can check at a glance, with current prices and daily movement, without tracking returns.
You can also follow individual stocks directly from their detail pages. When you search for a ticker, look for the option to add it to a portfolio or follow it. Followed stocks appear on your Google Finance homepage under your portfolios, making it easy to scan your entire list of interests in one visit.
Access Google Finance on Mobile
There’s no standalone Google Finance app, but the full experience works through your mobile browser at google.com/finance. You can also search for any stock ticker directly in the Google app or Google Search on your phone, which surfaces the same price charts, key metrics, and comparison tools. Your saved portfolios sync across devices as long as you’re signed into the same Google account, so anything you set up on desktop will be waiting on your phone.