If any of you cull the entire stock market without Q-charts, you may find this spreadsheet useful. I augmented the âcull stocktablesâ spreadsheet posted back in journal 1 to automatically cull the NYSE, NASDAQ, and AMEX exchanges with the data found at eoddata.com.
Step 1: Download the data at eoddata.com for the 3 exchanges.
Step 2: The files will be text files and we need them as spreadsheets so heres how to change them. Open excel, select open file, change it to list all types of files, and open the âNYSEâ file you just got from eoddata.com. A âtext import wizardâ box pops up, check âdelimited,â hit next, check âcommaâ, hit finish. Now the text file should appear as a spreadsheet.
Step 3: Copy the symbols (you can just click the A column and it will automatically select them all) and paste them into the A column of the âNYSEâ page.
Step 4: Repeat step 2 and 3 for the NASDAQ and AMEX symbols, pasting them into their appropriate pages. The NASDAQ symbol âTRUEâ causes an error in excel when culled so it must be manually deleted from the âNASDAQâ page.
Step 5: On the âresultsâ page, hit the âcull NYSEâ button, followed by the âcull NASDAQâ and âcull AMEXâ buttons.
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.)
Notes: Yahoo CSV does not have a â% held by insidersâ option so it cannot be culled for here. Sometimes Yahooâs float data is off so you may consider putting the âFloat minâ to 0 and manually checking all symbols with rank. If no symbols meet the criteria for a particular column (as is the case with the 1st AMEX column from Fridayâs data) all 200 symbols will appear in that column, just ignore that column.