Make your first spreadsheetStudy with Sierra Chart - futures io
futures io futures trading

Make your first spreadsheetStudy with Sierra Chart

Discussion in Traders Hideout

    1. trending_up 1,037 views
    2. thumb_up 7 thanks given
    3. group 7 followers
    1. forum 1 posts
    2. attach_file 0 attachments

Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

Search this Thread

Make your first spreadsheetStudy with Sierra Chart

(login for full post details)
  #1 (permalink)
Bangkok Thailand
Posts: 21 since Jan 2019
Thanks: 3 given, 29 received

for those who may be interested, example of creation of a study on the platform Sierra Chart, with the use of an Excel spreadsheet, integrated in the platform.
The use of the spreadsheet, more generally Excel, is a very good way for beginners, to be interested in programming with the help of extremely little knowledge.
Excel is a very powerful tool.

Here is the final result, just as an example.
Time needed less than 15 minutes.

Step by step :
1- Open a new chart on Sierra
2- Right mouse click on Chart an Select Chart Settings
3- On the Tab2 (Advanced Settings) , Chart Region, select 2 then OK
***I insert a Bollinger ands Indicator
1- Right mouse click on chart / Studies /
2- In the Studies Available frame, select : Bollinger Bands then click on Add >> Button
3- Now click on Settings (or double click on Bollinger Bands in Studies to Graph frame
4- On the first Tab (Settings and Inputs) :
-Length : 24
-Standard Deviations : 2.8
then on the left, select Hide Study, and click OK
*** I insert a SpreadSheet Study
1- Right mouse click on chart / Studies /
2- In the Studies Available frame, select : [B]Spreadsheet Study/B] then click on Add >> Button
3- Now click on Settings (or double click on Spreadsheet in Studies to Graph frame
4-Spreedsheet name : Fill the shield , with any name you want , FIRST for example,
then Select Chart Region 1 then click OK

you have a spreadsheet that appeared at the bottom of the tabs

In the columns A,B,C,D,E,F ,there is respectively
The Time Data / the open price / the high price / the low price / the close price / the volume
and as in the picture above, in the columns, AA(Top Bands), AB(Middle Bands), AC(Bottom ands), the data of the bollinger indicator.
The line 3 corresponds to my current candle.
The line '4 correspond to my candle period 1.
The line '5 correspond to my candle period 2.

I can now create my first indicator; he will indicate with the aid of arrows the return of the price in the bands of Bollinger.
I have at my disposal columns K to Z of the spreadsheet to enter my formulas and work to with the data.

Double left click in the cell K3, a small frame like this must appear : [ >> OK X ] to insert what you want (text formula, etc ...)

Fill in the cell K3 with that : =if(and(C4>AA4,C3<AA3),1,0)
Which means :
= to say that we insert a formula
if we insert a condition
and conditions has 2 criteria
C4> AA4 if my high price in period 1 is HIGHER than Bollinger high band in the same period
C3 <AA3 and if my current high price is SUPERIOR to my current high Bollinger band
1 then put a 1 in this box K3
0 otherwise put a zero in box K3

same thing in the other way, with the low price and the low band
Fill in the L3 with that : =if(and(D4<AC4,D3>AC3),1,0)

now the formatting of the indicator,
-Right click on the Chart
-Select Studies
-In the right frame (Studies to Graph), select the Spreadsheet study (Named First for me) and double left click
-On the second top Tab (Subgraphs), select the first line K(SG1) and below you can change the color to Red,
Drawn Style you can select Triangle Down, and Width select 10. Apply the changes for the second line too, L(SG2), color Green,
Triangle Down, 10
(you can hide something by select HIDDEN or IGNORE in Draw Style)
-You can unselect : Display Study Name Subgraphs Names and Subgraphs Values
-Click ok.

At this point, we know how to do everything technically to finish the rest.

so I will be shorter in my future explanations.

To create the oscillator,
I open a new Spreadsheet study,
-Chart Region select 3 , to place it at the bottom of the screen
-Give it a name
I will calculate the moving average at 24 of the closing price, and deduct it from this closing price.
Note that I do not need to import the Mobile Average indicator, I will directly calculate it in the formula of my spreadsheet.
Fill in the cell K3 of the second Spreadsheet Study with that : =E3-(AVERAGE(E3:E26))
Which means :
= to say that we insert a formula
E3 corresponds to the closing price
[COLOR="red"]E3[/-] subtract
AVERAGE(E3:E26)calculating the average price included in the cells between E3 and E26

Formatting K(SG1) : Drawn Style : Transparent Fill to zero

To create the last one, small arrows and White line.
I inserted a Commodity Channel Indicator , I calculated as for the Bollinger bands when the ICC is above the line 100 and then goes down again, to create the red arrows, and the reverse with the -100 level to create the green arrows this can give us a cycle indicator.
If I look at the levels scale on the right of my oscillator,
I see that the values oscillate between -0,020 and 0,020 approximately; so to be able to display my arrows on the oscillator in my formula, if ...... I put, 0,01 for my red arrows and -0,01 for my green arrows, like this
Cell P3= If (and (AE4 <AH4, AE3> AH3) - 0.01,0)
Cell Q3=if(and(AE4>AG4,AE3<AG3),0.01,0)
Formatting : [B]Drawn Style : Triangle Down/B]

To create the white line in cell R3 : P3+Q3 (I am merging the results of the 2 columns)
Formatting : Drawn Style : Line

Be careful, it is better to insert all of his indicators on the graph first, otherwise the columns of the spreadsheet can be moved when you add indicators.

To clear the graph of data, you can go to Chart Settings, Tab3(Advanced Settings 2, and in Region Data Lines, Hidden what you want.

These are very simple examples, but with good ideas, beginners can already create good things.

Reply With Quote
The following 7 users say Thank You to Orderbook for this post:

Can you help answer these questions
from other members on futures io?
NT8 indicator to simulate a Funding Evaluation where to …
Short Interest Ratio indicator?
Reading A set of Trading Signals
EasyLanguage Programming
Which kind of Blockvolume is visible? - order processing
Emini and Emicro Index
Help Needed: TOS Options Chain IV & IMPL MOVE Calcul …

futures io Trading Community Traders Hideout > Make your first spreadsheetStudy with Sierra Chart

Last Updated on January 14, 2019

Upcoming Webinars and Events

NinjaTrader Indicator Challenge!


Battlestations! Show us your trading desk - $1,500 in prizes!


Importance of Finding Your Own Way w/Adam Grimes

Elite only

Journal Challenge w/Jigsaw


Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432,
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.
no new posts