| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/1/2006
Posts: 19
|
I apologize upfront for not being able to figure this out, but as I noted in an earlier post, I am just getting reacquated with TC2000 and formula writing again. So, here we go:
I want to create formula where, on a monthly chart, the most recent month closing price is greater than the 20 EMA, and the 3 months prior, the closing month is lower than the 20 EMA, and also
I also would like a formula where the last 3 trading days the closing price is greater than the 50 EMA, and the 50 EMA is greater than the 100 EMA, but the 40 trading days prior, the closing price is less than the 50 EMA, and the 50 EMA is less than the 100 EMA.
Thank you guys, for making this happen!!
Best,
Randy
|
|
Registered User
Joined: 10/9/2011
Posts: 485
|
Randy:
Bruce may be able to respond in detail on Monday but I thought I will share some info to get you going. I will use the second example and formulate the pcf...
Last 3 trading days the closing price is greater than the 50 EMA
C > AVGC50 and C1 > AVGC50.1 and C2 > AVGC50.2
and the 50 EMA is greater than the 100 EMA,
AVGC50 > AVGC100
but the 40 trading days prior, the closing price is less than the 50 EMA,
c40 < AVGC50.40
and the 50 EMA is less than the 100 EMA.
AVGC50.40 < AVGC100.40
If you merge it all together its something like.....
C > AVGC50 and C1 > AVGC50.1 and C2 > AVGC50.2 and
AVGC50 > AVGC100 and c40 < AVGC50.40 and AVGC50.40 < AVGC100.40
Hope that helps to get you started on it this weekend. Good luck.
|
|
Registered User
Joined: 9/1/2006
Posts: 19
|
You guys truly do ROCK. Thank you so much, this is a HUGE help. What can be more fun on a Friday night than scanning charts?!
I look forward to hearing more from you guys. Have a great weekend, and thanks again!!
Best,
Randy
|
|
Registered User
Joined: 9/1/2006
Posts: 19
|
Hi Bruce -
When you get a moment, I would appreciate if you could address my question from Friday. One of your other team members was very helpful for a daily chart, but I wanted to get some help for the monthly.
To save you time here is the original post from Friday:
Thank you -
Randy
I apologize upfront for not being able to figure this out, but as I noted in an earlier post, I am just getting reacquated with TC2000 and formula writing again. So, here we go:
I want to create formula where, on a monthly chart, the most recent month closing price is greater than the 20 EMA, and the 3 months prior, the closing month is lower than the 20 EMA, and also
I also would like a formula where the last 3 trading days the closing price is greater than the 50 EMA, and the 50 EMA is greater than the 100 EMA, but the 40 trading days prior, the closing price is less than the 50 EMA, and the 50 EMA is less than the 100 EMA.
Thank you guys, for making this happen!!
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
I want to create formula where, on a monthly chart, the most recent month closing price is greater than the 20 EMA, and the 3 months prior, the closing month is lower than the 20 EMA...
C > XAVC20 and C1 < XAVGC20.1 and C2 < XAVGC20.2 and C3 < XAVGC20.3
...make sure you set the time frame on the condition to Monthly.
Busterram gave you the second formula...
C > AVGC50 and C1 > AVGC50.1 and C2 > AVGC50.2 and AVGC50 > AVGC100 and c40 < AVGC50.40 and AVGC50.40 < AVGC100.40
...make sure the time frame is set to Daily.
|
|
Registered User
Joined: 9/1/2006
Posts: 19
|
Thank you so much!
Best,
Randy
|
|
|
Guest-1 |