Excel sheet trading

[ashokram1]

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!

 

[ashokram1]

Hi here is the update

buy = low +((high-low)*0.236)

sell = high -((high-low)*0.236)

I used the OHLC values only. NExt is to find the trend using the same OHLC

 

[ashokram1]

update 1:

when the first 30 mins candle is green, you can buy above the buy levels and when it's negative,then red.

 

[sparun]

update 1:

when the first 30 mins candle is green, you can buy above the buy levels and when it's negative,then red.

for this we have to take the first 30min candle o,h,l,c values for intraday am i right or someother value