If you want a better understanding of how it works and have no programming experience, it's never too late to learn. Take a free course at Codecademy and flex your brain
Rates sheet with currency data
Create a new Google Sheets spreadsheet and name it something, or open an existing one
Create two new sheets called
Click "Tools > Script editor..." on the menu bar, and name your script project something
Select all of the text in the right-side pane and delete it
Paste the contents of scripteditor.js into the right-side pane
Add in as many currencies that you want to track
Add triggers to your project ("Edit > Current project's triggers..."). This is how your spreadsheet will update automatically.
You can manually execute the script to test it by clicking the
Select function, selecting
onOpen, and clicking the run button (looks like the play symbol)
Wallets Sheet with Account Balances
Note: Currently supports NANO, ETH, BCH, BTC, DGB, LTC, and VTC. Update other wallet balances manually in your spreadsheet for the time being. Feel free to submit an issue for other currencies.
If you don't have a
Walletssheet, one will automatically be created for you
Scroll down to the
WALLET BALANCE CONFIGURATIONsection (around line 130)
Follow the instructions for each currency to add your address. You can change the value in
getRangeto output the balance to a different cell in the
Market Cap Data
- A sheet called
Globalwill be automatically created for you, and populated with overall Market Cap Data.
There are comments in the code for anything that's not covered here. If you had to use these instructions, the safe bet is to not modify anything else.
Using the Data
solifugo has put together a guide on how to organize data from the Rates sheet.
How to Contribute
- Help others in the cryptosheets subreddit (https://www.reddit.com/r/cryptosheets/). You don't need to write any code to help others out.
- Hop in the gitter.im chat rooms
- Check out the contributing page and become involved on GitHub
- If all else fails, give a stranger a compliment and brighten their day
- Christopher Walken
This project is licensed under the GNU General Public License v3.0