⌛

Export Bar and Study Data

ziiiggy.com

Contents:

Export Chart and Study Data for Backtesting

Multiple methods available, I will demonstrate #1 and #2:

  1. Standard export method from title bar
  2. Using study “Write bar and study data to file”
  3. ACSIL

Standard Export:

  • Select the chart to export data from
  • Title Bar: Edit > Export Bar and Study Data to Text File
  • A window pops up. Type a name under File Name or leave it as is
  • Press Save
  • A Notepad ++ window will pop up
  • Click anywhere in the text and hit Ctrl + A then Ctrl + C to select all then copy to clipboard (or Title Bar: Edit > Select All > Edit > Copy)
  • Paste where needed. Excel for example

Tip: When pasting CSV data into Excel. It may all paste into 1 cell. If this occurs follow these steps:

  • Click the cell with all the data
  • Switch to Data tab in Excel
  • Click Text to Columns button
  • Select Delimited, click Next
  • Select Comma, click Next
  • Click Finish

Export Data Using a Study (Refreshes Automatically)

Using this study, data and studies from the chart will save in a CSV file automatically. This is not real time data. This updates happen as the same time frame the chart is set to itself. Example 5 minute chart should update the CSV every 5 minutes.

To get started:

  • Select the chart to export data from
  • Title Bar: Analysis > Studies > Write Bar and Study Data To File > Add
  • With the Chart Studies window still open, click the Write Bar and Study Data To File study
  • Press the Move Down button until the study is all the way to the lowest study, it should not be first
  • Now hit Settings (for the Write Bar… study)
  • Input Value for Path and File name needs a name, using “export-1” for example

Now, it’s time to switch over to the User/SierraChart/Data folder:

  • Right click anywhere in the folder
  • Hover on New
  • Select Text Document to create a new text document in the Data folder
  • Change the name to “export-1.csv” or whatever name you set from Sierra Chart, it must end in CSV

All setup! Data from the chart with the study applied will download to that file. It’s likely the desire is to send that to Excel.

(optional)

  • Open Excel, a new sheet
  • Switch to Data tab
  • Click From Text/CSV
  • Find the CSV file that was just saved to the User/SierraChart/Data folder, press Open
  • Press Load, or if there is data to be transformed then click Transform Data and make those changes

Tip: To refresh, setup an auto-refresh or press Refresh All under the Data tab of Excel

Excluding Studies or Subgraphs From Export

It’s possible to exclude entire studies, or just specific subgraphs within the study, as sometimes not all are needed.

To exclude entire study:

  • Title Bar: Analysis > Studies (or click Studies on Control Bar)
  • Select by clicking the desired study to hide
  • Click Settings
  • Un-check Include in Spreadsheet

    • (Check the Hide Study box to hide the study)

To exclude specific subgraphs of study:

  • Title Bar: Analysis > Studies (or click Studies on Control Bar)
  • Select by clicking the study that contains the desired subgraph to exclude
  • Click Settings
  • Switch to the Subgraphs Tab
  • Select the desired subgraph to hide from the list of subgraphs
  • Switch Draw style to Hidden
  • Uncheck Include in Spreadsheet box

◀️Previous Module: ⌛Backtest Signals Guide

▶️Next Module: ⌛Replay Feature

Back To Handbook Home

📊Sierra Chart Master Handbook - Unofficial

Please be aware that the information contained in this handbook is not intended to be and should not be taken as financial advice. The creator is not a financial advisor and the materials provided should not be relied upon in making any financial decisions. Any actions taken based on the information contained in this handbook are taken at the reader's own risk and the creator will not be held liable for any losses or damages resulting from such actions.

In addition, the creator is not a registered broker or financial advisor in the United States and the materials contained in this handbook do not constitute financial advice or a recommendation to buy or sell any financial instrument. The creator does not endorse or recommend any particular investment strategy and the reader should not rely on any information contained in this handbook as the basis for making any investment decisions.

Furthermore, past performance is not indicative of future results and the reader should be aware that trading futures, crypto, stocks, and NFTs carries a high degree of risk and the possibility of significant losses. The reader should carefully consider their financial situation and seek independent financial advice before making any investment decisions.

The creator of this handbook is not an expert and the materials contained within are provided for educational and entertainment purposes only. No material contained in this handbook suggests a specific method or strategy for investing or trading, and under no circumstances should anything contained in this handbook or any related materials be considered as financial advice.

Please also be aware that some pages within this handbook may contain affiliate links that pay the creator a small commission at no additional cost to the reader. The inclusion of these links does not constitute a recommendation or endorsement of the products or services being advertised and the reader should carefully evaluate the suitability of any product or service before making a purchase.

By accessing and using the materials contained in this handbook, the reader acknowledges and agrees to the terms of this disclaimer and releases the creator from any liability for financial losses or damages resulting from the reader's use of the materials contained within. It is possible to lose more than the value of a trading account. Nothing within this handbook is advice or a recommendation to the reader. Any damages or losses following changes the reader makes to Sierra Chart after reading material within this handbook the creator should not be held liable. This handbook is NOT created by Sierra Chart and is not an official handbook to Sierra Chart. Each purchase only grants the user associated with the email provided on checkout for lifetime access. Trading is risky.