An automatic portfolio tracker on top of Google sheets.
Cryptfolio will do most of the setup itself so getting started is as easy as copying over the code.
-
First go to google sheets (https://docs.google.com/spreadsheets) and create a new spreadsheet.
-
From within your new spreadsheet click Tools in the menu and select Script editor...
-
Copy all the files in the src directory to the scripts editor in Google sheets.
-
After copying the scripts over open index.gs and then click the icon the looks like a clock in the script editor menu. Create a trigger the runs the Run function every 10 minutes. Optionally a trigger that runs every time the spreadsheet opens. Click save.
-
Close the script editor and refresh the spreadsheet.
After importing the code and refreshing the spreadsheet you should see a sheet at the bottom named Config. Open it and provide your API keys and secrets where specified.
All keys used with cryptfolio should be readonly. Exchanges should offer a feature to do so but, if they do not, use at your own risk.
- Login to you bittrex account
- Click Settings from the top nav
- Click API Keys on the left of the page.
- Click Add New Key and click the slider so that READ INFO says ON.
- Enter your 2FA Authenticator Code and click Update Keys
- Copy your API key and secret to the Config sheet.
- Login to you binance account
- From the binance account page click API Setting
- Give the key a name (e.g. Cryptfolio) and click Create New Key.
- Edit the key so that only Read Info is checked if necessary.
- Copy the API key and secret to the Config sheet.
- Binance account support
- Bittrex account support
- CoinMarketCap support
- Unified portolfio dashboard for N many exchanges.
- Historical portfolio data for further use.
Coming soon
- Coinbase
- Full spreadsheet backups
- Trade tracking
Coming next
- Cost basis
- Tax calculator
If you find this useful please contribute back new features. Open a PR and I'll pull it in.