See David Marshall's post on the MSN Board. David posts under the handle dkm on the Elitetrader.com web site. - Spydertrader
The attachment includes the java source and the jar file for SpyderFilter v 1.0. It is a Java command line utility which means you have to go to Start menu ->Run and type cmd to get a command prompt. For XP command prompt, there is a Mark/Paste option under edit menu if you click the tiny C:\ icon at your upper left hand side of the command prompt. You might want to use it to cut and paste stock list. 1) You need to install Java Runtime Environment if you don't already have it: http://java.com/en/download/index.jsp 2) To run the Java jar file: java -jar SpyderFilter.jar I just want something to work. I did not really streamline the code so it would go out to the web multiple times to fetch the data. That's why it is a little slow. 3) Enter the stock symbols either on the same line or separate lines. Doesn't matter. BUT YOU HAVE TO HIT ENTER AGAIN TO TERMINATE THE INPUTS!!! Here is a sample run output: C:\>java -jar SpyderFilter.jar SpyderFilter version 1.0 by martys (c) 2005 Enter Symbols [empty line to terminate input]: ibm kndl ford Stock data: 1) ibm float=1569700000 EPS=0.94 avgVol=5607480 failed 2) kndl float=11200000 EPS=0.24 avgVol=259700 PASSED 3) ford float=6800000 EPS=0.33 avgVol=747627 PASSED Filtered results: kndl ford
I appreciate you sharing your efforts with the Journal. I have no doubt many find your time saving contribution helpful. - Spydertrader
The zip file contains 2 files. SpyderFilter.java is the Java source code and SpyderFilter.jar contains executable bytecodes. SpyderFilter is a fundamental data filter that uses the stock float and EPS information from clearstation.com and Avg Vol (3m) information from Yahoo.com. It relies on certain landmarks on the web page to strip the information properly. So if the sites changes the page format, they can break the program in which case it would display negative numbers for avg vol and float etc. This should automate the eye-ball step for the fundamental data. Let me know if you have any question or having problem to run the Java command line utility. Good trading, William P.S. stopped out on FORD. Don't like the way it whipsaws me.
FORD had a nice runup today after DU BO in the morning. Eventually it reversed going negative for the day. Sold at $25.39 for an 80c loss after being up 90c. Sold GMXR as it didn't reach FRV by EOD.
I kept the rest but I am usually wrong . Had my stops in. I figure the Price/Volume are still up and paid my broker enough for the day.
I fix the code to handle decimal average volume (on BBSI). The new attachment is up. Sorry about that. I apologize for the inconvenience. Remember to hit Enter again to give it an empty line signaling the end of inputs!
Here is a sample run using the results from today's Rank Scan: C:\>java -jar SpyderFilter.jar SpyderFilter version 1.0 by martys (c) 2005 Enter Symbols [empty line to terminate input]: BBSI BOOM BTUI CFK CKCM CMCO CUTR FORD IPII IRIS KNDL LMIA LMS MPWR NGPS NURO PETS PTC RNOW SUPX URGI VIVO VPHM Stock data: 1) BBSI float=5400000 EPS=0.4 avgVol=58747.7 failed 2) BOOM float=5400000 EPS=0.18 avgVol=1445800.0 PASSED 3) BTUI float=5600000 EPS=0.2 avgVol=342471.0 PASSED 4) CFK float=6000000 EPS=0.14 avgVol=154028.0 failed 5) CKCM float=9000000 EPS=0.27 avgVol=397182.0 PASSED 6) CMCO float=13100000 EPS=0.2 avgVol=302315.0 PASSED 7) CUTR float=9000000 EPS=0.27 avgVol=376485.0 PASSED 8) FORD float=6800000 EPS=0.33 avgVol=754175.0 PASSED 9) IPII float=2000000 EPS=0.4 avgVol=364402.0 failed 10) IRIS float=15900000 EPS=0.09 avgVol=195568.0 failed 11) KNDL float=11200000 EPS=0.24 avgVol=259700.0 PASSED 12) LMIA float=4000000 EPS=0.13 avgVol=68737.9 failed 13) LMS float=12400000 EPS=0.35 avgVol=170051.0 failed 14) MPWR float=20600000 EPS=0.13 avgVol=155420.0 failed 15) NGPS float=8199999 EPS=0.3 avgVol=286137.0 PASSED 16) NURO float=6800000 EPS=0.06 avgVol=203180.0 PASSED 17) PETS float=16600000 EPS=0.11 avgVol=493917.0 PASSED 18) PTC float=5100000 EPS=0.26 avgVol=99952.3 failed 19) RNOW float=12700000 EPS=0.07 avgVol=278002.0 PASSED 20) SUPX float=10500000 EPS=0.31 avgVol=153523.0 failed 21) URGI float=10600000 EPS=0.31 avgVol=77058.5 failed 22) VIVO float=17700000 EPS=0.14 avgVol=315980.0 PASSED 23) VPHM float=55700000 EPS=0.31 avgVol=2936860.0 PASSED Filtered results: BOOM BTUI CKCM CMCO CUTR FORD KNDL NGPS NURO PETS RNOW VIVO VPHM
martys, I know next to nothing about .jar files. When I go through the command C:>java -spyderfilter.jar, I get this error: "JAR" is not recognized as an internal or external command, operable program or batch file. Thanks for writing this as I see how it will save time. DS