Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Gold Customer
Joined: 2/1/2005 Posts: 51
|
I want to compare a 3 day Volume average vs a Existing Volume of the Day. Understand I would need to constantly refresh, but is there a possibility
AVG3 / V Error in formula syntax. AllI want to do is to compare the previous 3 day's Average Volume to the Existing Volume of today at present time period. It doesn't have to be exact. Unlike volume buzz, I would like to be able to see quickly a number indicating the difference. ie: The columns are already there with my present volume/3 day average.
Any help would be most appreciated. Thank You
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The problem is the AVG3 in your formula needs to be AVGV3 instead.
That said, I would probably write it as the following instead.
V / AVGV3
Or maybe as:
100 * V / AVGV3
Or:
100 * (V / AVGV3 - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 2/1/2005 Posts: 51
|
Thank you appreciate,
My only question now is I think my numbers are skewed because AVGV3 is Static doesn't change till tonight, but my V will increase during the day . For some reason my correlations are incorrect since for some reason I am finding in some cases higher daily volume vs 3 day average to be the same if the volume is reversed.
I guess I need a phd or 9 year child to understand. Should be a good quiz for my Daughter and a bunch of Intel engineers heading to Canada this PM.
Thank you again
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I may have misunderstood your question.
V / AVGV3 divides the volume of the current bar by the current 3 day average volume.
V1 / AVGV3.1 would divide the volume of the previous bar by the previous 3 day average volume.
V / AVGV3.1 would divide the volume of the current bar the previous 3 day average volume.
V1 / AVGV3 would divide the previous volume by the current 3 day average volume.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 2/1/2005 Posts: 51
|
Sorry, what I want to do is get a correlation of
Total Volume for today which off course is available vs the 3 day volume average.
You see volume buzz which is outstanding represent that period of time, while I am trying to
HOG Volume buzz of 750% Volume 14.3 M average 3 day volume is 1.7M correlates to Number
MRKT Volume 1.2M average 537K this as of 1:34PM today now the difference is with HOG at least 14: 1 ration vs 2:1 with MRKT so I want that to correlate to a number this way I know without looking at both volume and 3 day average what is going on at this particular period. I am not interested in the bar, all I am interested is daily total for this period of time accumalitive vs 3 day average (static)
Does that make sense?
By the way before I make you crazy, I have been with Telechart for 11years and note: the only real complaint is Worden fibs are lousy.
Mark
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Now I'm even more confused. Please try to restate exactly what you're looking for.
|
|
Gold Customer
Joined: 2/1/2005 Posts: 51
|
I doubled check and the problem was when I set up the indicator, I forgot to associate V with Daily which would give me the total volume since 9:30AM vs 3 day average, this way I can see a correct ratio during the day of 1 means that present volume is 500K and if 3 day average is Parity or 500K . Close enough for gov work.
The problem was I was getting screwy correlated numbers, because I first set this up without considering the time period . Normally you should be able to sort the column and expect ratios close to each other , Now is should be easy to convert ratios to % and be able to quickly determine volume intensity.
Thank You
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am happy to read you ware able to figure it out.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |