Options prices in Google Spreadsheet?

• ImportJSON

  52 1,943 0.0 HTML

  Discontinued Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet

Google Sheets doesn't have a native function to get and parse json. So you could use this with Google App Scripts and UrlFetchApp to get and parse the data. Brad Jasper wrote this script that creates a custom function that you can use in a sheet load and parse json into a sheet. https://github.com/bradjasper/ImportJSON.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• AmeritradeAPIwGoogleScripts

  1 18 0.0 JavaScript

  Ameritrade API with Google Scripts tutorial repository of code

Ameritrade If you have a Think Or Swim you can use Ameritrade's API. I'm a dumb dumb, so I really don't know how this all works, but I used a script written by Koh Joo Beng and was able to get it to work. https://www.youtube.com/watch?v=_KJsx7QD6dM https://github.com/kohjb/AmeritradeAPIwGoogleScripts

Suggest a related project