How To Track Your Crypto & NFT Portfolio In Google Sheets Using CoinGecko API
HTML-код
- Опубликовано: 19 окт 2024
- I spent a lot of time searching for how to manually track my crypto and NFT portfolio because I had assets stored in different wallets, exchanges, and/or platforms. I put together a Google Sheet that updates information relatively frequently to display current portfolio values.
Let me know if you have any questions - hopefully it's helpful!
Here's the link to copy the sheet: docs.google.co...
I've been asked about receiving tips for putting this together. I'd be happy to accept tips if you feel so inclined. Here's my ETH address: 0xD3D1435E40d6802171891c18Ef9Eb5486992D5E8
#Bitcoin #NFT #Cryptocurrency
Here's the link to copy the sheet: docs.google.com/spreadsheets/d/15Vc-sYp-kbYRA8SI6Kt-RuJ8hu54IKc9lQdAfVm35Ms/copy
I've been asked about receiving tips for putting this together. I'd be happy to accept tips if you feel so inclined. Here's my ETH address: 0xD3D1435E40d6802171891c18Ef9Eb5486992D5E8
Excellent video! Thanks for taking the time to make this, very useful!
This is brilliant, thank you for this!
Thanks Tino, I appreciate that - and you're welcome :)
Thanks man!
Oh gosh i'd love a copy!!!!
Here you go Mel :) docs.google.com/spreadsheets/d/15Vc-sYp-kbYRA8SI6Kt-RuJ8hu54IKc9lQdAfVm35Ms/copy
@@commascrypto389 wow thank you so much!
Thanks for the tutorial.
For sure, hope it helps!
Hi there,
Thank you so much for the sheet. I keep getting #N/A at the crypto sheet. Is the link still up to date? Ive changed usd to us and back but no luck!
Yep, it's still up to date. Sometimes even after updating or switching the formula, the API call won't work. I'm not sure if it's because it's overloaded or some other reason, but it's always shown again after waiting some time for me.
quick question, how would I change the NFT ETH command to a SOL Command because I currently use SOL. Appreciate any help, thanks
To get the value of SOL instead, you can just pull in the data from CoinGecko like shown on the "Crypto" sheet and bring that data over.
How can Cost column can be G3? when you bought NFT with x amount of ETH than cost in past should be past price of ETH , how can cost column cas be Current price of ETH, doesnt make sense. I think when you bought NFT its important to know what was price of ETH that point when you bought NFT or i am wrong?
Good point and you're correct. I've made some changes to the sheet and I paste values generally based on the current price at the time. This was the first version and can and should be customized as needed by anybody who wishes to use it.
@@commascrypto389 awesome!
Yes please me too! I'd love to have a copy
Here you go: docs.google.com/spreadsheets/d/15Vc-sYp-kbYRA8SI6Kt-RuJ8hu54IKc9lQdAfVm35Ms/copy
hey this is a great way to keep track, could you possibly send the link again ? its not working for me
Still working when I tested it, you need to be logged into Google for it to work as it's a Google Sheet.
Is there a way to get this kind of sheet working in Apple Numbers?
Oh and also thanks for this amazing tool, nearly forgot that 🙏❤️
I have no idea, I've never used Apple Numbers. If you can use similar functions, you can probably replicate the sheet (or much of it). Hope it helps if it does work!
Would love a copy, leave address for a tip if I can grab
Here you go! docs.google.com/spreadsheets/d/15Vc-sYp-kbYRA8SI6Kt-RuJ8hu54IKc9lQdAfVm35Ms/copy
I'd gladly accept a tip if you'd like, here's my ETH address: 0xD3D1435E40d6802171891c18Ef9Eb5486992D5E8