Track Stock Prices in Google Sheets: Complete GOOGLEFINANCE Guide

Why Track Stocks in Google Sheets?

Picture your mornings: you wake up, and before coffee, you're manually updating your investment tracker. Fifteen different stock codes, copy-paste, paste, copy-paste. Repeat daily. Rinse. Repeat tomorrow.

Manual tracking is tedious. Worse, it's error-prone. You might type the wrong ticker, or use yesterday's price instead of today's. One digit difference is hundreds of dollars in miscalculation.

Google Sheets' GOOGLEFINANCE function fixes this problem. It automatically fetches live prices from the web. Your numbers are always fresh—no manual updates needed. Set the formula once, and it works forever.

In this guide, you'll learn exactly how GOOGLEFINANCE works and how to build your own auto-updating portfolio tracker.

GOOGLEFINANCE Basics: Syntax & Parameters

GOOGLEFINANCE is a built-in Google Sheets function that pulls stock prices, fund data, and currency quotes. Here's the syntax:

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

Parameter Breakdown

ticker (required) The stock code. Format depends on exchange:

• Taiwan stocks: TPE:code (e.g., TPE:2330 = TSMC)
• US stocks: exchange prefix + code (e.g., NASDAQ:AAPL = Apple)
• Cryptocurrencies: CURRENCY:code (e.g., CURRENCY:BTC = Bitcoin in USD)

attribute (optional, default "price") What you want to retrieve:

• "price" — Current stock price (most common)
• "high" — Today's high
• "low" — Today's low
• "open" — Opening price
• "close" — Yesterday's closing price
• "volume" — Trading volume
• "pe" — Price-to-earnings ratio
• "market_cap" — Market capitalization

start_date & end_date (optional) For historical prices, specify a date range. Format: DATE(2026,3,1) or "2026-03-01"

interval (optional) Data frequency. 1 = daily, 7 = weekly.

Most Common Use Cases

Get current price:

=GOOGLEFINANCE("TPE:2330")

Get P/E ratio:

=GOOGLEFINANCE("TPE:2330", "pe")

Get today's high:

=GOOGLEFINANCE("TPE:2330", "high")

Taiwan Stock Examples

Taiwan Stock Ticker Format

Taiwan listed stocks use the format TPE:XXXX, where XXXX is a four-digit code.

Common examples:

| Company | Code | GOOGLEFINANCE Format | |---------|------|---------------------| | TSMC | 2330 | TPE:2330 | | Foxconn (Hon Hai) | 2317 | TPE:2317 | | MediaTek | 2454 | TPE:2454 | | Bank of Taiwan | 2880 | TPE:2880 | | Cathay Financial | 2882 | TPE:2882 | | Chunghwa Telecom | 1326 | TPE:1326 |

Real Formula Examples

Try these in your Google Sheet:

Get TSMC's current price:

=GOOGLEFINANCE("TPE:2330")

Returns: TSMC's current price (e.g., 990)

Get TSMC's P/E ratio:

=GOOGLEFINANCE("TPE:2330", "pe")

Returns: P/E ratio (e.g., 28.5)

Get Foxconn's trading volume:

=GOOGLEFINANCE("TPE:2317", "volume")

Returns: Volume in shares (e.g., 12345600)

US Stock Examples

US Stock Ticker Format

US stocks require the exchange prefix:

• NASDAQ: — Nasdaq (tech-heavy)
• NYSE: — New York Stock Exchange (blue chips)

Common examples:

| Company | Ticker | Exchange | GOOGLEFINANCE Format | |---------|--------|----------|---------------------| | Apple | AAPL | NASDAQ | NASDAQ:AAPL | | Microsoft | MSFT | NASDAQ | NASDAQ:MSFT | | Tesla | TSLA | NASDAQ | NASDAQ:TSLA | | TSMC ADR | TSM | NYSE | NYSE:TSM | | Nvidia | NVDA | NASDAQ | NASDAQ:NVDA | | Google | GOOGL | NASDAQ | NASDAQ:GOOGL |

Real Formula Examples

Get Apple's stock price:

=GOOGLEFINANCE("NASDAQ:AAPL")

Get Tesla's P/E ratio:

=GOOGLEFINANCE("NASDAQ:TSLA", "pe")

Get Microsoft's daily high:

=GOOGLEFINANCE("NASDAQ:MSFT", "high")

