Home >> Support Board

Support Board

Date/Time: Thu, 25 Apr 2024 22:12:59 +0000

How to Post a Message for Support

[User Discussion] - Spreadsheet Alert with 3 different Futures

View Count: 2663

[2013-05-05 18:15:44] #1 [Go To First Post]
Moti - Posts: 63
Hello, I will like to build Alert on (a spreadsheet system for trading) , That contained 3 futures DX , EC , BP ( tick bars, Study / price Overlay ) The condition Are : DX 3 bars making Lower Low AND, EC AND BP have "close > open" (divergence ) Then Alert with Green point & sound alert ( below the Low of the Third DX Lowest bars ) Sometimes the EC AND BP condition " close >open " appear only few bars later the Third DX make is Lowest. I still want to get the Green point & sound alert, IF the Low Of this bar Equel to the Low of the Third DX Lowest bars. ( Maximum 3 supplement bars after the 3rd Lowest DX bar ) Please Help, My first time WIth Sierra spreadsheet. Thank you, Moti

[2013-05-06 00:16:31] #2 [Go To First Post]
Sawtooth - Posts: 3976
If you only want a green point and a sound alert, the Spreadsheet System/Alert study is what you want to use. The recommended way to begin is to use two Study/Price Overlay studies on the DX chart, to bring the EC and BP to the DX chart. Then add the Spreadsheet System/Alert study, and give it a name in the Spreadsheet Name field. Now you can build your formulas referencing each market. Here is the documentation: http://www.sierrachart.com/index.php?l=doc/doc_StudiesSystemsAlerts.php The basic structure of the spreadsheet studies: 1) Each row corresponds to a bar on the chart. The current bar is in Row 3; earlier bars are in rows below. This means the array is in descending order. 2) Columns A-G contain the Bar open DateTime, OHLC, Volume, and # of trades. 3) Column H is open and intended for the user’s intermediate calculations. Other open cells are Row 1 of Columns K-Z, I1, I2, J1, and J2. 4) Column J contains a mix of read-only and user defined cells relative to the chart and system. Column I contains the titles for the cells in Column J. 5) Columns K-Z are for the user’s formulas. (In v947, this can be expanded to columns K-AX). Formulas are entered in Row 3, and when the chart is updated, those formulas will be advanced and auto-filled in rows below. 6) Columns AA and above contain the output values of the chart indicator studies. In v947, this can be moved as far as column AY to allow up to 40 user-calculation columns K-AX. The Chart Studies’ Studies to Graph list determines in what order the study outputs appear on the spreadsheet. 7) Row 2 of Columns K-Z (or up to K-AX in v947) is for user-defined names for the respective subgraphs SG1-SG16 (or up to SG40 in v947). 8) Cells can be formatted for various types, in addition to font, font size, color, background, and borders. Date Time Of Last Edit: 2013-05-06 00:16:46

[2013-05-06 15:32:49] #3 [Go To First Post]
Moti - Posts: 63
Thank you for the detailed mail, I will like to add to this pattern buy/sell orders (later ). Isn't it better to start directly with spreadsheets for Trading? Can you help me Please to build this chart, I would be grateful, it will guide me for future development, Thank you, Moti

[2013-05-06 16:32:54] #4 [Go To First Post]
Sawtooth - Posts: 3976
If this will eventually become an autotrader, you can use the Spreadsheet System for Trading study. Start with a formula in cell K3 that will go TRUE when the DX has 3 consecutive bars with lower lows. For example: =AND(D3<D4,D4<D5,D5<D6) Then build on that success to include more conditions: =AND(D3<D4,D4<D5,D5<D6,AA3>AD3,AM3>AP3) Where AA and AD are the Open and Close of the EC, and AM and AP are the Open and Close of the BP. Then keep building on the success. Date Time Of Last Edit: 2013-05-06 16:33:33

[2013-05-13 18:27:06] #5 [Go To First Post]
Moti - Posts: 63
Hello Tom, I have in H3 : =AND(D3<D4,D4<D5,D5<D6) How and Where I add the second condition : =AND(D3<D4,D4<D5,D5<D6,AA3>AD3,AM3>AP3)? Where I can add to the chart Greenpoint above the bar & sound alert when all conditions accure ? Thank you, Moti

[2013-05-14 09:17:43] #6 [Go To First Post]
Moti - Posts: 63
Hello Tom, I will formulat diffrent: All conditions are in H3 on a row ? OR, H4, H5 are cell Also for conditions? Where I can add to the chart Greenpoint above the bar & sound alert when all conditions accure ? Thank you, Moti Date Time Of Last Edit: 2013-05-14 09:23:56

[2013-05-14 13:03:17] #7 [Go To First Post]
Sawtooth - Posts: 3976
Moti, Using Spreadsheet studies can be overwhelming at first. It seems you would benefit from looking at some documentation. Here are two overviews: http://www.sawtoothtrade.com/tip-1.html http://www.sawtoothtrade.com/tip-2.html For the comprehensive SC documentation, see this: http://www.sierrachart.com/index.php?l=doc/doc_Worksheets.html Put the formula in K3. Date Time Of Last Edit: 2015-08-14 01:34:40

To post a message in this thread, you need to log in with your Sierra Chart account: