Big news! We're rolling out our first-ever Software Development Kit (SDK) - say hello to the Market Data Go SDK v1.1! This is just the start for us at Market Data. We're on a mission to make your life easier with a suite of SDKs designed to simplify and enhance your experience with our API. , with a Python SDK already in the pipeline. This is our way of signaling our commitment to supporting a . We're excited to see what you build with our SDKs, and we can't wait to hear your feedback.

The Go SDK for Market Data has been meticulously crafted to offer you a seamless integration process with our financial data API. Here are some :

The release of the Go SDK is just the beginning. We are already working on a Python SDK, and more languages will follow, ensuring developers have the tools they need in their preferred programming environment.

We are excited for you to try the Go SDK and look forward to your feedback and contributions. Together, we can make the Market Data SDKs an invaluable resource for the financial developer community.

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.

Ready for earnings season? With Market Data, you can get both a as well as . Whether you decide to shun these binary events or trade through them is up to you. Now using the Sheets Add-on or the API, you can get the earnings calendar for any U.S. stock and see when it will be reporting. The data includes the fiscal year & quarter, the earnings release date & time, as well as the Wall Street consensus estimate.

You can also review past earnings releases and see how earnings surprises affected the company's share price. You'll have access to the and the difference in both dollars per share and percent terms.

will get you future earnings calendar data in Sheets.

does the same thing, but in the API.

We have a blog post explaining how to use the EARNINGS formula in Sheets.

Interested in exploring all the possibilities with this feature? Head over to our Sheets documentation or our API documentation to get a comprehensive understanding of how to make the most of it. We've laid out various examples, formats, and potential use-cases to guide you.

It is important to note that this formula is . Free accounts and trial accounts can only use the AAPL ticker to test it, but cannot use it with other tickers.

If you have 3 minutes to spare, watch this month's video tutorial and learn how to get started with the EARNINGS formula and see several use-cases for this new tool.

Expanding our functionality to cater to your needs, we've added support for relative dates and times! Now, you no longer need to be restricted to specifying exact dates. Whether it's , , or even , our system understands and processes it for you. This allows you to easily "hardcode" dates into your Google Sheets formulas or API calls and get data that is forever updating relative to the current day/time. Perfect for screeners or dashboards.

Interested in exploring all the possibilities with this feature? Head over to our documentation to get a comprehensive understanding of how to make the most of it. We've laid out various examples, formats, and potential use-cases to guide you.

Throughout September and October we've worked to improve performance and this month, we're thrilled to announce substantial improvements to our API's response times:

This translates to a noticeably snappier experience, not just when using our API but also in our Google Sheets Add-On. We understand the significance of speed in the trading world, and we're committed to ensuring you receive your data promptly and efficiently.

Did you know that you can use our Swagger User Interface to test our API right from your browser with no programming knowledge needed? Watch this month's video tutorial and learn how to get started.

More new tickers this month! We added support for that quote on NYSE and NASDAQ. For NASDAQ-listed stocks we support the 5 letter ticker and for NYSE-listed preferred you can use the original NYSE symbol or the more common root symbol and dash. We've prepared an article that explains how these symbols work.

The optionchain formula in sheets now allows you to use the keyword "LIMIT" to limit the number of strikes displayed to the strikes that are close to the money for any given expiration. For example, the formula would return the 4 strikes closest to the money for next month's AAPL option chain. You can combine LIMIT with other filters such as ITM or OTM to return 4 in the money or 4 out of the money strikes.

If you don't know the option symbol for the contract you want to look-up, you no longer need to worry. Just write out the option using natural language and the OPTIONLOOKUP formula will now understand you. Try it out yourself:

As long as the input includes (1) stock ticker (2) expiration date (3) strike price (4) call/put then the formula will work. It doesn't matter what order you use or how you format the dates. You can even put all this data in 4 different cells and use 4 cell references:

We haven't left API users out of this update. at /options/lookup/ that allows you to make use of the same functionality. It will return a properly-formatted option symbol that you can then use with the quote endpoint. Read the docs for full details.

