I have created this simple system in excel and would like to try to convert it to AFL. If anyone can help, I would appreciate it.
===================================DEFINITIONS======================================= MACD = EMA12 EMA26 9 Day Signal = 9 Day Average MACD Histogram = MACD - 9 Day Signal ==================================== Hist Trend ======================================== Hist Trend = If Histogram > 0, 1, -1 =IF(Histogram Today >0 , IF(Hist Trend Yesterday = 5 , 5, Hist Trend Yesterday +1) , IF(Histogram Today > Histogram Yesterday , Hist Trend Yesterday , IF(Hist Trend Yesterday =-5 , -5, Hist Trend Yesterday -1))) ==================================== MACD Trend ====================================== MACD Trend = If MACD > 0, 1, -1 =IF(MACD Today > 0 , IF(MACD Trend Yesterday = 5 , 5, MACD Trend Yesterday +1) , IF(MACD Today > MACD Yesterday , MACD Trend Yesterday , IF(MACD Trend Yesterday = -5 , -5 , MACD Trend Yesterday -1))) ===================================== MA Trend ======================================= MA Trend = IF (Close > MA20 , 1 , -1) =IF(Close Today > MA20 Today , IF(MA Trend Yesterday = 5 , 5, MA Trend Yesterday +1) , IF(Close Today > Close Yesterday, MA Trend Yesterday , IF(MA Trend Yesterday = -5 , -5 , MA Trend Yesterday -1))) ======================================TREND========================================= Trend = (Hist Trend + (MACD Trend * 3) + (MA Trend * 2)) / 6 //Weighted Average of Three Trend Indicators Trend Average = AVERAGE (10 Day Trend) =IF (Trend Average Today >= 0 , IF (Trend Average Yesterday < 0 , "BUY" , "Hold") , IF (Trend Average Yesterday > 0 , "SELL" , "Hold")) =========================================END========================================
