Login Page - Create Account

Support Board


Date/Time: Mon, 23 Dec 2024 08:16:42 +0000



spreadsheet: how to plot only current value

View Count: 2699

[2015-09-24 16:05:36]
jivetrader - Posts: 410
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]
Sierra Chart Engineering - Posts: 104368
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: 4141
To do it with a spreadsheet formula, try this:

=IF(ROW()=3,YourConditions,0)
[2015-09-25 01:32:43]
jivetrader - Posts: 410
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: 4141
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:

Login

Login Page - Create Account