Prescott AZ USA
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 216
Thanks Received: 603
|
You can do it with the Spreadsheet Study study.
Put this in K3:
=MATCH(A3-30/1440,A3:A1002,-1)
This works for any bar type whose duration is <=30 minutes, and it includes the current bar.
To exclude the current bar, use this:
=MATCH(A3-30/1440,A3:A1002,-1)-1
|