1. Barchart for Excel includes lists, like Leaderboards for Stocks & Options that are easily accessible and contain key market data.  

To start, just Click on the Stocks menu in the Barchart for Excel ribbon.

Step 1 image

2. The window now displays all of the Lists available within the Stocks section.  You will find everything from Today's Top Stocks to Price and Volume Leaders, along with key Market Indexes.

Once you Insert a List, it will dynamically update in Excel.

Step 2 image

3. Here's the list for Today's Top Stocks.  The prices will dynamically update and new stocks will be added and removed throughout the day.

Included are the default data fields, but you can customize them and even use Barchart.com Custom Views.  

Step 3 image

4. Let's open the Stocks List menu again.  And this time, let's Insert Five Day Gainers.  With this list you can select the Data Type, either Advances or Declines. 

We'll go with Advances.  Click Insert.

Step 4 image

5. And your list is instantly added.  You can now adjust the columns, filter the data or apply other Excel functionality, such as Sort by a column.

Step 5 image

6. There are also Lists for Exchange Traded Funds. 

Click the ETF menu to see what is available.

Step 6 image

7. For Exchange Traded Funds you can find everything from Popular Funds, to percent leaders for different time periods, to volume leaders. 

In the window you will also see a section for Mutual Funds.

Step 7 image

8. Here is the Popular Exchange Traded Funds list.  You will see different categories are added, like Global, U.S. Industries and Specialty Industries.  Along with default data fields like Last and Opinion.  In the window, you can customize the fields.

Step 8 image

9. Finally, let's take a look at the Options Lists.  Click the Options menu.

Step 9 image

10. The Options window contains a variety of lists, including Unusual Options Activity, Most Active Options, Options Volume Leaders and more.  With the click of a mouse you can instantly add any list to Excel.

Step 10 image

11. Here is Barchart's Unusual Options Activity, which lists the top options contracts sorted by the highest volume to open interest ratio.  Like other lists, this list will dynamically update throughout the day.

Thanks for watching!

Step 11 image