Support Board
Date/Time: Mon, 20 Jan 2025 11:24:27 +0000
Post From: Spreadsheets and study/price overlay
[2018-06-05 23:58:33] |
TechTrader - Posts: 116 |
You could use a CHANGE in the 5m OPEN price to determine the start of the 5m overlayed bar. If overlayed 5m bar OPEN is in Column AA of the spreadsheet this formula in Column K would count each 1 min bar 1-5. Hide the Overlay study so the overlayed values are not visible. =IF(AND(AA3<>AA4),1,IF(AND(AA3=AA4),1+K4,0)) An additional formula is required if there are two consecutive 5m OPENS at the same price. This example uses column L. =IF(AND(K3>=1,K3<=5),K3,IF(AND(K3>5),-5+K3,0)) You can then process each individual 1m bar in the spreadsheet within the 5m overlayed bar. ie IF(L3=1 then ???) through to IF(L3=5 then ???) This post has been edited Date Time Of Last Edit: 2018-06-06 00:01:00
|