# Custom Formula Collection

Moving Average of Only One Day of a the Week

Frequently we get requests for a formula that would take only one day of the week and average them for several weeks. For example construct a moving average of only the Fridays. This can be done in MetaStock^{TM} for Windows by using the following formula.

The following MetaStock formula is for a moving average of the Friday of every week, if you want it calculated on any other day you would substitute a 1 for Monday, 2 for Tuesday, 3 for Wednesday, and 4 for Thursday. The number of day you wanted would replace the two 5's already in the formula. This moving average is currently a 6 week or 6 Friday moving average. If you wanted to change it to another periodicity you would change the 30 to the number of weeks or specific days multiplied by 5. In other words if you wanted a 4 day moving average of Friday you would change the 30 to 4*5 or 20.

Mov(If(DayOfWeek( )=5,C,Peak(1,If(DayOfWeek( )=5,C,0),1)),30,S)

For additional help with formulas, please see the Formula Primer.

Can't find the custom formula you need? MetaStock can create formulas for you.

- Creating Custom Formulas
- Absolute Breadth Index
- Advance / Decline Line with Negative Volume
- ADX/ADXR Custom (without rounding)
- Alpha and Beta
- Arms Index (TRIN)
- Average-Modified Method
- Breadth Thrust
- CCI Moving Average Crossover System Test
- Chande's Momentum Oscillator
- Combining Trend and Oscillator Signals System Test
- Commodity Channel Index Buy and Sell Signals
- Comparative Relative Strength
- Comparative Relative Strength Exploration
- Coppock Curve
- Derivative Moving Average
- Detrended Price Oscillator
- Disparity Index
- Displaying the Price of a Security in 32nds and 64ths
- Divergence between the Close and an Indicator
- Dynamic Momentum Oscillator
- Elder Ray and The Force Index
- End Point Moving Average
- Genesis of a Simple Futures Trading System
- Historical Volatility Daily
- Historical Volatility System, Connors and Raschke's
- Historical Volatility Weekly
- InSync Index
- Investor Preference Index
- Keltner Channels
- Ken Roberts' Formulas
- Kurtosis Indicator
- MACD Histogram
- Market Facilitation Index
- Market Facilitation Index Expert Advisor
- Market Thrust Oscillator
- Martin Pring's KST Formulas
- Mass Index
- McClellan Oscillator
- McClellan Summation Index
- Modified VIX Indicator
- Money Flow Index
- Moving Average of Only One Day of a the Week
- Natenberg's Volatility
- New Advance Decline Line
- Pathfinder Trading System
- Polarized Fractal Efficiency
- Price Action Indicator (PAIN)
- Price Volume Rank
- Random Walk Index
- Rate of Change Since a Specific Date
- Regression Oscillator and the Slope/Close Indicator
- Relative Strength Index, Custom (RSI)
- Relative Volatility Index (RVI)
- Slope of a Line
- Slope of a Linear Regression Line
- Standard Error Bands
- STIX Oscillator
- Stochastic %D
- Stochastic Relative Strength Index
- Tick Line Momentum Oscillator
- Trading Channel Index
- Wilder's Volatility
- WillSpread by Larry Williams