Support Board
Date/Time: Sat, 21 Dec 2024 18:38:29 +0000
[User Discussion] - Next bar rage on Flex renko
View Count: 920
| [2015-07-16 15:55:59] |
| Locomotora - Posts: 14 |
|
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] |
| Sawtooth - Posts: 4141 |
|
Use a formula like this: =IF(ROW()=3,yourconditions,0) |
| [2015-07-16 17:16:48] |
| Locomotora - Posts: 14 |
|
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 |
|
sorry, i just read the Format: IF(Condition, TrueValue, FalseValue)
|
| [2015-07-16 19:27:11] |
| Sawtooth - Posts: 4141 |
|
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 log in with your Sierra Chart account: