Kyle J Carlton 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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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
/ 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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //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. |