Welcome to the Tool Series, a set of videos in which we discuss tools that help understand cryptocurrency tech and managing investments.
In today’s video we will walk through how to create your very own cryptocurrency portfolio tracker in Excel with automated price updates from CoinMarketCap.com using an API link. This tool will allow you to input your existing holdings across exchanges and wallets and calculate current fiat value and overall gross profit. We also touch briefly on styling / formatting to ensure a clean look and feel.
Release version (v1.00) can be found using the link below. Future videos will involve updating the tool to accommodate user requests and new functionalities. Feel free to leave a comment below on how to improve this tool and I will read and consolidate all feedback for future updates.
EXCEL MODEL LINK 🚀
https://drive.google.com/open?id=11f9YgPIsO1gqGd5pxx3AaxVNpGugEGyT
ESSENTIAL CRYPTO RESOURCES ✔️
● Recommended hardware wallet: LEDGER NANO S
https://www.ledgerwallet.com/r/34fd
● Recommended exchange to buy Bitcoin / Ethereum (free $10 bonus): COINBASE https://www.coinbase.com/join/59aee0fcd9ffbc017821da88
SOCIAL MEDIA ❤️
● Twitter: https://twitter.com/mycelias
● Instagram: https://www.instagram.com/mycelias
● Steemit: https://steemit.com/@mycelias
ATTRIBUTION 🎵
Morning Stroll: Josh Kirsch/Media Right Productions
BirdBrainz: Otis McDonald
Coupe: The Grand Affair
Retro: Wayne Jones
Inevitable: Diamond Ortiz
Hello Mr. Princeton: Otis McDonald
First: Text Me Records
Church of 8 Wheels: Otis McDonald
Sunny Morning: Bruno E.
Head Candy: William Rosati
DISCLAIMER ❗
I am not a financial advisor and statements should not be considered financial advice. Information provided reflects my opinions only and I am not responsible for any investment decisions you decide to make.
▶️ DTube
▶️ IPFS