Login Page - Create Account

Support Board


Date/Time: Wed, 01 Jan 2025 11:58:13 +0000



Post From: Current Price Line

[2016-05-17 04:33:45]
Sawtooth - Posts: 4144
The spreadsheet will not update on every uptick/downtick beyond 10 rows. This is done for performance reasons.

10 is the minimum Number of Rows setting, however, you can use these formulas to limit it to 5 rows:
Cell K3:
=IF(AND(ROW()<8,ID9.SG1@$3>E$4),ID9.SG1@$3,0)
Cell L3:
=IF(AND(ROW()<8,ID9.SG1@$3<E$4),ID9.SG1@$3,0)
Cell M3:
=IF(AND(ROW()<8,ID9.SG1@$3=E$4),ID9.SG1@$3,0)