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
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.
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.
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
As Miller Brewing company would say it, "Good Call." That was a nice FTT. Thanks for pointing it out. - Monkman
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!
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
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