Support Board
Date/Time: Thu, 06 Feb 2025 03:02:30 +0000
[Programming Help] - Spreadsheet question
View Count: 590
| [2020-04-12 21:21:22] |
| User183724 - Posts: 191 |
|
If the time an event occurred is known, is it possible to read the information from bars row? i'd like to be able to use INDEX (MATCH) or OFFSET or similar function to get the OPEN, LAST, etc. values that happened at given time value. thx tim
|
| [2020-04-12 22:46:35] |
| Sawtooth - Posts: 4169 |
|
Try this in P3: =IF(AND($P$1>=FRACTIME(A3),$P$1<FRACTIME(A2)),B3,P4) This will return the persistent Open price of the bar wherein the time in P1 occurred. Date Time Of Last Edit: 2020-04-12 23:29:46
|
| [2020-04-13 00:45:33] |
| User183724 - Posts: 191 |
|
sorry... can't get that one to work... tried changing the variables... noticed A2 in the last FRACTIME value. thx tim
|
| [2020-04-13 03:19:17] |
| Sawtooth - Posts: 4169 |
|
P1 is a time value, like this: 14:15:00 If P1 is a DateTime value, use this formula: =IF(AND($P$1>=A3,$P$1<A2),B3,P4) but this will only return one value because P1 is only one day, and only if that day is within the range of the spreadsheet sheet. The formula uses A3 and A2 so that the returned value is in the correct row. |
| [2020-04-13 03:22:43] |
| User183724 - Posts: 191 |
|
thank you
|
To post a message in this thread, you need to log in with your Sierra Chart account: