How To View and Filter An Options Chain In Google Sheets скачать в хорошем качестве

How To View and Filter An Options Chain In Google Sheets

Learn how to download a complete option chain into Google Sheets using Market Data’s Add-On by using the OPTIONCHAIN formula. In this video you’ll learn how to filter the chain by date, strike, side. You’ll learn how to make it dynamic by using DTE and DELTA parameters to filter the chain. And we’ll build a vertical call spread and a rudimentary option screener. ========================================== #callspread #marketdata #optionchain #options #trading #stockmarket #googlefinance CHAPTERS 0:00 Introduction 0:15 What’s the difference between OPTIONDATA and OPTIONCHAIN? 1:22 Customize The Column Output 2:45 Filter The Option Chain By Expiration 4:44 Filter The Option Chain By Strike 5:28 Filter The Option Chain By Side 6:18 Build A Dashboard or Screener 7:13 Filter By Deltas 10:14 Thank You For Watching RESOURCES ► Download the Market Data Add-On For Google Sheets: https://www.marketdata.app/sheets-addon/ FORMULAS USED In the video, we used the OPTIONCHAIN formula to filter the option chain. You can copy & paste them into your sheet and see them work: ► Basic Option Chain (all column output): =OPTIONCHAIN("AAPL") ► Filter The Columns (selected column output): =OPTIONCHAIN("AAPL","option symbol,side,strike,expiration,mid") ► Select the Date (make sure you update the date to a current date): =OPTIONCHAIN("AAPL","option symbol,side,strike,expiration,mid","3/31/2023") ► Use a Strike Range (make sure you update the date to a current date): =OPTIONCHAIN("AAPL","option symbol,side,strike,expiration,mid","3/31/2023","150-170") ► Filter the Side (calls only): =OPTIONCHAIN("AAPL","option symbol,side,strike,expiration,mid","3/31/2023","150-170","calls") ► Use DTE for Date (45 days to expiration): =OPTIONCHAIN("AAPL","option symbol,side,strike,expiration,mid","45 DTE","150-170","calls") ► Use Deltas For Strike (60,30 delta): =OPTIONCHAIN("AAPL","option symbol,side,strike,expiration,mid","45 DTE","delta 60,30","calls") Remember, you need the Market Data Add-On for these formulas to work.