Skip to content

Instantly share code, notes, and snippets.

View kylejcarlton's full-sized avatar

Kyle J Carlton kylejcarlton

View GitHub Profile
@kylejcarlton
kylejcarlton / Stocks_Over_Time.gs
Last active November 23, 2021 08:25
Google App Script that requests current stock prices from Yahoo Finance for several portfolios and logs the results in a Sheet. Google Sheet available @ http://tinyurl.com/heoxlvg, make a copy to view the Script Editor.
// robinHood = 13, K4:M16
// scotTrade = 2, V4:X5
// tD = 9, AG4:AI12
// eTrade = 15, AR4:AT18
//Lookup ticker symbol using Yahoo's web service (Called by each Account Function)
function lookupTicker(symbol) {
//var symbol = "SPY" //Uncomment to test this function
@kylejcarlton
kylejcarlton / Read_Temperatures.gs
Last active June 29, 2017 17:07
Google Apps Script that records temperature values from TMP36 sensor connected to Particle Photon, Nest thermostat and WeatherUnderground API into Sheet. More @ http://techiys.com/tagged/WiFiTemp.
//PARTICLE DEVICE
//Define the Particle Photon's Device ID and Access Token. Then use those variables to create the URL to access JSON output from board.
var deviceID = "3e002..................."; //Set to specific device ID.
var accessToken = "6dae...................................."; //Set to specific device's access token.
var particleUrl = 'https://api.particle.io/v1/devices/' + deviceID + '/analogvalue?access_token=' + accessToken;
//WEATHERUNDERGROUND
//Define WeatherUnderground API key, weather station location and request type. Then create URL to access JSON results.