Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 07:42:39 +0000



Post From: Keltner Moving Averages

[2014-01-13 19:39:56]
Sawtooth - Posts: 4120
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/