Login Page - Create Account

Support Board


Date/Time: Tue, 07 May 2024 17:07:58 +0000



Post From: Problem with study data being replaced with zeroes when chart tagged for recalculation

[2015-11-30 00:44:16]
Sierra Chart Engineering - Posts: 104368

Every time the chart is tagged for recalculation all the bid and ask prices in all the rows in columns AA though AE get replaced with zeroes?
This cannot be. All of the rows cannot be zero unless you were to restart Sierra Chart.

Many of the rows could be zeroed, but not all of them. What is the Number of Rows input setting for the Spreadsheet study set to?

Is there anyway to copy and paste these columns as values in the spreadsheet or protect them in some way so they do not get recalculated with the Main Price graph data columns when a chart is tagged for recalculation?

No but there are other solutions. The most reliable solution is to use the Bid and Ask Prices study on chart bars that are set to 1 Number of Trades Per Bar. This is documented here:
http://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s355

Another thing which may be a solution is to use the -BIDASK data recording suffix:
http://www.sierrachart.com/index.php?page=doc/doc_RecordingModes.php

Although we have not tested the above to see if it will work exactly like you require and how best to configure the chart to give you the result you need.
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: 2015-12-01 08:01:18