I will build custom crypto portfolio tracker in google sheets

China

I speak Chinese, English

Crypto Spreadsheet Developer Financial Tool Builder

I build professional-grade Google Sheets tools for crypto traders and investors. My templates handle live CoinGecko price tracking, multi-wallet portfolio management, FIFO tax reporting, trade journ...
About this Gig

Crypto Portfolio & Tax Tracker Built in Google Sheets


I build professional Google Sheets templates that replace expensive crypto tax and portfolio SaaS. No subscriptions. No data harvesting. Your data stays in YOUR Google Drive.



What I'll build for you:


Portfolio Dashboard

Multi-wallet holdings tracking

Live crypto prices via CoinGecko API (no API key needed)

Auto-calculated P&L and asset allocation

Color-coded profit/loss


Tax Report (Standard & Premium)

FIFO cost basis calculation

Short-term vs long-term gain classification

Staking, airdrop, and mining income tracking

Accountant-ready export


Trade Journal (Standard & Premium)

Long and short trade P&L

Win rate by strategy

Profit factor and R:R ratio


DeFi Dashboard + NFT Tracker (Premium)

Multi-protocol yield tracking

Impermanent loss calculator

NFT collection and rarity log



Why Google Sheets over apps?

No monthly subscriptions

Full control edit any formula

Private no wallet connections

Accessible on any device


Every delivery includes setup guide, sample data, and CoinGecko price script.


Need something custom? Just ask.


Message me before ordering to confirm your requirements.

Platform:

Excel

Google Sheets

Development technology:

Google Apps Script

Python

Excel

Expertise:

Formulas

Functions

Dashboard

Related tags