Login Page - Create Account

Support Board


Date/Time: Thu, 07 Jul 2022 16:40:58 +0000



[User Discussion] - Keltner Moving Averages

View Count: 1448

[2014-01-08 16:10:13]
JamesP - Posts: 89
Hello,
I'm just wondering if there is a way to get alternative moving averages within the keltner channel study such as volume weighted average. If not is there a custom study or a study by another name that would allow this. Thanks.
[2014-01-08 18:41:08]
tomgilb - Posts: 3335
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.
[2014-01-13 14:20:07]
JamesP - Posts: 89
Hey tomgilb,
Thanks for the detailed response. I don't have any experience with the spreadsheet study but I will give this a try. Do you know if it would be possible to add a different moving average to the bid ask volume ratio study? Out of curiosity Tomgilb are you a part of sierra chart admin? Again, thanks for the help.
Jim
[2014-01-13 19:39:56]
tomgilb - Posts: 3335
Do you know if it would be possible to add a different moving average to the bid ask volume ratio study?
Using the formula here:
http://www.sierrachart.com/index.php?l=doc/doc_TechnicalStudiesReference.html#s230

1) Add the Ask Volume study and the Bid Volume study, and Hide both studies.
2) You can use the same instance of the Spreadsheet Study study used for your Keltner, if you set the Draw Style of N(SG4) to Ignore.
3) Put this in cell N3:
=100*(AE3-AG3)/(AE3+AG3)
where the Ask Vol is in column AE and the Bid Vol is in column AG.
4) Add the MA study you want, and set the 'Based On' to the spreadsheet study, column L.
-Set the Length.
-Set the Chart Region.
5) To get a zero line, add the Line study.
-Set the Chart Region to the same as the MA.
-Set the Value to 0.

It is also possible to do your custom Keltner and BA Vol Ratio studies using several instances of various Study Subgraph studies (if you don't want to use a spreadsheet study). Let me know if you'd rather, and need some help.

Out of curiosity Tomgilb are you a part of sierra chart admin?
No, I am just an user of Sierra Chart. But here is my blog on SC spreadsheet studies:
http://sawtoothtrade.com/


To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account