# Support Board

Date/Time: Tue, 24 May 2022 06:41:30 +0000

## Custom Order Quantity on New Sierra Chart Version

### View Count: 1626

 [2013-06-12 20:29:50] #1 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] #2 Sierra Chart Engineering - Posts: 102839 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] #3 tomgilb - Posts: 3272 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] #4 Sierra Chart Engineering - Posts: 102839 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] #5 Sierra Chart Engineering - Posts: 102839 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] #6 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] #7 tomgilb - Posts: 3272 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] #8 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!