Hi Bruce

I want to konw the stocks which are Down/Up two years in a row (i.e. If C104 is 20 then C52 should be lower than 20 Say 10, so now we have C52 as 10 and so C should be less than 10 say 5)  and used following Weekly formula

C104 > C52 AND C52 > C

Test Formula result show:

30.54 > 25.92 AND 25.92 > 32.11

Value = False

Here

30.54 > 25.92 is correct but 25.92 > 32.11 is not correct. 

Please correct the Formula and let me know.

One General question

When we use say Yearly Bar then in this 2 years period, Yearly Bar will be of 2010 and 2011 (two completed years) or it will use 2011 and 2012 till date. and what about weekly, daily bar and so on.

There is nothing to correct without more information as to your specific intent and the reason you think the test results are wrong.

Your formula is written exactly the way I would write a Condition Formula for Price being down two years in a row using a Weekly Time Frame and your test results match the current Weekly chart for IBM:

C = 32.11 on Thursday, April 26, 2012
C52 = 25.92 on Friday, April 29, 2011
C104 = 30.54 on Friday, April 30, 2010

TC2000 version 12.1 does not use bars based on a rolling bar interval. It uses calendar based years, quarters, months, weeks and days. The intraday Time Frames are always set up so the last bar of the day is a full bar if a 6.5 hour trading day is not equally divisible by the Time Frame.

The newest bar starts forming at the beginning of a new calendar year, quarter, month, week, day or intraday interval and will not be complete until the calendar year, quarter, month, week, day or intraday interval is complete and the next bar is ready to form or actually starts forming.

So on a Yearly Time Frame, the current bar covers January 1, 2012 through December 31, 2012 or January 3, 2012 through April 26, 2012 when US market trading days and the current date and time of day are taken into account.

On Quarterly Time Frame, the current bar covers April 1, 2012 through June 30, 2012 or April 2, 2012 through April 26, 2012 when US market trading days and the current date and time of day are taken into account.

While the Monthly Time Frame for the current bar only covers April 1, 2012 through April 30, 2012, the current Monthly bar currently covers the exact same period of time as the current Quarterly bar when US market trading days and the current date and time of day are taken into account.

The current Weekly bar could theoretically cover April 21, 2012 through April 27, 2012, April 22, 2012 through April 28, 2012 or April 23, 2012 through April 30, 2012. It doesn't matter because only Monday through Friday can be trading days. So when US market trading days and the current date and time of day are taken into account, the current Weekly bar runs from Monday, April 23, 2012 through Thursday, April 26, 2012.

Since the market is closed, all of the current intraday bars with the exception of the Tick Time Frame are for Thursday, April 26, 2012 at 4:00 PM ET.

The time of the most recent Tick bar would depend on when the most recent trade actually happened. A Tick bar is the only Time Frame which is a fully formed bar when it is first created.

Hi Bruce

Thank you for your reply.

Your result is exactly same as my result. The objective is to find stocks which are currently down two years in a row.

Lets look at your result

C52 (25.92) < C104 (30.54) so this result is correct as mentioned in my first message. 

but

C (32.11) is not lower than C52 (25.92). C Should be lower than 25.92 then only it confirms the objective mentioned here and before.

but 25.92 > 32.11 is not correct  (As mentioned in forst post)

Once again thank you for your help and please look in this.

Regards

The test returns a value of False.  

30.54 > 25.92 AND 25.92 > 32.11

Value = False

It's returning False because 25.92 is NOT > 32.11

Hi

Thanks you for reply.

How to solve this problem.

Regards

There isn't a problem.  The test symbol doesn't pass the conditions of the formula.