Sir, Please let me know how to find the candle percentage using its values like Prv.Close, Open, Close, Low & High. I Want to find 1 day stock candle percentage using an excel formula so that I can do it for more than 50 on one go. Thanks In Advance.