Support Board
Date/Time: Sun, 22 Dec 2024 04:07:16 +0000
Unexpected spreadsheet signals
View Count: 1318
| [2015-07-16 15:36:50] |
| User911705 - Posts: 89 |
|
Hello, I have a spreadsheet for trading study that is operational and seems to be working mostly correct. However, I've had at least one occurrence of the following scenario: Study is set to operate end of bar on 30 min bars with 20 rows in the sheet. The study properly plotted an up arrow for a long entry at 12:00. An order was submitted and correctly put on a position. 7 bars later, with the position on, the up arrow disappeared from it's original location and plotted on a bar that was impossible for the conditions to be true. I have screenshots of the chart and sheet, so I can be sure of this. Even if the new arrow should have plotted (which it should NOT in this case) the original arrow should have stayed on the chart until the max 20 rows was reached, not row 7). The rest of the trade played out correctly, but I'm sure you can imagine it's a worrisome situation that happened. Can you advise on what might have happened or what I need to do to troubleshoot this? |
| [2015-07-16 17:51:28] |
| |
|
the up arrow disappeared from it's original location and plotted on a bar that was impossible for the conditions to be true. I have screenshots of the chart and sheet, so I can be sure of this. When you look at the particular cell causing that new arrow and what it references, should it be TRUE? You must evaluate it at the current moment in time. It does not help to provide us any screenshots. We would not look at those in a case like this. Even if the new arrow should have plotted (which it should NOT in this case) the original arrow should have stayed on the chart until the max 20 rows was reached, not row 7). http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#DisappearingArrows This is also something to review: http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#DelayedTrueResult 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 |
| [2015-07-16 21:09:35] |
| |
|
There is also this section which has more insight into how the Spreadsheet study interacts with a Sheet in a Spreadsheet window. http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#SpreadsheetCalcProcessingOfSpreadsheetData We just made some updates to it. 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 |
| [2015-07-16 22:48:54] |
| User911705 - Posts: 89 |
|
Thank you for this information, I will study it carefully.
|
To post a message in this thread, you need to log in with your Sierra Chart account: