January 2024 Update

If you've used our formula, you may have wished it updated faster — like you're used to with . This hasn't been possible yet due to Google Shees' technical limitations for third party developers. However, with this month's release, we've now implemented a quotes and daily candles update process via bulk downloading.

The new formula don't just support faster downloads — . That means you can bundle all your real-time quotes in a single request using a single formula. You'll be able to build a large table of stocks and request prices on everything all at once. The Add-on will make a single API call to Market Data and fetch all your prices at the same time — no more refreshing delays!

You could download all 500 prices of the S&P 500 in a single request — all without worrying about exhausting the quotas that Google places on your account. It is this process of combining all your quotes in a single formula that will allow a lightning fast update of your sheet.

We haven't forgotten about our API users, either. Bulk stock quote and stock candle downloads are available for API users as well. There are two new endpoints for this, stocks/bulkquotes and stocks/bulkcandles. These endpoints use most of the same parameters as the single quote / candle endpoints, so the integration into your application will be very quick if you are already using our existing endpoints.