Support Board
Date/Time: Thu, 16 Jan 2025 19:05:27 +0000
Post From: Spreadsheet Auto trading
| [2017-11-01 20:34:18] |
| User81767 - Posts: 6 |
|
=OR(AND(SG1[0] > SG1[-1],SG1[-1] < SG1[-2]),AND(SG1[0] < SG1[-1],SG1[-1] > SG1[-2])) The formula referenced above came from your reference in your answer. “In the examples here at 8 and 9 there are formulas related to Slope: Study/Chart Alerts And Scanning: Alert Formula Examples” The formula has two steps: 1.It identifies a change in slope by (a) a change in color of the MA bars and (b) a change in direction of the MA. 2. It then selects from a list of audio alerts to make a sound. I want to change this formula to modify its function as follows: 1. Same function. 2. It will select from a list of placing a “buy” or “sell” order Presently when I place this formula in K3 under “Buy” on a spreadsheet associated with a chart it returns an error #SYNTEX! It looks like the section “StudyChartAlertsAndScanning.php#FormulaExamples” is the part that is wrong. Can somebody help me so that when this formula is in K3 (Buy) it will place a buy order and when the formula is in L3 (Sell) it will sell this position? Conversely, it also needs to be modified to be used in execution a short position in M3 and N3. Thanks for your help. billhess0@gmail.com |