Support Board
Date/Time: Wed, 04 Dec 2024 18:58:10 +0000
Post From: ADD NUMBERS BOTTOM DATA
| [2024-11-27 21:22:17] |
| John - SC Support - Posts: 36468 |
|
As noted, when using "FRACTIME()", you need to set the cell Number Format to be "Time". Refer to the following: Spreadsheet Menu: Spreadsheet >> Number Format Sorry, I was doing some testing and did not give you the right formula. Here is what you would need: =GETCORRESPONDINGMATCH($F$3:$F$35, MAX($F$3:$F$35), 0, 0, 1, A$3:A$35, 0) In the above formula it is checking cells from Row 3 to Row 35. You would need to adjust these to test for the time period you are wanting. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |