[Including Scan Result Link] Crypto/NFT Investment Portfolio Tracker Template for Excel | Cryptocurrencies, NFTs, and more | Live Data & Calculations

Hello,

This is a spreadsheet I made to easily keep track of my investments. I've decided to share it for free as a give back to the community.

​

𝐅𝐞𝐚𝐭𝐮𝐫𝐞𝐬

————-

https://www.youtube.com/watch?v=gIlkqdGDb8s

​

𝐇𝐨𝐰 𝐢𝐭 𝐰𝐨𝐫𝐤𝐬 (𝐆𝐮𝐢𝐝𝐞 𝐢𝐧𝐜𝐥𝐮𝐝𝐞𝐝)

——————————————-

1. Portfolio’s Currency is selected.
2. History is inputted either with a CSV file or manually (Transactions, Trades, Dividends).
3. Each investment’s information is specified (Asset Class, Region, Sector, etc.)
4. All data are then calculated automatically based on the above information.

​

https://preview.redd.it/m4tnbo5g1zx81.jpg?width=2700&format=pjpg&auto=webp&s=f2653cb0b30087fb77a3381b62f3cab4a4d2e049

https://preview.redd.it/cpoyoo5g1zx81.jpg?width=2700&format=pjpg&auto=webp&s=f2152599e4fc05889edb28d099c1a6b70647a837

https://preview.redd.it/3v4pit5g1zx81.jpg?width=2700&format=pjpg&auto=webp&s=67ed7f98233f1b89662cf154abdf1994ee58ada0

https://preview.redd.it/6z8vrx5g1zx81.jpg?width=2700&format=pjpg&auto=webp&s=2b58723870da767e5b58ed6c7c74fc62880e344e

https://preview.redd.it/kfs4zs5g1zx81.jpg?width=2700&format=pjpg&auto=webp&s=9fd3027f8f44a691fc5ea39d151c4bc2cce74a58

𝟏𝟕 𝐓𝐚𝐛𝐬/𝐒𝐡𝐞𝐞𝐭𝐬

———————-

(w/Automatic calculation unless stated otherwise)

✦ Dashboard

✦ Portfolio

✦ Desired Portfolio (Manual Input)

✦ Pies

✦ Allocation

✦ Tickers Info (Manual Input)

✦ Crypto and NFT Portfolios

✦ Transactions/Trades/Dividends History (Manual Input)

✦ Returns

✦ Dividends

✦ Calculators

✦ Valuation

✦ Screener

✦ Annual Reports

✦ Watchlist (Manual Input)

✦ Customization and Info

✦ Guide

​

𝐃𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐋𝐢𝐧𝐤

———————-

https://www.dropbox.com/t/Nzkbi4zzqzITB7M5

​

Scan Result:

https://www.virustotal.com/gui/file/e4c553b69d87513d5795272eb76338adb7c4441fecaa67797951df3a766660f3