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
>
Daily P/L 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
Daily P/L spreadsheet
Overview:
Works on SC version 877 and later. Might work on some earlier versions.
This spreadsheet study calculates 12 Profit/Loss data, 6 based on the Last price, and 6 based on the Bid (if long) and Ask (if short). These are the 12:
-Currency
-Points
-Points - ignore quantity
-Ticks
-Ticks - ignore quantity
-Currency - after commissions
-Currency (bid/ask)
-Points (bid/ask)
-Points - ignore quantity (bid/ask)
-Ticks (bid/ask)
-Ticks - ignore quantity (bid/ask)
-Currency - after commissions (bid/ask)
You can option it to calculate either the Open P/L (SC's 'P/L' in the trade window) or the Open + Daily Closed P/L (SC's 'Net P/L' or 'NPL'). It does not calculate only the Daily Closed P/L (SC's 'Daily P/L' or 'DPL').
-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 12 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 >>
DailyPL-
-When asked 'Clear existing studies on chart?' , choose No.
-On the spreadsheet, in cell J1, enter 'y' to add the Daily Closed P/L to the Open P/L, or enter 'n' for only the Open P/L.
-On the spreadsheet, in cell J2, enter your round trip commissions.
-It is recommended that you use the DailyPL-.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.
Category
Sierra Chart
Details:
Daily P/L spreadsheet
Category:
Sierra Chart
September 2nd, 2012
Size: 22.45 KB
Downloaded: 210 times
1262
tomgilb
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