| 
				
					
				 
					
					| ehop |  
					
					| Gold User, Member, TeleChart |  
					
					| Registered User |  
					
					|  |  
					
					|  |  
					
					|  |  
					
					|  |  
					
					| Unsure |  | 
				
					
				 
					
					| Tuesday, November 30, 2004 |  
					
					| Monday, December 16, 2019 7:30:20 PM |  
					
					| 33 [0.01% of all post / 0.00 posts per day]
 |  | 
| 
		
			
		 
			| 
 Thank You. |  
			| 
 Trying to write a formula in 12.2 where MACD (X and S) is greater than the moving average today but was less than the moving average 5 days ago. |  
			| Is there a way to write a formula for the 20 month exponential moving average? |  
			| Bruce - How is the 3 month exp moving average being calculated? |  
			| Bruce - How is the 3 month exp moving average being calculated? |  
			| Bruce -Thanks again.  This seems to work fine. 
 Going forward, how would I modify this formula to test other periods (4 month exp ma instead of 3 month exp ma) and if I wanted to test the L, H, or O instead of the C would I just change the C in the formula to L, H, or O?
 |  
			| Bruce - Thanks so much for the info. 
 How would the formula differ if I just wanted to see C crossing its 3 month exp moving average with C1 (or C21) being less than its 3 exp moving average?
 |  
			| No.  I'm looking at C 5 days ago on the monthly. |  
			| Can you help me develop a pcf where C <= the 3 month exp moving average and C5 was >= the 3 month exp moving average |  
			| Bruce.  Thank you for your help.  Tried again and failed.  I think I haven't been clear regarding my intent and I apologize for any waste of your time.  I was trying to find a way to isolate a pattern like- TRP, 10/25/07.  The MinL10 is contained within the 10 and 21 day XMA's with the 10 XMA being greater than the 21 day XMA.  Is this possible? |  |