/crypto-sheets

Google Sheets script editor code for managing a cryptocurrency tracking spreadsheet

Primary LanguageJavaScriptGNU General Public License v3.0GPL-3.0

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. Create new spreadsheet

    2. Name your spreadsheet

  2. Create two new sheets called Rates and Wallets

    1. Rates and Wallets sheets

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

    1. Script Editor

    2. Project Name

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

    1. Delete existing code

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

    1. Paste script

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

    1. Add currencies to track

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

    1. Add triggers

    2. Set up a new trigger

    3. New trigger

    4. In the "Run" dropdown, choose "onOpen" and choose which triggers will refresh the data. We recommend using "Time-driven/Minutes/Every 30", and "From spreadsheet/On open."

    5. Trigger definition

  8. 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)

    1. Manually execute script

Populating 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.

  1. If you don't have a Wallets sheet, one will automatically be created for you

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

    1. wallet section

  3. 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. before wallet config

    3. After configuration

    4. after wallet config

Market Cap Data

  1. A sheet called Global will be automatically created for you, and populated with overall Market Cap Data.

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.

Using the Data

solifugo has put together a guide on how to organize data from the Rates sheet.

How to Contribute

Powered By

Acknowledgements

  • solifugo
  • iKrazy
  • apiontek
  • 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