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 |

Problem with XAVG & AVG Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
pmckeon
Posted : Friday, April 11, 2008 6:43:30 PM
Registered User
Joined: 10/7/2004
Posts: 13

Hi - 
I want a 10 day exponential moving average of ((C+H+L)/3)

When I use XAVG((C+H+L)/3,10) and test it, the calculation is made, but in the text box showing the results, I get XAVGError, followed by the calculation.

The same thing happens when I try a simple moving average.

Can you tell me what's wrong?

Thank you,   Pat

diceman
Posted : Friday, April 11, 2008 9:50:29 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
That is not proper syntax.
 
You could try something like:
 
(XAVGC10+XAVGH10+XAVGL10)/3
 
 
 
Thanks
diceman
 
pmckeon
Posted : Friday, April 11, 2008 10:44:45 PM
Registered User
Joined: 10/7/2004
Posts: 13
Thanks Diceman.  I wasn't aware that formulas weren't allowed as arguments to AVG or XAVG.

Pat
diceman
Posted : Saturday, April 12, 2008 1:16:46 AM
Registered User
Joined: 1/28/2005
Posts: 6,049
One thing to note. You can also create this as a
custom indicator.
 
Use:
 
(H+C+L)/3
 
as your formula. Then set the smoothing average
to 10 exp.
 
 
You may be interested in this:
 
 
 
 
Thanks
diceman
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.