Sierra Chart - P/L After Commissions spreadsheet

Categories

Show

Help

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

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: 277 times