How To Import Live Binance Price To Google Sheets?

This is my little trick Google Sheets allows us to import data from live price.binance.com (which only supports the latest version of GoogleSheets, see here) in order to get historical data for Binance. So I wrote this tiny script that makes it very easy:

import liveprice import folium README = ‘Get price updates site-wide’ ‘/…/liveprice/?url=Binance_Live%20Price’ xpi = “https://storage.googleapis.com/googlecollections/postponed-update/monopoly-globalfiles-elite.xpi” # Get an access token for OAuth if you don’t have one already access_token = folium . AccessTokenRequest () oauth_key = “********” response = { “success”: true } print( “OAuth tokens received in google sheets” ) print( ‘OAuth key : %s ‘ % oauth_key ) print( ‘OAuth token : %s – %s ‘, access_token , oauth_key ) access_token . save ( “/path/to/.token” , maxcharindex=100 , maxbytesperrequest=30000 , append=[ fpath=( fullpath . rfind ( ‘/..’ ))] ) def getPrices(): urlparseopts={} posArgs={} changeset={} url = qq+ startwith?format?&date?