How to Use GOOGLEFINANCE in Google Sheets: Stock & Currency Tracker Guide

TL;DR: The GOOGLEFINANCE function in Google Sheets lets you pull stock prices, currency exchange rates, historical prices, volume, market cap, P/E ratio, and some mutual fund data directly into a spreadsheet. I use it for simple personal finance tracking, portfolio watchlists, and currency conversion sheets. But it is not perfect: data can be delayed, some tickers do not work, and it should not be used for trading decisions.

Quick note: This is not investment advice. Google Finance data is useful for tracking and learning, but always verify prices from your broker or official source before making any financial decision.

If you use Google Sheets for budgeting, stock tracking, currency conversion, or personal finance dashboards, GOOGLEFINANCE is one of those formulas you should know.

I use Google Sheets a lot for finance-related tracking. Not because it is the fanciest tool, but because it is flexible, free, easy to edit, and works well when I want a custom setup instead of another paid app.

For example, I can build a simple sheet that shows:

• Current stock price of Apple, Google, TCS, or any supported stock.
• USD to INR exchange rate for international payments.
• Historical price movement of a stock for the last 30 days.
• Basic market data like volume, market cap, 52-week high, or P/E ratio.
• A lightweight portfolio tracker without manually typing every price.

That is where GOOGLEFINANCE helps.

It is not a replacement for a broker terminal or proper portfolio accounting software. But for personal tracking, dashboards, and learning, it is genuinely useful.

What is GOOGLEFINANCE in Google Sheets?

Short answer: GOOGLEFINANCE is a Google Sheets function that fetches current or historical securities information from Google Finance.

In plain English, it lets your spreadsheet talk to Google Finance and pull market data automatically.

The basic syntax is:

=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

Here is what each part means:

The simplest version only needs a ticker:

=GOOGLEFINANCE("NASDAQ:AAPL")

By default, Google Sheets returns the price if you do not specify an attribute.

Still, I prefer writing the attribute clearly because it makes the sheet easier to understand later:

=GOOGLEFINANCE("NASDAQ:AAPL", "price")

Google’s official documentation recommends using both the exchange code and ticker for better accuracy. So instead of using only "AAPL", use "NASDAQ:AAPL". Instead of only "TCS", use "NSE:TCS".

How to get the current stock price

Short answer: use =GOOGLEFINANCE("EXCHANGE:TICKER", "price").

For Apple stock, I would use:

=GOOGLEFINANCE("NASDAQ:AAPL", "price")

You can do the same for other US stocks:

=GOOGLEFINANCE("NASDAQ:GOOGL", "price")
=GOOGLEFINANCE("NASDAQ:MSFT", "price")
=GOOGLEFINANCE("NYSE:KO", "price")

The exchange prefix matters. Google can sometimes guess the exchange if you only enter the ticker, but I do not like relying on guessing in finance sheets. A clear ticker is better.

If you are making a portfolio tracker, put tickers in one column and use a formula reference instead of writing each formula manually.

Example:

Then you can copy the formula down for more tickers.

How to track Indian stocks in Google Sheets

Short answer: use exchange codes like NSE or BOM with the stock ticker.

For example, to get the current TCS price from NSE:

=GOOGLEFINANCE("NSE:TCS", "price")

For BSE, Google Finance uses BOM as the exchange code in many cases, not BSE. So a BSE-style formula may look like this:

=GOOGLEFINANCE("BOM:500325", "price")

That example uses a BSE code format. For Indian stocks, some tickers work cleanly and some do not. If one exchange does not work, check the same security on Google Finance and copy the format shown there.

Useful exchange examples:

One thing to remember: Google says GOOGLEFINANCE does not support most international exchanges. So if a ticker does not work, your formula may be correct and the data may simply not be available through Sheets.

How to get USD to INR exchange rate

Short answer: use CURRENCY:USDINR.

If you want the current USD to INR exchange rate in Google Sheets, use:

=GOOGLEFINANCE("CURRENCY:USDINR")

I use this kind of formula when I am working with international tools, SaaS subscriptions, affiliate payments, or anything where USD pricing affects my actual cost in India.

You can also use other currency pairs:

=GOOGLEFINANCE("CURRENCY:EURINR")
=GOOGLEFINANCE("CURRENCY:GBPUSD")
=GOOGLEFINANCE("CURRENCY:USDEUR")

If you want to convert an amount, multiply the value by the exchange rate.

Example: if A2 contains a USD amount, use:

=A2*GOOGLEFINANCE("CURRENCY:USDINR")

This is useful in budget trackers too. In my own Google Sheets monthly spending tracker, currency conversion is one of those small things that can make a sheet much more useful if you deal with foreign payments.

Just remember: Google’s own disclaimer says exchange rates should be confirmed before transactions that depend on the rate. So treat this as a tracking value, not a final settlement rate.

How to get historical stock data

Short answer: add a start date, end date, and interval.

For example, to get TCS historical prices for the last 10 days:

=GOOGLEFINANCE("NSE:TCS", "price", TODAY()-10, TODAY(), "DAILY")

You can also use fixed dates:

=GOOGLEFINANCE("NASDAQ:AAPL", "close", DATE(2025,1,1), DATE(2025,12,31), "WEEKLY")

For historical data, Google supports only these attributes:

• "open"
• "close"
• "high"
• "low"
• "volume"
• "all"

