CryptoCurrency Portfolio template update
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
Nice addition - looking forward to more updates!
Congratulations @mix1009! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOP공유해주신 시트로 여기저기 흩어져 있는 코인들을 편하게 관리하게 되었습니다. 그런데 마켓갭API가 지원 하는 시간이 정해진 것인가요? 하루에 몇시간만 시세가 업데이트 데는것 같군요. 좀더 실시간 시세를 계속 받은 수 있으면 좋겠습니다
I'd like to add a column with ETH price. Help me, plz!
Glad I went to check for other posts by you - this just keeps getting better and better. Once again: thanks for sharing!
Hello,
VERY HELPFULL. THANKS
Can you make the ICO monitor for this ?
Since is CMC Api and some ICOs are not listed, we get errors
Thanks
Hello, i am still using this portfolio everyday because i love it !
But how can i add 2 more hours to the DateTimeString (australia time)? I cant even delete the Date time string code in the script, it keeps coming back.
Thank you so much if you can help :D
Thank you for your template idea. I have also created another version here https://steemit.com/cryptocurrency/@htuan/cryptocurrency-portfolio-and-transaction-management-with-googlesheet