Registered User
Joined: 7/2/2008
Posts: 23
|
I am a new TC User and already loving it. My last hurdle is trying to convert a scan from Trade Navigator (old platform) into TC. The problem is that TN had an indicator called cashflow. I think the equivalent might be moneystream.
Cashflow to them equals the sum of price change * volume for each bar.
ABS(C-C1)*V
absolute(close-close.1)* volume
Can I create something like this in TC
Also, here is the scan I had, could I get help rewriting for TC:
Optionable
Pirce >=40
Volume over 1 million for last 30 days
Cashflow + or - 2000000
Thanks in advance for help
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:
If you are new to TeleChart READ THIS FIRST!
You could create Cashflow as a Custom Indicator.
Select Chart Template | Add Indicator | Indicator.
-Visible: Checked
-Center Zero Line: Unchecked
-Plot using price scale: Unchecked
-Smoothing Average: 1
-Smoothing Type: Doesn't matter (because the Smoothing Average is 1)
-Indicator Formula: ABS(C - C1) * V
Plotting Custom Indicators with Examples
PCF Formula Descriptions
You can create an EasyScan combining built in System Criteria with one or Personal Criteria Formulas.
Using EasyScan to find stocks that meet your own criteria
Definitions of all built in scanning and sorting criteria
How to create a Personal Criteria Forumula (PCF)
Optionable is one of TeleChart's built in Fundamental System Criteria.
Price Per Share is also one of TeleChart's built in System Criteria (which could be used with the EasyScan Rangefinder), but you could also create a Boolean (True / False) PCF:
C > = 40
I'm not sure if you mean Average Volume:
AVGV30 >= 10000
Or Minimum Volume over the last 30-Days:
MINV30 >= 10000
I'm not sure I understand the Cashflow Condition. Since it is the Absolute Value of the Net Change times Volume, it should always be positive.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/2/2008
Posts: 23
|
Thank you so much for your help.
Is there a way for me to take that formula for Cashflow and smooth it out like a moving average. I followed your instruction on how to add it to a pane and it's obviously to choppy. Can I place the AVG code somewhere so that it shows this figure as an average for say the past say 30 days.
Thanks again,
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Change the Smoothing Average in the Custom Indicator to 30.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/2/2008
Posts: 23
|
Can we go back to the + or - 2000000 for the cashflow vallue.
Basically I only want stocks with a value greater than 2 million or less than - 2000000. For example -4000000 would show up in the result but -1500000 would not.
Also, with the price per share, do I just change the value type to Value and raise the slider to 40.00 to max.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Cashflow will always be positive, so I guess you could just represent it as (since Volume in TeleChart is reported in Blocks of 100 Shares):
ABS(C - C1) * V > 20000
If you use the Price Per Share built in System Criteria as an EasyScan Condition (instead of using the Boolean Personal Criteria Formula presented above), you would select Value and adjust the EasyScan Rangefinder to the desired values (so the short answer would be yes).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/2/2008
Posts: 23
|
Sorry, I am confused by saying that Cashflow is always positive.
Does C = Close or Casflow? I thought it stood for Close. So if C - C1 cant result in a negative #?
Thanks yet again for fast responses.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
C - C1 can be negative but ABS(C - C1) cannot. ABS() is the Absolute Value function. It will convert any negative Value to a positive Value of the same magnitude (and leave non-negative Values as is).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/2/2008
Posts: 23
|
OK gotcha, so for the indicator on the chart I will keep the ABS code; however, for my EasyScan, how do I write the code that will show the (C - C1) * V so that stocks with values more than 2 million or less than negative 2 million.
Thanks so much.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Well if you were to take the ABS() function off, you would get (you need to put parentheses around the negative number):
(C - C1) * V > 20000 OR (C - C1) * V < (-20000)
But for reasons that may or may not be obvious, this will return the same results as:
ABS(C - C1) * V > 20000
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/2/2008
Posts: 23
|
So are you saying I should change the code to this:
C - C1) * V > 20000 OR (C - C1) * V > (-20000)
Again, my goal is to pull positive moving stocks that will have a number like 25000 and in the same scan I want stocks that were down that day that will have a return value of -25000. I however do not want stocks with values like 10000 or - 10000.
So, by changing the greater than sign above am I getting the right place or am I still way off.
Thanks Bruce for sticking with me.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I was actually trying to point out that you don't need to change anything.
(C - C1) * V > 20000 OR (C - C1) * V < (-20000)
And:
ABS(C - C1) * V > 20000
Should both do what you want (they return the same results).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/2/2008
Posts: 23
|
oh ok - duh,
Because ABS takes the negative number an makes it positive then we only need the positive 20000.
Sorry, late on a Friday.
You Rock!
Michael
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'm happy to read you were able to figure it out.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Bruce,
The statement:
"Cashflow to them equals the sum of price change * volume for each bar."
sounds like a cumulative indicator to me.
I do not know why anyone would ever be interested in:
ABS(C - C1) * V > 20000
It tends to retun True more often on high price, high volume stocks.
Thanks,
Jim Murphy
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
The following is from the Trade Navigator Manual:
__________________
Cashflow Accumulation
This is an accumulation distribution indicator (Cumulative sum of the price change x volume for each bar).
Filter Criteria Uses: (Example Only)
If the Cash Flow Accumulation of 3 bars is the highest it has been in the last 60 days.
Syntax:
Highest (CashFlow Accumulation (3), 60)
__________________
accendo,
You apparently want something like:
CashFlow Accumulation ( P ) > 20000 OR CashFlow Accumulation ( P ) < -20000
for some P.
Bruce gave you the syntax:
ABS(C - C1) * V > 20000
to use in TeleChart when P = 1 (provided volume is measured in 100's of shares in Trade Navigator).
For example, if P = 3, the correct syntax is:
ABS((C0-C1)*V0 + (C1-C2)*V1 + (C2-C3)*V2) > 20000
(provided volume is measured in 100's of shares in Trade Navigator). Please note that an equivalent result cannot be obtained by smoothing ABS(C-C1)*V.
Again, the value of imposing such a condition on Cashflow Accumulation is questionable.
Thanks,
Jim Murphy
|
|
Registered User
Joined: 7/2/2008
Posts: 23
|
Jim, You bring up a good point. I pretty much no longer use it as an indicator/moving average anymore; however, I do still use it a s part of my scan/filter.Thanks,
|
|
|
Guest-1 |