How to Calculate the Bollinger Bands Indicator in Excel

Video showing how to calculate Bollinger Bands using Excel. If you want to see the formulas used in this video, the accompanying article is posted: http://wp.me/p32qmZ-BL How to calculate this and other popular indicators are included in my latest eBook, now available in the Amazon Kindle Store: http://amzn.to/1smFKHr My ebook course on building backtest models in Excel is also available in the Amazon Kindle Store: http://amzn.to/15NDaw4 Follow me on twitter: https://twitter.com/Tradinformed www.tradinformed.com

Comments

1. Well done Mark. Thanks a million. I never knew the trick of F4 to convert to absolute notation and double click on the right down corner to fill the below cells!
   
   HOWEVER,
   
   A mistake you made, when you started to calculate STDEVPA, is that you overlooked the first row of data due to freezing the upper label 3 rows. So, you actually ignored row no. 4. Thereby, you considered 19 rows instead of 20.
2. Can you teach me to be rich? Why does FMCC and FNMA keep dropping at around 4.50 back down to 2.50?
3. Hi Mark - QUESTION; - you show to take the average of cells F4 thru F23 (20 cells) to initially calculate the average. Then you state to take the entire population of the SAME period... yet you only sample 19 cells? - please explain - thanks.
4. Thanks ! - I found that using STDEV.S rather than STDEVPA was more relevant to what my Trading Platform was using.
5. Hi Mark, thanks for the video. Just curious, why people use different values of standard deviation to calculate the bollinger bands? What are the effects if we use different values of the std? Thanks 
6. Extremely useless video. You started with a chart and there was nothing about the chart. Cannot dislike it more than once, the link to the article is even rubbish. Be happy you got a visitor to your rubbish video and even more rubbish article