Bitcoin Ledger with Google Sheets and Apps ScriptWas hoping to get to a usable state before Christmas but I guess I'll have to leave to till after New Year. This is pre-alpha...
A few months back, I began to do Bitcoin arbitrage. Keeping track of the flow of money a big issue so I began work on a ledger to simplify and automate things. I didn’t want a conventional Excel spreadsheet where you manually enter in all everything and do a few =SUM()s and =AVG()s. So being a lazy programmer, I decided to automate as much as I could. Bitcoin's dependence on the block chain helps the automation process a lot.
I ended up using Google Sheets for this fancy ledger, but Excel and SQL databases were among the candidates for this project. This is mainly because of
-running on Google Servers means reliability, easy permissions, and saves you electricity (you can pull data from the web even when the spreadsheet is closed
-the new Google Sheets allows offline editing, with puts it back in competition with Excel
-Excel/Spreadsheets are much easier to setup than a SQL database and a web frontend
The project is currently in its early stages, but you can enter your Bitcoin address and it will generate a QR code from the Charts API, display your balance and estimated worth in any of the 16 currencies (thanks to BlockExplorer's APIs), and automatically query the block chain to get all transactions made by your addresses. However this is far from finished. Features to be implemented are pivot tables and charts (and graphs) for a simple at-a-glance overview, separate accounts (eg. HSBC, Bank of America) where you bitcoins 'deposit' into, virtual grouping so you can sell of those
bitcoin you bought at x dollars per BTC (this lets you easily calculate your profit), and a few more minor features.
This project is license under The MIT License, so feel free to use it or contribute to it. #bitcoin