Discussions
 » 
Product and Service Development
 » 
Formula Assistance
 » 
How can you encode a MA that comes within 2% of it Support
 
        
            
            
    
        
Rank: Advanced Member
  Groups: Registered, Registered Users Joined: 4/27/2005(UTC) Posts: 130
  
 
     | 
    
        
            
	      
                Does anyone know how to encode a 10 period MA that comes within 2 percent of it support or resistence level? 
            
  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
     | 
        
        
        
            
        
            
            
    
        
Rank: Advanced Member
  Groups: Registered, Registered Users, Subscribers Joined: 9/8/2004(UTC) Posts: 2,266
  Was thanked: 1 time(s) in 1 post(s)
  
 
     | 
    
        
            
	      
                What type of average are we talking about ? ( exponential, simple, variable , ... )
How do you calculate the support and resistance values?
Patrick :mrgreen: 
            
  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
     | 
        
        
        
    
        
            
            
    
        
Rank: Advanced Member
  Groups: Registered, Registered Users Joined: 4/27/2005(UTC) Posts: 130
  
 
     | 
    
        
            
	      
                I wanted to use a exponential moving avg. I'm really just interested in how you write the formule so it is within 2% of another varible. The support is going to be the normal formula of 
Resistance 3 = High + 2*(Pivot - Low)
Resistance 2 = Pivot + (R1 - S1)
Resistance 1 = 2 * Pivot - Low
Pivot Point = ( High + Close + Low )/3
Support 1 = 2 * Pivot - High
Support 2 = Pivot - (R1 - S1)
Support 3 = Low - 2*(High - Pivot) 
            
  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
     | 
        
        
        
            
        
            
            
    
        
Rank: Advanced Member
  Groups: Registered, Registered Users, Subscribers Joined: 9/8/2004(UTC) Posts: 2,266
  Was thanked: 1 time(s) in 1 post(s)
  
 
     | 
    
        
            
	      
                It's easy :D 
Cross(Variable1,Variable2*.98)
or the opposite
Cross(Variable2*1.02,Variable1)
Patrick :mrgreen: 
            
  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
     | 
        
        
        
    
        
            
            
    
        
Rank: Advanced Member
  Groups: Registered, Registered Users, Subscribers Joined: 10/29/2004(UTC) Posts: 1,394 Location: Glastonbury, CT
  Was thanked: 3 time(s) in 3 post(s)
  
 
     | 
    
        
            
	      
                There is a difference between the 2% of Variable*1.02 and the 2% of variable*.98
for a true 2% difference
A:=Mov(C,10,S);
Upper:=A*1.02;
Lower:=(2*A)-Upper;
Upper;A;Lower; 
            
  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
     | 
        
        
        
    
                           
    
| Users browsing this topic | 
| 
 
Guest (Hidden) 
 | 
Discussions
 » 
Product and Service Development
 » 
Formula Assistance
 » 
How can you encode a MA that comes within 2% of it Support
 
    
        Forum Jump
         
    
    You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.