|
Bangkok Thailand
Posts: 19 since Jan 2019
Thanks Given: 3
Thanks Received: 32
|
Hello,
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.
|
