Trouble with moving average test

[Kauri]

Hello,
I am having a challenge with formulas for a Moving Average test I am trying to conduct and after a long
time of working on this I am not sure if what I want to do is possible.
At present my worksheet contains 8 columns (A to H) and 519 rows
The data begins in row 17 and I import it from another worksheet between the dates I specify in cells B10 & B11

I am wanting to enter the first Moving average in cell F1 and the second in cell G2 with column H showing the value of the cross.
For the MA formulas I have used in F2 =IF(COUNTBLANK($A17:$E17)>0,"",ROUND(AVERAGE(E17*$F$2),4))
And in G2 =IF(COUNTBLANK($A17:$E17)>0,"",ROUND(AVERAGE(E17*$G$2),4))
But this is just multiplying the individual cell numbers in the column.
I hope this makes sense.
Does anyone have any ideas please?

 

[awoohaw]

hi, welcome to the forum.
Would you be kind enough to post your data using the xl2bb add in (Link below) or just paste as a table.
Your image has only 5 columns yet you mention there are columns A:H, and you have a references to a in A:E, F and G.
While your image is helpful in describing your question it does not help the forum answer your question as accurately or as easily as possible.
With images the forum needs to enter your date/time stamps manually which is time consuming and can have errors.
Please help the forum help you.

Thanks in advance.

 

[Kauri]

Hello, Thank you for your welcome and your reply.
I have followed instructions on xl2bb but not sure if below is what is supposed to happen,
No, another error message, too much data.

$A$519 Fast MA Slow MA ​ ​ 1 1 Enter Start Date 1/07/2021 Enter End Date 30/06/2023 DATE OPEN HIGH LOW CLOSE 1/07/2021 4294.25 4312.00 4286.00 4309.50 4309.50​ 4309.50​ 2/07/2021 4309.75 4347.00 4308.00 4338.75 4338.75​ 4338.75​ 6/07/2021 4341.00 4348.00 4305.25 4328.25 4328.25​ 4328.25​ 7/07/2021 4328.00 4353.25 4320.25 4351.75 4351.75​ 4351.75​ 8/07/2021 4352.25 4352.25 4279.25 4310.25 4310.25​ 4310.25​ 9/07/2021 4310.25 4364.00 4293.25 4362.00 4362.00​ 4362.00​ 12/07/2021 4362.00 4379.25 4341.75 4375.75 4375.75​ 4375.75​

I appreciate your time in helping, thank you.

 

[Kauri]

Hello, Thank you to all who looked at this post.
I have now solved with named cells and AVERAGE formula but in different cells than I started out wanting to use.
Happy formulas all ☺