Home >> Support Board

Support Board

Date/Time: Sat, 04 May 2024 02:31:50 +0000

How to Post a Message for Support

[Programming Help] - Automate trading system spreadseet bug,

View Count: 300

[2023-04-20 17:45:13] #1 [Go To First Post]
Hopeman - Posts: 156
Hello, I have a very basic system set up in the Spreadsehet consisting of a staked imbalance which I unify in one signal along with the other graph with the time and sales indicator the signal is very simple when there are groups of 4 in the tape and a staked imbanlce that gives a buy or sell signal in this case it is a buy signal the formula as indicated is very simple and it is a test, the problem is that it gives inputs when there is no staked imbalance and when there is not there is stacking on the tape indicator. I have mounted the time an sales indicator with an email to the same sheet, I have checked that everything is fine including the formulas. In the buy entry box I have this =AND(ID0.SG4@3>ID3.SG3@3, Q3, AK3,) where K3 is the staked imbalance and q 3 is the sending of the spreadsset in chart number 1 in this case with this formula =AND(Sheet1!AL@3) in cell Q a 1 is output when it is the case that there is a stacked on the tape, the probelam is that spreadseht gives input when there is not a staked ask in this case on the tape ni in staked imbalance of indicator ! I can understand that it is the case that there was an entry, as is the case in the following candle, but the tape does not accompany it and SC also opens a buy operation, can you be so kind as to tell me where the error is, because I do not understand that being such and such a simple formula the program is giving problems of this type. Thank you,


staking ASK.png / V - Attached On 2023-04-20 17:45:06 UTC - Size: 98.12 KB - 79 views

[2023-04-20 19:00:11] #2 [Go To First Post]
Sawtooth - Posts: 3993
It is unlikely this is a bug. It is not recommended to use a direct reference to another spreadsheet sheet. Instead, the recommendation is to use the Study/Price Overlay study. Referencing Other Charts in Spreadsheet Study Formulas: Referencing Other Charts in Spreadsheet Study Formulas

[2023-04-20 19:12:45] #3 [Go To First Post]
Hopeman - Posts: 156
Thanks Tomb from now on I will use the advice that you tell me; On the other hand, I want to tell you that it doesn't make sense that you are reading an entry when there isn't one, the referred cell never marks TRUE to give way to the entry, in any case the entry should not be executed since the row is not executed. It would be a sending error per cell in the case that the input was not executed since there is no TRUE

[2023-04-21 18:32:48] #4 [Go To First Post]
Hopeman - Posts: 156
Hello @tomgilb, The solution of using a study price overlay is unfortunately not a good one since the chart that I am intending to pass without sending the Spreadseet is based on volume and the main spreadseet is based on time, so the result is wrong, it only gives one value. per box, the error giving inputs where they are not persists, please would you be so kind as to provide a solution to this bug which does not make any sense that it occurred since it does not give True in the door since it should not give input is a Very strange thing. I've been trying and reviewing the problem for several days before contacting you, Thank you

[2023-04-21 19:26:16] #5 [Go To First Post]
Sawtooth - Posts: 3993
please would you be so kind as to provide a solution The Study/Price Overlay study is the only solution when comparing two bar period types. It has two settings that will affect its accuracy: - Data Copy Mode - Bar Time Matching Method Experiment with these settings to find the best settings. (Be sure 'Fill Blanks With Last Value' is set to Yes.) There is no better solution. When overlaying from different bar period types, there can never be a 100% alignment with 100% of the bars. You can get close with the two settings mentioned above, but there will occasionally be a misalignment. Occasionally the signal will disappear, or it will arrive late. Also, in a spreadsheet study, it's not possible to make an intrabar event persistent; only close-of-bar events can be made persistent. Date Time Of Last Edit: 2023-04-21 19:30:07

[2023-04-26 15:08:18] #6 [Go To First Post]
Hopeman - Posts: 156
Hi tomgilb, The solution you offered definitely doesn't work and makes things worse! Sending the Spreadsheet works perfectly, that is not the error, I have detected that it does not read the inputs correctly, even though it has all the boxes in true SC, it does not open any type of operation, I have reviewed all the documentation over and over again, my formulas and everything seems be correct, a possible failure is that the signal lasts very little, close to a millisecond and SC through Spreadseet is unable to read the order. I thought that there might be a formula that is capable of keeping the signals in the rows? Would you be so kind as to give me a solution to the problem, thank you.

[2023-04-27 01:59:47] #7 [Go To First Post]
Sawtooth - Posts: 3993
Would you be so kind as to give me a solution to the problem Please Direct Message me.

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