StockFetcher Forums · Filter Exchange · low for past two months and date<< >>Post Follow-up
5 posts
msg #56663
Ignore prokewl
11/11/2007 10:07:16 AM


I'm trying to write a filter and want the following five variables to be set, but am unsure how to go about it:

lowestClosePastTwoMonths - the lowest of the closing price during the last two months

lowestClosePastTwoMonthsDate - the date of when lowestClosePastTwoMonths occured

currentClose - this one I can figure out which is just "close"

currentCloseDate - today's date -- couldn't find a function and am unsure if there is one?

timeBetweenCloseDates = can I just subtract currentCloseDate from lowestClosePastTwoMonthsDate to get the number in days?

Thanks for any help!

6,358 posts
msg #56664
Ignore TheRumpledOne
11/11/2007 10:22:01 AM

set{low2m, close 2 month low}

add column low2m

draw low2m

market is nasdaq 100

low2m is the lowest close for the past 2 months.

DAYS doesn't work to tell you how many days since the 2 month low occurred because you don't know at the time it is the 2 month low.

If you look at the chart for FLEX, you'll see at the time the present 2 month low occurred it wasn't the current 2 month low.

Perhaps there's a SF trick I need to learn... THINKING CAPS ON!


StockFetcher Forums · Filter Exchange · low for past two months and date<< >>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 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