How to Build a Crypto Portfolio Tracker in Notion(With Live Prices)
Build a fully self-updating crypto portfolio tracker in Notion — complete with live prices from CoinGecko, P&L formulas, and views that surface your best performers at the top.
Why build your own instead of using CoinMarketCap?
Full control
Your layout, your properties, your views. No ads, no cluttered UI, no feature you don't need.
Linked to your workspace
Attach wallet addresses, DCA logs, research notes, and tax records to each coin row — all in Notion.
Your data, always
No portfolio lock-in. Export anytime, share with a partner, or migrate — your data is yours.
Want a full comparison? See Pulsn vs CoinMarketCap portfolio →
Design your database schema
Create a full-page Notion database with the following properties. The auto-synced columns are filled by Pulsn — you only need to enter your holdings and cost basis manually.
| Property | Type | What it does |
|---|---|---|
| Coin | Title | Full name (e.g. Bitcoin) |
| Ticker | Text | Short symbol (e.g. BTC) |
| Current Price | Number | Auto-synced by Pulsn |
| Market Cap | Number | Auto-synced by Pulsn |
| 24h Change (%) | Number | Auto-synced by Pulsn |
| Units Held | Number | Your holdings |
| Avg Buy Price | Number | Your cost basis per coin |
| Total Value | Formula | Current Price × Units Held |
| P&L | Formula | (Current Price − Avg Buy Price) × Units Held |
| P&L % | Formula | ((Current Price − Avg Buy Price) / Avg Buy Price) × 100 |
| Notes | Text | Research, buy rationale, target price |
Add the P&L formulas
Once Pulsn keeps the Current Price property updated, these formulas calculate your position value and profit/loss automatically.
Total Value
P&L ($)
P&L (%)
Connect Pulsn and add sync flows
- 1Click Connect Notion free →. Notion will ask you to authorize Pulsn and select which databases to grant access to.
- 2After authorizing, you'll be redirected back to Pulsn. Pick your crypto portfolio database from the list.
- 3Pulsn adds a Pulsn Actions column to your database with a “Configure sync” link on each row.
- 4Click “Configure sync” on the first row (e.g. Bitcoin) to open the sync configuration form for that row. Build your sync flows — one per coin per metric:
Each row in your database gets its own sync flows — so Bitcoin in row 1 and Ethereum in row 2 each track their own coin.
Set up your portfolio views
Portfolio table
All coins in one view. Sort by P&L % (descending) to see your best performers at the top.
Gallery view
Visual card per coin. Great as a dashboard — show the coin name, current price, and 24h change on each card.
Watchlist filter
Add a Select property called 'Category' and filter to show only your active positions vs. watchlist coins.
Start building your tracker
Pulsn is free for one Notion database. No credit card required.
Connect Notion for free →