| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User
Joined: 1/28/2008
Posts: 19
|
thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |