StockFetcher Forums · General Discussion · Minimum Low of 0<< >>Post Follow-up
jjmcguire
14 posts
msg #158299
Ignore jjmcguire
12/31/2021 5:58:17 PM

Hello, for stocks that IPO'd within 1 yr, does anyone know how to make the minimum low calculation evaluate only on the trading days and exclude the days prior to the stock trading?

The code below gives me a min low of 0 when I want it to be a non-zero number calculated over the valid trading days:

Fetcher[
apply to symlist(AMPL)
set{min253, Low 253 Day Low}
add column min253
]



adding "above 0" doesn't work either:

Fetcher[
apply to symlist(AMPL)
set{min253, Low 253 Day Low above 0}
add column min253
]



Thanks!
Jason

jjmcguire
14 posts
msg #158300
Ignore jjmcguire
12/31/2021 6:10:40 PM

I forgot I had posted this before at https://www.stockfetcher.com/forums/General-Discussion/Non-Zero-Minimum-Low/158063.

Xarlor did respond with a solution, although I'm surprised there isn't a simpler solution that works in all cases.

Thanks,
Jason




StockFetcher Forums · General Discussion · Minimum Low of 0<< >>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 2021 - 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.