SMA (Simple Moving Average)
Returns a Simple Moving Average calculation.
Notes
- This is a utility function for SMA calculations
Syntax
=SMA1()Returns
number
Simple Moving Average value
Examples
=SMA1()When to Use
- Technical analysis
- Trend identification
- Moving average calculations
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Intraday SMA | RTI_SMA() |
| Exponential MA | EMA functions |
Common Issues & FAQ
What period is used?
Consult specific documentation for period details.
Related Formulas
More MarketXLS Technical Indicators formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?