% Above/Below MA

[Bosox13]

I was looking to create a custom report that shows the % above/below certain MA (ie. 10 week, 20, 40 etc.)

Is there a function that I could create to give me this number?

Thanks alot

[Mark]

Hi Bosox13,

There is no built-in field to show exactly this, but if you're using the Professional or Advisor version you can define your own field to show this. In the Custom Report Settings dialog, press "Define Fields..." and create a new field, and assign it an equation like this:

100 * (End_NAV - MA10W) / MA10W

Press "Help" in this dialog for more explanation, but the above equation gives you the ending price's percentage above the 10 week moving average.

[Bosox13]

thanks mark