Support Board
Date/Time: Sun, 02 Feb 2025 22:45:18 +0000
Post From: Spreadsheet AutoTrader - RSI Based - Formulas Question - Help
| [2019-10-03 15:54:55] |
| maddy91 - Posts: 11 |
|
I want the following four scenarios to work. 1. When RSI Crosses 70, generate a Buy Signal and use with the Attached Order. Used the following formula in Spreadsheet Buy Entry =AND(ABS($J$8)=0,CROSSFROMBELOW(AE3,AF3)) where AE is RSI Current Value and AF is Top Band(70) Sell Exit(Buy) Buy Entry =AND(ABS($J$8)<>0,CROSSFROMBELOW(AE3,AF3)) where AE is RSI Current Value and AF is Top Band(70) and J8 is position Quantity 2. When RSI Crosses 30, generate a Sell Signal and use with the Attached Order. Used the following formula in Spreadsheet Sell Entry =AND(ABS($J$8)=0,CROSSFROMBELOW(AE3,AG3)) where AE is RSI Current Value and AG is Lower Band(30) Sell Exit(Buy) Buy Entry =AND(ABS($J$8)<>0,CROSSFROMBELOW(AE3,AG3)) where AE is RSI Current Value and AG is Lower Band(70) and J8 is position Quantity What am i doing wrong,? when i use the same crossover formulas in alert for studies they work. I am not getting any buy sell orders alerts using this system. |