Dear Mahernosh
Pls COPY Columns B(LTP),D(High),E(Low) to Columns P(Close),Q(High),R(Low) in CALLS SHEET after Market Close for next day Trade.
I hereby attaching Modified Excel sheet incorporating Buy above & Sell below Columns (Columns S,T,U,V) to get Buy above & Sell Below levels for net trade Trade.
You can place Pre Market Buy above & Sell below orders (Before Market Open) or Between 9.15 to 9.30 based on Buy above & sell below columns next day as you wish.
Modified
Pls note that i Deleted my earlier attachment & inserted New Excel sheet because there is 100 KB attachment restriction from the Site Owner.
Regards
Pls COPY Columns B(LTP),D(High),E(Low) to Columns P(Close),Q(High),R(Low) in CALLS SHEET after Market Close for next day Trade.
I hereby attaching Modified Excel sheet incorporating Buy above & Sell below Columns (Columns S,T,U,V) to get Buy above & Sell Below levels for net trade Trade.
You can place Pre Market Buy above & Sell below orders (Before Market Open) or Between 9.15 to 9.30 based on Buy above & sell below columns next day as you wish.
Modified
Pls note that i Deleted my earlier attachment & inserted New Excel sheet because there is 100 KB attachment restriction from the Site Owner.
Regards
As per my understanding,
Column 'B' of call sheet is the 'LTP', typically, the trades price at 15:29:59 &
Column 'P' of Call sheet is the 'close' price, which is arrived at calculating the weighed average of traded prices in the last 30 mins of trading
are different.
'Close' may have to be obtained from Bhav copy.
If my understanding is NOT correct, you may automate the copying process with the help vb code and a 'COPY' button which will copy if pressed between say, 15:31 & 23:59 of the trading day.
Yourself / Veluri may please clarify whether price at 15:29:59 is to be used or the previous close, as the difference is quite a lot and may bring unexpected results.
Thanks in advance.
murthymsr
Last edited: