Support Board
Date/Time: Sat, 23 Nov 2024 05:15:16 +0000
Custom Order Quantity on New Sierra Chart Version
View Count: 2297
| [2013-06-12 20:29:50] |
| CMG - Posts: 179 |
|
Hello, I downloaded the new Sierra Version and noticed some changes on the Spreadsheet for trading. I have managed to adjust the changes but the Custom Order Quantity is still not working on cell J26. I have a simple formula =IF(ABS(J8)=($J$65*5),($J$65*3), IF(ABS(J8)=($J$65*2),($J$65*1),0)) what could be the problem? |
| [2013-06-12 22:23:52] |
| |
|
We cannot help with formulas. Manually enter an integer value into that Order Quantity cell. If that works OK, then the problem must be with the formula. 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 Date Time Of Last Edit: 2013-06-12 23:25:14
|
| [2013-06-12 23:13:36] |
| Sawtooth - Posts: 4118 |
|
In older versions, J65 was the read-only order quantity from the study settings that was overwritten by any non-zero value in J26. In newer versions, this study setting has been removed and the order quantity is totally controlled by J26. J65 is now an unused cell that always contains a value of 1. You will have to rewrite your J26 formula with this in mind.
|
| [2013-06-12 23:25:58] |
| |
|
We had not paid attention to the particular cell numbers they specified. The proper Order Quantity cell is: http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#CellJ26 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 |
| [2013-06-12 23:36:45] |
| |
|
If you delete the data that is currently in J65 it will be removed and nothing will appear there any longer.
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 |
| [2013-06-13 13:16:23] |
| CMG - Posts: 179 |
|
What is happening is that when I put any formula, at the start of the test back the formula result is 0, so it seems like it defaults to 1 and that is the quantity that is buying overiding cell J65. How it worked on the previous Sierra Version was: the formula result was 0 while program had no positions, as soon as the program buys according to the quantity the J26 cell value changed to whatever custom quantity. In the case of my example : =IF(ABS(J8)=($J$65*5),($J$65*3), IF(ABS(J8)=($J$65*2),($J$65*1),0)) When the buy entry condition is met, and buys the first 20 contracts, the value of J26 changed from 0 to 12, the effect on the buy exit was to sell 12 contracts.If the quantity was 8 contracts, the effect on buy exit was to sell 4 contracts. As you know this J26 cell is combined with the buyexit or sellexit. http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#AutomatedTradingExample The formulas on J26 on the new version are not working because from 0 default to 1 overiding the default quantity. Any other suggestions so I can use custom exits? |
| [2013-06-13 13:50:33] |
| Sawtooth - Posts: 4118 |
|
Assuming your original default quantity was 4, try this: =IF(ABS(J8)=(4*5),(4*3),IF(ABS(J8)=(4*2),(4*1),4)) Date Time Of Last Edit: 2013-06-13 13:50:56
|
| [2013-06-13 15:54:55] |
| CMG - Posts: 179 |
|
Thanks, the 4 instead of 0 at the end of the formula did the trick. Meaning if no position the default quantity will remain, in this case 4. Case resolved by tomgilb! |
To post a message in this thread, you need to log in with your Sierra Chart account: