Crypto Sheets

This is a (javascript-based) tool to aid in creating your own crypto tracking spreadsheet. It can automagically pull in current cryptocurrency rates, as well as your wallet balances. It requires the use of Google Sheets and its built-in script editor.

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 💪🎆. Programming can open doors for you, no matter your occupation. https://www.codecademy.com/learn/introduction-to-javascript

Instructions

Populating Rates sheet with currency data

1. Create a new Google Sheets spreadsheet and name it something, or open an existing one

   1. 

   2. 

2. Create two new sheets called Rates and Wallets

   1. 

3. Click "Tools > Script editor..." on the menu bar, and name your script project something

   1. 

   2. 

4. Select all of the text in the right-side pane and delete it

   1. 

5. Paste the contents of scripteditor.js into the right-side pane

   1. 

6. Add in as many currencies that you want to track

   1. 

7. Add triggers to your project ("Edit > Current project's triggers..."). This is how your spreadsheet will update automatically.

   1. 

   2. Set up a new trigger

   3. 

   4. In the "Run" dropdown, choose "getData" and choose which triggers you'd like. I use "Time-driven/Minutes/Every 15", and "From spreadsheet/On open".

   5. 

You can manually execute the script to test it by clicking the Select function, selecting getData, and clicking the run button (looks like the play symbol)

Populating Wallets sheet with account balances

Note: Currently only supports BCH, BTC, ETH, and VTC. Update other wallet balances manually in your spreadsheet for the time being. Feel free to submit an issue for other currencies.

1. Make sure you have created a Wallets sheet

   1. 

2. In the script editor, uncomment (delete the // before) var ssWallets = ss.getSheetByName('Wallets')

   1. 

   2. It should look like this

   3. 

3. Scroll down to the WALLET BALANCE CONFIGURATION section (around line 130)

   1. 

4. Follow the instructions for each currency to add your address. You can change the value in getRange to output the balance to a different cell in the Wallets sheet.

   1. Before configuration

   2. 

   3. After configuration

   4. 

Advanced

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.

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
  • Lobby
  • Development
• Check out the contributing page and become involved on GitHub
• If all else fails, give a stranger a compliment and brighten their day

Powered By

CoinMarketCap Block Explorer Etherscan explorer.vertcoin.info

Acknowledgements

apiontek iKrazy solifugo yukihirai0505 Christopher Walken

Donations

• XRB
  • xrb_3ix8dfgn7hkz3choqi1qr6jgopoodh1jr1giwixzqaohks7d1f98dau45c11
• ETH
  • 0x7E9DDB5343a583705Ed9ADE065C0595EFB55D681
• VTC
  • Vo8EXgAtxCVUtMaTQECuzLD2tZU1HqLbhT
• BCH
  • 1Gzs8uKoUY23R7kTRE8NwAucAArAk8mdCg

License

This project is licensed under the GNU General Public License v3.0