Easily track crypto portfolio and automate prices in Excel | Tool Series

in cryptocurrency •  7 years ago 


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
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Hi! I am a robot. I just upvoted you! I found similar content that readers might be interested in:
https://www.youtube.com/watch?v=wps8xavga0A

Coins mentioned in post:

CoinPrice (USD)📈 24h📉 7d
BTCBitcoin8245.510$3.93%-14.18%
DMDDiamond7.413$7.37%-23.35%
ETHEthereum542.833$-1.84%-25.23%
LINKChainLink0.374$-0.07%-27.31%
NANONano8.338$5.54%-28.43%