Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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 ?
|
|
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
|
|
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 :)
|
|
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
|
|
Guest-1 |