Skip to content

Instantly share code, notes, and snippets.

Created May 23, 2013 05:23
  • Star 1 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
Star You must be signed in to star a gist
What would you like to do?
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