| 
Rank: Newbie
 Groups: Registered, Registered UsersJoined: 3/26/2009(UTC)
 Posts: 1
 
 | 
            
	      
                I need help creating the following:
I want to do an exploration using a moving average cross over- showing the following:
50 ma of close 5 days ago, current 100 ma, and current 50 ma. The stocks listed in the results should be those whose prior 50 ma was below the 100 ma and whose current 50 ma is now above the 100 ma.
Any help or ideas would be greatly appreciated. | 
    | 
             | 
            
         | 
    |  | 
        
        
        
            
        
            
            
    | 
Rank: Newbie
 Groups: Registered, Registered UsersJoined: 4/27/2006(UTC)
 Posts: 6
 
 | 
            
	      
                Hi moggie,
 I'm pretty new to this, but i think this is what you're after;
 
 colA:
 Ref(mov(c,50,s),-5)
 
 ColB:
 mov(c,100,s)
 
 ColC:
 mov(c,50,s)
 
 Filter
 cross(colC,ColB)
 
 erko
 
 | 
    | 
             | 
            
         | 
    |  | 
        
        
        
    
                           
    
| Users browsing this topic | 
| 
Guest (Hidden) | 
    
        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.