Make your first spreadsheetStudy with Sierra Chart - Traders Hideout | futures io social day trading
futures io futures trading

Make your first spreadsheetStudy with Sierra Chart
Updated: Views / Replies:220 / 1
Created: by Orderbook Attachments:0

Welcome to futures io.

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

futures io is the largest futures trading community on the planet, with over 100,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors – all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you don’t need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

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

Thread Tools Search this Thread

Make your first spreadsheetStudy with Sierra Chart

  #1 (permalink)
Trading Apprentice
Bangkok Thailand
Trading Experience: Intermediate
Platform: SIerra Chart , MetaTrader
Broker/Data: No one
Favorite Futures: YM
Posts: 7 since Jan 2019
Thanks: 0 given, 6 received

Make your first spreadsheetStudy with Sierra Chart

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.
Please register on to view futures trading content such as post attachment(s), image(s), and screenshot(s).

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

Please register on to view futures trading content such as post attachment(s), image(s), and screenshot(s).

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 user says Thank You to Orderbook for this post:
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.


futures io > > > Make your first spreadsheetStudy with Sierra Chart

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

futures io is celebrating 10-years w/ over $18,000 in prizes!

Right now

Pro Trader vs Pro Athlete w/Brannigan Barrett @ Habitus Capital

Elite only

Similar Threads
Thread Thread Starter Forum Replies Last Post
Want your Sierra Chart indicator created, free? Big Mike The Elite Circle 341 February 24th, 2019 01:06 AM
First In First Out steve2222 Terms (Glossary) 0 May 18th, 2016 04:40 AM
How to change First In First Out in Interactive Broker? bmtrading9 Reviews of Brokers and Data Feeds 8 September 17th, 2015 01:25 PM
Do educated traders make it harder to make a profit randyf Beginners and Introductions 47 March 2nd, 2014 05:33 AM
Goodbye, First Amendment: ‘Trespass Bill’ will make protest illegal kbit News and Current Events 2 March 10th, 2012 06:15 AM

average, data, dow, futures, how to, indicators, information, moving average, oscillator, platform, programming, reverse, sierra, sierra chart, spreadsheets, top, white

All times are GMT -4. The time now is 10:56 PM. (this page content is cached, log in for real-time version)

Copyright © 2019 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432 WhatsApp Business,
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
Page generated 2019-05-18 in 0.21 seconds with 15 queries on phoenix