Hello!)
I wonder if you can help me with this.
I am trying to replicate in excel on technical analysis indicator – Bollinger Bands. They are pretty straight forward to calculate – you take average of the closing prices and add to them 2 standard deviations of the closes above and subtract to place the lower band below. Now I used this approach and the results differ from the two charting packages – first two colored column zones – green and yellow. I also compared my version with the excel specialized technical analysis package EXCEL TECHS and they align almost perfectly with the two charting packages. I also tried step by step FORMULA APPROACH and it does not get the right result as well) I wonder what I am doing wrong here)
More on Bollinger Bands:
http://excelta.blogspot.com/2007/11/...ger-bands.html
I will be waiting to hear what you think on this)
Dima
Bookmarks