Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Need to create simple PCF 3 day Volume Average vs Existing Volume Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
MarkAB
Posted : Thursday, June 30, 2016 1:19:01 PM
Gold Customer 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

 

Bruce_L
Posted : Thursday, June 30, 2016 1:44:25 PM


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
MarkAB
Posted : Friday, July 1, 2016 12:51:17 PM
Gold Customer 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

 

Bruce_L
Posted : Friday, July 1, 2016 1:13:48 PM


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
MarkAB
Posted : Friday, July 1, 2016 1:38:39 PM
Gold Customer 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

 

StockGuy
Posted : Friday, July 1, 2016 1:55:42 PM

Administration

Joined: 9/30/2004
Posts: 9,187

Now I'm even more confused. Please try to restate exactly what you're looking for.

MarkAB
Posted : Friday, July 1, 2016 3:39:45 PM
Gold Customer 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

Bruce_L
Posted : Friday, July 1, 2016 3:40:53 PM


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