Support Board
Date/Time: Wed, 03 Sep 2025 09:20:31 +0000
Post From: Spreadsheet system alert study all symbols net p/l not updating as expected
| [2025-07-30 15:08:47] |
| User273277 - Posts: 83 |
|
The key part to fix this was adding an IF(ROW()=3) to my code. For v1 Column I/J values spreadsheets: =IF(ROW()=3,(J10+J103) > 200, 0) For v2 Column I/J values spreadsheets: =IF(ROW()=3, J65 > 200, 0) Otherwise, the spreadsheet alerts on the second row on my sheet, due to v.1 J11 being the cumulative closed p/l line, and v.1 J104 being the all symbols cumulative net p/l, and v.2 J66 being All symbols cumulative net P/L. Date Time Of Last Edit: 2025-07-31 00:24:47
|