I'm trying to make a PCF of a 5 period EMA of TSV12 Exponential Setting using xavg(TSV12,5) but that is different to the actual value from the chart indicator. Please could you correct.

Your formula would be a 5 period exponential moving average of a 12 period simple TSV. A 5 period exponential moving average of a 12 period exponential TSV can be written as follows.

(11 * XAVG(TSV,12) - 4 * XAVG(TSV,5)) / 7

Cascades of Moving Averages

The attachment is a bit above my pay grade but extrapolating that formula, would a 7EMA of TSV18 be:

(17 * XAVG(TSV,18) - 6 * XAVG(TSV,7)) / 11

You have it exactly right.

There are some interesting things about this technique which can make some fomulas shorter than you might expect.

For example an 18 period exponential moving average of a 7 period exponential TSV would also be what you figured out.

(17 * XAVG(TSV,18) - 6 * XAVG(TSV,7)) / 11

And while you could write exponential TSV18 crossing up through through its 7 period exponential moving average as follows.

XAVG(TSV,18) > (17 * XAVG(TSV,18) - 6 * XAVG(TSV,7)) / 11 AND XAVG(TSV1.1,18) <= (17 * XAVG(TSV1.1,18) - 6 * XAVG(TSV1.1,7)) / 11

It simplifies down to the following:

XAVG(TSV,7) > XAVG(TSV,18) AND XAVG(TSV1.1,7) <= XAVG(TSV1.1,18)

As does an exponential TSV7 crossing up through its 18 period exponential moving average.

Thanks for that, I'll try and remember.

One function that would be helpful on this forum is to be able to see all your previous posts - currently you can only see the last 10.

I use search to list more than my 10 most recent posts. Click where it says Posts in the search window and change it to Posted By. Then search using your username.

Learn how to use the forums: post a new topic, reply, Search existing topics