Again: I am not a TOS promoter and get nothing from them. If I were I would be saying something like "Open your account with TOS and tell them Palmer sent ya." Have you heard that from me? Nope.

This is one of the more involved videos and I think I hit it all. Ask as needed...

Keeping track of earnings winners can be a chore but finding those or getting alerted to those that are actually making a move can be an entirely different task. You can set alerts but a real-time flow of information is good also. I've touched on using the Zacks earnings calendar to find those winners and how to use TOS to compose scans or watchlists to organize the flow of data with them. Now I am going to look at how to use Excel to organize some of that data and see the flow of price and data in real-time using the TOS Export to Excel link.

You need to be somewhat familiar with Excel to sort, filter, copy, and paste data but the possibilities of what you want to do with that real-time data is endless per the Excel functions. However, my main focus is always volume so that's where this is centered.

There can be certain stocks (penny stocks) that have great earnings numbers but are dead in the water at the open. Usually this is because the average volume of that stock (10 day, 20 day, 100 day, etc.) is very low...50K or or a few hundred K shares and it does not get the attention to get it going. Sometimes these do run but more often than not there is very little movement. Even if they did have a previous day's volume of 50K shares and the day of earnings the volume is 250K shares that is still pretty low even with a 500% increase in volume. You can still be faced with bad fills and exits with a 250K volume per day moving stock. So, not only is finding earnings winners important but they need the volume to be tradeable.

Some of you may have noticed that the more windows or watchlists that you have open TOS can start to lag. This is a function of your CPU and not really memory per your computer. Extra memory does help but the speed of your machine is critical also and only so many things can be done at once including updating charts, indicators, watchlists, etc. Using Excel can free up some those resources and get rid of some of the lag in addition to simplifying things. If your PC or Laptop has a CD-ROM I would disable it when trading because that alone takes up a lot of resources per your PC speed. My new laptop that does not have a CD-ROM is a lot faster per using TOS vs. my new desktop with a CD-ROM.

Here we go:

Open a new Excel spreadsheet and label the cell O1 as xx.

Copy and past this formula in to cell O2 :

=IF(ISNA(MATCH(A2,J:J,0)),"",INDEX(J:J,MATCH(A2,J:J,0)))

Head over to Zacks (see the previous video) and go to the Earnings Release page and select whatever date you chose.

Have TOS open as well.

Again, going to try to do this in one video, if not then there will be a Part 2:

 

Palmer

The Penny Stock Quest