Support Board
Date/Time: Sat, 11 Jan 2025 04:42:32 +0000
Spreadsheet for trading - Cell J10 Open P/L not calculated correctly
View Count: 683
| [2016-10-27 02:39:05] |
| User553714 - Posts: 184 |
|
Hi, I am trading symbol GBP-201612-GLOBEX in an IB paper account and J10 is not being calculate correctly - see attached screenshots. A you can see it is producing very strange almost random behaviour both in the sheet and the P&L shown on the chart. The P&L was correctly shown in IB TWS. I was hoping to rely on the P&L in J10 for various trading decisions instead of calculating myself but with this behaviour (not the first time I have seen it..) I will not be able to rely on it? Are you aware of P&L calc issues in spreedsheets? How is the futures multiplier being taken into account as it is not shown anywhere in the J column of the sheet? |
Private File Private File |
| [2016-10-27 04:11:16] |
| |
|
What is the purpose of attaching two screenshots? One is enough. And we do not know what you mean by "futures multiplier". You are also using the incorrect symbol. You are going to create various real problems for yourself, including this one, when you do not use the symbols which are listed in File >> Find Symbol. Change the symbol of the chart to match. Refer to: Chart Settings: Symbol (text box) (Chart >> Chart Settings >> Symbol >> Symbol menu) For how the Profit/Loss is calculated, refer to: Basic Trading and the Trade Window: Main/C >> Open Profit/Loss (P/L) As is documented here: https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#CellJ10 on the Spreadsheet it is displayed as a currency value. 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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2016-10-27 04:12:00
|
To post a message in this thread, you need to log in with your Sierra Chart account: