Login Page - Create Account

Support Board


Date/Time: Wed, 12 Aug 2020 15:05:07 +0000



[User Discussion] - Next bar rage on Flex renko

[2015-07-16 15:55:59]
Locomotora - Posts: 14 | Ending Date: 2015-07-10 [Expired]
I am trying to draw the open and close line for a "future" flex renko bar, (possible bullish and possible bearish) and i am using spreadsheet for this. Is there a way to limit the calculation ONLY to the last bar? I don't need to see this information for previous bars. I have tries to change the spreadsheet settings but it only allows 10 rows minimum. Any help??
[2015-07-16 16:25:15]
tomgilb - Posts: 2636 | Ending Date: 2020-12-03
Use a formula like this:

=IF(ROW()=3,yourconditions,0)
[2015-07-16 17:16:48]
Locomotora - Posts: 14 | Ending Date: 2015-07-10 [Expired]
Thanks for your help. I almost get it done but the chart got all messed up.

=IF(ROW()=3,B4<E4,C4+5)

condition in this case is if open < close, draw a dash at C (high + 5 ticks.


my chart looks a mess.
[2015-07-16 17:23:20]
Locomotora - Posts: 14 | Ending Date: 2015-07-10 [Expired]
sorry, i just read the Format: IF(Condition, TrueValue, FalseValue)
[2015-07-16 19:27:11]
tomgilb - Posts: 2636 | Ending Date: 2020-12-03
Try this:
=IF(ROW()=3,IF(B4<E4,C4+5*$J$21,0),0)

This would also work:
=IF(AND(ROW()=3,B4<E4),C4+5*$J$21,0)

To post a message in this thread, you need to login with your Sierra Chart account:

Login

Login Page - Create Account