I thought it would be interesting to create a spreadsheet for the NASDAQ 100. You'll notice in Sheet 1 that there are 2 sets. There is no reason for the two different sets other than Excel would not allow more than 70 stocks to be refreshed at once, so I divided it into two equal groups. 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 on the NASDAQ 100. You'll notice the top 25 are quite hard to move, but the bottom 75% 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 (Firefox and Excel 2007 recommended) Click Here
Sphere: Related Content
Saturday, June 20, 2009
Subscribe to:
Post Comments (Atom)
Hottest Blog Posts of All Time
-
I sold my 500th E-Book on July 5, 2009. Thank you to all my readers for purchasing my E-Books and reading my blog. I will continue to blog b...
-
I am going to do an analysis on the top 20 Financial stocks in the S&P 500. I will be analyzing these stocks by selling below the curren...
-
Today I will explain why I plan on getting into three consumer discretionary stocks and how I plan on getting into them. First, I will state...
-
Today I will write about five stocks which I am rotating into that will allow me to get a little more defensive but still participate in thi...
-
I am going to do an analysis on the top 20 tech stocks in the NASDAQ 100. I will be analyzing these stocks with the buy/write option strate...
-
Perhaps the worst kept tech secret in history was that the Apple (AAPL) iPhone would be on Verizon (VZ) someday. Now that it has finally bee...
-
As stated in my last article 3 Dow Stocks to Buy-Write Now I believe financials will outperform the market in the early part of this year. ...
-
Someone once asked me "how have you made the most money playing in the stock market?" I had to think long and hard because in toda...
-
As the market has been grinding higher over the past few months, we've heard many bears state that we are overbought and that we're...
-
When I was 16 years old, I took a vacation to Italy and purchased a gold chain. At the time I remember everyone telling me the price of Gold...
3 comments:
Looks interesting. Downloaded read-only version. Assume this read-only can be tested too - IOW, data will reresh, etc? How to get an editable spreadsheet so I can tweak, if necessary?
I will experiment and post my own discovoeries, if any. BTW, liked you online book. Keep up the good work.
CP
CP, thanks for dropping by and the comments. The spreadsheet will refresh and you can edit it. Please keep me posted on any of your findings.
I'm trying to find a financial tool/program that performs analysis of a companies financial data. Once I sort through stock list of companies that I can afford to invest with, I need the function of a program that can help determine the companies financial soundess. Basically, I want low cost stocks with high dividends and growth. Any suggestion? And, thank you.
Post a Comment