RELATIVE DATES AND TIMES ARE NOW AVAILABLE!
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
2 months ago
, -5 minutes
, or even yesterday
, 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.HOW DOES IT WORK?
- =STOCKDATA("AAPL", "date, price", "1 week ago", "today")will retrieve the data from exactly one week ago through today.
- https://api.marketdata.app/v1/stocks/candles/D/AAPL/?from=-1week&to=todaydoes the same thing, but in the API.
- Our documentation explains all the supported keywords you can use.
DIVE DEEPER INTO THE UPDATE
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.
MAJOR API PERFORMANCE ENHANCEMENTS
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:
- In August,before our performance work began, more than8%of requests took more than 5 seconds to complete.
- Today, 99.84%of all API requests are completed in less than 5 seconds.
- And 88.56%of API requests are now processed in under 1 second.
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.
VIDEO TUTORIAL
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.
We also finished this month:
- Bug: Candles are now output in OHLC order
- Data: Missing option data for several days now added
- Bug: Issue with timestamps corrected