Support Board
Date/Time: Wed, 27 Nov 2024 12:29:15 +0000
[Programming Help] - Is it possible to automate via spreadsheet an entry above or bel
View Count: 400
| [2023-08-14 18:07:49] |
| Hopeman - Posts: 166 |
|
Hello, I am currently generating the formula in box AB3, I am putting the formula just as indicated and it gives me an argument error. The formula that I am working on in the BUY entry or SELL ENTRY is the following, in this case I put the example of the Buy entry I have also tried putting it at the end of the line and it doesn't work, do you have any idea what it is? =AND (OR(CROSSFROMBELOW (ID0.SG4@3:ID0.SG4@5, ID7.SG1@3:ID7.SG1@5), CROSSFROMBELOW ( ID0.SG4@3:ID0.SG4@5, ID7.SG2@ 3:ID7.SG2@5), CROSSFROMBELOW ( ID0.SG4@3:ID0.SG4@5, ID3.SG3@3:ID3.SG3@5)),O3,Q3,X3,Y3,AK3,AZ3,AO3 ,AT3,AF3) |
| [2023-08-14 18:08:55] |
| John - SC Support - Posts: 36309 |
|
On a quick glance, if this is an exact copy of what is entered, the one problem is that there is a space between the '@' sign and the number 3 in the second CROSSFROMBELOW() function.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-08-14 19:10:59] |
| Hopeman - Posts: 166 |
|
Hi John! I am trying to put this formula =ID1.SG1@3 + $J$21 * 2, theoretically I am trying to make an entry signal around a breakout, many times a signal happens just a few ticks after a breakout in the same candle or a candle later, to achieve this I use this formula in cell AC3, I tried this formula putting it like this =AND (OR(CROSSFROMBELOW (ID0.SG4@3:ID0.SG4@5, ID7.SG1@3:ID7.SG1@5, AC3:AC5), CROSSFROMBELOW ( ID0.SG4@3:ID0.SG4@5, ID7.SG2@3:ID7.SG2@5,AC3:AC5), CROSSFROMBELOW ( ID0.SG4@3:ID0.SG4@5, ID3.SG3@3:ID3.SG3@5,AC3:AC5)),O3,Q3,X3,Y3,AK3,AZ3,AO3 ,AT3,AF3) And it does not work, I also tried putting only AC3, and putting AC3 together with the Q3 formulas, etc. Thanks |
| [2023-08-14 19:45:56] |
| John - SC Support - Posts: 36309 |
|
This last formula has 3 arguments in the CROSSFROMBELOW() functions, you can only have 2.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-08-15 05:12:27] |
| Hopeman - Posts: 166 |
|
Do you think a formula could be made that describes four tiks above or below VA? I can't think of any other solution
Date Time Of Last Edit: 2023-08-15 05:56:08
|
| [2023-08-15 14:30:34] |
| Sawtooth - Posts: 4120 |
|
Try this: =AND (OR(CROSSFROMBELOW (ID0.SG4@3:ID0.SG4@5, ID7.SG1@3:ID7.SG1@5), CROSSFROMBELOW (ID0.SG4@3:ID0.SG4@5,AC3:AC5), CROSSFROMBELOW ( ID0.SG4@3:ID0.SG4@5, ID7.SG2@3:ID7.SG2@5),CROSSFROMBELOW (ID0.SG4@3:ID0.SG4@5,AC3:AC5), CROSSFROMBELOW ( ID0.SG4@3:ID0.SG4@5, ID3.SG3@3:ID3.SG3@5),CROSSFROMBELOW (ID0.SG4@3:ID0.SG4@5,AC3:AC5)),O3,Q3,X3,Y3,AK3,AZ3,AO3 ,AT3,AF3) |
| [2023-08-16 16:54:24] |
| Hopeman - Posts: 166 |
|
@Sawtooth One question because if I put AC3:AC5 in all the CROSS it gives an ARG error, theoretically it shouldn't happen? Date Time Of Last Edit: 2023-08-16 16:54:44
|
| [2023-08-16 20:14:55] |
| Sawtooth - Posts: 4120 |
|
if I put AC3:AC5 in all the CROSS it gives an ARG error
The CROSSFROMBELOW function only allows 2 ranges.https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSFROMBELOW_Function |
To post a message in this thread, you need to log in with your Sierra Chart account: