crypto-portfolio · git:20261102.ca94c46 · 2026-11-02 · sha256 97e6fcb317f77b99
crypto-portfolio git:20261102.ca94c46A
Immutable. This exact content never changes and is served at /api/v1/blob/97e6fcb317f77b99.
---
name: crypto-portfolio
description: Combine crypto exports from Binance, Coinbase, Kraken, Wealthsimple, WazirX, CoinDCX or a wallet into one ledger and show holdings, average cost and unrealized profit/loss, without API keys. Use when the user says "track my crypto", "what's my crypto worth", "combine my exchanges", uploads an exchange CSV, or asks about their crypto profit or loss.
---
# Crypto portfolio
## Safety first
- Work only from CSV exports the user downloads (Transaction history / Tax report on each exchange). Never ask for API keys, seed phrases or passwords.
- This is record-keeping, not trading advice. Don't predict prices or tell the user to buy or sell.
## Step 1: build one ledger
Read each export's headers and map every row into this format (one file for all exchanges):
```
date,type,asset,qty,price,fee,exchange,to
```
- `type`: buy, sell, income (staking, earn, airdrop, mining, referral rewards), transfer (between the user's own wallets).
- `price`: value of one unit in the user's tax currency (CAD, INR or USD) at that time. If an export is in USDT or another currency, convert with the rate on that date and say which rate source you used.
- `fee`: in the tax currency. A swap (BTC → ETH) becomes two rows: sell BTC and buy ETH at the fiat value.
- Withdrawals to and deposits from the user's own wallets are `transfer` rows (from `exchange` to `to`), not sells.
- Show the user the first 10 mapped rows and any rows you weren't sure about before running anything.
## Step 2: run
```
python scripts/crypto.py ledger.csv summary
python scripts/crypto.py ledger.csv summary --prices prices.csv # prices.csv: asset,price
```
Get current prices from the user or a price site they trust; say the time the prices are from.
## Step 3: show
Holdings table (asset, units, cost, value, unrealized %), allocation by asset, and total. If the app can make charts, draw allocation as a bar chart and cost vs value per asset.
## Tax
Use the country skill with the same ledger: canada-crypto-tax, india-crypto-tax or us-crypto-tax.
## Calculator code
If `scripts/crypto.py` isn't in this skill's folder (some apps keep only SKILL.md), save this code as `crypto.py` and run it the same way. Don't do the arithmetic by hand.
<!-- embed: scripts/crypto.py -->
```python
"""Crypto ledger: holdings and tax reports for Canada (ca), India (in) and the US (us).
Usage: python crypto.py ledger.csv summary [--prices prices.csv]
python crypto.py ledger.csv ca|in|us
ledger.csv columns: date,type,asset,qty,price,fee,exchange,to
date YYYY-MM-DD
type buy | sell | income (staking, airdrop, mining, rewards) | transfer (between your own wallets)
price value of ONE unit in your tax currency (CAD / INR / USD) at that moment
fee fee in your tax currency (can be blank)
exchange where it happened (Coinbase, Binance, Ledger...); for transfer, the wallet it left
to transfer only: the wallet it arrived in
Crypto-to-crypto swap = two rows on the same date: sell the coin you gave up, buy the coin you got, both at fiat value.
prices.csv (optional): asset,price current price per unit, for unrealized profit/loss.
"""
import csv
import sys
from collections import defaultdict, deque
from datetime import date
def load(rows):
out = []
for r in rows:
out.append(dict(d=date.fromisoformat(r["date"].strip()[:10]), t=r["type"].strip().lower(), a=r["asset"].strip().upper(),
q=float(r["qty"]), p=float(r.get("price") or 0), f=float(r.get("fee") or 0),
w=(r.get("exchange") or "").strip(), to=(r.get("to") or "").strip()))
return sorted(out, key=lambda x: (x["d"], x["t"] != "buy"))
def summary(tx):
"""Pooled average cost per asset across all wallets."""
q, cost = defaultdict(float), defaultdict(float)
for x in tx:
if x["t"] in ("buy", "income"):
q[x["a"]] += x["q"]; cost[x["a"]] += x["q"] * x["p"] + (x["f"] if x["t"] == "buy" else 0)
elif x["t"] == "sell":
avg = cost[x["a"]] / q[x["a"]] if q[x["a"]] else 0
q[x["a"]] -= x["q"]; cost[x["a"]] -= avg * x["q"]
return {a: (q[a], cost[a]) for a in q if q[a] > 1e-12}
def canada(tx):
"""Average cost (ACB) pooled across all wallets; superficial loss flag; staking etc. as income."""
q, cost = defaultdict(float), defaultdict(float)
gains, income, flags = defaultdict(float), defaultdict(float), []
for x in tx:
a, y = x["a"], x["d"].year
if x["t"] in ("buy", "income"):
q[a] += x["q"]; cost[a] += x["q"] * x["p"] + (x["f"] if x["t"] == "buy" else 0)
if x["t"] == "income":
income[y] += x["q"] * x["p"]
elif x["t"] == "sell":
if x["q"] > q[a] + 1e-9:
raise ValueError(f"{x['d']}: selling {x['q']} {a}, only {q[a]} recorded; add the missing buys")
acb = cost[a] / q[a] * x["q"]
g = x["q"] * x["p"] - x["f"] - acb
q[a] -= x["q"]; cost[a] -= acb; gains[y] += g
# ponytail: flags a rebuy within 30 days either side; doesn't compute the exact denied amount
if g < 0 and any(o["a"] == a and o["t"] in ("buy", "income") and abs((o["d"] - x["d"]).days) <= 30 and o is not x for o in tx):
flags.append(f"{x['d']} {a}: loss {-g:,.2f} may be a superficial loss (rebought within 30 days)")
return gains, income, flags
def fifo(tx, per_wallet):
"""FIFO lots. per_wallet=True for the US (basis tracked per wallet since 2025)."""
lots = defaultdict(deque) # key -> [qty, unit_cost, acquired]
sales, income, tds = [], defaultdict(float), defaultdict(float)
for x in tx:
key = (x["a"], x["w"]) if per_wallet else (x["a"],)
if x["t"] in ("buy", "income"):
lots[key].append([x["q"], x["p"] + x["f"] / x["q"] * (x["t"] == "buy" and per_wallet), x["d"]])
if x["t"] == "income":
income[x["d"]] += x["q"] * x["p"]
elif x["t"] == "sell" or (x["t"] == "transfer" and per_wallet): # transfers don't matter without per-wallet basis
left, dest = x["q"], (x["a"], x["to"]) if per_wallet else None
while left > 1e-12:
if not lots[key]:
raise ValueError(f"{x['d']}: moving {x['q']} {x['a']} from '{x['w']}' but not enough recorded there; add the missing buys or transfers")
lot = lots[key][0]; used = min(left, lot[0])
if x["t"] == "sell":
unit = x["p"] - (x["f"] / x["q"] if per_wallet else 0) # India: no deduction except cost
sales.append((x["d"], x["a"], used, used * unit, used * lot[1], lot[2]))
else:
lots[dest].append([used, lot[1], lot[2]])
lots[dest] = deque(sorted(lots[dest], key=lambda l: l[2])) # first in = earliest acquired
lot[0] -= used; left -= used
if lot[0] <= 1e-12:
lots[key].popleft()
if x["t"] == "sell":
tds[x["d"]] += x["q"] * x["p"] * 0.01
return sales, income, tds
def fy_india(d):
return d.year if d.month >= 4 else d.year - 1
def india(tx):
sales, income, tds = fifo(tx, per_wallet=False)
out = defaultdict(lambda: {"gains": 0.0, "losses_ignored": 0.0, "tds": 0.0, "income": 0.0})
for d, a, q, proceeds, cost, _ in sales:
g = proceeds - cost
out[fy_india(d)]["gains" if g > 0 else "losses_ignored"] += g
for d, v in tds.items():
out[fy_india(d)]["tds"] += v
for d, v in income.items():
out[fy_india(d)]["income"] += v
return out
def us(tx):
sales, income, _ = fifo(tx, per_wallet=True)
out = defaultdict(lambda: {"short": 0.0, "long": 0.0, "income": 0.0})
for d, a, q, proceeds, cost, acquired in sales:
long_term = (d.year, d.month, d.day) > (acquired.year + 1, acquired.month, acquired.day)
out[d.year]["long" if long_term else "short"] += proceeds - cost
for d, v in income.items():
out[d.year]["income"] += v
return out
def _selftest():
rows = [dict(date="2025-01-10", type="buy", asset="BTC", qty="1", price="40000", fee="0", exchange="Coinbase", to=""),
dict(date="2025-03-01", type="income", asset="ETH", qty="1", price="3000", fee="", exchange="Coinbase", to=""),
dict(date="2025-06-01", type="buy", asset="BTC", qty="1", price="60000", fee="0", exchange="Binance", to=""),
dict(date="2025-07-01", type="transfer", asset="BTC", qty="1", price="0", fee="", exchange="Coinbase", to="Binance"),
dict(date="2026-02-01", type="sell", asset="BTC", qty="1", price="70000", fee="0", exchange="Binance", to="")]
tx = load(rows)
g, inc, _ = canada(tx)
assert g[2026] == 20000 and inc[2025] == 3000 # sold at 70k vs average cost 50k
i = india(tx)
assert i[2025]["gains"] == 30000 and i[2025]["tds"] == 700 # FIFO: the 40k coin; FY 2025-26
u = us(tx)
assert u[2026]["long"] == 30000 and u[2026]["short"] == 0 # Binance holds the Jan coin (moved in) and the Jun coin; FIFO sells Jan first
assert summary(tx)["ETH"] == (1, 3000)
if __name__ == "__main__":
_selftest()
if len(sys.argv) < 3:
sys.exit(__doc__)
with open(sys.argv[1], newline="") as f:
tx = load(list(csv.DictReader(f)))
mode = sys.argv[2]
if mode == "summary":
prices = {}
if "--prices" in sys.argv:
with open(sys.argv[sys.argv.index("--prices") + 1], newline="") as f:
prices = {r["asset"].strip().upper(): float(r["price"]) for r in csv.DictReader(f)}
tot_cost = tot_val = 0
for a, (q, c) in sorted(summary(tx).items()):
line = f"{a}: {q:g} units, cost {c:,.2f} (avg {c / q:,.4f})"
if a in prices:
v = q * prices[a]; tot_val += v
line += f", value {v:,.2f}, unrealized {v - c:+,.2f} ({(v - c) / c:+.1%})" if c else f", value {v:,.2f}"
tot_cost += c
print(line)
print(f"Total cost {tot_cost:,.2f}" + (f", total value {tot_val:,.2f}, unrealized {tot_val - tot_cost:+,.2f}" if prices else ""))
elif mode == "ca":
g, inc, flags = canada(tx)
for y in sorted(set(g) | set(inc)):
print(f"{y}: capital gain/loss {g[y]:,.2f} CAD (taxable half {max(g[y], 0) / 2:,.2f}); staking/rewards income {inc[y]:,.2f} CAD")
for line in flags:
print("WARNING:", line)
print("If you trade often, CRA may treat gains as business income (100% taxable). Foreign-exchange holdings costing over $100,000 need form T1135.")
elif mode == "in":
for fy, v in sorted(india(tx).items()):
print(f"FY {fy}-{str(fy + 1)[2:]}: taxable VDA gains Rs {v['gains']:,.0f}, tax @30% + 4% cess Rs {v['gains'] * 0.312:,.0f}; "
f"losses that can't be set off Rs {-v['losses_ignored']:,.0f}; TDS est. Rs {v['tds']:,.0f} (check 26AS); "
f"staking/rewards income Rs {v['income']:,.0f} (taxed at slab rates)")
elif mode == "us":
for y, v in sorted(us(tx).items()):
print(f"{y}: short-term {v['short']:,.2f} USD, long-term {v['long']:,.2f} USD, staking/rewards income {v['income']:,.2f} USD")
print("Long-term is taxed at 0/15/20%, short-term and income at your bracket (see us-income-tax).")
else:
sys.exit("mode must be summary, ca, in or us")
```