Google Sheets script editor code for managing a cryptocurrency tracking spreadsheet
This is a template for creating your own spreadsheet to track your cryptocurrency balances and current prices. It assumes the use of Google Sheets and the built in script editor (Tools > Script editor...).
- Click "Tools > Script editor..." on the menu bar
- Select all of the text in the right pane and delete it (unless you have already written your own functions)
- Paste the contents of scripteditor.js into the pane on the right
- Add in as many currencies that you want to track
- Add triggers "Edit > Current project's triggers..."
- Click "Add a new trigger"
- 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".
There are comments in the code, and I'll add better instructions here in the future.
*More instructions to follow.
- Add detailed instructions for configuring your own Google Sheets crypto tracker
- Templatize the script to pull in lists of cryptos to track, and account balances to track
- Historical data
They are appreciated but not expected
- XRB - xrb_3ix8dfgn7hkz3choqi1qr6jgopoodh1jr1giwixzqaohks7d1f98dau45c11
- ETH - 0x7E9DDB5343a583705Ed9ADE065C0595EFB55D681
- VTC - Vo8EXgAtxCVUtMaTQECuzLD2tZU1HqLbhT
This project is licensed under the GNU General Public License v3.0