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 analyzed the underlying security, you can apply additional fields through the Edit Fields button or insert a Custom View by clicking on the Main View.

Check out our User Guide to learn how to view historical unusual options activity and how to remove options lists.