Spreadsheet: 766912d1644164527-problem-regarding-building-a-portfolio-sheet-1portfolio-tracker
Sheet: Crypto Portfolio

 | [NAME]
 | 📍 Input holdings and label by category; edit categories by right clicking the dropdown and selecting Data Validation
 | 📍 Futher automation is possible using price feeds and various APIs; please share your modifications and improvements!
 | BTC Price |  | ETH Price |  | [NAME] (USD) |  |  |  |  | [NAME] (BTC) |  |  | [NAME] (ETH) |  |  | Annual Passive Income
 | Total Position Mix
 | Metrics here are auto-calculated by adding your positions in the green boxes below
 | Category |  | $ |  | %
 | Bitcoin
 | Ethereum
 | DeFi
 | ETH Killer
 | Web3
 | Metaverse
 | Other
 | Stablecoin
 | [Custom Category]
 |  | Total Crypto Assets
 |  | Less Debts
 |  | Net Portfolio Value
 | Inputs
 | Non-Interest Bearing Holdings
 | Asset |  | $ |  | BTC Value | Eth Value | Category |  | Mix of Non-Interest-Bearing Holdings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | BTC |  | 5000 |  |  |  | Bitcoin |  |  |  |  |  |  |  | Transaction type |  | $ |  |  | Transaction type |  | $
 | ETH |  | 1500 |  |  |  | Ethereum |  | Category |  | $ |  | % |  | Bitcoin |  |  |  |  | Bitcoin
 | YFI |  | 1000 |  |  |  | DeFi |  | Bitcoin |  |  |  |  |  | Ethereum |  |  |  |  | Ethereum
 | LUNA |  | 1000 |  |  |  | ETH Killer |  | Ethereum |  |  |  |  |  | DeFi |  |  |  |  | DeFi
 | MANA |  | 1000 |  |  |  | Metaverse |  | DeFi |  |  |  |  |  | ETH Killer |  |  |  |  | ETH Killer
 | DAI |  | 1500 |  |  |  | Stablecoin |  | ETH Killer |  |  |  |  |  | Web3 |  |  |  |  | Web3
 |  |  | 0 |  |  |  |  |  | Web3 |  |  |  |  |  | Metaverse |  |  |  |  | Metaverse
 |  |  | 0 |  |  |  |  |  | Metaverse |  |  |  |  |  | Other |  |  |  |  | Other
 |  |  | 0 |  |  |  |  |  | Other |  |  |  |  |  | Stablecoin |  |  |  |  | Stablecoin
 |  |  | 0 |  |  |  |  |  | Stablecoin
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  | Total
 |  |  | 0 |  |  |  |  |  |  | Total
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | Total
 | Interest-Bearing Holdings
 | Log LP positions and other holdings generating yield; use both category columns for multi-category LPs
 | Position |  | $ |  | APR | Annual Income |  |  |  |  | Category I |  | Weight | $ |  | Category II |  | Weight | $
 | USDC-ETH LP |  | 1000 |  | 0.1 |  |  |  |  |  | Stablecoin |  | 0.5 |  |  | Ethereum |  | 0.5
 | ETH-WBTC LP |  | 5000 |  | 0.1 |  |  |  |  |  | Ethereum |  | 0.5 |  |  | Bitcoin |  | 0.5
 | Staked Aave |  | 5000 |  | 0.05 |  |  |  |  |  | DeFi |  | 1
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | Total
 | Mix of Interest-Bearing Positions
 | Category |  | $ |  | %
 | Bitcoin
 | Ethereum
 | DeFi
 | ETH Killer
 | Web3
 | Metaverse
 | Other
 | Stablecoin
 |  | Total
 | Debts
 | Log any debts and the associated interest rate (e.g. using Compound, Alchemix, Liquity, Aave, etc.)
 | Position |  | $ |  | Rate | Annual Interest Expense
 | Borrowed LUSD |  | 1000 |  | 0
 | DAI in Aave |  | 2500 |  | 0.04
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | Total