Build Your Own Portfolio Tracker

Now that you understand GOOGLEFINANCE, let's build a simple portfolio tracker table.

Table Structure

Set up these columns:

| Stock Name | Ticker | Shares | Buy Price | Current Price (Auto) | Market Value | Cost Basis | Gain/Loss $ | Gain/Loss % | |-----------|--------|--------|-----------|-------------------|---------|----------|-----------|-----------| | TSMC | TPE:2330 | 10 | 800 | ? | ? | 8,000 | ? | ? | | Foxconn | TPE:2317 | 5 | 180 | ? | ? | 900 | ? | ? | | Apple | NASDAQ:AAPL | 2 | 150 | ? | ? | 300 | ? | ? |

Formula Setup

Current Price column (assume column E):

=GOOGLEFINANCE(B2)

Automatically fetches the price for the ticker in cell B2.

Market Value column (assume column F):

=C2*E2

Shares × Current Price = What your position is worth today.

Cost Basis column (assume column G):

=C2*D2

Shares × Buy Price = How much you originally invested.

Gain/Loss $ column (assume column H):

=F2-G2

Market Value − Cost Basis = Profit or loss in dollars.

Gain/Loss % column (assume column I):

=(H2/G2)*100

(Gain/Loss $ ÷ Cost Basis) × 100 = Return percentage.

Complete Worked Example

Say you hold:

• 10 shares of TSMC, bought at 800
• Current price: 990

| Item | Value | |------|-------| | Shares | 10 | | Buy Price | 800 | | Current Price | 990 (auto-fetched) | | Market Value | 9,900 (10 × 990) | | Cost Basis | 8,000 (10 × 800) | | Gain/Loss $ | 1,900 (9,900 − 8,000) | | Gain/Loss % | 23.75% (1,900 ÷ 8,000 × 100) |

Once you set up the formulas, Google Sheets refreshes the prices automatically. Your returns recalculate in real-time.

GOOGLEFINANCE Limitations & Gotchas

1. Price Data is Delayed

GOOGLEFINANCE isn't truly real-time. Taiwan and US stocks are typically delayed by 15−20 minutes. If you're a day trader who needs second-by-second prices, this isn't the tool.

2. No Cryptocurrency Support

GOOGLEFINANCE handles stocks and some funds, but not Bitcoin, Ethereum, or other cryptocurrencies. (The CURRENCY:BTC syntax exists but is unreliable.)

3. No Taiwan OTC Stocks

Only listed stocks work. Over-the-counter (OTC) and emerging stocks aren't supported.

4. Requires Internet Connection

GOOGLEFINANCE fetches data live. If you open your spreadsheet offline, prices will be whatever they were last refreshed. No connection = no update.

5. Ticker Format Must Be Exact

One typo (e.g., TPE2330 without the colon) and the formula returns #N/A or #VALUE! error.

When GOOGLEFINANCE Isn't Enough

If your needs go beyond GOOGLEFINANCE—like tracking crypto, handling multi-currency portfolios, creating beautiful dashboards, or just not wanting to maintain a spreadsheet—there's a better way.

WalletMap is built for investors who want automation and intelligence. Here's why people choose it:

• Auto-fetch Taiwan, US, and crypto prices: One setup, unlimited updates
• Your data stays in your Google Sheets: We don't store any of your financial information
• Automatic currency conversion: Multi-currency portfolios handled seamlessly
• Real-time charts and insights: See your portfolio performance and net worth trends instantly
• Set it and forget it: No manual updates. The system works in the background.

Think of WalletMap as GOOGLEFINANCE++ — it takes the power of GOOGLEFINANCE, adds automation, polishes the visuals, and throws in crypto support.

Summary: Start Tracking Your Stocks Today

GOOGLEFINANCE is powerful and free. If you only track Taiwan and US stocks, a few formulas get the job done.

The process is simple:

1. Open a Google Sheet
2. Create a table (ticker, shares, buy price)
3. Use =GOOGLEFINANCE("ticker") in the Current Price column
4. Add simple formulas for gains/losses
5. Done. It updates automatically.

But if your portfolio grows complex (crypto, multiple currencies, want better visualization), or if you just don't want to babysit a spreadsheet, WalletMap takes over. It transforms your Google Sheets into a real investment dashboard.

Whichever path you choose, the important thing is starting. Invisible assets are worthless assets. Track them.