dburger/sma

Created February 8, 2021 20:51

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dburger/9125055c074445e9b553b70abd3bf0fd.js"></script>
Save dburger/9125055c074445e9b553b70abd3bf0fd to your computer and use it in GitHub Desktop.

Download ZIP

Composition of functions to calculate an SMA in Google Sheets.

Raw

sma

=AVERAGE(INDEX(GOOGLEFINANCE(A2 , "close" , WORKDAY(TODAY(), -$C$17, holidays) , TODAY()), 0, 2))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment