Support Board

Date/Time: Thu, 16 May 2024 01:37:35 +0000

Post From: Spreadsheet AutoTrader - RSI Based - Formulas Question - Help

[2019-10-03 15:54:55] Link To Thread - Link To Post [Go To First Post]
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.