I got overwhelming feedback from the last post. I didn’t expect so much feedback. Thank you.
Original post is here:
https://steemit.com/cryptocurrency/@mix1009/cryptocurrency-portfolio-template-for-google-sheets
To use the template, please “Make a copy…” from the file menu.
Please don’t request access! I’m getting too many request mails.
I’ve updated the template to include history of price for each coin.
Register a timer for “RECORD_HISTORY” in script editor.
A row is added to “History” sheet each time RECORD_HISTORY is called. So if you want a snapshot everyday, add a trigger to run it every day.
I’m still looking into displaying date in different time zones.
Here’s the template:
https://docs.google.com/spreadsheets/d/14UcwwmrHAdTl_zFHgbVJR2UW0ange0Hvt4Bz51FC42o/edit?usp=sharing