Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 20 Apr 2024 06:32:30 +0000
Post From: Keltner Moving Averages
| [2014-01-08 18:41:08] |
| Sawtooth - Posts: 3976 |
|
Using the formula here, it would be easy to do this with the Spreadsheet Study study: http://stockcharts.com/school/doku.php?id=chart_school:technical_indicators:keltner_channels 1) Add the Moving Average-Volume Weighted study and the Average True Range study, and Hide both studies. 2) Add the Spreadsheet Study study -Set the Chart Region to 1 3) Use the following formulas in the respective cells: K3: =AA3 L3: =K3+(2*AC3) M3: =K3-(2*AC3) where the Volume Weighted MA is in column AA and the ATR is in column AC. |