Daily Stock Market Equity and Options Trading Commentary

To get a better understanding of the option ideas expressed in this blog, buy my ebook today!

Tuesday, June 23, 2009

S&P 500 Stocks Spreadsheet

Similar to my NASDAQ 100 spreadsheet, I thought it would be interesting to create a spreadsheet for the S&P 500.

You'll notice in Sheet 1 that there are 11 sets. There is no reason for the eleven different sets other than Excel would not allow all data on 1 set etc... To get daily or even by the minute (delayed 20 minutes) stock data click "data" and then "refresh all". Sheet 2 of this spreadsheet has each company and in order by Market capitalization. To refresh this click "data" "refresh". The way I use this as a tool is to see which stocks are being bought and sold. I rank them on a weekly basis by market cap to see which stocks moved up or down on the list. You'll notice the top 50 are quite hard to move, but the bottom 90% of the list vary on a weekly basis and could provide some insight on the stronger companies as their stock prices (overall market cap).

To download this spreadsheet click here (Excel 2007 and Firefox recommended)

Open a TradeKing account today

Bookmark and Share
Sphere: Related Content


thisissparty said...

Any thoughts on where I might find market cap ranking statistics historically? (last 10 years, 20 years?)

Option Maestro said...

I'm sorry I don't. If you figure out please share!

Hottest Blog Posts of All Time