| awaisakbar |
|
Gold User, Member, TeleChart
|
| Registered User |
|
|
|
|
| Gender: |
|
| Tuesday, January 10, 2012 |
| Friday, June 8, 2012 10:58:32 PM |
7
[0.00% of all post / 0.00 posts per day] |
|
|
Wonderful. Bruce, you're a ton of help. Thank you and have yourself a great weekend!
|
|
Hi,
I would like to chart 20 period rate of change for OBV and William's A/D. How do I do that?
Thank you.
|
|
This should work. Thank you Bruce!
|
|
Hi Bruce,
Thank you for the prompt response. Fortunately, the author has provided a table in the book which we can use to validate our formula. Here's the data:
|
Open |
High |
Low |
Close |
Volume |
Effective Volume |
|
11.07 |
11.07 |
11.06 |
11.06 |
5,889 |
0 |
|
11.06 |
11.06 |
11.06 |
11.06 |
200 |
0 |
|
11.06 |
11.07 |
11.06 |
11.06 |
28,335 |
0 |
|
11.05 |
11.06 |
11.05 |
11.06 |
18,131 |
18,131 |
|
11.04 |
11.06 |
11.03 |
11.05 |
33,188 |
16,594 |
|
11.03 |
11.04 |
11.03 |
11.04 |
3,298 |
0 |
Can you input this data in Excel to see if our formula works? Alternatively you can provide me the formula and I'll do it myself. And again, thank you for your work.
|
|
Bruce,
Thank you. That helps a lot!
|
|
Hi,
I am trying to create the Effective Volume Formula from the book "Value in Time: Better Trading Through Volue". It's derived from William's A/D line. Here's what the book says:
Effective Volume Formula
The Effective Volume is calculated by using the following formula, which is a modified version of the Larry Williams accumulation/distribution (A/D) formula:
(Closei−1 − Closei) + PI / Highi − Lowi + PI * Volumei
where:
Closei −1 = Closing price corresponding to time interval (i − 1): TIi−1
Closei = Closing price corresponding to time interval i: TIi Highi = Max (Highi, Closei−1)
Lowi = Min (Lowi, Closei−1)
PI = Price interval (usually US $0.01)
As you can see, the Larry Williams formula was changed in three ways:
-
I replaced the open of the time interval with the close of the previous time interval.
-
I adapted the high and the low of the current time interval to the value of the close of the previous time interval.
-
I added the PI number, usually 0.01, to use the exact number of ticks between Closei−1 – Closei and between Highi – Lowi, and not just the mathematical difference between these values.
Can anyone show me how to do it?
Thank you.
|
|
Hi Bruce,
I am trying to convert the 12 bar VWEMA code you posted to a 20 bar and a 50 bar average. I can't figure out what the number at the beginning of your code is all about: .153984303064341 and whether I need to change it to something else or not.
Also to change the exponential moving average to a simple one, I would only need to change the code from XAVG to AVG at the end. Correct?
Thanks.
|
|