TC2000.com• Download software • Tutorial videos • Subscription & data-feed pricing • Class schedule
TC2000Brokerage.com• New account application • Trading resources • Margin rates • Stock & option commissions
Worden Discussion Forum
Thanks a lot Bruce. Is there a way to calculate however what the ATR of a basket of stocks is... Say I have a basket of 100 stocks and I want to check what the general average ATR of all the ATR's on this list is? Anyway to do that?
How do I write a condition PCF that;
1. caclulates the ATR is great than a number for instance; ATR > 1
2. I can use to find stocks where he ATR is currently X% (maybe 10%), more than the average true range over a X period (maybe 14 days)
Any plans on when this is going to be a possible feature in TC2000 in the future?
Secondly, is there a way to build a PCF that helps to determine an intraday swing high or swing low on a chart... such that I can paint the highest point of the swing high or the lowest point of the swing low with a dot?
I know we can write a simple PCF to mark (using the dots) the O,H,L,C of a candle - what I want to do though is reflects those points on a larger time frame like the 1hr for instance on the smaller time frame like the 2mins.
So more like I want to see OHLC price points on my 1hr TF, marked as a dot on the 2min TF.
So technically all I want to see is the OHCL prices of the 6 bars that make up the 1hr chart (assuming we are not including pre/post market prices - doesn't matter). It means that if there is a price of say, 69 on the L of a candle in the 1hr chart, at the point that, that occurs I can also see it on the 2min chart - it doesn't matter if on the 2min chart price repeatedly touches that price point, as long as it didn't repeat on the 1hr chart more than once, that's it.
Except though (instead of a dot), there is a way to draw a horizontal line. Let me know if this is unclear and I can send an email to support with images instead.
Hi bruce, thanks for the help - when I write the formular... C<AVGO11 and L<AVGH24 as
CountTrue (C<AVGO11 and L<AVGH24, 100) as PCF in my condition column, I don't get any numbers on the watchlist. It returns blank - and I need it to return with numbers (after the count).
Hi Bruce, I need help in using the COUNT feature - I want to be able to how many times a condition is true. I have written a pcf that shows up as green bar when true and red bar when false - but I want to be able to count how many times it is true or false on my watchlist - by showing it to me in numbers. That means if the condition is true 26 times, I can see it, if it is false 30 times i can see it.... Is that possible?
I'll start by mentioning that fairly extensive testing was done along with follow-up in other threads at the time this was posted which indicated that the formulas given in my original response were the correct formulas and that Volume Buzz used the previous moving average while Volume Surge Today used the current moving average.
This doesn't mean there is any sort of guarantee the testing was right at the time or even if it was that the values don't use exactly the same basis today. I mention it mostly as a caution on the possibility of this previous testing being correct and possibly still be applicable. I have not done any recent tests.
Your idea as to how to convert Volume Buzz into the Zanger Volume Ratio is quite creative. The big issue I see with it as regards TC2000 is that there is no way to reference Volume Buzz in a Personal Criteria Formula or in an on chart indicator.
Hi Bruce, thanks for your comment.
I did the manual calculation today with multiple stocks. Was not able to get exact match of Vol Buzz for each of them, but the AVGV100 seems to result in closer Vol Buzz value than the AVGV100.1.
The values of AVGV100 and AVGV100.1 are usually very close for most stocks except for those with hugh vol spike on current day, in which case the Vol Buzz value is huge and standout. It doesn't make much difference to get a more accurate value since Vol Buzz is used for sorting anyway.
As to the ZVR, it is a shame we can't reference the Vol Buzz value. My solution is adding an indicator PCF column called ZVR Factor = AVGV100 / AVGV20.1 by the side of the Vol Buzz column. That way I can calculate in my mind the ZVR value by (Vol Buzz + 100) * (ZVR Factor).
I wish TC2000 can provide a shorter term Vol Buzz using 20-25 day moving average. 100 day is too long and not sensitive enough for swing trading (though it is still quite useful in observing breakout validity).
Hi Bruce - thanks for the feedback. You are always so helpful.
Now, here is the challenge though; Within the cell properties of the Formular I am using is...
"List to Count" - from which a list to select is there; for instance - MorningStar Industry Groups....
This invariably means the report is counting based on the list....
What I was hoping this would do, is count based on the formular ON the Stock/chart in Question.
So as with the PCF example, if the condition is positive 10x, it tell me. If it is Negative 30x, it tells me - realtime as it would with a selected list on the List count....
Do you understand?
My concern is the stock in view not a List of stocks, or index or groups etc.
So if I have this linked for my watchlist for instance, everytime I scroll through a stock/chart the numbers should change - based on the chart I am looking at... that's my focus.
Thanks Bruce. My bad. I got it now. Is there any reason why "100" is the reference number here? I am trying to do some tweak and see if there is any impact though.
Secondly, what I was hoping to see as the outcome, was a number count as to when the condition is true or otherwise. If there was a way to attach an image here I would have sent you what I am looking at? can I send it to support?
Thanks Bruce - But I need a bit more help -
So here is the PCF I wrote;
O >= L1 and C > AVGC9 and C1 > AVGH14 and O > AVGO9 and C >H14)
So how do I count True on this...
CountTrue (O >= L1 and C > AVGC9 and C1 > AVGH14 and O > AVGO9 and C >H14) -
and got some Formular error message.
What I basically want to do is count how many times this is true and possibly be able to sort it out on my columns in my watchlist.