Tweet
Need help with writing formula for McClellan Oscillator
The following are the exact formulas (the "*" is the spreadsheet version of a multiplication sign)
5% Index:
((Todays's Adv minus Decl - Prior Day's 5% Index) * 0.05) + Prior Day's 5% Index = Today's 5% Index
10% Index:
((Today's Adv minus Decl - Prior Day's 10% Index) * 0.10) + Prior Day's 10% Index = Today's 10% Index
(Note: The first time you begin to calculate an exponential average, you must calculate a simple moving average.)
McClellan Oscillator:
Todays's 10% Index - Today's 5% Index = Today's McClellan Oscillator
Need to have data run on intraday basis.
The following are the exact formulas (the "*" is the spreadsheet version of a multiplication sign)
5% Index:
((Todays's Adv minus Decl - Prior Day's 5% Index) * 0.05) + Prior Day's 5% Index = Today's 5% Index
10% Index:
((Today's Adv minus Decl - Prior Day's 10% Index) * 0.10) + Prior Day's 10% Index = Today's 10% Index
(Note: The first time you begin to calculate an exponential average, you must calculate a simple moving average.)
McClellan Oscillator:
Todays's 10% Index - Today's 5% Index = Today's McClellan Oscillator
Need to have data run on intraday basis.
Comment