Data Errors or Spikes in Charts, Flat or Flat Line Graph, Compressed Graph, Errors with Date/Time Values
Below is an example of a chart data error which causes a flat or compressed graph. This error causes the the chart to display incorrectly and be compressed.
There are different types of errors that can affect charts in various ways. This is only one example. There could be data records with incorrect Date-Time values which will cause out of order Date-Time values in the chart. This could cause Chart Drawings and some Studies not to function properly.
There could be errors with price values that can be either small or large which can also affect the appearance of the chart.
- 2.1 Intraday Charts
- 2.2 Historical Charts
- 2.2.1: Manually Correcting the Data Errors
- 2.2.2: Correcting Data Errors by Downloading the Data Again
- 2.2.3: Last Bar Continues to Have an Error
- 2.2.4: Data Errors Caused by Symbol Differences
- 2.2.5: Data Error at Last Bar in Historical Chart Caused by Incorrect Multiplier Settings
- 2.2.6: Removing Permanent Data Errors from Real-time Data Feed
- 2.3 Methods to Filter out Intraday Chart Data Errors
2.1 Intraday Charts
There are two ways to correct errors in an Intraday chart.
2.1.1 Manually Correcting Data Errors
The first method is to correct or delete data records that contain errors. For instructions to locate these records and perform the edit, see Quickly Locating a Specific Record In the Editor on the Intraday Data Editor documentation page.
2.1.2 Deleting and Re-downloading Data. (Easier and Recommended Method)
The second method is to delete and re-download the data with the possibility that the newly downloaded data will not contain the errors. This method will not always work, since the server may contain the same errors. This method is also the very same method used to restore missing data in a Intraday chart. Refer to the image below.
- Scroll the chart so that the area before the data errors or missing data is visible.
- Right-click with your pointer on the chart before the data errors or missing data. Select Delete and Download Data on the menu.
You can also select Edit >> Edit/Download Data - Intraday Chart. In this case the Intraday Data Editor will display. Scroll to the appropriate position using the editor scrollbar and then press the Delete And Download From Current Position to End button.
- Click Yes to confirm. The data will be deleted and new data will be downloaded.
For more information about deleting and downloading Intraday data, refer to Delete And Downloading Data on the Intraday Data Editor documentation page.
2.2 Historical Charts
2.2.0: General Information
There are two methods to correct an error or errors in Historical charts (Daily, Weekly, Monthly, Quarterly, Yearly bar time frames). The first step with either method is to reconnect to the data feed to attempt to clear errors that may exist with the current days quote data for a symbol.
To reconnect select File >> Disconnect on the menu and then File >> Connect to Data Feed.
After reconnecting to the data feed, to clear the potentially invalid data from the prior connection to the real-time data feed providing the current quote data, go to the chart and select Chart >> Reload and Recalculate.
The current days quote data can be displayed by going to the chart for the symbol and selecting Window >> Current Quote Window. It is also merged into the very last bar in the chart.
2.2.1: Manually Correcting the Data Errors
The first method is to correct the error yourself. Look closely at your chart and find the date of the incorrect value. The Chart Values Tool on the Tools menu can be used to display the exact date.
Select Edit >> Edit Data - Historical Chart on the menu to open the text editor. Find the particular date you want to edit in the editor and delete the incorrect data line or correct it.
Save the file and close the editor. When the editor is closed, the charts that use that data file will automatically reload. Refer to Edit Menu for more information.
2.2.2: Correcting Data Errors by Downloading the Data Again
This method relies upon the Data or Trading service to have corrected the error or errors.
Scroll the chart so that the location of the data error is within view. Right-click on the chart before the data error and select on the displayed menu Delete and Download Data. This will re-download the data.
If the data error is at the last bar in the chart, or the bar before the last bar, then you can select Edit >> Download Data - Historical Chart. This will download data starting at the last two records in the historical chart data file, to the present date.
Depending upon the reason for the data errors and the type of data errors, it may be necessary to fully re-download the data in the chart. For example, there could be price differences between recent bars and prior bars due to a stock split. In these cases, fully re-download the data in the chart by selecting Edit >> Delete All Data and Download from the main menu.
Refer to the Downloading Historical Daily Data documentation page for more information about downloading historical Daily data.
If the error continues to be in the chart, then use the first method described above (2.2.1) to manually correct it yourself. If the data error is at the last bar in the chart, then refer to 2.2.3: Last Bar Continues to Have an Error.
2.2.3: Last Bar Continues to Have an Error
If the very last bar in a Historical chart continues to have an error with either the prices or volume after following the instructions in help topic 2.2.0, 2.2.1 or 2.2.2, then most likely the current days quote data on the real-time data server for the symbol has an error.
The current days quote data can be displayed with Window >> Current Quote Window. If you see incorrect values there with the prices or volume, you need to contact your Data or Trading service to have them correct the error. If the current quote data looks correct, then reload the data in the chart with Chart >> Reload and Recalculate.
If there was a data error with the current quote data from the Data or Trading service and it has been corrected, then follow the instructions in section 2.2.0 to clear the error from the chart. You may also have to follow section 2.2.2: Correcting Data Errors by Downloading the Data Again to correct the data in the chart data file as well.
To determine if the error you see at the last bar in the chart is in the chart data file, select Edit >> Edit Data - Historical Chart. A text editor will display showing the data. Go to the bottom of the file and locate the date for the last bar in the chart. Verify the the prices and volume are correct. If they are incorrect, then the source of the data errors at last in bar is in the data file itself.
2.2.4: Data Errors Caused by Symbol Differences
If you have a Historical chart open that uses Historical Daily data from a service different than the real-time Data or Trading service you are using, and there are symbol differences between these two services, then you may have an error in your chart on the very last bar.
This could appear as a very long bar which compresses the rest of the chart and makes all the other bars look like a thin line.
What is actually happening in this case is the Historical Daily chart symbol matches with another symbol from the real-time data feed but actually is a different symbol. In this case select Chart >> Chart Settings >> Advanced Settings and disable Allow Real-Time Updating of Historical Chart.
2.2.5: Data Error at Last Bar in Historical Chart Caused by Incorrect Multiplier Settings
Apparent data errors in a chart can be caused by incorrect chart Multiplier settings. Select Chart >> Chart Settings >> Advanced Settings 2.
Both the Real-time Price Multiplier and Historical Price Multiplier both should be set to 1 in almost all cases.
Change these to 1 and press OK to see if the data errors are resolved.
2.2.6: Removing Permanent Data Errors from Real-time Data Feed
There may be cases for some symbols, that the real-time data feed Sierra Chart is connected to is providing consistently invalid Current Quote values which are affecting the display of the last bar in a Historical chart.
For example, this could be the case with Interactive Brokers where it provides -1 values for some symbols. This may be in the case where there is not a real-time data subscription for the particular symbol.
In this particular case, the solution is to go to the particular Historical chart and select Chart >> Chart Settings >> Advanced Settings. Uncheck the Allow Real-time Updating of Historical Chart option. Press OK. The invalid real-time Current Quote values will be removed from the last bar in the Historical chart.
2.3 Methods to Filter out Intraday Chart Data Errors
There are methods to filter out data errors in Intraday charts. You can filter the errors out using one of the two methods described here.
If the apparent data errors occur at certain regular times, such as outside of regular trading hours, you can adjust the Intraday Session Times in Chart >> Chart Settings to exclude those times where the data errors occur, to prevent the data with the errors from displaying in the chart.
Another method is to utilize the Sierra Chart Error Filter to filter out the data errors. The error filter should be used with caution and for data errors which are significantly out of range. You could end up filtering out valid data if you make the settings to tight and that is definitely not recommended.
After making changes to the Error Filter settings, you will need to delete and re-download the data following the instructions in help topic 2.1.2 in order to filter out the existing data errors.
*Last modified Monday, 23rd October, 2017.