DataHack datahack-ru

Pine Mini-Reference for more information

Pine Script™ Operators

The following operators are available.

Operator	Description
+	Adds two operands

Pine Mini-Reference for more information

Pine Script™ Operators

The following operators are available.

Operator	Description
+	Adds two operands

Overview

This collection of files serves as a simple static demonstration of how to post to a google spreadsheet from an external html <form> following the example by Martin Hawksey

Run example

You should be able to just open index.html in your browser and test locally.

However if there are some permissions errors you can make a quick html server with python. Open terminal and cd to the directory where the gist files are located and enter python -m SimpleHTTPServer. By default this creates a local server at localhost:8000

Multipart-POST Request Using Google Apps Script

These sample scripts are for requesting multipart post using Google Apps Script.

In most cases, the multipart request is used for uploading files. So I prepared 2 sample situations as follows. For each situation, the request parameters are different.

Upload a file from Google Drive to Slack.
Convert an excel file to Spreadsheet on Google Drive using Drive API v3.

Multipart post is required for these situations.

1. Clone your fork:

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream

Packages

lxml - Pythonic binding for the C libraries libxml2 and libxslt.
boto - Python interface to Amazon Web Services
Django - Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design.
Fabric - Library and command-line tool for streamlining the use of SSH for application deployment or systems administration task.
PyMongo - Tools for working with MongoDB, and is the recommended way to work with MongoDB from Python.
Celery - Task queue to distribute work across threads or machines.
pytz - pytz brings the Olson tz database into Python. This library allows accurate and cross platform timezone calculations using Python 2.4 or higher.

	/**
	* Convert Excel file to Sheets
	* @param {Blob} excelFile The Excel file blob data; Required
	* @param {String} filename File name on uploading drive; Required
	* @param {Array} arrParents Array of folder ids to put converted file in; Optional, will default to Drive root folder
	* @return {Spreadsheet} Converted Google Spreadsheet instance
	**/
	function convertExcel2Sheets(excelFile, filename, arrParents) {

	var parents = arrParents \|\| []; // check if optional arrParents argument was provided, default to empty array if not

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console

DataHack datahack-ru

Pine Mini-Reference for more information

Pine Script™ Operators

Pine Mini-Reference for more information

Pine Script™ Operators

Overview

Run example

Multipart-POST Request Using Google Apps Script

1. Clone your fork:

2. Add remote from original repository in your forked repository:

Packages

Guides