Username or Email
Password
Forgot
New User Signup (free)
Browse
Register
Downloads / Indicators
Trading Webinars
Articles
Upgrade to Elite
Unanswered Posts
My Posts
Return to Homepage
Today's Posts
Trading Reviews and Vendors
Futures Brokers Reviews
Traders Hideout (general)
Platforms and Indicators
Trading Journals
Elite Trading Journals
Psychology and Money Management
Off-Topic
The Elite Circle
Trading Articles
Main Trading Articles Index
Article Categories
Help, Tutorials, How-To's
Traders and Trading Methods
Platforms, Tools and Indicators
Terms (Glossary)
Article Tools
List New Articles
List Recent Article Changes
Random Article
Most Popular Articles
Category Groupings
Wanted Articles
Most Linked to from Forum
Go to Page...
Quotes
by TradingView
futures io
>
Downloads
>
Sierra Chart
>
P/L After Commissions spreadsheet
Categories
Show
Search
Help
Search
title and description
keywords
Advanced Search
Winning nominations
What's Hot
What's New
New Ratings
Some Random Entries
Home Category
Up a Level
Sierra Chart
Sierra Chart Downloads / Sierra Chart Studies
Filter
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
0
1
2
3
4
5
6
7
8
9
Entries
Login to Download
P/L After Commissions spreadsheet
Overview:
Built in 892, but should work in some earlier versions.
This spreadsheet calculates your profit/loss after commissions, based on 3 data:
Daily PL
Net PL
OpenPL
-The calculation subtracts the full round trip commission per contract, even if you still have a position open.
-This is a standalone study that does not require any other studies for its calculations, but it is intended to be used with the
Text (Large) Display for Study
study, so that you can display any/all of the 3 values anywhere in the chart region. The chart in the pic is only an example.
Instructions:
-Unzip the attached file, put the contents in your Sierra Chart \data folder.
-Focus your chart, click on Analysis >> PL After Comm-
-When asked 'Clear existing studies on chart?' , choose No.
-Enter your round trip commissions in cell J2.
-It is recommended that you use the PL After Comm-.StdyCollct file because it loads the correct spreadsheet study and contains the correct settings.
-This spreadsheet study uses the Spreadsheet System for Trading study because it the only study that has the required outputs. To assure that it does not cause erroneous entries, autotrading has been disabled in cell J28. Furthermore, do not put any formulas in columns K,L,M,N.
Update: You may instead want to consider using the
Trading: Profit/Loss Text
study now that it has the option to deduct commissions from the DPL, NPL, and OpenPL. However, it does not subtract the full round trip commission per contract when you still have a position open.
Category
Sierra Chart
Details:
P/L After Commissions spreadsheet
Category:
Sierra Chart
September 14th, 2012
Size: 7.26 KB
Downloaded: 255 times
1268
tomgilb
View Download Details
December 3rd, 2014 12:02 AM
Japhro
Interesting idea, nice risk management tool. Thanks!
Category
The Elite Circle
NinjaTrader
- NinjaTrader 8 Indicators and More
- NinjaTrader 6.5 Indicators
- NinjaTrader 7 Indicators
- NinjaTrader 6.5 Strategies
- NinjaTrader 7 Strategies
- NinjaTrader 6.5 Templates
- NinjaTrader 7 Templates
- NinjaTrader 6.5 Miscellaneous
- NinjaTrader 7 Miscellaneous
MetaTrader
- MetaTrader 4 Indicators
- MetaTrader 5 Indicators
TradeStation
MultiCharts
ThinkOrSwim
Sierra Chart
FXCM Strategy Trader
Matlab Functions
Educational
Free Section
True Edge Awards / Best Products
Trading Webinars How-to's
Trading Reviews & Products
Futures Broker Reviews
NinjaTrader Brokerage (Broker)
NinjaTrader Indicators to Download
Kinetick (Data Feed Provider)
IQFeed (Data Feed Provider)
Bookmap (Trading Software)
NinjaTrader (Trading Platform)
Topstep (Prop Trading)
SharkIndicators (Trading Software)
Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432,
info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us
-
Contact Us
-
Site Rules, Acceptable Use, and Terms and Conditions
-
Privacy Policy
-
Downloads
-
Top