Login Page - Create Account

Support Board


Date/Time: Thu, 13 Feb 2025 14:05:50 +0000



Post From: Trade activity log (Statistics Tab) safe as excel file

[2020-12-06 19:43:04]
Sierra Chart Engineering - Posts: 104368
To save the data from the Trade Statistics tab follow the instructions here:
Trade Activity Log: Saving to a Text File

This is an example of what you will get:
Trade Statistics  First Fill  Last Fill  Daily Date
[Sim]All Symbols  2020-12-03 14:36:06  2020-12-03 14:36:16  2020-12-03
All Accounts
Currency Value (C)
  All Trades  Long Trades  Short Trades  Daily Trades
Closed Trades Profit/Loss  -5.00  -5.00  0.00  -5.00
Closed Trades Total Profit  0.00  0.00  0.00  0.00
Closed Trades Total Loss  -5.00  -5.00  0.00  -5.00
Profit Factor  0.00  0.00  0.00  0.00

Equity Peak  0.00  0.00  0.00  0.00
Equity Valley  -5.00  -5.00  0.00  -5.00
Maximum Runup  0.00  0.00  0.00  0.00
Maximum Drawdown  -5.00  -5.00  0.00  -5.00
Maximum FlatToFlat Trade Open Profit  0.00  0.00  0.00  0.00
Maximum FlatToFlat Trade Open Loss  -5.00  -5.00  0.00  -5.00
Average Trade Open Profit  0.00  0.00  0.00  0.00
Average Trade Open Loss  -5.00  -5.00  0.00  -5.00
Average Winning Trade Open Profit  0.00  0.00  0.00  0.00
Average Winning Trade Open Loss  0.00  0.00  0.00  0.00
Average Losing Trade Open Profit  0.00  0.00  0.00  0.00
Average Losing Trade Open Loss  -5.00  -5.00  0.00  -5.00
Maximum Trade Open Profit  0.00  0.00  0.00  0.00
Maximum Trade Open Loss  -5.00  -5.00  0.00  -5.00
Highest Price During Positions  0.0  0.0  0.0  0.0
Lowest Price During Positions  0.0  0.0  0.0  0.0
Total Commissions  0.00  0.00  0.00  0.00

Total Trades  1  1  0  1
Total FlatToFlat Trades  1  1  0  1
Total Filled Quantity  100  100  0  100
Percent Profitable  0.00%  0.00%  0.00%  0.00%
FlatToFlat Percent Profitable  0.00%  0.00%  0.00%  0.00%
Winning Trades  0  0  0  0
Winning FlatToFlat Trades  0  0  0  0
Losing Trades  1  1  0  1
Losing FlatToFlat Trades  1  1  0  1
Long Trades  1  1  0  1
Long FlatToFlat Trades  1  1  0  1
Short Trades  0  0  0  0
Short FlatToFlat Trades  0  0  0  0

Average Trade Profit/Loss  -5.00  -5.00  0.00  -5.00
Average FlatToFlat Trade Profit/Loss  -5.00  -5.00  0.00  -5.00
Average Winning Trade  0.00  0.00  0.00  0.00
Average FlatToFlat Winning Trade  0.00  0.00  0.00  0.00
Average Losing Trade  -5.00  -5.00  0.00  -5.00
Average FlatToFlat Losing Trade  -5.00  -5.00  0.00  -5.00
Average Profit Factor  0.00  0.00  0.00  0.00
Average FlatToFlat Profit Factor  0.00  0.00  0.00  0.00

Largest Winning Trade  0.00  0.00  0.00  0.00
Largest FlatToFlat Winning Trade  0.00  0.00  0.00  0.00
Largest Losing Trade  -5.00  -5.00  0.00  -5.00
Largest FlatToFlat Losing Trade  -5.00  -5.00  0.00  -5.00
Largest Winner % of Profit  0.00%  0.00%  0.00%  0.00%
Largest FlatToFlat Winner % of Profit  0.00%  0.00%  0.00%  0.00%
Largest Loser % of Loss  100.00%  100.00%  0.00%  100.00%
Largest FlatToFlat Loser % of Loss  100.00%  100.00%  0.00%  100.00%

Max Consecutive Winners  0  0  0  0
Max Consecutive Losers  1  1  0  1

Average Time In Trades  0:10  0:10  0:00  0:10
Average Time In Winning Trades  0:00  0:00  0:00  0:00
Average Time In Losing Trades  0:10  0:10  0:00  0:10
Longest Held Winning Trade  0:00  0:00  0:00  0:00
Longest Held Losing Trade  0:10  0:10  0:00  0:10

Total Quantity  50  50  0  50
Winning Quantity  0  0  0  0
Losing Quantity  50  50  0  50

Avg Quantity Per Trade  50.00  50.00  0.00  50.00
Avg Quantity Per FlatToFlat Trade  50.00  50.00  0.00  50.00
Avg Quantity Per Winning Trade  0.00  0.00  0.00  0.00
Avg Quantity Per FlatToFlat Winning Trade  0.00  0.00  0.00  0.00
Avg Quantity Per Losing Trade  50.00  50.00  0.00  50.00
Avg Quantity Per FlatToFlat Losing Trade  50.00  50.00  0.00  50.00
Largest Trade Quantity  50  50  0  50
Largest FlatToFlat Trade Quantity  50  50  0  50
Maximum Open Position Quantity  50  50  0  50

Last Trade Profit / Loss  -5.00  -5.00  0.00  -5.00
Last FlatToFlat Trade Profit / Loss  -5.00  -5.00  0.00  -5.00
Expectancy  -5.00  0.00  0.00  0.00

Number of Open Trades  0
Open Trades: Open Quantity  0
Open Trades: Average Entry Price  0.0

This is a file which contains tab separated values and can be open in any spreadsheet program.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2020-12-06 19:47:15