Sierra Chart - P/L After Commissions spreadsheet
futures io

Categories Help    

Sierra Chart
Sierra Chart Downloads / Sierra Chart Studies

P/L After Commissions spreadsheet 4 *
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
-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.

-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 
Suggest other entries I might like
Details: P/L After Commissions spreadsheet
Category: Sierra Chart 

September 14th, 2012
Size: 7.26 KB
Downloaded: 277 times


Copyright © 2022 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada),
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.