Seeking Alpha

Option Maestro's  Instablog

Option Maestro
Send Message
Marco is a trader of stocks, options, currencies, and futures. He has been fascinated with the financial markets ever since he bought his first stock at 11 years old. Marco entered the business world at the age of 13, with the creation of an extremely successful retail website... More
My blog:
Hot Trading Strategies for a Cold Market
My book:
Trading Options Made Easy
  • NASDAQ 100 Spreadsheet: Where's the Money Moving? 0 comments
    Jun 21, 2009 2:02 AM | about stocks: DIA, SPY, QQQ, TEVA, ESRX, DTV, GILD, CELG, GOOG, NWSA, MSFT, AAPL, COST, QCOM, CMCSA, ADP, AMZN, YHOO, ATVI, AMGN, EBAY, CSCO, ORCL, BBRY, INFY, INTC, DELL

    As recently posted in my blog OptionMaestro.com, I am writing this article to announce a new FREE way I will be tracking the performance of stocks in the NASDAQ 100. I am still testing this method of stock picking, to see if it has any significance, but I believe it may be a way to see where the money is moving without staring at a heatmap which would not give you this list anyway, and would cost money for the software. To the point however, I have created a spreadsheet which has the NASDAQ 100 ranked both alphabetically and by market cap. If worst comes to worst I still have the entire list of NASDAQ 100 stocks ranked alphabetically which I can analyze in the click of a button.

    To download this sheet click here.

    Explaining each sheet:

    Sheet 1 of spreadsheet: There are 2 sets of data. 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". This will allow you to see each stock in the NASDAQ 100 and their daily data as well as yearly data. This list is ranked alphabetically.

    Sheet 2 of spreadsheet: This has each company ranked by Market capitalization (greatest to least). 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 and monthly basis by market cap to see which stocks have moved up or down on the list of 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 and monthly basis and could provide some insight on the stronger companies or at least more bullish stocks (overall market cap).

    Like I said I do not know if this method has any credibility yet, but I will be testing this over the months to come to see if I can find anything significant.

Back To Option Maestro's Instablog HomePage »

Instablogs are blogs which are instantly set up and networked within the Seeking Alpha community. Instablog posts are not selected, edited or screened by Seeking Alpha editors, in contrast to contributors' articles.

Comments (0)
Track new comments
Be the first to comment
Full index of posts »
Latest Followers

StockTalks

  • Time for profits... I can raise cash and be patient or pay down debts as I wait for a corrction.
    Nov 18, 2013
  • Ugly weekly candle stick with slightly heavier volume... Use caution
    Jul 28, 2013
  • $SPY $SPX put in a doji for the year... I'm expecting a huge range and a +/- 25% move either way this year
    Jan 2, 2012
More »
Posts by Themes
Instablogs are Seeking Alpha's free blogging platform customized for finance, with instant set up and exposure to millions of readers interested in the financial markets. Publish your own instablog in minutes.