Chart Data and Chart Data Files
- Notes About Chart Data Files
- Renaming Chart Data Files
- Deleting a Chart Data File
- Correcting Letter Case of Symbols
- When Intraday Data Files Are Updated
- Volume Data
- Bid Volume and Ask Volume
- Simulate Trades to Match Daily Volume
- Deleting and Re-Downloading Data for Multiple Charts
- Locating Missing Data in Charts
- Large Volume Trades
- Cleaning Up Old and Unused Symbols for Efficiency
- Completeness of Bar Data and Volume in Chart
- Reducing Number of Symbols Being Tracked by Sierra Chart
- The Meaning of the [M] Designation after a Symbol
Notes About Chart Data Files
Chart data files for both Historical charts and Intraday charts are stored in the Sierra Chart Data Files Folder which is set through Global Settings >> General Settings. By default this is the Data subfolder in the folder where Sierra Chart is installed to on your computer system.
Historical daily data files have a dly file extension.
Intraday data files have a scid file extension.
In the case of Intraday data files, they are compressed using the operating system file compression. When you look at these files through the File >> Open Historical/Intraday Chart window or through Windows Explorer, you will notice that the filename is in blue indicating they are compressed. If the filename is in black, then the file is not compressed.
Renaming Chart Data Files
Chart data is stored in files. Each symbol has its own file. These files are called chart data files. To rename a file, follow these instructions below.
- Disconnect from the data feed by selecting File >> Disconnect on the menu.
- Select File >> New/Open Historical Chart or File >> New/Open Intraday Chart on the menu. Select the specific chart data file for the symbol you want to rename.
- Right click the file you want to rename with your mouse pointer. Select Copy. Press Ctrl-V on your keyboard to paste a copy of the file into the same folder.
- Select the copy of the file which should be at the end of the file list. Right click the file with your mouse pointer. Select the Rename command on the displayed menu. Type the new symbol and if you see a file extension, make sure it is still part of the file name. Historical Daily chart data files use the extension: dly and Intraday data files use the extension: scid. If you do not see the extension, then there is no need to type it. If the file disappears after renaming it, then it is because the file extension was lost. In this case, select the All Files filter in the Files of Type list box to see the file and add the extension back by renaming the file. Note: If you get an error saying the file already exists when renaming a file, then you need to either Delete or Rename the existing file you are trying to rename to.
Example: Stock symbol ABCD has changed to ABC. Rename ABCD to ABC.
- Do this for each chart data file for each symbol you need to rename. When you are done, press the Cancel button on the Open File window.
- After renaming a symbol you will need to change the symbol of your charts that are using the old symbol to the new symbol. To do this, go to the chart, select Chart >> Chart Settings on the menu. Type the new symbol into the Symbol box or select one from the list opened with the Find button. For complete instructions, refer to Changing the Symbol of a Chart documentation page.
- To have your chart drawings (Lines, Rays, Text...) from the prior symbol display on the new symbol, then enable the Show Chart Drawings for Different Symbols option in Chart Settings.
- Press OK to close the Chart Settings window.
- Select Global Settings >> Intraday File Update List on the menu. If you have added the renamed symbols to this list previously, then you need to modify those symbols to the new symbol you are charting. To do this, click on the symbol in the Symbols List, modify the symbol displayed in the Symbol box, do this for each symbol, and press OK when finished.
- Connect to the data feed by selecting File >> Connect to Data Feed on the menu.
Deleting a Chart Data File
- To ensure the chart data file you will deleting does not come back, you first need to do 2 things.
- Select Global Settings >> Intraday File Update List on the menu. If the symbol of the file you want to delete appears on the list, highlight it and press the Delete button.
- Select Window >> Windows and Chartbooks on the menu. From this window look at each Chartbook and see if there is a chart for the symbol you want to delete.
If there is, then select it and press OK. This will activate the chart. To remove the chart from the Chartbook, select File >> Close Active Window on the menu. Repeat this step until you no longer find any charts for the symbol you want to delete.
- Select File >> Save All to save your Chartbooks after removing the charts.
- Disconnect from the data feed by selecting File >> Disconnect on the menu.
- Select File >> New/Open Historical Chart or File >> New/Open Intraday Chart on the menu. Select the symbol in the file list.
- Right click the file you want to delete with your mouse pointer. Select Delete on the menu to delete the file.
- Click on Cancel to close the Open File window.
- Connect to the data feed by selecting File >> Connect to Data Feed on the menu.
Correcting Letter Case Of Symbols
In the case where a Data or Trading service has case sensitivity for Symbols, it is essential that the case of the symbols is correct.
This is not a problem when you choose symbols through the File >> Find Symbol window. If you manually type in symbols, you must make sure the letter case of them is correct according to the symbol specifications for the Data or Trading service you are using.
If you have used an incorrect letter case for symbols, this can cause the market data requests and order submissions to get rejected. This will prevent charts from updating, prevent the quotes on Quote Boards from updating, and cause rejected orders.
Follow the below procedure to correct the letter case of symbols which are incorrect. Generally this is an uncommon issue and is a rarely required procedure.
- If you have any Quote Boards which are open which contain Symbols with incorrect letter case, then correct the letter case of those Symbols by selecting Settings >> Set Symbols on the Quote Board menu.
- Select Global Settings >> Intraday File Update List. Check all of the symbols in that list, if any, and make sure the letter case of them is correct.
- Select Window >> Windows and Chartbooks on the menu. This window will let you see all of your open Chartbooks and charts within those Chartbooks. Go through each of the open Chartbooks and go to each chart within the Chartbook which has a Symbol which is of the incorrect letter case.
- When a chart that has a Symbol with an incorrect letter case is active, select Chart >> Chart Settings.
- In the Symbol box, choose the correct symbol by pressing the Find button beside it and selecting the correct symbol.
- Press OK.
- It is essential, that every single chart and Quote Board that has a Symbol with an incorrect letter case, has the Symbol corrected to be of the proper case. Otherwise you will continue to have the same problem.
- Select File >> Disconnect.
- Select File >> Connect to Data Feed.
- Once the above is done, in the case of an Intraday chart, follow the procedure to Delete Intraday Data File to delete the data file for the Symbol with the incorrect letter case. This is an essential step.
When Intraday Data Files Are Updated
Data is downloaded to an Intraday chart data file and current trade data is written to the file only when the chart data file is open or the symbol is added to the Intraday File Update List.
Select Global Settings >> Intraday File Update List on the menu to add files to this list.
If the Data or Trading service Sierra Chart is connected to does not provide streaming real-time or delayed data, then Intraday charts will not automatically be kept up-to-date. This applies to the Sierra Chart Historical Data service . You will need to select File >> Disconnect and File >> Connect to Data Feed to cause a historical data download for the Intraday charts so they will be up-to-date.
Not all symbols from a Data or Trading service will provide historical and real-time volume data. This would include some cash indexes and the Forex markets. Futures and stock markets will provide historical and real-time volume data.
If a Data or Trading service provides historical volume data for a particular symbol, then it will be available in real-time also for that same symbol.
If the Data or Trading service does not provide historical volume data, then it will not be available in real-time either.
In the case where there is no historical volume data available either historically or in real-time, Sierra Chart will set the volume to 1 for every trade received in real-time. Or in the case of the Forex markets, for every Bid and Ask price received in real-time. This is commonly known as Tick Volume.
When using the Sierra Chart Real-Time and Historical Forex/CFD Data Service and other Forex Data/Trading services, the volume data is Tick Volume where each new Bid and Ask price update received causes the volume to be incremented by 1.
It is a substitute for the lack of actual volume data. Although, it is not true volume data.
In the case where Sierra Chart is using 1 for volume on the price data received in real-time, you will not see any volume data at all for the bars in the chart downloaded from historical data unless the data comes from the Sierra Chart historical data servers which will be the case for the Sierra Chart Real-time and Historical Forex/CFD Data Service and the Sierra Chart Real-time and Historical Exchange Data Feed.
Bid Volume and Ask Volume
Throughout the Sierra Chart documentation and functionality you will see references to Bid Volume and Ask Volume.
Bid Volume is the volume of trades that occurred at the Bid price or lower. Usually this is in relation to the volume for a chart bar.
Ask Volume is the volume of trades that occurred at the Ask price or higher. Usually this is in relation to the volume for a chart bar.
In the case where the trade occurs between the Bid and Ask, it is considered to be at the Bid price, if it traded lower than the price before. Or if it traded at the same price as before, then when looking back through trades, the last time there was a trade at a different price, that trade was down compared to the previous price. The opposite is true if a trade occurs at a higher price and is between the Bid and Ask prices. It will be considered at the Ask if it traded higher than the previous price.
Bid Volume and Ask Volume only are available for Intraday charts. Not for Historical Daily charts.
Bid Volume and Ask Volume volume is not always available historically with all supported Data and Trading services. For more information, refer to Historical Bid Volume and Ask Volume.
In the case of the Forex markets where there are only Bid and Ask prices and not last trade prices, Bid Volume and Ask Volume are determined by comparing the midpoint price, the price between the Bid and the Ask, to the prior midpoint price. If the midpoint price increases, then this is considered an Ask trade and Ask Volume is incremented by 1. If the midpoint price decreases, then this is considered a Bid trade and the Bid volume is incremented by 1.
The determination of Bid Volume and Ask Volume with Data/Trading services that only transmit the Bid price as the last trade price, is not going to be accurate. Most if not all of the volume will be assigned to Bid Volume. This would be true with IQ Feed and OEC. This is not the case with the Sierra Chart Real-Time and Historical Forex/CFD Data Service.
Simulate Trades to Match Daily Volume
For Interactive Brokers, there are simulated trades generated by Sierra Chart in response to Daily Volume messages received from the data feed which are used to make up for missing trades not transmitted by the data feed.
Daily Volume messages for a symbol sent by the data feed indicate the total Daily Volume for the trading day at the current moment. These are frequently sent messages. They may be sent with every trade or sent every few seconds.
When a Daily Volume message is received from the data feed, Sierra Chart calculates the difference between this Daily Volume message and the prior Daily Volume. If the sum of the volumes for the insectionidual trades received since the prior Daily Volume message is less than that needed to match the current Daily Volume message, then a simulated trade is generated with the volume needed to fill in the difference. The price of this simulated trade, is the last trade price received. The volume of this simulated trade, is the quantity of the difference as explained.
This inserted trade will be considered to be at the Bid price if the price of the simulated trade is at the current Bid price or lower. Or it will be considered to be at the Ask price if the price of the simulated trade is at the current Ask price or higher. If it is considered at the Bid, then the volume will be added to the BidVolume for the data record. If it is considered to be at the Ask, then the volume will be added to the AskVolume for the data record.
When using the Interactive Brokers Trading service, this functionality to simulate a trade in order for the Intraday chart volume to match the Daily Volume messages, has shown to cause volume spikes in Intraday charts. Therefore, this can be disabled for Interactive Brokers. To disable this, uncheck Global Settings >> Data/Trade Service Settings >> More Interactive Brokers Settings >> Simulate Trades to Match Daily Volume.
Deleting and Re-Downloading Data for Multiple Charts
To delete and re-download data from a particular Date-Time for multiple charts, follow the steps below.
- Select Global Settings >> Customize Chart Shortcut Menu.
- Add the Delete and Download Data-All Charts command to the Selected Menu Items list.
- Press OK.
- Go to a chart and right-click at the Date-Time in the chart where you want to delete and re-download data from.
- Select the Delete and Download Data-All Charts command on the menu.
- Press Yes to confirm. The data will be deleted from that Date-Time in all of the currently open charts and the data will be downloaded if connected to the data feed.
Locating Missing Data in Charts
There can be various reasons why data is missing from Historical or Intraday charts. It is more likely that Intraday charts are affected and much less likely that Historical charts are affected. Follow the instructions below to locate missing data in charts, whether they are Historical or Intraday charts.
- Go to the chart.
- Select Chart >> Chart Settings >> Advanced Settings.
- Enable Include Columns with No Data. Press OK.
- When you have enabled the Include Columns With No Data option, this will insert bars where there is no data in the chart data file for the Date-Time of those inserted bars. The open, high, low, close will all be the same price. These bars will have the same price as the previous closing price. These bars help you to clearly spot where there is missing data in the chart.
- Use the Tools >> Chart Values Tool tool and the Window >> Tool Values Window to look at the Date-Times of the bars which have been inserted with the Include Columns With No Data option. The Date-Times of these bars is where you have missing data, assuming there was actually trading at those particular Date-Times. Therefore, you must be familiar with the particular market you are trading in order to confirm this.
In the case of Intraday charts, there will not be bars inserted for entire days which are missing. This is something to keep in mind.
- Select Chart >> Chart Settings >> Advanced Settings .
- Disable Include Columns with No Data. Press OK.
- Once you have located that there is missing data, then you can re-download it by right clicking with your pointing device before the missing data in the chart and select Delete and Download Data or select Edit >> Delete All Data and Download to re-download all the data in the chart.
Large Volume Trades
This section provides a discussion of why large volume trades cannot be identified and when they are identified, they do not have any definite significance.
- First and foremost, a large trade does not fill all at once. An order for 100 contracts likely will fill in many smaller orders as it is matched with smaller orders. It is unlikely that there is going to be a matching 100 contract order to fill it. Therefore, the activity of large traders, simply cannot be tracked. Combining trades of the same side, the same time and same price is also not a reliable means to detect a large trade.
- Since a large trade matches up with multiple smaller orders, there can be different fill prices which makes the ability to detect these types of trades even more difficult and impossible.
- A large trader most likely will enter a series of smaller orders. For example, if they want to sell 100 contracts, they can enter 100 orders of 1 lot each very simply using a computer algorithm. This could be part of a high-frequency trading strategy. Making it impossible to even identify the large order to begin with. And as we indicated in the previous items, it is still not possible to reliably identify a large order.
- You have no idea why a large trader is entering the order that they are. It is not a predictive of short-term price movement. There can be numerous reasons.
- For every order there is both a buyer and a seller. So in the case where you see a large order go through, what does it mean? Can you answer this question definitively? If not, then obviously the trade in and of itself, does not mean much of anything.
- You have no idea as to the timeframe the large trader is trading in. It could be 5 minutes, or it could be 3 months. Although in the short-term, a position they put on may be a loss, it could be a profit over a longer timeframe.
- The trade could be part of a hedge. They could be taking an opposite trade in some other market.
- The exchange, the data feed, or the program you are running, could be combining multiple trades into one making it seem as though there was a large trade, when there was not. For example, when using Interactive Brokers and you have enabled Global Settings >> Data/Trade Service Settings >> Simulate Trades to Match Daily Volume (we recommend this be enabled), you will see large trades appear in the Time and Sales occasionally, which are not actually high-volume trades but an insertion of volume to make the Intraday volume match the Daily reported volume. This is necessary with the Interactive Brokers data feed. Otherwise, you would notice the trading activity in the chart to be sparse.
- In summary, relying upon large trades, does not come across as reliable and is misleading. Traders who pay attention to large trades as being meaningful in the futures market, generally are going to be inexperienced traders who do not know how the markets work. Additionally, the concept of identifying large trades is based upon the idea that a large trader is "smart" and knows what is going to happen in the future. Nobody can definitively predict the future unless they are planning something at a future point in time to move the market. They very well could be planning to move the market and are part of an organization with large sums of money, most likely banks, which are capable of moving the market. The problem is, it is not possible to identify their activity to begin with, at least not always, and exactly when that move will occur.
Instead of paying attention to large trades, we recommend using the Cumulative Delta Bars studies found in Analysis >> Studies. These studies provide an objective analysis of buying pressure and selling pressure over a period of time.
Also, it would seem to be more useful to be looking at increases in volume over a period of time and the direction the market is moving in during that increase. What exactly this means, is not the purpose of this discussion. This is up to you to determine and to determine if this is even useful to begin with.
Cleaning Up Old and Unused Symbols for Efficiency
To avoid market data requests and historical data downloading for symbols that you no longer use or have expired, it is a good idea to clean them up from your Sierra Chart Chartbooks and other features of Sierra Chart which contain symbols. Follow the steps below to do this.
- Select Window >> Windows and Chartbooks on the menu. From this window look at each Chartbook and see if there is a chart for an old/unused symbol.
If there is, then select it and press OK. This will activate the chart. To remove the chart from the Chartbook, select File >> Close Active Window on the menu. Repeat this step until you no longer find any charts for old/unused symbols.
- Look among the Quote Boards and remove any old/unused symbols through Settings >> Set Symbols on the Quote Board menu. If you cannot see a Quote Board and you know that you have one within the current open Chartbook, then you can set it to a default position by selecting Window >> Reset Windows.
- Select Global Settings >> Intraday File Update List. Remove any old/unused symbols from that list.
- Select Window >> Alerts Manager . Select the Symbol Alerts tab. Right-click your Pointer on the lines for any old/unused symbols and select Delete.
- Select File >> Disconnect.
- Select File >> Connect to Data Feed. This will cause Sierra Chart to no longer track the old/unused/expired symbols which you have removed with the steps above.
Completeness of Bar Data and Volume in Chart
The completeness of the chart bars and volume in a chart depends upon the particular Data/Trading service being used, the symbol and the particular point in time the chart bar is for.
In the case of a futures contract, the data at a particular point in time for a chart bar and the volume for that bar depends upon the contract month and year, and whether that particular contract is actively traded at that time.
Also, a futures contract which is just not actively traded at any time, will contain much less data compared to an actively traded futures contract.
For an actively traded futures contract, to ensure that for every bar in the chart you are looking at the most active contract year and month and see complete data, use the Continuous Futures Contract feature.
Reducing Number of Symbols Being Tracked by Sierra Chart
When connected to the real-time data feed in Sierra Chart, Sierra Chart will begin real-time streaming data updates for the symbols in Charts, Trade DOMs, Quote Boards, Quote Spreadsheets, the Intraday File Update List, and Symbol Alerts.
If a symbol is no longer being used in one of these objects or the object has been closed, Sierra Chart will continue to track that symbol until you reconnect to the data feed.
Tracking too many symbols can cause a problem where when you have a symbol limit with the real-time data feed being used, that you end up exceeding the symbol limit.
When the symbol limit has been exceeded, you need to reduce the number of symbols being currently used.
This involves any of the following:
- Closing Chartbooks.
- Closing Charts.
- Closing Trade DOMs.
- Closing or reducing the number of symbols in Quote Boards.
- Closing or reducing the number of symbols in Quote Spreadsheets.
- Reducing the number of symbols in the Global Settings >> Intraday File Update List.
- Removing Symbol Alerts from the Window >> Alerts Manager >> Symbol Alerts.
When you have completed any of the above, follow the instructions to Reconnect to the Data Feed to reduce the number of symbols subscribed to with the real-time data feed.
The Meaning of the [M] Designation after a Symbol
On the title bar of the chart, in the Region Data Line and other places where a Symbol is displayed, the Symbol may have a [M] designation after it.
This means that Symbol is remapped to an alternate data feed. Sierra Chart supports multiple data feeds with separate connections. The letter M is from the word map.
*Last modified Friday, 12th August, 2016.