Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 15:00:25 +0000

How to Post a Message for Support

Post From: Spreadsheet Alert with 3 different Futures

[2013-05-06 00:16:31] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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