Login Page - Create Account

Support Board


Date/Time: Sun, 16 Mar 2025 21:31:00 +0000



spreadsheet systeme auto trading CELL J4 not correct

View Count: 411

[2022-08-24 10:25:19]
User719206 - Posts: 93
Hello I m using spreadsheet system auto trading ,

when when I make a accurate trading systeme backtest , it seems that sometimes sierra chart does'nt realise that there is a working order , on the chart there is not the line to show there is a working order , and the cell j4 is 0.
it make big trouble for me because i manage my exit quantity with the working order quantity .

if I Go back in the past to 1 bar , or if i unchek and chek again "show order and position " sierra is actualised the line come back and the j4 cell is filled .

any idea about where does this issu come from ?
Date Time Of Last Edit: 2022-08-24 11:00:34
[2022-08-24 11:08:11]
Sierra_Chart Engineering - Posts: 18799
We had a look at this, definitely the cell that contains "Position with Working Orders Quantity (read-only):" is up-to-date at every calculation. However, it may not visibly update but it is in the background.

You definitely do not need to do this:
, or if i unchek and chek again "show order and position "

Pause the replay and see if you notice the order at that time. The chart graphics and spreadsheets may not visibly update for performance reasons but in the background, all of the orders are being tracked properly.
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, use the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2022-08-24 11:09:35
[2022-08-24 11:29:58]
User719206 - Posts: 93
it's well updated in the background , the trade is in my activiy log , the order and position line appear , and few bar later it disapear , and the cell j4 show 0.

the problem is , if the spreadsheet is not well updated , i cant exit with the good quantity , because i use the j4 cell to manage the exit quantity , so if it show 0 i cant exit.

it worked proprely during 2 week , and yesterday it begin to fail.
Date Time Of Last Edit: 2022-08-24 11:32:11

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

Login

Login Page - Create Account