Hello,

I am looking for a way to compare intraday if the 'last 3-minute-bar' closed below the 'closing price of yesterday'. But so far I am failing. One reason for this seems the fact, that mixing time-frames in setting up scans is not possible. But I assume this must be programmable, especially if this indicator still works: Closing price on specific day -  C'MM/DD/YY'

Could you help me on this issue?

Regards from Germany

The following works in a 3-minute time frame in my copy of TC2000 v18 (unfortunately the version can make a difference when trying to reference the date in an intraday time frame).

C1 < C'2/11/19'

The above assumes the "last 3-minute-bar" is the previous bar and not the currently forming bar. If you are interested in the currently forming bar, you can just use the following daily formula instead.

C < C1

That said, my computer is set to use the MM/DD/YY time format. If your computer is not set this way, you may want to try setting the date format to match your local settings instead to see if it makes a difference.

Hello Bruce,

thanX for the super fast response - my compliments to you and Worden for this phantastic support and this forum.

I will check it out and let you know how it worked.

Regards Leon.

You're welcome.

Hello Bruce,

unfortunately it does not produce proper results. I assume I have chose some parameters of the condition wrong. Would love to enter a picture here, but somehow can't upload any graphics. So I will describe what I did:

• Calculation I entered in Condition: ( C1 < C'2/12/19' )
• Formula Value: Is true
• True: Now
• TimeFrame: 3 Minute

At time of writing this message this brings back 1131 results. Many correct but i.e. it brings back GILD or CEP which did not trade in negative territory the whole day. 

ThanX for all help in advance !

Best regards - Leon.

Try it using the current date instead (I know this is counterintuitive).

C1 < C'2/13/19'

Hello Bruce,

as you said - it is counterintuitive BUT it works ;-)

Could you also say WHY ? I mean I am scanning for todays 3min.-bars and compare them explicit with yesterdays date BUT to get correct results I have to enter todays date. I do not mind as I do not have other formulas using the date formula C'MM/DD/YY' - but strange it is.

Regards Leon.

As mentoned, using dates in intraday formulas actually works differently in different versions of TC2000.

That said, I think the reason it works is that when no time is specified as part of the date (and there isn't any syntax for doing so), it fills in the time as midnight (or 00:00:00). So the program finds out what the value of whatever is being checked in the intraday time frame using midnight at the start of the day. Since there aren't any bars yet for the new trading day at midnight, you get the last intraday value from the previous day as the value being referenced.