Behold, for the rags to rags story of the century. As I dip my feet into crypto and promptly loose 7 of my toes, I decided to *closely monitor* my losses with the comfort of a spreadsheet. So I built a CRYPTO PORTFOLIO TRACKER. Did I say it is LIVE? Yes! It is a live tracker.
So in this brief but entertaining video let me share the story of my crypto tracker.
PS: You can also use it for tracking stocks and mutual funds.
💰 Easily invest in Crypto with EasyCrypto
==================================
I use EasyCrypto to purchase BTC, ETH and many other crypto currencies. Sign up with my link if you want an easy to use platform – https://easycrypto.com/?ref=90688513
In the video ⏱👉
==============
0:00 – The origin story of my crypto
1:01 – Demo of the crypto tracker
2:08 – How I built the tracker side of things
3:50 – Building the portfolio page
5:18 – Getting LIVE Bitcoin / Crypto prices to Excel
7:18 – Creating the dashboard tiles
LEARN MORE ABOUT THE CONCEPTS IN THE VIDEO 💪
=============================================
UNIQUE formula – https://chandoo.org/wp/dynamic-array-functions/#unique
# SPILL ranges – https://www.youtube.com/watch?v=kR6czKY4FEw
Data types – https://support.microsoft.com/en-us/office/excel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877
WATCH NEXT 💻👉
================
📊 Making a dashboard in Excel (quick tutorial) – https://youtu.be/pPpkYB9uG9A
📚 More Excel Dashboards & Reports (playlist) – https://www.youtube.com/watch?v=pPpkYB9uG9A&list=PLmejDGrsgFyDN-HoP5wlkvq9zKbWM9KtT
🎵 Music from Epidemic Sound. Sign up here for awesome music for your video / podcast – https://www.epidemicsound.com/referral/gdubva
Note: I get a small commission from EasyCrypto / Epidemic Sound when you use my link to join them (at no extra cost to you).