title: Finding the average of monthly closing price on Google Finance
body: <p>With Google Finance, I'm trying to calculate the 12-month moving average of a ticker. For example, I want to retrieve end-of-month closing price for a ticker for the last 12 months and find the average of these values.</p>
  <p>I've tried to refer to this question: <a href="https://stackoverflow.com/questions/68295501/googlefinance-get-history-by-month">GoogleFinance: Get History By Month</a></p>
  <p>Though I was able to retrieve the end-of-month closing prices, it wasn't letting me calculate the average of these values. I think this is because all the numbers are formatted as texts.</p>
  <p>Any idea on how I can accomplish this?</p>
  <p>EDIT: here is what I have so far and hopefully this provides a better sense of my desired outcome.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1Mf9wVli7ofJBGTaNTVrfGREMAwDNQwwO6nZWDwyGCbM/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1Mf9wVli7ofJBGTaNTVrfGREMAwDNQwwO6nZWDwyGCbM/edit?usp=sharing</a></p>