Support Board

Date/Time: Sun, 19 May 2024 09:22:30 +0000

Post From: Using Spreadsheet Studies with Alerts

[2021-10-21 22:20:23] Link To Thread - Link To Post [Go To First Post]
Botan626 - Posts: 294
I have some general questions on this matter. I already use 1 Spreadsheet Study on the chart to plot pivot lines using my own formulas, which are based on other Study/Price Overlay studies. This is the 1st task. Now I want to create an advanced alert for the same chart, so I should use Spreadsheet System/Alert study. This is the 2nd task. 1. Can I get rid of my Spreadsheet Study and use only Spreadsheet System/Alert study for both tasks? 2. This section Spreadsheet Systems, Alerts and Automated Trading: Creating a System or Alert says: The formulas on the Spreadsheet should return either a 1 (TRUE) or 0 (FALSE) value. A value of 1 or TRUE indicates the System/Alert formula condition has been met. but then for columns K-N it says: Although any value other than 0 is considered a TRUE condition Which value in fact indicates a true condition? 1 or any nonzero value? 3. If I will use columns other than K-N in the Spreadsheet System/Alert study to plot pivots lines on the chart, the return values of the formulas will be nonzero for some rows, including the last bar in the chart. These values will be considered as true conditions too, which will create alerts? Date Time Of Last Edit: 2021-10-21 22:46:26