CryptoHelper

Watch the intro video and an update about the pi.

This is basically a CoinSpot/GoogleSheet bridge-application. With optional automatic updates to track real gains over time - without including the cost of the coins you purchased.

This simple console application reads private data from your CoinSpot account, and writes to your private GoogleSheet spread sheet.

Of course you will need to supply your own API keys and secrets for the APIs used.

It's faster to type 'g' or 'b' into the console of this app, rather than opening a new tab, logging in, and checking things.

Most people that invest in crypto-currencies have their own spreadsheets. This app will give you basic use cases, and also provide a basis for more elaborate automation if you wish. For instance, you could add logic to add/remove buy/sell orders according to market moves, rather than having to monitor it all yourself.

You can think of this as a meta-automation for handling your crypto accounts.

Note: Balances will not include your unused account funds on CoinSpot. This is intentional. The same is true for 'total spent', though I'll need fully automate this. This is all a bit more complicated than I first suspected.

Example Session

This is using an alt account setup, but shows the basics of what you can expect.

Note that when you use the 'u' command, if you have the Spreadsheet open in a browser window, it will instantly update as well.

You can use this framework to connect your inputs from CoinSpot to your outputs/analysis in Google Sheets.

An example session using an alt account of mine:

You will see that the app shows the difference in absolute value and gain percentage every time you query it.

NOTE: I don't update the image with every change the app, so it may differ from what you see when you build it. Any drastic changes, I'll update the image.

Setup

Most configuration is stored in App.config. Start with App.config.example and rename it to App.config. Add all the required keys and secrets.

You will need a CoinSpot account. The default is CoinSpot Australia. Change the currency used to your locale. The default is AUD.

You will also need a Google account and at least one Google Sheet if you wish to use the auto-update methods. You can use the app without this of course.

External references

These are the required references:

• Google Api.
• Google Sheets v4.

These should automatically install via the file packages.config in the Solution folder.

CoinSpot API

Login to CoinSpot and get an API key and secret. Add them to App.config.

GoogleSheets API

Get your Google API credentials from this page. Put it in the folder along side the executable. Add your spreadsheet id to App.config.

Usage

It's a simple console application, which starts by printing the help screen.

Follow the dots.

Non-functional Systems

The following items are implemented but are not functional:

• Buy
• Sell
• Swap

I have contacted CoinSpot about why I cannot use these API calls even with an elevated key/secret.

Automatic Updating

In the App.Config file, you can change the updateTimerMinutes setting to automatically update your spreadsheet every N minutes. If this is 0, no auto-updates will be made.

Using a Raspberry Pi

You don't want to keep your desktop on 24/7 just to write updates to your spreadsheet. But if you have a Raspberry Pi, you can use that to send updates at a very low power consumption that costs a few cents/day in power to run.

Note You do NOT need a Pi to use this application. I provide this information for those that already have a pi and want to use it to automatically write updates without having to keep full power to a desktop machine.

Making it easier to login to your pi

Append the contents of your ~/.ssh/rsa_pub.rsa file to the ~/.ssh/known_hosts file on your pi.

Then you can use ssh pi@yourpiname to quickly get into your pi without having to type your password.

Setup on Pi

• Get everything working locally as you wish
• ssh into the pi
• Set your real locale with sudo dpkg-reconfigure tzdata
• Install mono on the pi
• Logout from the pi
• Use scp -rp [src] [dest] to copy the files to the pi. You need to copy recursively as there are sub-folders for the token
  • See update-pi script for example
  • Note that you will need the target folder to exist on the pi
• Login to the pi
• Use screen to be able to make detachable sessions. Run screen
• Start a new screen session with ^A^C
• Change the updateTimerPeriod element in App.Config to set the number of minute between updates. The default is zero
• Run CoinSpotUpdater.exe
• Detach the process with ^A^D

You can now close the ssh window to the pi. The CoinSpotUpdater process will still keep running on the pi, even if you turn off your desktop.

Later, ssh back into the pi and type screen -ls to find the session you want then screen -r ### where ### is the number output in the screen -ls command:

In this case, you would say screen -r 1021.

You are now back controlling the CoinSpotUpdater.

There are probably easier ways to do this, but I was already familiar with scp and screen so that's how I did it. Feel free to leave feedback on better ways!

Help

Raise an issue on GitHub if you have any questions or bug reports, or email me directly. Happy to help set you up.