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
|