Worden Discussion Forum

Welcome Guest, please sign in to participate in a discussion.

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » Formula for Stocks on a Certain Date

Formula for Stocks on a Certain Date

Rate this Topic:

Previous Topic · Next Topic

Watch this topic · Print this topic ·

m42000

Posted : Saturday, January 5, 2008 1:33:52 PM

Registered User
Joined: 12/21/2007
Posts: 18

I was told you can write for me a formula. I need to find out the stocks at a particular time that come up in an easy scan. For example, say I have a formula for 52 week highs in the S&P. I want to look at stocks that meet that criteria at whatever date, say 1/12005, 1/12006, 1/1/2007. etc...

Let me know if you can or cannot provide this.

Bruce_L

Posted : Monday, January 7, 2008 8:52:42 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There are two distinct ways to use historical data with Personal Criteria Formulas.

Any criteria can be used to scan X number of days back by adding '.XX' where XX is equal to the number of market days past to calculate for. An example of this is (AVGC21.21), which is a 21 day moving average 21 of close, 21 days ago. This use of historical data always refers to the market day XX number of days ago (in this case, 21). If you wish to use a specific date’s data, use the option detailed below.

The other method of using historical data is by specifying a precise date in history to use. For example, (AVGC21.'12/31/97') will provide a 21 day moving average of close for December 31, 1997 (the period should be used in cases where the first method requires a period and not used when the first method does not use a period). In this particular case, December 31 is the last trading day of that specific year. This will not always be the case. Always confirm that the date you wish to use using this parameter was a market day.

You may wish to review the following:

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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

m42000

Posted : Monday, January 7, 2008 11:53:12 AM

Registered User
Joined: 12/21/2007
Posts: 18

Bruce:
The PCF I was looking for is: C'07/26/07' >= 0.85*MAXH252.'07/26/07'

Yesterday I used :C'07/26/07' >= 0.85*MAXH252.'07/26/07'. However, in the chart, at the top right hand corner blinking RED, the date that showed up was NOT 07/26/2007. The day and month were off, the year was correct. Why is that the case. How can I get the correct date, and month as well to show up.

I would like to see the chart pattern of stocks that I am looking at on 07/26/07.

Thanks.

William

Bruce_L

Posted : Monday, January 7, 2008 11:59:54 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The Past Chart Date that you are describing has absolutely nothing to do with any Personal Criteria Formulas that you might have in TeleChart. It merely reflects the date on the far right of the chart when you have scrolled the charts to view anything besides the most current data. You may wish to review the following:

Clipping your chart back to a previous date

I notice that you are quite new to TeleChart. You may also wish to review the If you are new to TeleChart READ THIS FIRST! topic to help you utilize you better utilize TeleChart to its fullest.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Winnie

Posted : Monday, January 7, 2008 12:04:10 PM

Registered User
Joined: 10/7/2004
Posts: 1,006

Please try this PCF:

C’7/26/07’ >= 0.85 * MAXH252.’7/25/07’

Winnie

m42000

Posted : Monday, January 7, 2008 12:22:50 PM

Registered User
Joined: 12/21/2007
Posts: 18

Hi Winnie:
The PCF C’7/26/07’ >= 0.85 * MAXH252.’7/25/07’ is what I was looking for and it works. BUT the Chart that comes up has a date and month in the top RH corner of Chart which is NOT 07/26. I would like to look at the chart pattern of those stocks on 07/26/2007.

I take a look at the above links.

Thanks.
William

bustermu

Posted : Monday, January 7, 2008 12:56:59 PM

Registered User
Joined: 1/1/2005
Posts: 2,645

William,

Construct a Custom Indicator with:

0.85*MAXH252

and check "Plot using price scale".

Scroll so that you view any dates you please. If the Close is above the Custom Indicator for a bar, the PCF is True for the date of the bar.

Thanks,
Jim Murphy

Winnie

Posted : Monday, January 7, 2008 1:23:40 PM

Registered User
Joined: 10/7/2004
Posts: 1,006

m4200,

I’m not sure if this is what you are looking for, below are my notes for Hot Keys, to move, add indicators, select WatchLists etc, to move the chart backward or forward use the [ or ] key, move the chart to your desired date.

Hope the format from my Word document carries over to the post.

Winnie

TELECHART HOT KEYS

WatchList Operations

Select WatchList Alt - L

Sort criteria for WatchList Alt - S

Jump to top of WatchList Home

Next Symbol Down in List Spacebar

Next Symbol UP in List Ctrl - Spacebar

Next Flagged Symbol Shift - Spacebar

Next WatchList Ctrl - W

Previous Symbol history Backspace

Previous WatchList history Ctrl-Backspace

Add Sym to Personal WatchList Ctrl - A
Remove Sym Personal WtchList Ctrl - Delete

Active Symbol Memberships Ctrl - M

Flag/Unflag Active Symbol F

Add note to Active Symbol N

Notes Scroll Up/Dn Arrows Up / Dn

Jump to a Symbol J

Custom Date Sort C

Charts (Template Layout F1 - F12 )

Move Chart bkwd/frwd 1 bar [ or ]

Move Chart bkwd/frwd 5 bars { or }

Move Chart bkwd/frwd Ctrl - MseScroll

Large/Regular Chart, Toggle Ctrl - L

Trendline, Draw D

Trendline, Erase last Ctrl - D

Trendline, Toggle Extension Ctrl - T

Pointer, Toggle on/off ( . )

Pointer, Move far right Chart End

Price/Bar/Line/Candle, Toggle Ctrl - B

Chart Scaling Box Ctrl - G

Compress/Decompress scaling ( -) (+)

Zoom Level Shift - MseScroll

Zoom Level Shift 1 - 9

Days per Bar (1 Day – 9 Day) 1 - 9

Days per Bar (1 Day - 1Yearly) MseScroll Wheel

Toggle Adjusted for Splits Ctrl - \

Edit Chart Template I

Technical/Data Sheets, Toggle Ctrl - V

Indicators, Adding, Editing and Removing

Edit, Delete, Sortby Rt Clk on indctr

Erase Indicators Dialog Box X

Delete last Indicator plotted Delete

Comparison Symbol Box Ctrl - C

Compare Symbol Toggle Ctrl - F

$100 Scale Ctrl - H

Add Moving Average A

Add Balance of Power (BOP) B

Add Envelope Channels E

Add Bollinger Bands G

Add Rate of Change H

Add Linear Regression L

Add MACD M

Add On Balance Volume O

Add Wilder’s RSI R

Add Relative Strength Ctrl - R

Add Stochastics S

Add TSV T

Add Volume V

Add MoneyStream Y

EasyScan Functions

Open EasyScans List Box Ctrl - S

Search for EasyScans Type Name

Open EasyScan List Box Ctrl - E

Other

Worden Reports W

Scroll sent Chat Messages Shift + Arrows Up/Down

Pointer Mode: Toggle the pointer with the . key, and use the arrow keys to move up or down.

To display the actual value of indicators established in the middle and lower pane using the pointer mode . character, plot duplicates of your middle and bottom window in the top window BUT uncheck their visible option. You will not see them but you will get values in the data box when in pointer mode.

m42000

Posted : Monday, January 7, 2008 1:58:28 PM

Registered User
Joined: 12/21/2007
Posts: 18

Thanks.

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.