Well, I seem to have finally gotten things organized here. I had to take the original spreadsheet and divid it up because it appears I hit the physical limits of the capabilities of the Open Office spreadsheet - it choked when I added the full price relative database to it. What I did was create 5 seperate spreadsheets: the first calculates the price relative for each stock in the database (almost 5000 stocks), the second calculates whether price relative is rising or falling, the third screens for new highs in price relative, the fourth scans for breakouts on 4 time frames, and the fifth calculates a relative strength "score" based on the new high and advancing/declining data. One buzz saw I ran into today; the third spreadsheet, the one scanning for new highs, takes about 4 hours to finish it's calculations (the others, having only slightly fewer calculations, rarely take more than 10 minutes). That is a perplexing problem, and one that will keep me from being able to do it on a daily basis (weekly won't be a problem). What is really annoying is that while it is running I am not able to run any other spreadsheets. Anyway, the system is wortking, just not quite as smoothly as I had planned. Here is the price relative scan for Friday: 1 200 day breakout (Finviz screen here), no 100 day breakouts, 5 50 day breakouts (here), and 7 20 day breakouts (here).
I am now fairly exhausted, so I am putting this to bed for now. I will run the 5th spreadsheet tomorrow (time permitting) and post the results during the trading day.
I am now fairly exhausted, so I am putting this to bed for now. I will run the 5th spreadsheet tomorrow (time permitting) and post the results during the trading day.
