上班实在有些空虚没事写了个AWK的小东西分析一下股票的CSV文件。

BEGIN { print "*"} {DATE[NR]=$1; OPEN[NR]=$2; HIGH[NR]=$3; LOW[NR]=$4; CLOSE[NR]=$5; VOL[NR]=$6; MOUNT[NR]=$7 print $5 } function closeAver(data, MA ,temp, aver) { for (i = NR-MA+1; i<=NR; i++) { temp+=CLOSE[i] } aver=temp/MA; print temp "----" aver return temp aver; } function highMax(max, MA, temp ) { temp=0; for (i=j-MA+1; i <= NR; i++) { if (HIGH[i]>temp) temp=HIGH[i]; } print "---------------" temp return temp } function lowMin(min, MA, temp ) { temp=LOW[NR]; for (i=j-MA+1; i <= NR; i++) { if (LOW[i]<temp) temp=LOW[i]; } print "---------------" temp return temp } END { for (j=12; j <= NR; j++) { ###########define some var######### sum1=0; #for the MA13 sum2=0; #for the MA34 sum3=0; #for the MA55 sum4=0; #for the VOL13 sum5=0; #for the VOL34 sum6=0; #for the VOL55 ############## For the MA system################# for (x=j-12; x <= j; x++) {sum1+=CLOSE[x]; sum4+=VOL[x]} aver1= sum1/13; vol13= sum4/13 for (x=j-33; x <= j; x++) {sum2+=CLOSE[x]; sum5+=VOL[x]} aver2 = sum2/34; vol34 = sum5/34; for (x=j-54; x <= j; x++) {sum3+=CLOSE[x]; sum6+=VOL[x]} aver3 = sum3/55; vol55 = sum6/55; #################################################### #print "sum1 is :" sum1 ; #print "MA13 is :" aver1 ; #closeAver(CLOSE[j],13) #print "sum2 is :" sum2 ; #print "sum3 is :" sum3 ; #print "MA34 is :" aver2 ; #print "MA55 is :" aver3 ; ############## FOR the KDJ System #################### rsvSum=0 max=0; min=LOW[j]; for (x=j-8; x <= j; x++) { if (HIGH[x]>max) max=HIGH[x]; if (LOW[x]<min) min= LOW[x]; } rsv=(CLOSE[j]-min)/(max-min) rssv[j]=rsv print "max::" max print "min::" min highMax(HIGH[j], 9); lowMin(LOW[j], 9); #print rsv ############# FOR the analyze system################# a1=CLOSE[j]; a2=CLOSE[j+10]; b1=OPEN[j]; v1=VOL[j] if ( aver1=aver3 && a1<a2 && b1>a1 && v1<vol34) { # print "present:" CLOSE[j]; # print "DATE-------------------------->>" DATE[j] present=CLOSE[j] c=j+20; # print "<<<<<<--------------->>>>>>" j c # print "Ater :" CLOSE[c]; after=CLOSE[c] increase = (after-present)/present*100; if (increase>0 && j>NR-5 ) {print "You can play with it:" DATE[1] >> "/home/test/stockpool" print "BEST pointer:" DATE[j]>> "/home/test/stockpool" } # print "increase:" increase; if (after>present) { counter++;} total++; } } stock= DATE[1] print "the stock number:"DATE[1] >> "/home/test/report" print "total times:" total >> "/home/test/report"; print "Success counter:" counter >> "/home/test/report"; ; print "Succecess rate is :" counter/total*100 "%" >> "/home/test/report"; }