Google Spreadsheets Paper Test By Calling Google’s Spreadsheets API

I have made one post about doing paper test by using google app script. For a fully automated paper testing, you can use Google’s Spreadsheets API to track your paper test result. How to do it?

  1. Connect to Google’s Spreadsheets API There is a quickstart documentation. And I have posted mine: package main import ( "time" "encoding/json" "fmt" "io/ioutil" "log" "net/http" "os" "" "" "" "" ) // Retrieve a token, saves the token, then returns the generated client.
Read more →

Google Spreadsheets Paper Test

I was inspired by the alpaca’s idea of using google spreadsheet as a test environment for auto algo trading. So I decided to make a version for bitcoin paper test trading. For alpaca’s stock version, you can find the details here. The google spreadsheet will look like this: I am using coinbase api to get the lastest Bitcoin price. And there is already one google app script class that you can use - Class UrlFetchApp.
Read more →