StockFetcher Forums · Filter Exchange · Help with coding up a 'local minimum' of a value in SF<< >>Post Follow-up
88 posts
msg #91137
Ignore sbuck143
4/13/2010 1:41:02 PM

I am trying to code up a filter in SF that will produce a buy signal when a stocks ADX value is up 20% off of the lowest ADX value within the last 30 days. There are other components too like making sure ADX is not above a certain value, etc, but I've got no problems with that part of the code.

This involves calculating the minimum value of the ADX over the last 30 days. Is there a filter phrase / indicator measure I am missing here, or is this even possible?

I can longhand algorithm it but will need to cut the number of days compared down significantly. Seems like there should be a quicker way to do this with something that says (in stockfetcher-ese)

lowest value of ADX(14) within last 30 days

Thanks for your help guys...


EDIT: Okay brain kicked in and realized the "Reached a new" phrase solves half of this problem. Now I need a way to quantify what that value is.

show stocks where

and price is above 10

and ADX(14) reached a new 30 day low within the last 10 days

/* add missing line here to look for 20% increase off of 30 day low*/

add col ADX(30)

88 posts
msg #91139
Ignore sbuck143
4/13/2010 2:13:05 PM

FYI i tried setting 30 day low of ADX(14) as a variable but it didn't take.

set{minADX, 30 day low of ADX(14)} didn't seem to affect anything. Adding it as a column to the filter it shows to be whatever ADX is, and not its 30 day min.

88 posts
msg #91141
Ignore sbuck143
4/13/2010 2:25:36 PM

well this was a fun conversation with myself :)

Figured it out.....the magic phrase is thus:

"and ADX(14) is more than 25 percent above the 30 day low"

and while you can draw the 30 day low on the graph, it appears to be impossible to extract that actual number. Unless a kind chetron, TRO, or four would shed some light?

88 posts
msg #91144
Ignore sbuck143
4/13/2010 4:58:05 PM


the proper verbage for the set variable is as follows:

set{minadx, ADX(14) 30 day low}

setting as

set{minadx, 30 day low of ADX(14)} was NOT acceptable to stockfetcher.

2,817 posts
msg #91146
Ignore chetron
4/13/2010 5:52:04 PM


StockFetcher Forums · Filter Exchange · Help with coding up a 'local minimum' of a value in SF<< >>Post Follow-up

*** Disclaimer *** 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. does not recommend particular securities., 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 2018 - 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