📓

Trade Metrics Guide

ziiiggy.com
image

Overview

While Sierra Chart offers detailed trade logging, many traders will export data for further analysis.

For tracking trade metrics either export data from Sierra to another app or service, OR use a service that can connect to Sierra Chart (or your data/broker trade data).

Pasting into Excel or Google Sheets is common. There are a small handful of Sierra Chart trade analyzers available, however it’s “easier” to paste or connect into a journaling platform. At the time of this publishing the creator doesn’t have one public, but check the website HERE if it’s been added.

Trade Log Overview

The majority of trading performance metrics are accessed through the Sierra Chart Trade Activity Log.

  • Title Bar: Trade > Trade Activity Log

Trades Tab: Select Date Range, Accounts, P/L Format, and any additional settings to view a list of all trades. Simulated trades can be viewed as well. Once Trades tab is selected Hit Edit > Flat to Flat Display for Trades List

Statistics Tab: Shows a summarized snapshot of trading performance metrics

Edit title: Used for manually exporting data from various tabs. Also, make sure to refresh the log if figures don’t appear correct.

AccStats: Shows account stats by symbol for the specified date range, counts trades, and quantity filled

Trade Log Export

The majority of trading performance metrics are accessed through the Sierra Chart Trade Activity Log.

Statistics overview, trades, trade activity, and account performance can be viewed and exported.

To get started:

  • On title bar hit Trade > Trade Activity Log
  • Click the tab of desired trading data to export. Commonly use [*Trades]
  • Click Edit on title bar, select Copy All
  • The data is now on the clipboard, and can be pasted anywhere else, such as Excel

Tip: If the data pastes all into one cell, the data needs to “Text to Columns” in Excel.

  1. Select the cell with all data
  2. Click Data tab in Excel
  3. Text To Columns, and delimit by “,” (comma, as the format is CSV)
  4. Apply

Real Time Metrics - 3 Options

  1. Title bar: Trade > Trade Orders Window , and Trade Positions Window. This shows order and position info live
  2. Use studies on chart graphs. Open the Chart Studies window on any chart, and select studies such as: Daily Profit/Loss, Profit/Loss Text, Maximum Drawdown, Position Average Price
‣
See Image (Click Arrow)
  1. DTC Protocol Server (Advanced)

Trade Log Files

Trades are saved in a file:

User/SierraChart/TradeActivityLogs folder

Creating a Custom Daily Profit and Loss Equity Chart

It is possible to have custom equity charts within Sierra. Candlesticks, lines, and more.

  • Title Bar: Global Settings > Symbol Settings
  • New
  • Type any name “Equity_Curve”
  • OK

Now open up any chart or create a new one

  • Title Bar: Chart Settings > [Symbol] Tab > Symbol
  • Change the value to the newly created symbol “Equity_Curve”
  • Switch to the [Bar Period] tab
  • Change the Value for Chart Data Type to Historical Chart
  • OK
  • Title Bar: Edit > Edit Data - Historical Chart
  • Paste in values. These must be derived yourself either using something like Excel or within Sierra Chart.

IT IS CRITICAL TO LEAVE A BLANK LINE AT THE BOTTOM OF THE NOTEPAD ++ FILE EDITOR. USE RETURN KEY TO ADD AN EXTRA LINE

  • Title Bar: Edit > Reload and Recalculate (or ‘Insert’ button shortcut)

Note: When changing settings for the Equity Curve symbol, consider selecting Custom Symbols. Ensure the Custom button is selected and has a name.

Note: The Historical Chart uses the following parameters when graphing data, pasted in a string:

  • Open
  • High
  • Low
  • Close
  • Volume
  • Open Interest

Example of 1 row:

2022/04/20, 5000, 5100, 4090, 5050, 1, 1

[Open, High, Low, Close, Volume, Open Interest]

◀️Previous Module: 🔢Create & Optimize a DOM

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.