Support Board
Date/Time: Wed, 12 Mar 2025 16:33:57 +0000
Post From: SPREADSHEET TRADING
| [2022-05-08 02:18:23] |
| Sawtooth - Posts: 4182 |
|
i'm trying to extract the RTH Open value out of a 1m chart
In a Formula Column, use the FRACTIME function to return only the Time of Day from the Serial DateTime of column A, e.g. cell O3:=FRACTIME(A3) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FRACTIME_Function Then use the GETCORRESPONDINGMATCH function to return the Open price in column B at 08:30 in column O: =GETCORRESPONDINGMATCH(O3:O600,TIMEVALUE("08:30:00"),1,0,0,B3:B600,0) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#GetCorrespondingMatch_Function |