GSheet-Plugin

To use the G-Spreadsheet google plugin, you need to do the following:

  1. Install the G-Spreadsheet from the Google addon store
  2. After, go to Bavest / Add api key and add your api key

Now, you can use the G-Speadsheet plugin.

Commands

EndpointCommandDocumentation
Quotequote("AAPL")Quote
Profileprofile("AAPL")Profile
Metricmetric("AAPL")Metrics
Dividendsdividends("AAPL")Dividends
Peerspeers("AAPL")Peers
Financialsfinancials("AAPL"; "quarterly"; "cf"; "EUR")Financials
Candlecandle( "AAPL";1540620499, 1666850899;"resolution": "D" )Candles
Fundamentalsfundamentals("AAPL")Fundamentals
ESGesg("AAPL")ESG
Splitsplit("AAPL")Split
Suchesearch("AAPL")Search
Sentimentsentiment("AAPL")Sentiment

What’s Next