Create a gist now

Instantly share code, notes, and snippets.

pulls data from YQL and puts in a spreadsheet
function pullData() {
//select * from where symbol in ("YHOO","AAPL","GOOG","MSFT")
var url="*";
var response = UrlFetchApp.fetch(url);
var json=JSON.parse(response.getContentText());
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var quotes=json.query.results.quote;
for(var i=0;i<quotes.length;i++){
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment