// Set your variables below
SHEET_NAME="MC-Import-Data"
URL="https://coinmarketcap.com/currencies/views/all/"
// Create a trigger to refresh every 5 minutes
function myFunctionA() {
ScriptApp.newTrigger("getData")
.timeBased()
.everyMinutes(5)
William Thompson willinspire
willinspire
/ bittrex.py
Created
July 8, 2017 08:56
— forked from hamstah/bittrex.py
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from requests import Session # pip install requests | |
| from signalr import Connection # pip install signalr-client | |
| def handle_received(**kwargs): | |
| print('received', kwargs) | |
| def print_error(error): | |
| print('error: ', error) | |
willinspire
/ Google Script Cache-Busting IMPORTHTML.md
Last active
June 15, 2023 16:16
— forked from ranaroussi/Google docs cache-busting importdata.md
It is not easy to refresh the IMPORTHTML functions in Google Sheets due to cashe limitations. The resulting limitations are old data instead of new data being pulled into the Sheet upon running a Script to reload the IMPORTHTML function. This Google Script is a "Cache-Busting" function which circumvents this problem.