Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

formula help Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dlefkowitz
Posted : Monday, April 28, 2014 11:03:40 AM
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.

Bruce_L
Posted : Monday, April 28, 2014 11:09:19 AM


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
dlefkowitz
Posted : Friday, May 16, 2014 6:08:02 PM
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

Bruce_L
Posted : Tuesday, May 20, 2014 11:48:17 AM


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
dlefkowitz
Posted : Tuesday, May 20, 2014 12:35:55 PM
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

Bruce_L
Posted : Tuesday, May 20, 2014 1:23:57 PM


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
dlefkowitz
Posted : Wednesday, May 21, 2014 5:00:31 PM
Registered User
Joined: 11/11/2011
Posts: 32

Will get my thoughts together, then schedule. D

Bruce_L
Posted : Thursday, May 22, 2014 2:03:27 PM


Worden Trainer

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

I am looking forward to it.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dlefkowitz
Posted : Tuesday, June 3, 2014 10:28:47 AM
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

Bruce_L
Posted : Wednesday, June 4, 2014 2:45:56 PM


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
dlefkowitz
Posted : Wednesday, June 4, 2014 6:24:16 PM
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

jbcarlini
Posted : Monday, June 16, 2014 1:00:52 AM
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)

Bruce_L
Posted : Monday, June 16, 2014 3:12:24 PM


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
jbcarlini
Posted : Monday, June 16, 2014 8:02:36 PM
Registered User
Joined: 11/2/2009
Posts: 2

Thank you Bruce!

Joe

jmccray
Posted : Friday, June 27, 2014 2:17:46 PM
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

jmccray
Posted : Friday, June 27, 2014 2:44:43 PM
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

 

Bruce_L
Posted : Friday, June 27, 2014 2:49:24 PM


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
Quiktdr
Posted : Saturday, June 28, 2014 3:27:04 PM
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  !                                                                                                                                                                                                                            

Bruce_L
Posted : Monday, June 30, 2014 10:25:43 AM


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
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.