mahkoh
1,065 posts
msg #122261
- Ignore mahkoh
modified |
12/16/2014 6:15:01 AM
Use the count function:
set{jan,Date(20140131,close) - Date(20140101,close)}
set{jan1,count(jan above 0,1)}
set{feb,Date(20140228,close) - Date(20140201,close)}
set{feb1,count(feb above 0,1)}
set{mar,Date(20140331,close) - Date(20140301,close)}
set{mar1,count(mar above 0,1)}
set{up1,jan1 + feb1}
set{monthsup, mar1 + up1}
add column monthsup
|
15minoffame
131 posts
msg #122282
- Ignore 15minoffame |
12/17/2014 12:45:55 AM
Mahkoh,
Would you know why this didn't work? Appreciate your help!
optionable
close above 1
average volume(63) above 1000000
set{jan,Date(20140131,close) - Date(20131231,close)}
set{jan1,count(jan above 0,1)}
set{feb,Date(20140228,close) - Date(20140131,close)}
set{feb1,count(feb above 0,1)}
set{mar,Date(20140331,close) - Date(20140228,close)}
set{mar1,count(mar above 0,1)}
set{up1,jan1 + feb1}
set{monthsup, mar1 + up1}
set{a1, DATE(20140131,close)-DATE(20131231,close)}
set{n1, a1/DATE(20131231,close)}
set{jan, n1*100}
set{b1, DATE(20140228,close)-DATE(20140131,close)}
set{o1, b1/DATE(20140131,close)}
set{feb, o1*100}
set{c1, DATE(20140331,close)-DATE(20140228,close)}
set{p1, c1/DATE(20140228,close)}
set{mar, p1*100}
set{d1, DATE(20140430,close)-DATE(20140331,close)}
set{q1, d1/DATE(20140331,close)}
set{apr, q1*100}
set{e1, DATE(20140530,close)-DATE(20140430,close)}
set{r1, e1/DATE(20140430,close)}
set{may, r1*100}
set{f1, DATE(20140630,close)-DATE(20140530,close)}
set{s1, f1/DATE(20140530,close)}
set{june, s1*100}
set{g1, DATE(20140731,close)-DATE(20140630,close)}
set{t1, g1/DATE(20140630,close)}
set{july, t1*100}
set{h1, DATE(20140829,close)-DATE(20140731,close)}
set{u1, h1/DATE(20140731,close)}
set{aug, u1*100}
set{i1, DATE(20140930,close)-DATE(20140829,close)}
set{v1, i1/DATE(20140829,close)}
set{sept, v1*100}
set{j1, DATE(20141031,close)-DATE(20140930,close)}
set{w1, j1/DATE(20140930,close)}
set{oct, w1*100}
set{k1, DATE(20141128,close)-DATE(20141031,close)}
set{x1, k1/DATE(20141031,close)}
set{nov, x1*100}
set{l1, close-DATE(20141128,close)}
set{y1, l1/DATE(20141128,close)}
set{dec, y1*100}
set{m1, close-DATE(20131231,close)}
set{z1, m1/DATE(20131231,close)}
set{2014, z1*100}
add column monthsup
add column 2014
add column dec
add column nov
add column oct
add column sept
add column aug
add column july
add column june
add column may
add column apr
add column mar
add column feb
add column jan
sort column 5 descending
|