Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 26 Apr 2024 07:48:05 +0000
[Programming Help] - Spreadsheet Help__How do I limit subgraph to current bar?
View Count: 591
| [2019-10-19 16:11:52] |
| Atlatyl - Posts: 19 |
|
I'm after the image on the right, and can't seem to think through the formula that doesn't leave a trail of past instances. Here I've taken the range bar size from $J$39, and applied it to the current Hi/Lo, and split the difference, as the center is what I'm really after. Thanks in advance :-) |
SC.jpg| [2019-10-19 16:43:07] |
| Sawtooth - Posts: 3976 |
|
Try this: =IF(ROW()=3,(C3+D3)/2,0) Date Time Of Last Edit: 2019-10-19 17:59:46
|
| [2019-10-19 17:19:18] |
| Atlatyl - Posts: 19 |
|
Perfect Tom, Thanks! :-) Can I trouble you to tell me in english what * Row()=3 * says/means? |
| [2019-10-19 17:34:43] |
| Sawtooth - Posts: 3976 |
|
Can I trouble you to tell me in english what * Row()=3 * says/means?
Each spreadsheet row is a chart bar. The current bar is in row 3 and earlier bars are in rows below.If you don't give the ROW function a cell reference between the parentheses, it returns its own row number. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ROW_Function |
| [2019-10-19 17:51:57] |
| Atlatyl - Posts: 19 |
|
Great, thank you..old dog learned new trick today ;-)
|
To post a message in this thread, you need to log in with your Sierra Chart account: