Support Board
Date/Time: Thu, 21 Nov 2024 16:13:29 +0000
Spreadsheet Study Column J - Day Max
View Count: 90
| [2024-11-05 15:05:35] |
| User133996 - Posts: 4 |
|
Good morning, the simple things always seem to be the most difficult. In the Spreadsheet study, I have a calculation in column K that works great. I would like to use J to just take max of this column for the day. My chart setting time is 18:00 to 16:59:59. Is this possible. I can't use Daily OHLC from study as it will just how open and not high. Thanks
|
| [2024-11-05 21:33:44] |
| John - SC Support - Posts: 36186 |
|
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 |
| [2024-11-05 22:39:41] |
| Sawtooth - Posts: 4118 |
|
I would like to use J to just take max of this column for the day. My chart setting time is 18:00 to 16:59:59. Is this possible.
Do you want the max in column K from 18:00 to 16:59:59, or some other time frame?
|
| [2024-11-06 02:31:53] |
| User133996 - Posts: 4 |
|
Thanks for reply John and Sawtooth, correct about column L3. =MAX(K$3:K$2000) is close, I just need to change 2000 so instead it starts at 1800 and finishes at 16:59:59 daily. These are the times set in my Intraday Chart Session Times. |
| [2024-11-06 04:20:06] |
| Sawtooth - Posts: 4118 |
|
I just need to change 2000 so instead it starts at 1800 and finishes at 16:59:59 daily.
Use a formula like this in row 3 of a spare Formula Column, e.g. column L:=IF(FRACTIME(A3)=TIME(18,0,0),ROW(),L4) this will return the row # of the 18:00:00 bar. Then use a formula like this in any spare cell, e.g. J1, or any cell in row 1, or any cell in column H: =MAX(K3:OFFSET(K3,L3-3,0)) this will find the max value from the current bar to the 18:00:00 bar. this will be accurate until the next 18:00:00 bar. Date Time Of Last Edit: 2024-11-06 13:59:02
|
| [2024-11-06 05:22:51] |
| User133996 - Posts: 4 |
|
Sawtooth, thankyou, thankyou. Really appreciate, this works perfectly.
|
To post a message in this thread, you need to log in with your Sierra Chart account: