Sheets

14 articles on sheets from Market Data.

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.

A conceptual image with a Microsoft Excel theme, representing stock earnings, featuring the title 'EARNINGS' prominently in the center. The image includes visual elements like Excel spreadsheets, pie charts, bar graphs, and financial data. The background mimics the classic green and white color scheme of Excel, emphasizing the use of spreadsheets in financial analysis. This image conveys the practical and analytical aspects of handling stock earnings in Excel.

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.

How To Get Stock Market Holidays In Your Spreadsheet

Get past, present, and future stock market holidays for the United States directly into your spreadsheet with the MARKETSTATUS formula.

Candles vs Quotes, What’s The Difference?

What's the difference between candles vs quotes when it comes to stock data? Market Data offers both candlestick and quote data, so make sure you use the right data for your spreadsheets.

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.

How to Calculate Theta For An Option

Learn how to calculate theta and understand how to add time decay to your spreadsheets.

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.

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.

How To Calculate Implied Volatility In Your Spreadsheet

Using the OPTIONDATA formula, you can calculate implied volatility for any option.

How To Calculate Option Greeks In Your Spreadsheet

The OPTIONDATA formula will calculate the option greeks to your spreadsheet automatically using the keyword "greeks" as a parameter. Risk management has never been easier.

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.

How To Build A Covered Call Spreadsheet

Learn how to build a covered call spreadsheet to track all your covered calls. Download our free covered call tracking spreadsheet example sheet for Google Sheets and begin tracking your covered calls today.

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.

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.

Winning trades are born from superior data.

Free 30 day demo for new accounts. No credit card required.