linglung

Benchmark: Loop for Array Processing using Google Apps Script without V8

April 16, 2018 Published.

July 26, 2018 Updated. Result of reduce was added.

Binance API for Google Apps Script

This sample script is for using Binance API by Google Apps Script. This script encryptes "signature" like samples. In this script, "Example 1: As a query string" is used, and it retrieves "All orders (SIGNED)" by "GET".

function main() {
    var key = '#####'; // Please input your key.
    var secret = '#####'; // Please input your secret.
    var api = "/api/v3/allOrders"; // Please input API Endpoint you want.
    var timestamp = Number(new Date().getTime()).toFixed(0);
 var string = "symbol=LTCBTC&amp;timestamp=" + timestamp; // Please input query parameters for the inputterd API.

Telegram Bot on Google App Script

This is the source code of one of my blog post. To read the full blog post please click here.

JSON Puller - Google Apps Script

Transforms the data of a given Spreadsheet Sheet to JSON.

The frozen rows are taken as keys for the JSON.
The data taken for the values is only that after the frozen rows

Set up:

exportJSON(Spreadsheet) - transforms the data in the given sheet to JSON.

	// ==UserScript==
	// @name Card style View in Google result
	// @namespace https://twitter.com/yume_yu
	// @homepage https://github.com/yume-yu/CardStyleView-in-GoogleResult
	// @supportURL https://twitter.com/yume_yu
	// @version 0.5
	// @description This scripts add cardView to your GoogleSearchResult.
	// @author @yume_yu
	// @match https://www.google.com/search*
	// @match https://www.google.co.jp/search*

	<?
	header("Content-type: text/html; charset=utf-8");

	//get list of symbols
	$xinfo = json_decode(file_get_contents("https://api.binance.com/api/v1/exchangeInfo"), true);

	$symbols = [];
	foreach($xinfo["symbols"] as $sym) $symbols[] = $sym["symbol"];
	asort($symbols);

	//this script will monitor for all pairs and find any open orders for that pair.
	// I've done my best to account for throttling and make the script robust.
	// save locally, add your api key, and run with "node <script name>" in console.
	// You'll get alerted (in console) when an order fills.
	// if you'd like to send a donation my way:
	// BTC: 1JD595vphvXmWEwpjiUmfw3QzsBtE9jUP7
	// LTC: LcaHE2dqrH73xLtoKXwDZEUtDiY42iAvk4
	// ETH: 0x110191093ffab1f0d3d6012cc0de15f42257b7f6
	// BNB: 0x110191093ffab1f0d3d6012cc0de15f42257b7f6
	// [email protected] for questions... I'll do my best to support the script if you find any bugs.

	def interval_to_milliseconds(interval):
	"""Convert a Binance interval string to milliseconds

	:param interval: Binance interval string 1m, 3m, 5m, 15m, 30m, 1h, 2h, 4h, 6h, 8h, 12h, 1d, 3d, 1w
	:type interval: str

	:return:
	None if unit not one of m, h, d or w
	None if string not in correct format
	int value of interval in milliseconds

	// import_json_appsscript.js
	// https://gist.github.com/allenyllee/c764c86ed722417948fc256b7a5077c4
	//
	// Changelog:
	// (Oct. 16 2019) tag: allenyllee-20191016
	// 1. Fixed google script error: urlfetchapp - service invoked too many times https://stackoverflow.com/questions/10598179/google-apps-script-urlfetchapp-service-invoked-too-many-times
	// (Jul. 16 2018) tag: allenyllee-20180716
	// 1. Fixed the issue "If you try to query /arrayA[k]/arrayB[n]/arrayC[m]/.../member, you will always get /arrayA[k]/arrayB[k]/arrayC[k]/.../member."
	// (Nov. 30 2017) tag: allenyllee-20171130
	// 1. Add the ability to query array elements by using xpath like "/array[n]/member" where "n" is array index

	<div>
	<iframe appIframeTracker (iframeClick)="onIframeClick()" src="http://www.google.com"></iframe>
	</div>