Support Board
Date/Time: Wed, 04 Dec 2024 18:50:20 +0000
Post From: ADD NUMBERS BOTTOM DATA
| [2024-11-27 18:46:52] |
| John - SC Support - Posts: 36466 |
|
To get just the Time portion of an item with date and time, use the FRACTIME() function. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FRACTIME_Function To display a cell in a Sierra Chart spreadsheet as a Time, you need to change the cell formatting. Refer to the following: Spreadsheet Menu: Spreadsheet >> Number Format There is not a way to sort data in the Sierra Chart spreadsheet studies, as the rows are all relative to the bars in the chart. But if you want to get the time of the highest volume for the day and have that displayed in row 3, then you would enter a formula like the following in an open column: =GETCORRESPONDINGMATCH($F$3:$F$35, 10369, 0, 0, 1, A$3:A$35, 0) Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#GetCorrespondingMatch_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |