StockFetcher Forums · Filter Exchange · Inside Month<< >>Post Follow-up
drawerguy
14 posts
msg #112221
Ignore drawerguy
modified
3/13/2013 8:51:45 PM

I've been trying to write a scan for " inside months", but not having much luck and I've run out of ideas. Does anyone know if it's even possible on SF? I was able to write one to find inside weeks but finding trying to write one for a month isn't working out that well

mahkoh
891 posts
msg #112240
Ignore mahkoh
modified
3/14/2013 2:32:34 PM

It requires some work as SF does not have monthly data
First determine how many trading days there were in the previous month. For February there were 19.

Today (Mar 14) we are at the 10th trading day of March. To calculate February's monthly high and low

set{prevmhigh,high 19 day high 10 days ago}
set{prevmlow, low 19 day low 10 days ago}

to check which stocks in the S&P500 so far have an inside month:

Fetcher[
S&P500
set{prevmhigh,high 19 day high 10 days ago}
set{prevmlow, low 19 day low 10 days ago}
high 10 day high below prevmhigh
low 10 day low above prevmlow
draw price line at prevmlow
draw price line at prevmhigh
]




You do need to adjust these numbers daily
For tomorrow:
Fetcher[
S&P500
set{prevmhigh,high 19 day high 11 days ago}
set{prevmlow, low 19 day low 11 days ago}
high 11 day high below prevmhigh
low 11 day low above prevmlow
draw price line at prevmlow
draw price line at prevmhigh
]



It really is a pity this doesn't work

Fetcher[
S&P500
set{x,10}
set{prevmhigh,high 19 day high x days ago}
set{prevmlow, low 19 day low x days ago}
high x day high below prevmhigh
low x day low above prevmlow
draw price line at prevmlow
draw price line at prevmhigh
]





drawerguy
14 posts
msg #112246
Ignore drawerguy
3/14/2013 4:53:17 PM

Hey mahkoh - you are awesome, it's EXACTLY what I needed !! And by analyzing the syntax that you wrote, I just learned a whole hell of a lot. Thanks so very much !!

drawerguy
14 posts
msg #112247
Ignore drawerguy
3/14/2013 5:00:42 PM

And I especially like the high and low lines for the previous month. Makes the chart look so very clear for what I'm looking for.
Thanks again mahkoh

StockFetcher Forums · Filter Exchange · Inside Month<< >>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