Support Board
Date/Time: Sat, 28 Dec 2024 09:32:41 +0000
GetCorrespondingMatch for dates
View Count: 823
| [2016-02-12 04:29:46] |
| rhovega - Posts: 279 |
|
Hi SC, In Trading Spreadsheet Study I would like to reference the high/low of the trade entry bar for stops placement. Having gone through this http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html I believe the only function capable of that sort of search is the GETCORRESPONDINGMATCH function. Yet it only works with numbers, not with text nor dates/time. Would you know of an alternative way to reference the high/low of the trade entry bar? If not, would you consider modifying the GETCORRESPONDINGMATCH function for it to accept dates/time as input? Many thanks |
| [2016-02-12 11:48:24] |
| |
|
A Date-Time is a number: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html#SerialDateTimeValues There are various functions to create the number. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-02-14 00:20:18] |
| rhovega - Posts: 279 |
|
For reference of anyone else looking into this, GETCORRESPONDINGMATCH combined with value(cell#) as input worked.
|
To post a message in this thread, you need to log in with your Sierra Chart account: