gsSQL
cachefinance
gsSQL | cachefinance | |
---|---|---|
5 | 7 | |
16 | 29 | |
- | - | |
8.3 | 6.0 | |
20 days ago | 12 days ago | |
JavaScript | JavaScript | |
GNU General Public License v3.0 only | GNU General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
gsSQL
-
What's the formula for this?
The code is at: https://github.com/demmings/gsSQL/blob/main/dist/gssql.js
-
Need Help
You would need the custom function added to your Apps Script. The source code is here: https://github.com/demmings/gsSQL/blob/main/dist/gssql.js
- Show HN: Google Sheets Full SQL Select Custom Function
- Google App Script Project and Code Coverage on GITHUB
-
Combining two QUERY tables with common column
gsSQL on GITHUB
cachefinance
- #N/A in GoogleFinance Field
-
=GoogleFinance("NYSE:FHN") not working?
If you are up to copy/paste of a Apps Script, you can test out my custom function: https://github.com/demmings/cachefinance/blob/main/dist/CacheFinance.js instructions are: https://github.com/demmings/cachefinance https://demmings.github.io/notes/cachefinance.html
-
Portfolio tracking has become even worse
My notes are: https://github.com/demmings/cachefinance and https://demmings.github.io/notes/cachefinance.html
- Stock Ticker URI returning error in google finance / google sheets
-
These google finance tags do not work anymore for me since about a week
The single .GS file for the custom function is: https://github.com/demmings/cachefinance/blob/main/dist/CacheFinance.js
-
help with the google finance function
Notes: https://github.com/demmings/cachefinance
- Show HN: Google Sheets GOOGLEFINANCE() reliability enhancement
What are some alternatives?
sqliterally - Lightweight SQL query builder
finnhub-python - Finnhub Python API Client. Finnhub API provides institutional-grade financial data to investors, fintech startups and investment firms. We support real-time stock price, global fundamentals, global ETFs holdings and alternative data. https://finnhub.io/docs/api
SheetsIO - Small configurable Java app that pulls data from a Google Spreadsheet (using v4 api) and writes to files and a local webserver.
plaid-transaction-script - Automate bank transaction data using the Plaid API into Google Sheets
StockAppScript - This is a function to retrieve stock prices from the FinnHub API, created to replace GOOGLEFINANCE() on Google Spreadsheets.
extract-gsheet - Quickly extract JSON data from a public Google Sheet without any API keys.
gcp-video-intelligence - The GCP Video Intelligence function allows you to enable powerful content discovery and analysis in your videos.
react-awesome-query-builder - User-friendly query builder for React
auto-youtube-subscription-playlist-2 - Script automatically adds videos to playlists from Youtube channels and/or subscriptions (Youtube Collections alternative).