You are viewing a single comment's thread from:

RE: The Cryptocurrency Bank Spreadsheet

in #crypto8 years ago

Really cool Luke, thanks for sharing!
One improvement that could be great would be to see the historical prices of these currencies, that's useful for analysing when to buy & sell.
One way to add this new tab would be to use this JSON importer :
https://github.com/pipaman/google-docs/blob/master/scripts/ImportJSON/Code.gs
and getting the historical data from Coincap for example:
http://www.coincap.io/history/365day/BTC

Sort:  

It already has the JSON importer to get the current rates. It wouldn't be too difficult to take a snapshot and save that off. I've modified my personal copy to have a button to refresh the rates and another button to take a snapshot of my holdings and save them off so I can see the change over time. I don't want to add those to the main spreadsheet though because once I added the button it asked me give the spreadsheet permissions to my account which I'm guessing most people will not prefer.

Got it, thank you!