Sierra Chart
futures io


Categories Help    

Sierra Chart
Sierra Chart Downloads / Sierra Chart Studies


Sort by

Show full/short entries Entries
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.
 
Suggest other entries I might like
Details: Daily P/L spreadsheet


September 2nd, 2012
Size: 22.45 KB
Downloaded: 215 times
Fibs of Pivots spreadsheet, v2b 4 *
Overview:
-Works on SC versions in the 800s and later. Should also work in earlier versions. Does not currently work in the New Spreadsheets version.
-This Sierra Chart spreadsheet study draws 5 fibs between pivots.
-It only uses whole pivots, no mid pivots.
-It displays 3 sets of 5 fibs; the middle set is between the pivots with the current price, the upper set is above the next upper pivot, the lower set is below the next lower pivot.
-The 3 sets will move together with the current price which will always be somewhere in the middle set.
-It will only draw the fibs of pivots for the current period. There are no historical fibs drawn. If you want to see historical fibs, scroll the chart into the past and go to Chart >> Replay Chart.
-When price is between R3 and R4 (or between S3 and S4), fibs will not display above R4 (or below S4). If price is above R4 (or below S4), no fib lines will display at all.

Instructions:
-Unzip the attached file, put the contents in your Sierra Chart \data folder.
-Focus your chart, click on Analysis >> Fibs of Pivots v2b-
-When asked 'Clear existing studies on chart?' , choose No.
-If necessary, add a pivot points study to your chart and, if you are NOT using another spreadsheet study on your chart, move the pivot points study to the first position in the Studies to Graph list.
-If you ARE using another spreadsheet study on your chart, do not move the pivot points study to the first position in the Studies to Graph list. Instead you'll have to locate the correct columns for each pivot then carefully and accurately edit the following cells to reference the pivots accordingly, using a row 3 reference of each column:
H11 = R4
H12 = R3
H13 = R2
H14 = R1
H15 = PP
H16 = S1
H17 = S2
H18 = S3
H19 = S4
-You can edit the values in cells H4-H8 to your fib% preferences, but each value should mirror the opposite %, as follows (see spreadsheet for example):
H4=1-H8
H5=1-H7
H6 should stay 50%
H7=1-H5
H8=1-H4
-It is recommended that you use the Fibs of Pivots v2b-.StdyCollct file because it loads the correct spreadsheet study and contains the correct settings.
-If you only use the Fibs of Pivots v2b.scwbf file, add the Spreadsheet Study study, name it Fibs of Pivots v2b in the Spreadsheet Name field, set the Chart Region to 1, set the Scale to Same as Region, check Draw Study Underneath Main Price Graph, set the Chart Data Output Sheet Number to 1, and move your Pivot Points study to the top of the Studies to Graph list.
 
Suggest other entries I might like
Details: Fibs of Pivots spreadsheet, v2b


August 30th, 2012
Size: 46.64 KB
Downloaded: 221 times
Ktrader Sierra Extensions 5 *
3 small extensions for sierra:

- Remove Account Number from a trading dom
- Remove menu/scroll when a chart window looses focus
- Display Opening High/Low, for a userdefines timeperiod (the image is a screenshot of this)

The zip files contains both a compiled dll and the source.

To compile the source you will need to setup include and library path for the windows api. (or build with Visual StudioI
 
Suggest other entries I might like
Details: Ktrader Sierra Extensions


June 10th, 2012
Size: 11.25 KB
Downloaded: 184 times
High Volume At Price 5 *
Version 1.0

This study shows the price that had the highest volume within each bar.

Requires Sierra Chart 834 minimum.
 
Suggest other entries I might like
Details: High Volume At Price


May 21st, 2012
Size: 1.74 KB
Downloaded: 885 times
Perrys Method - this is Perry of BMT fame 5 *
Updated to V1.3 - SORRY - I forgot to include the Spreadsheet file in zip file
this is a Sierra Chart spreadsheet for Trading that incorporates Perry's method. see this thread and post #856 - . Perry also did a webinar on Aug 30, 2011 that is in the Elite section. I have attached the files to incorporate into your Sierra Chart Data folder. All indicators used are standard Sierra Chart issue. For novice sierra charts users, I included a how to document
 
Suggest other entries I might like
Details: Perrys Method - this is Perry of BMT fame


October 24th, 2011
Size: 648.26 KB
Downloaded: 518 times
MacdBB'S Sierra Charts 2011v1 5 *
Enjoy!!!  
Suggest other entries I might like
Details: MacdBB'S Sierra Charts 2011v1


October 6th, 2011
Size: 38.53 KB
Downloaded: 303 times
reversal bar 5 *
reversal bar
 
Suggest other entries I might like
Details: reversal bar


January 16th, 2011
Size: 2.80 KB
Downloaded: 573 times
Open Range 5 *
multiple open range indicator
 
Suggest other entries I might like
Details: Open Range


January 14th, 2011
Size: 7.56 KB
Downloaded: 689 times
color last 5 *
this indicator colors a bar green if its close is above the prior close. The idea is to go with trend ie if 2 green bars trend is up. the example uses 2 range chart, type 2r hit enter to switch to 2 range chart.
 
Suggest other entries I might like
Details: color last


January 13th, 2011
Size: 2.24 KB
Downloaded: 474 times
 



 
Category
 



Copyright © 2021 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), 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.