Login Page - Create Account

Support Board


Date/Time: Sat, 20 Dec 2025 12:36:00 +0000



Spreadsheet J26 is not Updating Order Quantity.

View Count: 460

[2024-05-16 03:22:41]
User384855 - Posts: 5
Spreadsheet J26 is not Updating Order Quantity, I have tried So many times but its not working, is there something that's missing ?

Thanks
Attachment Deleted.
imagej26.png / V - Attached On 2024-05-16 03:20:57 UTC - Size: 97.31 KB - 114 views
imageJ261.png / V - Attached On 2024-05-16 03:21:02 UTC - Size: 18.34 KB - 126 views
[2024-05-16 15:01:02]
John - SC Support - Posts: 43555
Cell J26 does not update with the actual quantity that is selected. This cell allows you to set a quantity that you want to use for the Spreadsheet System for Trading. So any value entered in this cell will be used for the quantity for orders that are placed from the Spreadsheet System for Trading. If the cell is empty, then the quantity used will be the quantity set on the Trade Window.

Otherwise, there is no connection between the value set in cell J26 and the quantity set in the Trade Window.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2025-12-05 12:22:57]
MatrixTrades - Posts: 10
But what if I have a formula in J26 that calculates the quantity, yet when all the conditions are met, the Trade Window quantity still dictates the order fill - even though J26 had the desired quantity calculated at the same time?
[2025-12-05 14:46:03]
Sawtooth - Posts: 4300
If you are using v2, don't use J26. Use J69.
Date Time Of Last Edit: 2025-12-05 14:49:13

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account