Login Page - Create Account

Support Board


Date/Time: Fri, 21 Jan 2022 23:49:48 +0000



Custom Order Quantity on New Sierra Chart Version

View Count: 1522

[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]
Sierra Chart Engineering - Posts: 99895
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]
tomgilb - Posts: 3133
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]
Sierra Chart Engineering - Posts: 99895
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]
Sierra Chart Engineering - Posts: 99895
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]
tomgilb - Posts: 3133
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:

Login

Login Page - Create Account