Registered User Joined: 11/11/2011 Posts: 32
|
Help me understand why, when I create an indicator formula ((C-C1)/C1)*100 using weekly bars (to indicate price % change over the last week) and make a Easyscan column from it but then, when I create the formula ((C-C5)/C5)*100 using daily bars and make a secondEasyscan column from it, the two columns are not exactly the same. Ihave tried it several times, and the columns have different numbers.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The two formulas are two different things. The reason is that the weekly bars in TC2000 version 12.4 are based on calendar weeks. So the week goes from Monday through Friday if there aren't any market holidays.
So your weekly formula is using the end of the previous weekly bar as C1 and the current price as C. This means it is normally the price percent change since last Friday.
Your daily formula is checking for the price percent change over the most recent 5 trading days. As long as there aren't any market holidays, this means it is checking for the price percent change since the end of the same day last week.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/11/2011 Posts: 32
|
Bruce,
As you will remember, I am a long momentum trader. Recently, with so many down days, I have decided that I must look at downward momentum and consider the short side of trading. I have been using ROC % 10>10 Wkly as a "long" condition, and I cannot figure out how to turn this around so that I can can look at the worst US common stocks regarding % rate of change. Could you help me design this condition for a new EasyScan. Also, what else do you suggest as a condition (s) that would help me capture US common stocks with extremely negative momentum. I want to be able to define the "worst of the worst". Thank you, David
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you are using ROC % 10 > 10 Wkly as a long condition, my best guess would be that you would want to use ROC % 10 < -10 Wkly as your short condition.
Based on the name of the condition alone, it seems that it might have been created by adding a Rate of Change Percent Indicator ot the chart, setting the period to 10 and changing the time frame of the chart to Weekly.
You would then click on the Rate of Change % indicator and select Create Scan Condition to create a Condition for the Rate of Change % indicator being Less Than -10.
Create Conditions from Your Chart (5:25)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/11/2011 Posts: 32
|
Thanks for your help. Though I understand you can't design my scans, may I schedule an hour phone consultation with you at a time convenient to you? Jerry suggested that you are available for these consultations, as I did in the past with Julia.before she left Worden. I would get my thinking organized first, outlining in an emal areas where I need help, and then you could point me in the correct direction in a phone consultation. Please let me know if you would have time for this. David
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Yes, I can do personal training sessions. I am generally available between 9 AM and 5 PM ET Monday through Friday.
You can send an email to support@tc2000.com to schedule a training session. Including details of what you want to cover during the training sessions can be quite useful in preparing for a session to get the most value for your money.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/11/2011 Posts: 32
|
Will get my thoughts together, then schedule. D
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am looking forward to it.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/11/2011 Posts: 32
|
When short interest money moves into the market on an equity, would TSV show a positive move just like i would if long interest was active on that same security? David
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The trainers can't give setting, interpretation or investment advice. I will move this topic to the Stock and Market Talk forum where other traders are more likely to see it and reply.
Basic Info on BOP, TSV and MoneyStream
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/11/2011 Posts: 32
|
This is a really poor response. I'm not asking for investment advice, only asking you to help me understand one of your indicators. You (Worden) should be ashamed! David
|
|
Registered User Joined: 11/2/2009 Posts: 2
|
Could you please write me the formula for the Stochastic Momentum Index, with adjustable paramiters. MetaStock has a formula that calculates a 13,25,2 Stochastic Momentum Index as follows:
100 * ( Mov( Mov(C - (0.5 * ( HHV(H,13) + LLV( L,13))),25,E),2,E) / (0.5*Mov( Mov( HHV(H,13) -
LLV( L,13),25,E)))
I would like to be able to use this indicator with TC2000.
Thanks
Joe Carlini
(email removed by moderator)
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I cannot make an adustable version, but I can create an Indicator Formula for the Stochastic Momentum Index 13,25,2 as follows.
200 * (24 * (XAVGC25 - (XAVG(MAXH13,25) + XAVG(MINL13,25)) / 2) - (XAVGC2 - (XAVG(MAXH13,2) + XAVG(MINL13,2)) / 2)) / (24 * (XAVG(MAXH13,25) - XAVG(MINL13,25)) - (XAVG(MAXH13,2) - XAVG(MINL13,2)))
Stochastic Momentum Index
Stochastic Momentum Index related formula
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/2/2009 Posts: 2
|
Thank you Bruce!
Joe
|
|
Registered User Joined: 6/26/2014 Posts: 2
|
For a given exchange I want to create a condition that will give me the 52 week high
The 52 week low
For a given exhange I want to compare stocks hitting newhighs and stcks hitting new lows
Could you please provide these formulas or tll me wer they are in TC-200
Thanks
JPM
|
|
Registered User Joined: 6/26/2014 Posts: 2
|
Well let me try this again
For a given watclist I want to know the stocks with new 52 week highs.
And Iwant to know the stocks setting new 52week lows
I wold also ike to know what stocks are at all time highs or lows.
Please send me the appropiate formlias or shw me were I can fnd this in TC-2000.
Thanks
JPM
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
A daily Indicator Formula for the 52-week high can be written as:
MAXH252
A daily Indicator Formula for the 52-week low can be written as:
MINL252
A daily Condition Formula to check if the current trading day is a new 52-week high can be written as:
H > MAXH251.1
A daily Condition Formula to check if the current trading day is a new 52-week low can be written as:
L < MINL251.1
If you use one of the Conditon Formula as an EasyScan Condition, the count of the number of symbols returns (the Y in X of Y Items in WatchList at the bottom of the WatchList) would be the number of new highs or new lows in the List to Scan of the EasyScan.
You cannot plot this number over time on the chart however.
There are Worden Market Indicator (T2s) which give information about new highs and new lows for the NYSE, but not for the other exchanges or for arbitrary WatchLists.
US Market Indicators (T2s)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 794
|
I tried to post this under new topics but was unable to open window. I am looking for % change from lowest close this year to close and I just want to confirm this is correct formula ((MinL260-C)/C) this would give me % growth from low of year TY in advance !
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You would probably want to reverse this to:
100 * (C - MINL260) / MINL260
Or:
100 * (C / MINL260 - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |