# Financial Data Articles: Stocks & Options > 24 articles on Data. Tutorials, explainers and worked examples from Market Data for traders and developers. Source: https://www.marketdata.app/topics/data/ --- # Data The “Data” category encompasses a rich repository of subcategories including stocks, options, indices, and more, providing a comprehensive overview of the vast array of financial market data available through our services. It’s crafted to cater to traders, investors, and developers seeking in-depth insights and analyses on various asset classes. Through detailed descriptions, usage examples, and insights into data trends, this category aims to support informed decision-making and strategy development for market participants of all levels. Filter: [API](?tag=api)[Google Sheets](?tag=sheets)[Show All](?tag=) No articles on this page match that filter. [ (image: The words SMART MID in heavy black capitals, backlit by a blue glow against a dark starfield.) Smart Mid: A Better Real-Time Market Price Our proprietary model to estimate a fair real-time value for any stock, built on top of IEX market data. ](/data/stocks/what-is-smart-mid/)[ (image: The Greek alphabet in white capitals on dark grey, five rows of five, delta and theta among them.) Missing Options Contracts — Why You Can’t Find Them Understanding the common reasons traders can't find certain missing options contracts. The importance of knowing how options contracts are created and traded. ](/education/options/missing-options-contracts/)[ (image: A monitor on an office desk displaying MUTUAL FUNDS API, surrounded by glowing candlestick charts and network lines.) How To Use The Mutual Fund API Learn by example and get started with the mutual fund api. Get candlestick and pricing data going back decades. ](/api/funds/how-to-use/)[ (image: The Go language GO wordmark with trailing speed lines, glowing white against a purple starfield.) Getting Started With The Golang Stock API Get financial data in Go using the Golang Stock API. The SDK includes a variety of methods for accessing financial data such as real-time stock quotes. ](/sdk/go/golang-stock-api/)[ (image: Rows of green and magenta prices beside six-figure volumes on an angled market quote board.) How To Bulk Download Stock Data in Google Sheets Learn how to perform bulk stock data downloads using Market Data's Google Sheets Add-on. ](/sheets/stocks/bulk-download-stock-data/)[ (image: The word EARNINGS across a wireframe globe, ringed by bar charts, pie charts, line graphs and spreadsheet panels on a green background.) How To Get An Earnings Calendar For Any Stock In Google Sheets Add an earnings calendar to Google Sheets using Market Data's EARNINGS formula. Find what Wall Street Analysts are projecting for next quarter. ](/sheets/stocks/earnings-calendar/)[ (image: The letters API at the centre of a cyan network diagram, its spokes radiating to eight ringed nodes on dark navy.) How To Use The Free Stock Market API: A Guided Tour of our Swagger UI Finally, a free stock market API without scraping or proxies. Learn how to get stock pricing data, both current and historical, using swagger. ](/api/stocks/free-stock-market-api/)[ (image: A pencil on a blue-tinted calendar page, crossed by a red band lettered MARKET HOLIDAYS.) How To Use The Stock Market Holidays API Use the stock market holidays API to get the open or closed status for any date in the past, present or future. ](/api/stocks/stock-market-holidays/)[ (image: A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.) Candles vs Quotes, What’s The Difference? Candles or quotes? STOCKDATA returns both, and picking the wrong one skews your spreadsheet. Here is what each one holds and when to use it. ](/sheets/stocks/candles-vs-quotes/)[ (image: A phone home screen in close-up: the green Google Sheets icon between the Google and Instagram icons.) How To Get An Option Chain In Google Sheets Use the OPTIONCHAIN formula to get a complete real-time option chain in Google Sheets. Filter by date, days to expiration, strike, deltas, and more. ](/sheets/options/option-chain/)[ (image: The Greek letter theta, the options Greek for time decay, glowing white against a purple starfield.) How to Calculate Theta For An Option Learn how to calculate theta and understand how to add time decay to your spreadsheets. ](/sheets/options/how-to-calculate-theta/)[ (image: A phone home screen in close-up: the green Google Sheets icon between the Google and Instagram icons.) How To Get Historical Options Prices For Your Spreadsheet Using the Market Data Add-on, it is possible to get historical options prices going back decades directly into your spreadsheet with a simple formula. ](/sheets/options/historical-options-prices/)[ (image: Blue isometric circuitry lettered HISTORICAL STOCK DATA API, above a pill reading GETTING STARTED: LEARN BY EXAMPLE.) How To Use The Historical Stock Data API Learn by example and get started with the historical stock data api. Both daily and intraday data is available going back decades. ](/api/stocks/historical-stock-data-api/)[ (image: The letters API at the centre of a cyan network diagram, its spokes radiating to eight ringed nodes on dark navy.) How To Use the Stock Market API — With Examples! Get real-time and historical market data from the stock market api. Learn quickly with easy to use examples that work right from your browser. ](/api/stocks/stock-market-api/)[ (image: OPTION DATA API in heavy black capitals, rim-lit in cyan against a deep navy starfield, with faint candlesticks arcing upward behind the words.) How To Use The Option Data API — With Examples! The Option Data API allows you to easily get a real-time or historical option quote for stock, ETF, or index options. ](/api/options/how-to-use-the-option-data-api/)[ (image: Option value before expiration: red extrinsic value shrinks as blue intrinsic value grows from at-the-money into the money.) How To Calculate The Intrinsic / Extrinsic Value of an Option In Your Spreadsheet Using the OPTIONDATA formula, you can automatically calculate the implied volatility of any option that is currently trading. ](/sheets/options/intrinsic-extrinsic-value/)[ (image: A white bell curve over a faded blue collage of web pages, above a red band lettered IMPLIED VOLATILITY.) How To Calculate Implied Volatility In Your Spreadsheet Using the OPTIONDATA formula, you can calculate implied volatility for any option. ](/sheets/options/implied-volatility/)[ (image: The Greek alphabet in white capitals on dark grey, five rows of five, delta and theta among them.) How To Calculate Option Greeks In Your Spreadsheet The OPTIONDATA formula pulls delta, gamma, theta and vega straight into your spreadsheet, so position risk updates itself with the market. ](/sheets/options/calculate-option-greeks/)[ (image: The letters API at the centre of a cyan network diagram, its spokes radiating to eight ringed nodes on dark navy.) How To Use The Option Chain API — With Examples! The Option Chain API allows for ample sorting & filtering during each request, making it easy to get exactly the data you need. ](/api/options/option-chain-api/)[ (image: Rows of five-decimal quotes such as 1.20506 and 1.18189 glowing green and blue on a dark screen.) How To Get Real-Time Stock Prices in Google Sheets The GOOGLEFINANCE formula gives 15-min delayed stock prices. Get real-time stock prices into Google Sheets using the STOCKDATA formula. ](/sheets/stocks/how-to-get-real-time-stock-prices/)[ (image: Covered call payoff profile: the combined position breaks even at 95, rises to a profit of 5.00 at 100, and stays flat above it, while losses continue below 95.) How To Build A Covered Call Spreadsheet Build a covered call tracker in Google Sheets, formula by formula — and download our free example sheet to start tracking your positions today. ](/sheets/options/how-to-build-a-covered-call-spreadsheet/)[ (image: A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.) How To Get Intraday Stock Prices in Google Sheets Learn how to get intraday stock prices in Google Sheets (with prices down to the minute) using a simple formula that works the same way as GoogleFinance. ](/sheets/stocks/intraday-stock-prices/)[ (image: A black felt letter board spelling DOWNLOAD, a 3.5-inch floppy disk propped on its corner, on a wooden table.) How To Download Historical Options Prices in CSV Format Market Data makes it easy to download historical options prices for the entire market or for a single symbol. ](/data/options/historical-options-csv/)[ (image: A phone home screen in close-up: the green Google Sheets icon between the Google and Instagram icons.) How To Get Options Prices in Google Sheets Learn how to add real-time and historical options prices into your Google Sheets spreadsheets using a single formula. ](/sheets/options/how-to-get-options-prices/)