Stock Lists

Owned by Brendan Hebert
Last updated: Sept 21, 2021
3 min read

By clicking on the ‘Stocks’ icon located in the Lists section you can pull in Barchart.com stock lists directly into Excel.

 

Once selected, the Stocks 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 Data Type, Time Frame and Exchange.

For U.S. Markets: The "All US Exchanges" lists include only NYSE, Nasdaq, and NYSE Arca stocks that have traded today, excluding ETFs, unit investment trusts, closed end funds, warrant stocks, preferred securities and any non-SIC (OTC) classified stock. Stocks must have over 5 days of prices, with a last price above $0.25 and below $10,000, and with volume greater than 1000 shares. 

You may further filter the New Highs/Lows page to only includes stocks traded on the NYSE, Nasdaq, NYSE Arca, or OTC US exchanges. It also breaks out ETFs into a separate category. Each of these lists require the security to have over 5 days of prices, with a last price above $0.25 and below $10,000, and with volume greater than 1000 shares. Calculations are adjusted for stock splits but not dividend distributions.

Additional filtering based on Market Cap, Price, and Volume are available on pages for U.S. and Canadian Markets. For the U.S. Market, the Price listings are limited to stocks trading on the NYSE, Nasdaq, and NYSE Arca exchanges, and does not include ETFs, unit investment trusts, closed end funds, warrant stocks, preferred securities and any non-SIC classified stock.

Market Cap

  • Large Cap - stocks with a market cap greater than or equal to $5B

  • Mid Cap - stocks with a market cap greater than or equal to $1B and less than $5B

  • Small Cap - stocks with a market cap greater than or equal to 250M and less than $1B

  • Micro Cap - stocks with a market cap less than 250M

Price or Volume Filter

  • Price < $10

  • Price > $10

  • Volume < 500,000

  • Volume > 500,000

Once the list and filters are selected, apply any fields (or Custom View through the 'Custom Views' menu) and click Insert to pull the list into your Excel sheet.

 

Stock List Removal

Stock Lists inserted into a worksheet can be quickly removed by highlighting the Stock List anchor cell, Clicking on the Stocks icon and selecting the Clear button.