This is an important detail. If you specify dates, Google treats the formula as a historical request. That means attributes like "pe", "marketcap", or "eps" may not work in the historical format.

Also, historical data returns as an expanded table with headers. So do not place it in a cell where there is data immediately below or to the right, otherwise Google Sheets may throw an expansion error.

Useful GOOGLEFINANCE attributes

Short answer: price, volume, marketcap, pe, eps, high52, and low52 are some of the most useful for current data.

Here are formulas I actually find useful:

Some attributes do not return data for every symbol. If a formula works for Apple but not for a smaller stock or non-US ticker, it may not be your mistake. Google Finance may simply not have that attribute available for that instrument.

For mutual funds, Google supports a different set of attributes such as closeyest, date, returnytd, netassets, yieldpct, and expenseratio. I do not rely on this heavily for Indian mutual fund tracking because not every fund behaves the way I want in Sheets, but it can be useful for quick checks.

How I would build a simple stock tracker

If I were making a simple portfolio watchlist, I would keep it boring and clean.

Example structure:

This is not enough for tax reporting or serious portfolio management, but it is enough for a quick personal dashboard.

If you invest across currencies, add another column for currency conversion. For example, if a US stock is priced in USD and you want an INR estimate, multiply the USD value by GOOGLEFINANCE("CURRENCY:USDINR").

I like this approach because the sheet stays understandable. You do not need 50 formulas on day one. Start with ticker, quantity, buy price, current price, current value, and profit/loss. Add more only when you actually need it.

Common GOOGLEFINANCE errors and fixes

Here are the issues I see most often.

1. Formula returns #N/A

This usually means Google Finance could not fetch the symbol or attribute.

Try these fixes:

• Use the exchange prefix: NASDAQ:AAPL instead of AAPL.
• Check whether the ticker exists on Google Finance.
• Try a different supported attribute.
• For historical data, use only historical attributes like open, close, high, low, volume, or all.

2. Formula parse error

This is usually a syntax issue.

Check commas, quotes, and your spreadsheet locale. Some locales use semicolons instead of commas in formulas.

Comma version:

=GOOGLEFINANCE("NASDAQ:AAPL", "price")

Semicolon version:

=GOOGLEFINANCE("NASDAQ:AAPL"; "price")

3. Historical data does not fit

Historical results expand into multiple rows and columns. Clear the cells below and beside the formula before running it.

4. Price looks delayed

That is normal. Google’s docs say quotes may be delayed up to 20 minutes, and the delay depends on the market/data source. For trading, use your broker’s live quote, not a spreadsheet formula.

5. Apps Script or Sheets API cannot pull historical data

Google’s documentation says historical GOOGLEFINANCE data cannot be downloaded or accessed through the Sheets API or Apps Script. So if you are trying to build an automated backend around it, expect problems.

Limitations you should know

I like GOOGLEFINANCE, but I do not trust it blindly.

These are the main limitations:

• Quotes may be delayed.
• Some exchanges and symbols are not supported.
• Some attributes do not work for all stocks.
• Historical data uses a smaller attribute set.
• Historical data cannot be accessed through the Sheets API or Apps Script.
• Google says the information is provided as-is and not for trading or investment advice.
• Currency rates should be verified before actual transactions.

For personal dashboards, this is fine. For actual trading, tax calculations, or compliance-heavy reporting, use better sources.

This is the same mindset I use with credit card and spending trackers. A spreadsheet can give clarity, but it does not remove judgment. I shared a similar practical approach in my HDFC credit card limit increase guide: tools help, but your behaviour still matters.

FAQ

Is GOOGLEFINANCE free in Google Sheets?

Yes, the function is available inside Google Sheets. You do not need a paid add-on for basic stock, currency, and historical data supported by Google Finance.

Can GOOGLEFINANCE track Indian stocks?

Yes, many Indian stocks work with exchange prefixes like NSE and BOM. But not every symbol or attribute works perfectly, so check the ticker format on Google Finance if you get an error.

Is GOOGLEFINANCE real-time?

Not always. Google says quotes may be delayed up to 20 minutes, depending on the market and data source. Do not use it as your only source for live trading.

Can I use GOOGLEFINANCE for currency conversion?

Yes. Use formulas like =GOOGLEFINANCE("CURRENCY:USDINR"). For actual transactions, verify the rate with your bank, broker, or payment provider.

Why is GOOGLEFINANCE not working?

Common reasons include wrong ticker format, unsupported exchange, unsupported attribute, syntax errors, or trying to use real-time attributes in a historical formula. Use the exchange prefix and test a simple price formula first.

Can I use GOOGLEFINANCE in Excel?

No, GOOGLEFINANCE is a Google Sheets function. Microsoft Excel has its own stock data features, but the Google Sheets formula itself does not work in Excel.

Summing Up!

GOOGLEFINANCE is one of the most useful Google Sheets functions if you like building your own finance trackers.

You can use it to pull stock prices, currency exchange rates, historical data, volume, market cap, P/E ratio, and other useful market fields directly into your spreadsheet.

My advice is simple: use it for tracking, dashboards, learning, and personal finance visibility. Do not use it as your only source for trading, tax reporting, or serious investment decisions.

Start with a clean watchlist, use proper exchange-prefixed tickers, keep formulas simple, and verify important numbers before acting on them.

That is where GOOGLEFINANCE shines: not as a professional market terminal, but as a simple free way to make Google Sheets smarter for finance tracking.