Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

50MA over 150MA for a period of time Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
awkl1426
Posted : Sunday, June 4, 2017 6:02:32 AM
Registered User
Joined: 4/2/2017
Posts: 2

Hi there! Would anyone be able to tell me how I can write the formula for the 50 Moving Average being over the 100 Moving Average for a period of 100 days? What needs to be input other than: AVGC50>AVGC150  ?

diceman
Posted : Sunday, June 4, 2017 7:03:41 AM
Registered User
Joined: 1/28/2005
Posts: 6,049

Try this:

(This is for V17)

 

Exactly 100 days:

TRUEINROW(AVGC50>AVGC150,101)=100

 

 

100 days or more:

TRUEINROW(AVGC50>AVGC150,101)>99

 

 

 

Thanks

 

 

 

awkl1426
Posted : Monday, June 5, 2017 9:55:32 AM
Registered User
Joined: 4/2/2017
Posts: 2

Thank you diceman, this is exactly what I wanted! I figured out if I wanted to change the period to more than 200 I would need to make it TRUEINROW(AVGC50>AVGC150,201)>200. What does the comma before 201 mean? Additionally is there a place I can learn how to make these pcfs other than searching through the forum topics?

Thank you once again for the quick and helpful answer :)

diceman
Posted : Monday, June 5, 2017 10:21:07 AM
Registered User
Joined: 1/28/2005
Posts: 6,049

Comma separates the PCF it is checking from the length it is looking back.

(101 bars in this case)

 

I use the first post in V17 Ask a Trainer.

"Version 17 PCF Capabilities."

 

 

 

Thanks

 

 

 

Users browsing this topic
Guest-1

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.