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

Search | Active Topics |

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.
Back to top
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
Back to top
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
Back to top
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
Back to top
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
Back to top
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
Back to top
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
Back to top
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.
Back to top
m42000		Posted : Monday, January 7, 2008 1:58:28 PM
Registered User Joined: 12/21/2007 Posts: 18		Thanks.
Back to top
Users browsing this topic
Guest-1

Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos

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.