StockFetcher Forums · Filter Exchange · /* five year range min/max filter */<< >>Post Follow-up
TheRumpledOne
6,362 posts
msg #56551
Ignore TheRumpledOne
modified
11/8/2007 1:54:29 PM

Fetcher[
/* five year daily range min/max filter */

apply to symlist(qqqq,goog,aapl,rimm)

set{xRange, high - low}

set{UpperLim, xRange 1 year High}
set{LowerLim, xRange 1 year Low}

set{UpperLim1, UpperLim 1 year ago}
set{LowerLim1, LowerLim 1 year ago}

set{UpperLim2, UpperLim 2 years ago}
set{LowerLim2, LowerLim 2 years ago}

set{UpperLim3, UpperLim 3 years ago}
set{LowerLim3, LowerLim 3 years ago}

set{UpperLim4, UpperLim 4 years ago}
set{LowerLim4, LowerLim 4 years ago}


add column UpperLim
add column LowerLim
add column UpperLim1
add column LowerLim1
add column UpperLim2
add column LowerLim2
add column UpperLim3
add column LowerLim3
add column UpperLim4
add column LowerLim4

add column industry

sort column 5 descending
]



This can be adapted to just about anything you want to know the min/max of for the last 5 years.



TheRumpledOne
6,362 posts
msg #56552
Ignore TheRumpledOne
modified
11/8/2007 1:59:11 PM

Fetcher[
/* five year daily volume min/max filter */

market is nasdaq 100

set{xRange, volume / 1000000}

set{UpperVol, xRange 1 year High}
set{LowerVol, xRange 1 year Low}

set{UpperVol1, UpperVol 1 year ago}
set{LowerVol1, LowerVol 1 year ago}

set{UpperVol2, UpperVol 2 years ago}
set{LowerVol2, LowerVol 2 years ago}

set{UpperVol3, UpperVol 3 years ago}
set{LowerVol3, LowerVol 3 years ago}

set{UpperVol4, UpperVol 4 years ago}
set{LowerVol4, LowerVol 4 years ago}


add column UpperVol
add column LowerVol
add column UpperVol1
add column LowerVol1
add column UpperVol2
add column LowerVol2
add column UpperVol3
add column LowerVol3
add column UpperVol4
add column LowerVol4

add column industry

sort column 5 descending
]



SAFeTRADE
413 posts
msg #56553
Ignore SAFeTRADE
11/8/2007 2:20:30 PM

TRO some of these numbers don't look right. If the range max is "price", SIRI was never at over $500 a share.

TheRumpledOne
6,362 posts
msg #56555
Ignore TheRumpledOne
modified
11/8/2007 2:34:44 PM

Are you looking at the RANGE filter or the VOLUME FILTER??

LOL!!!


P.S. I renamed the columns UpperVol and LowerVol so you shouldn't get confused.


SAFeTRADE
413 posts
msg #56557
Ignore SAFeTRADE
11/8/2007 3:47:27 PM

Never to be heard from again....

TheRumpledOne
6,362 posts
msg #56566
Ignore TheRumpledOne
11/8/2007 5:48:41 PM

Don't leave us!

StockFetcher Forums · Filter Exchange · /* five year range min/max filter */<< >>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