Most common natural-language option formats have been added, . This should allow you to directly generate option quotes after downloading your position at your broker. However, if you find that you are making requests in natural language that the system does not understand, please do not hesitate to report that to us in the helpdesk. We'll get any missing formats added as they are brought to our attention.

If you're a Sheets user and you have 5 minutes to spare, you can learn to use OPTIONLOOKUP with this quick video tutorial. It has never been easier to work with your broker's CSV files.

We now have coverage of most indices including a customer request made on our feature request board for VIX3M, VIX6M, VIX9D, VIX1Y. We have also added new OTC stock tickers, including lightly traded tickers that were previously excluded. Market Data now has 100% coverage of U.S. equity markets, indices, mutual funds, equity and index options.

In the coming months we will be focusing on , with the goal of total U.S. financial market coverage. If you've already made the decision to purchase a Market Data subscription, this additional data will be added to your subscription at no additional cost to you. Our commitment is to never raise prices on existing customers.

As part of our urgent feature requests program, we added two new features this month: . Check the API & Sheets Documentation for full details.

The optionchain endpoint now includes a real-time quote for all options in the chain and the filtering of the chain is now based on real-time data rather than the previous day's data. It is no longer necessary to use the quote=true parameter to get a real-time quote.

If you're a Sheets user and you didn't check out last month's tutorial, now's the time! Learn to use our new OPTIONCHAIN formula with our video tutorial. Filter by expiration, strike, DTE, delta, and learn how to build an options screener.

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.

You can now use the new formula to download hundreds of options at once in Google Sheets. With you were limited to a single option in each formula. With you can download every option for a single expiration at once.

There are more than 25 columns you can use in the output. Use "ALL" to see them all and then pick just the ones you need. Column output is also ordered in the same order as you input them!

You can get the expiration date you need by using North American date formats "MM/DD/YYYY", a cell reference with a date in sheets, or timestamp format "YYYY-MM-DD". What's perhaps the best feature of the formula? You can now use "DTE 30" and get the expiration 30 days from today. Each time you open your spreadsheet this will update giving you an expiration 30 days in the future.

That means you can use "100-200", "100,200", or "<100" in the strike filter to get the exact strikes you want. What's even better? "DELTA 50" and get the at the money option.

And of course you can to calls, puts, in the money or out of the money options and eliminate the rest. Check out the video tutorial to see the formula in action or read our blog post for a complete tutorial with examples.

We spent all November & December working on stability issues in Google Sheets and our API. Users of extremely large and complex spreadsheets (500+ Market Data formulas, 1 million+ cells) have had a hard time using our product due to slowdowns and stability issues.

Our "All sheets" refresh process is now rock solid and can refresh a . Previously, large sheets could take 15-20 minutes to fully refresh. And now the "Current sheet" refresh will refresh sheets with 100,000+ cells in about 30 seconds.

You may have noticed periodic downtime for our real-time data API as well. We spent the better part of the month (stocks, options, and indices). That means when the connection to our primary data provider is offline or overloaded, we can switch over to a secondary source, avoiding those pesky 5-10 minute outages.

. Our Free Forever plan and free trial users can continue to use our API and Sheets Add-on, but will receive delayed data instead of real-time data. This change will help us conserve server/bandwidth resources and provide a better experience for paying customers.

With our 1 year anniversary on the horizon next February, we plan on ending the open beta. If you would like to take advantage of our beta pricing (), we encourage you to sign-up and lock in the lifetime discount, which is discounted for our beta customers.

Our October update now includes . You can now get . They can be requested both through Google Sheets and the API. Read our tutorial to learn more and see real-life examples. It is now possible to build advanced risk-management into your spreadsheets or trading applications using the greeks to help you manage risk.

Also included in this update: . It is now possible to graph the famous "option smile" curve in Google Sheets using the output from the IV parameter. Find opportunities when the market misprices option volatility and take advantage without ever leaving Google Sheets.

Our last options improvement for October—we've added automatic intrinsic & extrinsic value calculations to both real-time and historial options. on any option quote. The calculation is made at the time of the quote, so historic quotes will show the intrinsic/extrinsic values based on the historical stock price.

Read our tutorial for Google Sheets users to begin working with option greeks and see real-life risk management examples