StockFetcher Forums · General Discussion · percent change between lowest low an highest high within 40 days<< >>Post Follow-up
antares66
4 posts
msg #127730
Ignore antares66
3/28/2016 5:29:23 PM

Hello, i tried to build a filter to see which stocks changed most (%) within 40 days.

set{ll,low 40 days low}
set{hh,high 40 days high}
set{pc,hh*100/ll-100}
pc>10

But i get the message pc is undefined. I dont know why.
Can you help me?



four
3,949 posts
msg #127732
Ignore four
modified
3/28/2016 6:40:40 PM

Note: only one operation can occur inside { }
You have to break-up set{pc,hh*100/ll-100}

Fetcher[
set{ll,low 40 days low}
set{hh,high 40 days high}
set{pc, hh * 100}
set{pcc, ll - 100}
set{pccc, pc / pcc}
pccc > 10
add column pccc
]



antares66
4 posts
msg #127738
Ignore antares66
3/29/2016 9:02:18 AM

Thank you for your quick help.
I didn`t know that.

four
3,949 posts
msg #127755
Ignore four
3/29/2016 4:12:55 PM

Welcome

Check out the guide:
http://www3.stockfetcher.com/download/sfuserguide2_0.pdf

antares66
4 posts
msg #127811
Ignore antares66
4/3/2016 12:50:25 PM

set{ll,low 40 days low}
set{hh,high 40 days high}
set{pc,hh*100}
set{pc1,pc/ll]
set{pc2,pc1-100]
pc2>10

The changes didn`t work. I get failure messages for the first zwo settings.
Dont know why.

four
3,949 posts
msg #127813
Ignore four
modified
4/3/2016 2:02:14 PM

set{ll,low 40 days low}
set{hh,high 40 days high}
set{pc,hh*100}
set{pc1,pc/ll ]
set{pc2,pc1-100]


-- see above (bold) your brackets (lines 4 and 5) need to be changed -- you missed with the SHIFT key :)

Fetcher[
set{aa, low 40 day low}

set{ab, high 40 day high}

set{ac, 100 * ab}

set{ad, ac / aa}

set{ae, ad - 100}

ae > 10
]



dashover
165 posts
msg #127814
Ignore dashover
4/3/2016 2:22:44 PM


set{ll,low 40 days low}
set{hh,high 40 days high}

add column ll
add column hh
set{gg,hh-ll}

add column gg
set{ii,gg-ll}
add column ii

set{k,gg/ll}


set{%40day,k*100}

add column %40day

price > 1

Average Volume(30) > 300000

antares66
4 posts
msg #127830
Ignore antares66
4/4/2016 8:22:19 AM

thank you. I need new glasses ;-)

StockFetcher Forums · General Discussion · percent change between lowest low an highest high within 40 days<< >>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