Login Page - Create Account

Support Board


Date/Time: Tue, 18 Mar 2025 16:10:25 +0000



PnL in Spreadsheet differs from Trading Window

View Count: 781

[2022-09-20 18:46:48]
Jupitersbay - Posts: 54
Hi there,

I just can`t figure out, why the PnL in the TradeWindow is different from that in the spreadsheet cell J10.
I'd like to use it for the Exits of the trade.

Thank you
imagesierra pnl in spreadsheet.jpg / V - Attached On 2022-09-20 18:46:25 UTC - Size: 223.59 KB - 104 views
[2022-09-20 21:12:53]
John - SC Support - Posts: 38756
The information in J10 corresponds to the P/L that is displayed on the Trade Window. The difference is that what is displayed in the Trade Window is controlled by the Chart Settings for the Profit/Loss Display. Whereas the Spreadsheet is always displaying currency.

Therefore, the connection in the image you provided is that the P/L is showing 50 Ticks of profit (50T). For the ES the Currency Value per Tick is 12.5, therefore what is shown in the Spreadsheet is 50 * 12.5 = 625.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-09-20 21:28:33]
Jupitersbay - Posts: 54
OMG. That was simple. Obvious with these numbers...
Danke schön.

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

Login

Login Page - Create Account