Skip to content

Instantly share code, notes, and snippets.

View jaredcassidy's full-sized avatar

Jared Cassidy jaredcassidy

  • Port Elizabeth
View GitHub Profile
@woganmay
woganmay / script.js
Last active February 2, 2018 22:05
Gscript for Sheets - get crypto tickers and maintain a history
// Sample workbook here:
// https://docs.google.com/spreadsheets/d/1DPASIiKJw6x0n2eq7t4xRU_FQsizBH8Z8rXOfVk2Kb4/pubhtml
// Main function - does everything
// Triggered by Google every 15 minutes
function getAllTickers() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Crypto");
// Get all tickers