April 2023 Update

You can now request (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 or INDEXDATA formulas in Sheets or the STOCK CANDLES or INDEX CANDLES endpoints in the API. We also added the special relative date keyword "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, we added three new features this month: for quotes. These were not big user requests (you won't find them with many upvotes on our feature request board), but individual Market Data users needed these features urgently and now it they are available to all users. , we're happy to implement features by request. Check out the details of this program 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.

You can now use the STOCKDATA formula in Sheets or the STOCK CANDLES or STOCK QUOTE 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.

We've added a MARKETSTATUS formula in sheets and a new MARKET STATUS API endpoint. and get the open/closed status of the market on that day.

You'll see two new attributes in all our stock and index quotes: and . 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.