Support Board
Date/Time: Sun, 31 Aug 2025 16:17:54 +0000
Spreadsheet system alert study all symbols net p/l not updating as expected
View Count: 487
| [2025-07-12 06:30:56] |
| User273277 - Posts: 83 |
|
I'm trying to setup spreadsheet alerts based on "all symbols daily net profit/loss", field J65 with v2 J data enabled. I cleared all sim data/trades (trade activity log shows empty). Then I did 1 sim trade on a replay of around 9:35am Friday on a single chart. J65 shows 14. I don't know where the 14 comes from at all. J34 open Profit/Loss shows the correct -66.5. I want to reliably reference 1 field that provides the current open+closed net P/L for all tickers in the current account. (Setting up these alerts would be easier for users if incorporated into the global profit loss management. I just want audio alerts when the open+closed net p/l for all tickers is over, or under, account profit/loss values) |
 sierra-spreadsheet-2025-07-12_02-12.png / V - Attached On 2025-07-12 06:15:53 UTC - Size: 36.77 KB - 47 views sierra-spreadsheet2-2025-07-12_02-14.png / V - Attached On 2025-07-12 06:15:56 UTC - Size: 89.96 KB - 49 views |
| [2025-07-14 14:14:33] |
| John - SC Support - Posts: 41535 |
|
Given how your Trade Activity Log states "Cleared Trade Data", this implies that you cleared the trade data through the option when starting the replay and that you only cleared the data for the symbol MNQU25-CME. This means that you have another symbol somewhere that has fills for it that is contributing to the Net P/L. These would be from before July 12, 2025, since that is the only day that you are displaying in the Trading Activity Log. You need to change the "From Date" to go back far enough to find other orders that would be contributing. Another solution would be to use the "Trade >> Clear Trade Simulation Orders and Data" to completely remove all data associated with simulated trading. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-07-15 08:35:59] |
| User273277 - Posts: 83 |
|
I had cleared all trades using "Trade >> Clear Trade Simulation Orders and Data" before also clearing them on replay using Clear all trade data for symbol and account at replay start. I just tried it again a few times, and similar result. Today I replayed a couple minutes from yesterday, opened a trade and J65 immediately shows 770 (incorrect), and P/L shows 6 (correct). As soon as I closed the trade, J65 updated to the right P/L It looks like the open P/L is being incorrectly calculated? Attached is another test. |
| test1-2025-07-15_04-27.png / V - Attached On 2025-07-15 08:35:21 UTC - Size: 31.77 KB - 37 views test2-2025-07-15_04-29.png / V - Attached On 2025-07-15 08:35:25 UTC - Size: 57.25 KB - 34 views |
| [2025-07-15 16:51:40] |
| User273277 - Posts: 83 |
|
Related, I enabled P/L management, and this just happened in sim, but the logs don't match the p/l at all. It's not even say 10x like mnq/nq are mixed up. I can't see where this is coming from: 2025-07-15 12:42:49.679 | Profit management: Max Profit Reached for Daily Net P/L = 684.00. Trail triggered. Profit Value After Trigger to Flatten Positions is increased to 580.00. | Symbol: (unset) | TradeAccount: Sim1 2025-07-15 12:42:49.679 | Profit management: Daily Net P/L = 0.50. Profit value of 580.00 after initial trigger of 200.00, has been met. Flattening all Positions now. | Symbol: (unset) | TradeAccount: Sim1 2025-07-15 12:42:49.679 | Canceling orders for MNQU25-CME and trade account Sim1 for Flatten Position operation. | Symbol: MNQU25-CME | TradeAccount: Sim1 2025-07-15 12:42:49.679 | Profit/Loss management: Trading is now locked for 10m for trade account Sim1. | Symbol: (unset) | TradeAccount: Sim1 |
| Screenshot from 2025-07-15 12-50-25.png / V - Attached On 2025-07-15 16:50:45 UTC - Size: 867 B - 31 views |
| [2025-07-15 16:58:08] |
| User273277 - Posts: 83 |
|
Found it. It's the DefaultSpreadsheetSystemAlertStudy option "Use Column I and J Values Version 2 (ln: 73) set to yes that broke the live P/L for trading. I changed that value back to no, and the profit management works properly again. I'll have to find the column that gives me net open/closed p/l in the spreadsheet using v1 instead until v2 is fixed. Date Time Of Last Edit: 2025-07-15 16:58:42
|
| [2025-07-15 20:53:33] |
| Sawtooth - Posts: 4261 |
|
In v1, the Open P/L is in J10, and the Closed Daily P/L is in J45. IMO, it's best practice to use v1 because: - It's used by most so it's easier in discussions. - The documentation only mentions v1 locations. - Once you are familiar with v1, you don't need v2. |
| [2025-07-15 20:58:17] |
| User273277 - Posts: 83 |
|
Thanks, that's helpful. That takes care of my needs for now. I think V2 needs to be looked at by support. Enabling it immediately breaks the built-in profit management. Something I did not think would be related. Date Time Of Last Edit: 2025-07-16 00:11:53
|
| [2025-07-15 21:16:15] |
| Sawtooth - Posts: 4261 |
|
v1 cell locations: Spreadsheet Systems, Alerts and Automated Trading |
| [2025-07-15 21:18:17] |
| User273277 - Posts: 83 |
|
In v1, the Open P/L is in J10, and the Closed Daily P/L is in J45.
This is in the Spreadsheet System For Trading Study. I was using the Spreadsheet System Alert Study. But that works for me, thanks. |
| [2025-07-15 21:34:29] |
| Sawtooth - Posts: 4261 |
|
There is no Open P/L nor Closed P/L, nor many other outputs, in the Spreadsheet System/Alert study when using v1, so they probably shouldn't be there in v2 either. Using v2 in the Spreadsheet System/Alert study shows some Column J values that only the Spreadsheet System for Trading study has. This seems like it is unintended, or at best it is confusing. Yet another reason to avoid v2. Date Time Of Last Edit: 2025-07-15 21:47:52
|
| [2025-07-16 04:08:24] |
| Sierra_Chart Engineering - Posts: 20780 |
|
This has no effect upon the Global Profit/Loss Management: Found it. It's the DefaultSpreadsheetSystemAlertStudy option "Use Column I and J Values Version 2 (ln: 73) set to yes that broke the live P/L for trading. I changed that value back to no, and the profit management works properly again.
That is completely impossible. To understand All Symbols Daily Net Profit/Loss (read-only), refer to: Global Profit/Loss Management: How Daily Net Profit/Loss is Calculated for a Trade Account Using v2 in the Spreadsheet System/Alert study shows some Column J values that only the Spreadsheet System for Trading study has. This is definitely intended. Version 2 includes all of the different values for each Spreadsheet study unless they have no purpose for the particular version of the spreadsheet study.
This seems like it is unintended, or at best it is confusing. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2025-07-16 04:08:51
|
| [2025-07-16 05:43:19] |
| User273277 - Posts: 83 |
|
This has no effect upon the Global Profit/Loss Management:
I didn't think it should. After more testing, I agree P/L Management and the Spreadsheet are not related, but there is still something going on. It looks like this is only happening in replay mode (set to single chart, or charts with same link number). I have a linked chart for MNQ. I have cleared all sim orders and trade data, and set the TAL to current day. TAL Chart Stats and Trades are empty. I enter 1 MNQ short at current price with the replay paused. P/L on the toolbar of the chart I'm trading shows -0.50C. TAL chart stats Open P/L for this chart shows -0.50. TAL chart stats Open P/L for the linked chart of the same ticker shows 144.50. I must of missed clearing something, somewhere? Date Time Of Last Edit: 2025-07-16 16:34:00
|
| [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
|
| [2025-08-02 03:19:12] |
| User273277 - Posts: 83 |
|
To get the alert to only trigger once a day and automatically reset on the next trading day, just setup the spreadsheet alert on a daily chart and enable the option to reset alert on new bar. So simple, but I didn't think of that until today. |
To post a message in this thread, you need to log in with your Sierra Chart account: