Using Text/CSV Data For Charts
Sierra Chart can chart historical Daily and historical Intraday data files that are in a Text/CSV (comma separated values) format. This is the type of data to use if you require just Historical Daily charts or Intraday charts that do not continuously update and you would like to use an alternative data source than our integrated services. By using this type of data you are able to use data from any source. You can create data files yourself as well. The format is described on our Text/CSV Data Format documentation page.
The instructions below are only general guidelines. You will need to modify them for your specific case and external data software/source you are using.
- If you are using a service provider that provides Text/CSV data and a software program to download that data, then install your Text/CSV data provider's software on your computer following their instructions.
If you are creating your own data files, then refer to the Text/CSV Data Format page for the format and instructions. In this case, to open these files, continue with step number 4.
- Set your data providers software to format the Text/CSV data as required by Sierra Chart. The general Text/CSV format is as follows: Date, Time (Only needed for intraday data.), Open, High, Low, Close, Volume, Open Interest. See the Text/CSV Data Format documentation page for complete information.
- Set your data provider's software to create and maintain the files for each symbol in the Sierra Chart Data folder. Usually this is c:\sierrachart\Data on your disk drive. To view or change the Data Files Folder, select Global Settings >> General Settings on the Sierra Chart menu. Set your data provider's software to use a ".txt" extension for the chart data files. Other common extensions are supported as well.
- To open your Text/CSV data files, select File >> New/Open Historical Chart on the Sierra Chart menu to open and chart the files. You will want to use this command whether you have historical daily or historical intraday data. The symbols you downloaded data for using your data provider's software will be listed in this window. Just select the symbol and press the Open button. If you want to chart a new symbol that you do not have data for, then you need to go into your data provider's software, add the symbol there, and get data for it before opening it in Sierra Chart.
- For complete instructions to get started using Sierra Chart, see the Getting Started documentation page.
- Whenever your data files are updated at the end of the day or at any other time, you can load the new data into the charts that are currently open in Sierra Chart by selecting Edit >> Reload All Charts on the Sierra Chart menu.
*Last modified Friday, 12th August, 2016.