sfday2las

create table sfday2last as select * from sfday;

typein=22

CREATE TABLE "TEST"."SFDAY2LAST" 
   ( "TDAY" VARCHAR2(10), 
"DAYBOLLWD" NUMBER(7,4), 
"DAYBOLLWDCHG" NUMBER(4,2), 
"DAYPRICEMAX" NUMBER(6,0), 
"DAYPRICEMIN" NUMBER(6,0), 
"OPRICE" NUMBER(6,1), 
"HPRICE" NUMBER(6,1), 
"LPRICE" NUMBER(6,1), 
"CPRICE" NUMBER(6,1), 
"LASTOPRICE" NUMBER(6,1), 
"LASTHPRICE" NUMBER(6,1), 
"LASTLPRICE" NUMBER(6,1), 
"LASTCPRICE" NUMBER(6,1), 
"LASTDAY" VARCHAR2(10)
   )

高开低走:

60%胜率，如果收盘结的话， 但是收益 不算好。 

select oprice,hprice,lprice,cprice,lasthprice,lastcprice,lasthprice-cprice from sfday2last t
where oprice>lasthprice and lprice<lasthprice

select oprice,hprice,lprice,cprice,lasthprice,lastcprice,lasthprice-cprice from sfday2last t
where oprice>lasthprice and lprice<lasthprice

这个胜率更高 12/17， 70％

before:

,Total count:20, -count:7,Total point:285.6,win rate:65%,point avg:14.28,money:85080

去掉时间戳还真不好hai 

,Total count:34, -count:16,Total point:221.2,win rate:53%,point avg:6.506,money:65340

30也不好

,Total count:18, -count:6,Total point:239.8,win rate:67%,point avg:13.322,money:71400

90

,Total count:24, -count:10,Total point:288.8,win rate:58%,point avg:12.033,money:85920

70 (65)

,Total count:21, -count:7,Total point:305.2,win rate:67%,point avg:14.533,money:90930

45

,Total count:19, -count:6,Total point:286.2,win rate:68%,point avg:15.063,money:85290

次之的统计， 只是高开，未超过.

failed buy -->修正买上了, sell failed , 也是一样类似 处理

少了一次： (开始止损增大的话) 8

,Total count:20, -count:6,Total point:303.4,win rate:70%,point avg:15.17,money:90420

0.2

,Total count:21, -count:7,Total point:305.6,win rate:67%,point avg:14.552,money:91050

1小时内的高点 不好

,Total count:21, -count:8,Total point:288.2,win rate:62%,point avg:13.724,money:85830

21不错啊+8

,Total count:22, -count:7,Total point:316.8,win rate:68%,point avg:14.4,money:94380

21+止损4, 不好（胜率倒是很高－赢利大副下降)

,Total count:24, -count:6,Total point:184.6,win rate:75%,point avg:7.692,money:54660

21+6

,Total count:23, -count:7,Total point:324,win rate:70%,point avg:14.087,money:96510

21+7

,Total count:23, -count:7,Total point:327.6,win rate:70%,point avg:14.243,money:97590

多次的问题需要解决：