Easily track crypto portfolio and automate prices in Excel | Tool Series
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
Coins mentioned in post:
Congratulations @mycelias, you have decided to take the next big step with your first post! The Steem Network Team wishes you a great time among this awesome community.
The proven road to boost your personal success in this amazing Steem Network
Do you already know that awesome content will get great profits by following these simple steps that have been worked out by experts?
😫 ★★Nice Post...; 😫
thanks friend :)