# January 2024 Update | Market Data

> Bulk quotes and candles arrive for stocks. STOCKDATA gains array input, and two new API endpoints deliver bulk stock quotes and candles.

Source: https://www.marketdata.app/changelog/january-2024-update/

---

(image: The Market Data January Update banner: an isometric illustration of a figure at a large screen of bar charts, with gears above it, beside the words JANUARY UPDATE)

-   [Changelog](/changelog/)

# January 2024 Update

Bulk quotes and candles arrive for stocks. STOCKDATA gains array input, and two new API endpoints deliver bulk stock quotes and candles.

-   Last updated January 31, 2024

## BULK QUOTES & CANDLES FOR STOCKS

If you’ve used our `STOCKDATA` formula, you may have wished it updated faster — like you’re used to with `GOOGLEFINANCE`. 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 **much faster** quotes and daily candles update process via bulk downloading.

## ARRAY INPUT SUPPORT

The new `STOCKDATA` formula don’t just support faster downloads — **it supports array inputs**. 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](https://www.youtube.com/watch?v=a8lIfuJYOeI&ab_channel=MarketData) — 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.

## BULK DOWNLOADS VIA THE API

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](/docs/api/stocks/bulkquotes) and [stocks/bulkcandles](/docs/api/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.

## TUTORIAL

[How To Bulk Download Stock Market Data into Google Sheets Using Market Data's STOCKDATA Formula](https://youtube.com/watch?v=a8lIfuJYOeI)

**We also finished this month:**

-   API: Added nonstandard options filtering to optionchain.
-   API: Fixed a bug with strike limit not working.
-   API: Fixed a bug with negative delta values not working.