StockFetcher Forums · General Discussion · Work around for monthly statistics<< >>Post Follow-up
15minoffame
118 posts
msg #122240
Ignore 15minoffame
12/14/2014 9:55:04 PM

Hi,
I'm looking for a filter that can tell me how many up vs down months for the year. I know SF doesn't offer monthly filtering abilities, but would anyone know if there's a way to do a work around?

Thanks!

mahkoh
892 posts
msg #122242
Ignore mahkoh
12/15/2014 2:53:42 AM

I would look at time based reference syntaxes
http://www.stockfetcher.com/forums/Announcements/Date-Based-References/112556

15minoffame
118 posts
msg #122256
Ignore 15minoffame
12/15/2014 3:35:50 PM

I did, but it doesn't give you a count of up vs down months. I need this ability to sort it. I had to download it to Excel and do it that way.

mahkoh
892 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
118 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


StockFetcher Forums · General Discussion · Work around for monthly statistics<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus