Login Page - Create Account

Support Board


Date/Time: Fri, 22 Nov 2024 06:24:09 +0000



Post From: Spreadsheet Study Column J - Day Max

[2024-11-05 21:33:44]
John - SC Support - Posts: 36203
The Spreadsheets have a MAX() function. So if you want to find the Maximum value in Column K, you would enter a formula like the following in cell L3 (You can not use the J column, as that is for special items that are displayed in that column):
=MAX(K$3:K$2000)

where the 2000 would be whatever the maximum number of rows you are using in the spreadsheet.

refer to the following:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MAX_Function
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing