StockFetcher Forums · Filter Exchange · XARLOR? Can you do this?<< >>Post Follow-up
karennma
8,057 posts
msg #151554
Ignore karennma
3/29/2020 8:09:52 PM

XARLOR,
Another one of your fabulous filters!
I love this!
Can you add the following at the end, please ... ?
Subtract Lowest 3-month low from Highest 3-month high
AND add column $$ difference
AND add column %% difference
THANKS IN ADVANCE.




apply watchlist(-------)

set{H3H,high 3-month high}
set{H3C,close 3-month high}
set{H3L,low 3-month high}

set{L3H,high 3-month low}
set{L3C,close 3-month low}
set{L3L,low 3-month low}

add column H3H {Highest 3-month high}
add column H3C {Highest 3-month close}
add column H3L {Highest 3-month low}

add column L3H {Lowest 3-month high}
add column L3C {Lowest 3-month close}
add column L3L {Lowest 3-month low}


xarlor
581 posts
msg #151555
Ignore xarlor
3/29/2020 10:31:55 PM

Sure thing. Add some numbers here... a dash of percentages there... a pinch of separators... and WAHLA!

Fetcher[
symlist(SPY)

set{H3H,high 3-month high}
set{H3C,close 3-month high}
set{H3L,low 3-month high}

set{L3H,high 3-month low}
set{L3C,close 3-month low}
set{L3L,low 3-month low}
add column separator
add column H3H {Highest 3-month high}
add column H3C {Highest 3-month close}
add column H3L {Highest 3-month low}
add column separator
add column L3H {Lowest 3-month high}
add column L3C {Lowest 3-month close}
add column L3L {Lowest 3-month low}

set{DollarRange,H3H - L3L}
set{PercentDifference1,DollarRange / H3H}
set{PercentDifference,PercentDifference1 * -100}
add column separator
add column DollarRange {3-month Dollar Range}
add column PercentDifference {3-month Percent Difference}
]



karennma
8,057 posts
msg #151557
Ignore karennma
3/30/2020 9:23:50 AM

FABULOUS!
THANK YOU!


Cheese
1,374 posts
msg #152737
Ignore Cheese
6/23/2020 11:11:34 PM

pop

StockFetcher Forums · Filter Exchange · XARLOR? Can you do this?<< >>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.