Excel sheet trading

Hi

I am creating a excel sheet for trading (intraday and max 4 days holding), I will share the file once it's created!

I want the formula for identifying bullish stocks and bearish stocks in realtime as i have only 4 values. open, high, low, and LTP.

if anyone have inputs , please share here. I will help to share to all the members here!

thanks
Have a nice day!

Excel sheet trading