Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 20:02:34 +0000



Synchronized Internal Position Quantity not working properly

View Count: 651

[2020-02-12 23:04:43]
User120371 - Posts: 3
Hi,
Today I experienced a problem with my trading spreadsheet. A buy entry was triggered and sent the order to IB for trade. IB executed the trade correctly, but the Sierra Chart spreadsheet had problems updating the position quantity. It would initially correctly update, then suddenly revert back to zero, causing the spreadsheet to execute another trade and so on. This went on until capital was used up and IB stopped trades from going through. The funny thing is that, the spreadsheet was sending orders 1 share at a time. I have attached the trading log for support to have a look. I have never had any issues before with the trading spreadsheet and current algorithm. I also have the most updated version of Sierra Chart. Please have a look and address a fix.

Regards,

Chris
attachmentTradeActivityLog02_12_20.txt - Attached On 2020-02-12 23:02:35 UTC - Size: 779.49 KB - 250 views
Attachment Deleted.
[2020-02-13 11:31:41]
Sierra Chart Engineering - Posts: 104368
First the safest thing to do is to use the order fill calculated position:
Trading Information Windows: Using Order Fill Calculated Positions In Special Cases

You should check it each day to make sure it is correct though. And understand that it is based on order fills and adjust the Order Fills Start Date-Time in the chart and periodically update this to ensure the calculation is correct.

In this way you will not have any further problems with IB position reporting.

And also it is well-known there are position reporting problems with Interactive Brokers:
Interactive Brokers Trading Service: Trade Position Line or Quantity Disappearing or Displaying Zero

This is why we put out this posting:
***Interactive Brokers is Garbage*** (Technical Support is Now Fully Ended!!)

Please read what we have said in that link above carefully. We mean every bit of it. Every part of it. And we reaffirm everything we say.
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: 2020-02-13 11:36:11
[2020-02-13 11:48:01]
Sierra Chart Engineering - Posts: 104368
It sounds like you are trading stocks and based upon the problem you have, we have to advise you that it is very treacherous to be relying on IB position reporting for stocks. It is simply inherently unreliable to map that information back to a chart, assuming they even send it. There is no straightforward and reliable means to do so.

This is why you need to use the order fill calculated position. And understand how it is calculated.
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: 2020-02-13 11:48:54
[2020-02-13 12:17:46]
User120371 - Posts: 3
Thank you. Yes, I figured it was the that. But I could've swore that I had that function (order fill calculation) enabled before. Do you think the function was reset when migrating from 32bit to 64bit version of Sierra Chart? Also, can you tell me what other settings might have been reset when switching over to the new 64bit version? Thanks again.
[2020-02-13 18:51:33]
Sierra Chart Engineering - Posts: 104368
We know of no reason why the Use Order Fill Calculated Position option would be disabled. Changing to the 64-bit version will not change any settings. It is fully compatible with the 32-bit version.


Recently the global Order Fill Calculated Position on the Trade menu was removed because the global implementation did not make sense.

Make sure you have always been using the chart specific setting which is documented here:
Basic Trading and the Trade Window: Main/C >> Menu >> Settings >> Use Order Fill Calculated Position (chart specific)
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: 2020-02-13 19:01:18
[2020-02-13 19:01:25]
Sierra Chart Engineering - Posts: 104368
Prior post has been updated with the correct link.
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
[2020-02-13 20:09:18]
Sierra Chart Engineering - Posts: 104368
To safeguard against this kind of issue what we are going to do is add a new field to the I and J columns indicating whether the Order Fill Calculated Position is enabled or not for the chart. Then you can modify your formulas to check this state and if it is not enabled, do not do any auto trading.

We will try to get this in today.

You should also add some validation in regards to the order quantity in your formulas to make sure the order quantity cell is set as you require.
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: 2020-02-13 21:34:12
[2020-02-14 05:18:55]
User120371 - Posts: 3
Thank you for the help. Much appreciated.
[2020-02-14 08:25:30]
Sierra Chart Engineering - Posts: 104368
We are releasing this new Spreadsheet field in about 20 minutes in version 2050.
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

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

Login

Login Page - Create Account