Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 01:42:04 +0000



Post From: Uptick and downtick to volume ratio

[2014-12-06 17:10:56]
Sawtooth - Posts: 4000
This is the Spreadsheet Study study formula that replicates the Bid Ask Volume Ratio study when using an EMA:
=((100*(AA3-AC3)/(AA3+AC3))-L4)*(2/(1+$L$1))+L4
where:
the formula in is cell L3
AA3 is the Ask Volume study
AC3 is the Bid Volume study
L1 is the EMA length

You could modify this formula to create a ratio between the Uptick Volume study and the Ask Volume study, e.g., or between any two volume studies.:
Ask Volume
Bid Volume
Number of Trades - Ask
Number of Trades - Bid
Uptick Volume
Downtick Volume
Volume

Attached is an example spreadsheet and study collection. Put both in your Sierra Chart \Data folder. On a blank chart, go to Analysis >> Buy Sell Ratios-



Attachment Deleted.
attachmentBuy Sell Ratios-.StdyCollct - Attached On 2014-12-06 17:10:19 UTC - Size: 53.14 KB - 707 views
attachmentBuy Sell Ratios.scwbf - Attached On 2014-12-06 17:10:36 UTC - Size: 123.18 KB - 614 views