Spydertrader's Jack Hershey Equities Trading Journal III

[ra303]

Quote from nicepair111:


Step 6: Several columns of symbols appear on the “results” page. Yahoo only allows scanning 200 symbols at a time so each column represents a scan of 200 symbols. The columns are the symbols that meet the criteria selected on the “Watch List” page (float between 5M and 60M; average volume > 200,000; EPS > 0; price between $10 and $50.) These columns can then be copied and pasted into a watchlist at wealthlab and scanned for rank. (You can only scan 100 at a time at wealthlab.)

Hi Nicepair111 , thanx a ton for the spreadsheet. It has saved me hours of work. Can you just make one more modification to it ? To copy all the symbols from the results worksheet to a seperate sheet in one single column ? I tried it with the following code but it just copied the list as it is without sorting it in a single column. thanx for your help.


Sub Button1_Click()
Sheets("Results").Select
Range("A1:R209").Select
Selection.Copy
Sheets("Tickers").Select
ActiveSheet.Paste
End Sub

 

[nicepair111]

Quote from ra303:

To copy all the symbols from the results worksheet to a seperate sheet in one single column ?

The reason the symbols appear in separate columns is because a different number of symbols get returned for each group of 200. In order to put them in 1 column, there would need to be large gaps between what are now the different columns or else some symbols would get overwritten. I experimented with putting them in 1 column and just leaving 200 cells between each group of symbols, then have a macro which would hide all the empty cells. For 1 reason or another, I kept running into problems with that approach.

Im sure that there is a workaround for the need to have either separate columns or large gaps, I just havent figured it out yet. I have another, slightly more complicated, idea that could fix this problem. Ill try to see if I can make it work this weekend.

For now, what Ive been doing is just dragging and dropping the separate columns into 1 long column. This really doesnt take that long (under 1 minute) and makes the symbols much easier to work with.

 

[johnpinochet]

Quote from PointOne:

What do you guys think of this MTOX chart?

Given the fact that the universe posted by Spyder contains several nicer charts, why would you even bother? I'm going through Worden's 3 stock videos now as a refresher, and one of the things he mentioned is that the whole idea of screening is that you shouldn't have to stretch to find a solid stock to trade.

Look at GROW since May 2007. Look at DRYS since July 2007. Nice cycling chart. Solid stuff for the beginning method.

 

[LostTrader]

Quote from Monkman:

Amibroker w/iqfeed is a great combo.

Thanks, Monkman. I've been considering that option. Saw a demo on AB that looked pretty good.

 

[Monkman]

Quote from PointOne:

What do you guys think of this MTOX chart?

UV from Qcharts is .99 on MTOX. Looking from a beginner perspective I would rather wait for DU or for it to transition to an upward channel before taking the risk.
DU -> FRV all the way.

- Monkman

 

[Monkman]

Quote from PointOne:

What do you guys think of this MTOX chart?

<img

As Miller Brewing company would say it, "Good Call." That was a nice FTT. Thanks for pointing it out.

- Monkman

 

[johnpinochet]

Quote from johnpinochet:

Given the fact that the universe posted by Spyder contains several nicer charts, why would you even bother? I'm going through Worden's 3 stock videos now as a refresher, and one of the things he mentioned is that the whole idea of screening is that you shouldn't have to stretch to find a solid stock to trade.

Look at GROW since May 2007. Look at DRYS since July 2007. Nice cycling chart. Solid stuff for the beginning method.

PointOne,

Nice call on MTOX, but I still stand by my comment. Now, if you can do that consistently, I'll be looking forward to adding your journal to my ET subscribe list!

 

[Spydertrader]

Tuesday Dry Up

GROW JADE JSDA KMGB ROCM SFLY TASR TBSI

- Spydertrader

 

[johnpinochet]

Spyder,

I know this has been asked before, but given the subprime mess and all of the other bearish news, are you letting anything affect your stock buy decisions outside of the strict method?

In other words, do you ever look at things and say, "Nah, I'm not buying today, this week or this month?"

Thanks in advance!

John

 

[Spydertrader]

Quote from johnpinochet:

In other words, do you ever look at things and say, "Nah, I'm not buying today, this week or this month?"

Absolutely not.

This summer has been one the most unbelievable periods for trading since the dot-com frenzy of the late nineties. Once a trader can learn to remove all bias (long vs short) and can maintain a neutral bias with respect to all markets, one no longer need care about direction. Price simply needs to move in order to profit.

One thing these stocks (Final Universe) do, is move.

- Spydertrader