Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 08:26:58 +0000
spreadsheet: how to plot only current value
View Count: 2650
| [2015-09-24 16:05:36] |
| jivetrader - Posts: 387 |
|
a formula i wrote tallies a value at every bar, kind of like a trailing stop loss. however, i would like to display it only for the current bar, not for every historical bar. how can i hide it on previous bars (by modifying the formula or some other means) ? thanks in advance.
|
| [2015-09-24 18:20:01] |
| |
|
One way is to update Sierra Chart to the latest prerelease and use this new Study Subgraph Draw Style: Line at Last Bar to Edge.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-09-24 20:17:15] |
| Sawtooth - Posts: 3993 |
|
To do it with a spreadsheet formula, try this: =IF(ROW()=3,YourConditions,0) |
| [2015-09-25 01:32:43] |
| jivetrader - Posts: 387 |
|
tom, this is the kind of solution i was looking for, however the formula relies on previous values in the column being present (starting from row 4), and your formula won't process rows other than row 3. so i guess i will have to 1. use a helper column or 2. try to hide them instead, using SC solution above. thanks
|
| [2015-09-25 03:24:00] |
| Sawtooth - Posts: 3993 |
|
Yes, in that case you'd need to use another 'helper' Formula Column.
|
To post a message in this thread, you need to log in with your Sierra Chart account: