How to create a moving average graph?

Question

How to create a moving average graph?

I track currency pair trades and have it summarized into all time average and last 30 day average. How can I graph these two numbers over time as they daily fluctuate? Is there a function I can run or do I need to hard code each days results which will be tricky for adding past data?

I track 10 currency pairs. Each pairs tracks squeeze, touch and live results. The left column is for all time data, last complete month (sept. not needed graphed) and the 30 day win percentage. I would like each graph to contain the all time moving average and 30 day moving average. For instance, the EUR/USD squeaze today is 83.54% all time win percentage and the 30 day is 84.02%. I would like these as a line updated daily.

Thanks.

MacBook, macOS Sierra (10.12)

Posted on Oct 26, 2016 11:22 AM

Reply

Answer 1

Barry

Level 9

60,023 points

Oct 26, 2016 11:46 AM in response to braddonfromboulder

Hi Braddon,

Charts can graph only data that they can 'see' and can 'see' only data that is displayed on a table.

You will need to create a table containing one column for the x-axis values (dates) and one column for each line you want to appear on the chart, a header row to contain the labels and one row for each day for which data will be charted, and a means of recording (or calculating) each day's data in the appropriate cell.

Not a small task, especially with your data arranged as it is.

Regards,

Barry

Reply

Answer 2

SGIII

Level 8

37,562 points

Oct 26, 2016 1:03 PM in response to braddonfromboulder

Note that there is a 'Moving Average' option in Trendlines:

The usual procedures for laying out your data in a table apply.

SG

Reply