StockFetcher Forums · General Discussion · Using a specific date for a scan (an alternative to days offset)?<< >>Post Follow-up
Norm.Sash
26 posts
msg #98400
Ignore Norm.Sash
1/4/2011 3:49:11 PM

Is there a way to specify a specific date for a scan? For example, I could have the filter:

Show stocks where close is above 5
and day offset is 42

... which would find anything meeting the criteria as of 42 days ago.

But what if I have a specific date in mind (e.g. Nov 20, 2010) and always want to run against that date for comparison. If I used the "day offset is 42" in a scan today, then if I run that scan two days from now it will compare agains 42 days ago, and not the specific date of "Nov 20, 2010".

This would also be useful in backtesting when the literal run of a backtest might be done over several days so that the "days offset" doesn't always have to change.

Is there anyway to do something like "Date offset(Nov 20, 2010)" and have StockFetcher calculate the number of offset days requires so that the filter will always go back to "Nov 20, 2010" as the date?

dangreene
229 posts
msg #98404
Ignore dangreene
1/4/2011 5:53:13 PM

You almost had it !

Just say,

OFFSET 11/20/2010

Norm.Sash
26 posts
msg #98418
Ignore Norm.Sash
1/5/2011 10:03:45 AM

Awesome! Thanks, I'll give that a try. I couldn't find the "Offset" statement and date parameter in either the user guide or in the online help. Where did you find it?

Rick67
64 posts
msg #98428
Ignore Rick67
modified
1/5/2011 1:11:29 PM

As of 10/5/11, it appears that if I use OFFSET 10/04/2010 (3 months back) or earlier, no stocks will be returned. This seems to correspond to the default 3 month period that my charts are set to.

Do I need to set my default chart period to a longer time frame to go back further? Or can I insert a line of code that will do this for me?

Show stocks where the close reached a new 52 week high
and WMA(40) is greater than the WMA(80)
and stock is optionable
and close is greater than 70.00
and stocks in top industries(25,yearly)
and add column industry
OFFSET 06/20/2010

This is my second day on Stockfetcher...

Thanks,
Rick

four
5,087 posts
msg #98429
Ignore four
1/5/2011 1:33:42 PM

post your filter and we/I can see about duplicating your results

dangreene
229 posts
msg #98434
Ignore dangreene
modified
1/5/2011 2:27:40 PM

My mistake




StockFetcher Forums · General Discussion · Using a specific date for a scan (an alternative to days offset)?<< >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.