By clicking on the ‘Options’ icon located in the Lists section you can pull in Barchart.com equity option lists directly into Excel.
Once selected, the Options list dialogue will display where you can select a list you wish to insert.
Depending on the list selected, the dialogue will update and provide different filtering options like Type of underlying security and Increase or Decrease in volatility or open interest.
Once the list and filters are selected, click Insert to pull the list into your Excel sheet. If the Options List analyses the underlying security, you can apply apply additional fields through the Edit Fields button or insert a Custom View by clicking on the Main View.
Options List Removal
Options lists inserted into a worksheet can be quickly removed by highlighting the Options List anchor cell, Clicking on the Options icon and selecting the Clear button.
