How To Download IBD 200 To An Excel Spreadsheet

If you are looking for how to download the IBD 200 to an excel spreadsheet, what you are going to want to do is sign up for the eTables service on investors.com. Inside that subscription, you can download the main tables into an excel spreadsheet. It includes the top 300 stocks ranked by the Smart Select composite rating. I usually delete the bottom hundred to get the IBD 200. Once in the spreadsheet, I usually copy the tickers 50 at a time over to the My Stocks list on investors.com or into a watch list on Google finance. Portfolios on Google finance can keep up to 200 stocks at this writing.

You can add the stocks right from the eIBD into your stock market investing watch lists on investors.com but this is kind of time consuming. The other alternative is to write the tickers down or copy them from the electronic version but this also is a step that is nice to eliminate so you can spend more time reviewing stocks. Writing the tickers down helps you remember them better and that's a plus but for most of us, we'd like to skip that step.

In the last reader survery, I mentioned this would be a nice feature. As it stands now, you have to pay approximately $15 a month for the additional subscription. It's worth it though because you also get the IBD 100, the Weekly Review and the New America stocks as well.

Also, the main tables that provided the IBD 200 are updated daily, so you could update your spreadsheet every day with current stocks instead of waiting until Thursday of each week to get the list. I wrote more about using this list in Stockbee IBD 200 Trading Techniques.