# July 2026 | Market Data

> The Sheets Add-on gains a Formula Builder: a point-and-click sidebar that writes any Market Data formula for you, with a live preview before you insert.

Source: https://www.marketdata.app/changelog/july-2026/

---

(image: The Market Data July Update banner: an isometric illustration of a phone showing a price chart under a rising curve, a quote reading 153.090 and a gold coin, beside the words JULY UPDATE)

-   [Changelog](/changelog/)

# July 2026

The Sheets Add-on gains a Formula Builder: a point-and-click sidebar that writes any Market Data formula for you, with a live preview before you insert.

-   Last updated July 31, 2026

## FORMULA BUILDER

**Build any formula without memorizing the syntax.**

(image: The Market Data sidebar in Google Sheets showing the STOCKDATA Formula Builder: a live preview reading =STOCKDATA(A1:A19,"close,date"), a Multiple Symbols field holding A1:A19, a Use Selected Cell Range button, Historical Candles selected with Close and Date ticked among the column checkboxes, and Clear and Insert Formula buttons at the foot)Love the data but tired of hunting through the docs every time you need to remember argument order, attribute names, or how to write a strike range? We just made that a thing of the past. The Market Data Sheets Add-on now has a Formula Builder: a point-and-click panel in the sidebar that writes your formula for you.

Pick a formula, fill in a simple form, and watch the exact formula build itself in a live preview as you click. When it looks right, hit **Insert Formula** and it drops straight into your selected cell.

Options traders, this one’s for you. Building an `=OPTIONCHAIN()` used to mean remembering the syntax for expirations, strike ranges, delta filters, and calls-vs-puts all in one line. Now it’s checkboxes and dropdowns: tick the columns you want, choose an expiration on a calendar or just type the days-to-expiration, and set your filters with a click. The builder handles the syntax underneath.

And because it’s guided, there’s nothing to learn. New to the add-on? You can build a working formula on day one without reading a single doc.

## What it does for you

-   **Live formula preview**: See the exact `=FORMULA(...)` string form as you make choices, so you know precisely what you’re inserting before you insert it.
-   **Grab cells with one click**: Click a cell (or select a range) in your sheet and hit **Use Selected Cell** to drop the reference into the form. No typing `A1:A500` by hand.
-   **A form that adapts**: Pick Real-Time Quotes and the date fields disappear; pick Historical Candles and they come back. You only ever see the fields that matter.

## What else we worked on in July

-   Earnings Data: Improved reliability on this endpoint.
-   Options Data: Began a large project to backfill missing index option data.
-   Stock Candles: Optimizations for faster responses from our database.