Support Board
Date/Time: Sun, 02 Feb 2025 23:19:02 +0000
[Programming Help] - Automated Trading Spreadsheet setting
View Count: 837
| [2019-10-02 13:20:36] |
| Bubba - Posts: 30 |
|
Hello Below is a screen shot of my spread sheet, what I'm trying to get is settings that will allow multiple trades in one direction. From what I see, and what I've tried to change has always reverted back to the original setting because of the read only settings on the spreadsheet itself. I also have columns K, M, O, P, Q, R that all have codes in them to achieve different orders, but because I'm not able to get more than one trade at a time working I'm not sure if they all are working. I believe that they all work mostly because there are no errors showing in the columns after putting codes in each. Thanks for the help, and I hope I copied things well enough that it makes sense to you. Mark http://www.sierrachart.com/image.php?Image=1570021727919.png = CROSSFROMBELOW(ID3.SG1@3:ID3.SG1@5,ID6.SG1@3:ID6.SG1@5) cell K = CROSSFROMABOVE (ID3.SG1@3:ID3.SG1@5,ID6.SG1@3:ID6.SG1@5) cell M =OR(CROSSFROMABOVE(ID2.SG2@3:ID2.SG2@6,ID2.SG3@3:ID2.SG3@6)) cell O =OR(CROSSFROMBELOW(ID7.SG2@3:ID7.SG2@6,ID7.SG3@3:ID7.SG3@6)) Cell P =OR(CROSSFROMBELOW(ID2.SG2@3:ID2.SG2@6,ID2.SG4@3:ID2.SG4@6)) Cell Q =OR(CROSSFROMABOVE(ID2.SG2@3:ID2.SG2@6,ID2.SG3@3:ID2.SG3@6)) cell R |
| [2019-10-02 16:49:15] |
| Sawtooth - Posts: 4164 |
|
The Read Only cells in column J are outputs from the spreadsheet study settings and cannot be changed on the spreadsheet sheet. Set 'Allow Multiple Entries In Same Direction' to Yes. If you are using Attached Orders, also set 'Allow Entry With Working Orders' to Yes. |
| [2019-10-02 17:32:29] |
| Bubba - Posts: 30 |
|
I try to set these to 1 or yes in column J but they go back to 0 or no. Is there somewhere else I should be changing these settings? This is the only place I know of, sorry for my confusion. Bubba |
| [2019-10-02 17:37:02] |
| Sawtooth - Posts: 4164 |
|
You must change them in the spreadsheet study settings. You cannot change them on the spreadsheet. Go to Analysis >> Studies >> highlight the spreadsheet study >> Settings button >> Settings and Input tab |
| [2019-10-02 17:49:57] |
| Bubba - Posts: 30 |
|
Thanks got it
|
To post a message in this thread, you need to log in with your Sierra Chart account: