In a previous post, I wrote how you can use Google Sheets to track your crypto. If you haven't already checked it out, I would recommend doing so first before looking at this one as this post is an updated and add on version to that post.
In this post I want to show you how you can use Google Sheets to get real time data on your portfolio with an add-on called "Crypto Sheets." Crypto Sheets is a crypto data aggregator site which you can then request Google Sheets to pull information from. You can check them out here.
Essentially after you've inputted all of your transactions in to Google Sheets, you can then use Crypto Sheets to give you real time quotes to the value of your portfolio without you needing to manually input it. Crypto Sheets now helps with automating some of the process that needed to be updated manually before. You would still need to input the data just as you would with any portfolio tracker though.
Here's a brief 5 minute video where I show you exactly how you can set up your portfolio to get real time prices.
Hopefully the video helped you out. If it has, please let me know in the comments down below if it has! If you'd like some help with setting up your portfolio using Google Sheets and Crypto Sheets, feel free to contact me.
If you liked this article, please give it a thumbs up or share it with others! You can check out my other posts here: https://www.publish0x.com/@Cryptoforcanadians.
Like what you see? Consider signing up with my link: https://www.publish0x.com?a=Mvbm9jpbYA. It takes less than 30 seconds.
If you have any questions or comments, please feel free to leave them down below as I will respond. You can also contact me at firstname.lastname@example.org. You can also message me on Telegram @cryptoforcanadians or feel free to join my Telegram group where we talk crypto: https://t.me/crypto4canadians.