# April 2023 Update | Market Data

> Candles now include the current trading day and minute. Mutual fund data, a market status endpoint, and change and percent change all arrive.

Source: https://www.marketdata.app/changelog/april-2023-update/

---

(image: The Market Data April Update banner: an isometric illustration of figures working at an isometric dashboard of charts and graphs, beside the words APRIL UPDATE)

-   [Changelog](/changelog/)

# April 2023 Update

Candles now include the current trading day and minute. Mutual fund data, a market status endpoint, and change and percent change all arrive.

-   Last updated January 28, 2024

## REAL-TIME CANDLES, MU​TUAL FUNDS, & MORE

**Big data upgrade this month!** You can now request **OHLC candles that include the current trading day** (or even the current minute when requesting intraday candles). Before this update, candlestick data was only updated once per day in the middle of the night. Now we are pleased to offer you a real-time feed of this data. No new formulas or endpoints are needed. Just use the [STOCKDATA](/docs/sheets/stocks/stockdata) or INDEXDATA formulas in Sheets or the [STOCK CANDLES](/docs/api/stocks/candles) or INDEX CANDLES endpoints in the API. We also added the special [relative date keyword](/docs/sheets/dates-and-times#relative-dates-and-times) “now” that will always refer to the current time. This will let you create formulas or API calls that always give you the latest candle data.

As part of our [urgent feature requests program](/docs/account/feature-requests#urgent-feature-requests), we added three new features this month: **mutual fund data, market status, and change/changepct** for quotes. These were not big user requests (you won’t find them with many upvotes on our [feature request board](https://roadmap.marketdata.app/features)), but individual Market Data users needed these features urgently and now it they are available to all users. **For a payment of about $350 that can be applied to extending your Market Data membership**, we’re happy to implement features by request. Check out [the details of this program](/docs/account/feature-requests#urgent-feature-requests) if there’s something you urgently need added and you’re willing to pay for its development. The only condition is that we don’t develop private features. Any feature we develop will be made available to all Market Data users after it is finished.

## MUTUAL FUND DATA

You can now use the [STOCKDATA](/docs/sheets/stocks/stockdata) formula in Sheets or the [STOCK CANDLES](/docs/api/stocks/candles) or [STOCK QUOTE](/docs/api/stocks/quotes) endpoints in the API with mutual fund tickers. These tickers are always 5 characters and end with an X, for example: VFINX (Vanguard S&P 500 Index Fund). Remember, mutual fund NAVs are updated once a day and use a single daily price, so they won’t have bid/ask values; they aren’t traded the way ETFs are; and the candles will give duplicate values for each OHLC price for the day.

## MARKET STATUS

We’ve added a [MARKETSTATUS](/docs/sheets/markets/marketstatus) formula in sheets and a new [MARKET STATUS API](/docs/api/markets/status) endpoint. **Use any past, present, or future date** and get the open/closed status of the market on that day.

## CHANGE / PERCENT CHANGE

You’ll see two new attributes in all our stock and index quotes: **change** and **changepct**. This will display the change in dollars and in percent from the previous close. These values are now automatically included in the API responses and in Sheets when you request “ALL” columns for a stock or index quote. You can also request them specifically using change or changepct in the attributes part of our formulas or the columns parameter of the API.

## We also finished this month:

-   API: Improved performance of historical options queries.
-   API: Fixed a bug that caused users to drop their billing plan.
-   DevOps: Began work to add more server capacity.