robinrobinthomas

Shoonya 5min Extracted Column Data
Header J1: Price_Range_D1_D2_%
Formula J2: =IFERROR(ROUND((MAX(D2:D76)-MIN(E2:E76))/(MAX(D77:D151)-MIN(E77:E151))*100-100,2),0)
--------------------------------------------------
Header K1: Price_Range_D1_D3_%
Formula K2: =IFERROR(ROUND((MAX(D2:D76)-MIN(E2:E76))/(MAX(D152:D226)-MIN(E152:E226))*100-100,2),0)
--------------------------------------------------
Header L1: Price_Range_D1_D4_%
Formula L2: =IFERROR(ROUND((MAX(D2:D76)-MIN(E2:E76))/(MAX(D227:D301)-MIN(E227:E301))*100-100,2),0)
--------------------------------------------------