Login Page - Create Account

Support Board


Date/Time: Fri, 07 Aug 2020 09:07:17 +0000



Unexpected spreadsheet signals

[2015-07-16 15:36:50]
User911705 - Posts: 89 | Ending Date: 2015-07-03 [Expired]
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]
Sierra Chart Engineering - Posts: 88421 | Ending Date: 2021-04-05
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).
This is definitely not the case and is explained here:
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2015-07-16 21:09:35]
Sierra Chart Engineering - Posts: 88421 | Ending Date: 2021-04-05
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2015-07-16 22:48:54]
User911705 - Posts: 89 | Ending Date: 2015-07-03 [Expired]
Thank you for this information, I will study it carefully.

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

Login

Login Page - Create Account