Average formula for the day

#1
Hi,

Request your help for this below formula.

I have Date, time, O,H,L, C , volume data. I am seeking an explorer something like this.

CLOSE - PREV_CLOSE in a column
SUM_COLUMN_H - sum of above column
AVERAGE_CLOSE - average close price since the first bar, say 9:15 to 3:30 for a fifteen minute chart.

Attached screen print of excel formula.

The challenging here is, i need a day wise report of above values. The CLOSE - PREV_CLOSE should start only when the day starts, i.e. 9:15 and should end at 3:30 with 15 minutes interval as example. Its same for other two columns.

Request you to help me with formula, pls let me know if you have any query on my problem


thanks
ML
 

Attachments

Last edited:

Similar threads