Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Resistance Point Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
tdbroker
Posted : Sunday, March 16, 2008 5:10:15 PM
Registered User
Joined: 1/28/2008
Posts: 19
good morning guys
how can i write 
 
MINC5
MINC250
MINC500

have been no more than 6% from each other. for example if
C5 close @ 10 then C250 couldn't have close more than 10.65 and C500 no more that 6% from C5 

as always your input is appreciated .

also how can i write C5 was the lowest closing price of the last 6 months
thanks
Andrew
Bruce_L
Posted : Monday, March 17, 2008 9:09:52 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (tdbroker)
how can i write 
 
MINC5
MINC250
MINC500

have been no more than 6% from each other.

Please try the following:

Minimum Close over 5-Periods within 6% of Minimum Close over 500-Periods:

MINC5 / MIN500 <= 1.06

QUOTE (tdbroker)
for example if C5 close @ 10 then C250 couldn't have close more than 10.65 and C500 no more that 6% from C5

I'm not sure if you are looking for Closing Prices or Minimum Closing Prices over a period of time. If you want to compare the Closing Prices from 5-Periods Ago, 250-Periods Ago and 500-Periods Ago, you might wish to try the following instead:

C5, C250 and C500 within 6% of each other:

C250 / C5 <= 1.06 AND C500 / C5 <= 1.06 AND C5 / C250 <= 1.06 AND C500 / C250 <= 1.06 AND C5 / C500 <= 1.06 AND C250 / C500 <= 1.06

QUOTE (tdbroker)
also how can i write C5 was the lowest closing price of the last 6 months

Please try one of the following:

Closing Price from 5-Periods Ago is at Lowest Closing Price of the last 6-Months:

C5 = MINC126

Minimum Closing Price over the last 5-Periods is Lowest at Lowest Closing Price of the last 6-Months:

MINC5 = MINC126

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tdbroker
Posted : Monday, March 17, 2008 11:10:14 AM
Registered User
Joined: 1/28/2008
Posts: 19
Hi Bruce
what i am trying to use is the lowest closing price, in other words i am trying to say that the lowest closing price between C5, C250 and C500 hasn't been more that 6% from each other. is like saying that when stocks are at or close to those closing prices they tend to bounce back
thanks
Andrew
Bruce_L
Posted : Monday, March 17, 2008 11:39:58 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
My original interpretation is not even close to your apparent intent. Please try the following instead:

Minimum 245-Period Close ending 5-Periods Ago and Minimum 250-Period Close ending 250-Periods Ago within 6% of each other:

MINC245.5 / MINC250.250 <= 1.06 AND MINC250.250 / MINC245.5 <= 1.06

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tdbroker
Posted : Monday, March 17, 2008 1:29:39 PM
Registered User
Joined: 1/28/2008
Posts: 19
Are you saying that the last 250 closing days that ended 5 days ago in relation to the previous 250 days don’t have a closing price difference of more than 6% ?
thanks
Bruce_L
Posted : Monday, March 17, 2008 1:37:35 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
No. There are 245 days from C250 to C5, not 250 days. If you want to look at the 250 Trading Days ending 5-Periods Ago and the 250-Trading Days immediately prior to that 250-Trading Day Period instead, please try the following:

Minimum 250-Period Close ending 5-Periods Ago and Minimum 250-Period Close ending 255-Periods Ago within 6% of each other:

MINC250.5 / MINC250.255 <= 1.06 AND MINC250.255 / MINC250.5 <= 1.06

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tdbroker
Posted : Monday, March 17, 2008 2:36:14 PM
Registered User
Joined: 1/28/2008
Posts: 19
thanks
Bruce_L
Posted : Monday, March 17, 2008 2:43:49 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.