Posts

Showing posts from June, 2024
Image
  An Introduction to Computing and Interpreting EMAs with Excel   This post offers introductory coverage for computing and interpreting exponential moving averages (EMAs) with Excel.   I have written about and regularly use EMAs in my own securities trading.   A couple of my prior articles ( Differences Between Exponential Moving Average and Simple Moving Average in SQL Server and Revisiting Time Series Model Performance Assessment with T-SQL ) focus on how to compute and interpret EMAs.    Because of the significance of EMAs to security trading analytics, I expect to issue multiple posts on this topic in the next couple of years. This is the initial post with coverage of EMAs in this blog.   Therefore, the coverage will be both basic and simple from an analytical perspective.   The focus of this post is to show how to use Excel for computing EMAs and interpreting EMA values.   Excel’s charting capabilities are tapped to illustrate how to interpret EMAs.   The post also includes