Logo

Track Stocks in Notion with Live Prices: 4 Ways (2026)

Live prices for stocks, ETFs, and crypto inside Notion. Database setup, trade tracking, and 4 ways to automate prices — free, paid, and DIY.
Track Stocks in Notion with Live Prices: 4 Ways (2026)

Notion doesn't have built-in stock tracking. But with the right database structure and an external integration for prices, you can build a portfolio tracker that stays up to date.

This guide covers the database setup, how to record trades, and your options for getting live prices.

Short answer: to track stocks in Notion with live prices, you need (1) a Trades database with Symbol, Quantity, and Price properties, and (2) something external that writes current prices back into Notion. Four options exist: a finished tool like ($29 one-time, covers 100+ exchanges plus crypto), a subscription service like NotionInvest, a Make/Zapier automation pulling from Alpha Vantage / Twelve Data / Financial Modeling Prep, or manual updates if your portfolio is stable.

The Trades database

The Trades database is where you record every investment transaction—buying shares, selling positions, or acquiring crypto. It's separate from your regular income/expense tracking because investments work differently: you're not spending money, you're exchanging it for assets that have fluctuating value.

Every buy or sell is a row. Here's the structure:

PropertyWhat it does
SymbolTicker symbol (AAPL, MSFT, VTI, BTC)
AccountWhich investment account holds this position
CategoryStock, ETF, Crypto, or Commodity
TypeBuy or Sell
DateTrade date
QuantityNumber of shares/units
Price✨Price per unit (can be auto-updated)
Value✨Calculated: Quantity × Price
Currency✨Inherited from the linked Account

The properties are formulas or auto-updated fields.

Recording a trade

When you buy a stock:

  1. Open the Trades database
  2. Enter the symbol: "AAPL"
  3. Select account: "Vanguard Brokerage"
  4. Set category: Stock
  5. Set type: Buy
  6. Enter date, quantity, and price

Example:

Symbol: AAPL
Account: Vanguard Brokerage
Category: Stock
Type: Buy
Date: 2026-04-01
Quantity: 10
Price: 223.45

The Value✨ formula automatically shows $2,234.50.

When you sell, create another trade with Type: Sell. The system calculates your holdings by summing buys and subtracting sells.

What you can track

You're not limited to stocks. Use the Category property to organize different asset types:

CategoryExamples
StockAAPL, MSFT, GOOGL
ETFVTI, VOO, QQQ
CryptoBTC, ETH, SOL
CommodityGold, Silver

All four work with automatic price updates.

Getting real-time prices

Notion is a database tool, not a financial data provider. It can't pull stock prices from the market on its own—there's no built-in connection to financial APIs.

This means if you just create a Trades database and add your holdings, the prices will stay frozen at whatever you entered. Your portfolio value won't update as markets move.

To get live prices, you need something external that:

  1. Fetches current prices from a financial data source
  2. Writes those prices back into your Notion database

Here are your options:

The app updates prices automatically in the background. You don't configure anything—prices refresh periodically for all your holdings.

Works with stocks (US, EU, Asia exchanges), ETFs, crypto, and commodities. One-time purchase ($29), no subscription.

Option 2: NotionInvest

A third-party service that syncs prices to a Notion database. You create a "Prices" database, add your tickers, and it updates every 30 minutes.

Pricing: €2.90/month or €27.90/year (subscription).

Setup:

  1. Create a Prices database with Symbol and Price properties
  2. Connect NotionInvest to your workspace
  3. Add tickers to sync

Then use a relation + rollup to pull prices into your Trades database.

Option 3: Make/Zapier + API

For full control, use an automation tool with a financial API:

  1. Create a Make (or Zapier) account
  2. Connect to a price API (Alpha Vantage, Financial Modeling Prep, Twelve Data)
  3. Set up a scheduled automation that updates Notion

This requires more setup but gives you control over update frequency and data sources.

Option 4: Manual updates

If your portfolio doesn't change often, you can update prices manually. Create a "Last Updated" date property to track freshness.

Not ideal for active tracking, but works for quarterly check-ins.

Calculating portfolio value

Once prices update, your portfolio value calculates automatically:

Portfolio Value = Sum of (Quantity × Price) for all holdings

Create a Notion view that:

  • Filters to current holdings (net quantity > 0)
  • Groups by Account or Category
  • Shows sum of Value✨

Connecting to net worth

If you're tracking net worth, your investment accounts should be part of the picture.

The key is linking trades to accounts:

  • Each trade belongs to an investment account (via the Account relation)
  • The account's total value sums all trade values
  • Net worth includes these investment accounts alongside cash, property, and liabilities

This way, when stock prices update, your net worth updates too. For the full setup:

Views that help

Create these saved views in your Trades database:

ViewFilter/GroupPurpose
All HoldingsGroup by Symbol, filter to net quantity > 0See current positions
By AccountGroup by AccountSee holdings per brokerage
By CategoryGroup by CategoryStocks vs ETFs vs Crypto
Recent TradesSort by Date descendingReview recent activity
PerformanceAdd gain/loss calculationSee winners and losers

Tracking dividends

If you receive dividends, record them as income transactions linked to the investment account:

  1. Open the Incomes database
  2. Name: "AAPL Dividend Q1"
  3. Account: Vanguard Brokerage
  4. Amount: (dividend amount)
  5. Date: (payment date)

This keeps your account balance accurate and tracks income separately from capital gains.

What Notion won't do

Be realistic about what you're building:

  • No automatic trade import. You enter trades manually (or via CSV import).
  • No real-time streaming. Prices update periodically, not live tick-by-tick.
  • No advanced analytics. No Sharpe ratio, beta, or Monte Carlo simulations. Use a dedicated tool for that.
  • No tax lot tracking. For tax purposes, use your brokerage's records.

Notion is good for seeing your portfolio at a glance and tracking against your overall finances. It's not a replacement for a brokerage dashboard.

Frequently asked questions

Can Notion show live stock prices?

Not on its own. Notion's databases only display values you enter or calculate. To show live prices, you need a tool or automation that fetches the price from a financial data source and writes it into a Notion property. The four options above cover the main ways to do that.

Is there a free Notion stock price tracker?

Yes, two paths. The fully manual route is free but you update prices yourself. A Make or Zapier automation paired with a free-tier API (Alpha Vantage and Financial Modeling Prep both have free tiers) costs nothing for low-volume use, but the setup takes an evening. Finished products like ($29 one-time) save the setup time and cover 100+ exchanges out of the box.

How often do stock prices update in Notion?

Depends on the method. Manual updates are whenever you do them. Make/Zapier automations can run every 15 minutes on free tiers. Subscription services like NotionInvest update every 30 minutes. refreshes prices in the background every 30 minutes for all your holdings without configuration.

Can Notion track crypto prices?

Yes, the same setup works. Use BTC, ETH, SOL, etc. as ticker symbols and pick a price source that supports crypto. Most modern financial APIs (Twelve Data, CoinGecko, Financial Modeling Prep) and the finished tools listed above include crypto alongside stocks.

Can I track stocks from non-US exchanges in Notion?

Yes, but the price source matters. Many free APIs are US-only. For European, Asian, or other exchanges you need a provider that covers global markets — Twelve Data covers 100+ exchanges, Alpha Vantage has limited international coverage, and supports global exchanges by default.

Next steps

  • — see how trades connect to accounts and net worth
  • — if you invest in foreign markets
  • — if you also want budgeting in Notion
Get Notion Finance Tracker — stock and crypto tracking with automatic price updates, connected to your accounts and net worth.