Login Page - Create Account

Support Board


Date/Time: Thu, 18 Oct 2018 10:44:19 +0000



Post From: Cell Reference

[2018-01-03 06:03:29]
tomgilb - Posts: 1970
Yes, this is possible with a spreadsheet study. You must use a Formula Column to create a persistent variable where it is brought to row 3 where you can reference it. You must use an event that can be identified with a formula, like this in P3:
=IF(AND(FRACTIME(A3)>TIMEVALUE("08:00:00"),FRACTIME(A3)<TIMEVALUE("08:01:00")),ID0.SG1@3,P4)

There are many variations to this concept. You can use a second IF statement to set it to 0. You can count bars since an event.

You could also use the NMATCH function to find an event, then return a value with the INDEX function,
using a INDEX(...NMATCH(... combination:
=INDEX(B3:B1002,NMATCH(1,93,G3:G1002,0),1)
This finds the most recent occurrence of the bar with 93 trades, and returns the Open price of that bar.
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#NMATCH_Function
You might not need a Formula Column for this, depending on what you're doing.