Support Board
Date/Time: Sun, 02 Feb 2025 10:07:31 +0000
Post From: How to combine two crossfromabove statements
| [2019-08-31 02:15:42] |
| Sawtooth - Posts: 4164 |
|
See where the macd is still crossed down and the smi is crossed up. It took a short.
If 'Signal Only On Bar Close' is set to No, it's possible a short was signaled intrabar.Also, using a range of 4 bars (AA3:AA6) might give unexpected results. Use this for longs: =OR(AND(CROSSFROMBELOW(AA3:AA6,AB3:AB6),AF3>AG3),AND(CROSSFROMBELOW(AF3:AF6,AG3:AG6),AA3>AB3)) To only trade when price is above/below VWAP, add a condition to each AND statement comparing E3 to the VWAP subgraph. It's best practice to use this method to reference study outputs: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study Advantages: -You can increase/decrease the 'Number of Formula Columns' without modifying formulas. -You can insert/delete Formula Columns without modifying formulas. -You can add/remove/rearrange studies in the Studies to Graph list without modifying formulas. |