Calculate Simple Moving Average Using Google Sheets

Various SMA Calculated in Excel

Earlier we told you how to pull historical data in Google spreadsheet (see — HOW TO PULL HISTORICAL STOCK DATA FROM USING GOOGLE SPREADSHEET ). Once you have Historical data available in Google spreadsheet we can Calculate Simple Moving Average and values of other various technical indicators of our interest using the same. The method given here can be used in Excel as well as Google Sheets. However we have given formulas for Google sheet. In case you wish to do same in Excel you can achieve same result by importing historical data (by Any means) and then using these formulas (some minor modification in syntax of formula may be required). Today we are going to look how to calculate Simple Moving average or SMA for a particular period. SMA is nothing but average of last N number of Prices where N denotes the period. So if you want to calculate SMA(20,C) i.e. Simple Moving average of closing price of 20 day period. You can simply sum last 20 Close price and divide by 20, and you will get the SMA (20, C). Similarly SMA can be calculated on Open High or Low with any period, a screenshot with formula […]