Daily deals in US, India updated almost daily. Only verified deals would be uploaded
Friday, July 20, 2007
Bollinger Bands
The purpose of Bollinger Bands is to provide a relative definition of high and low.
Bollinger Bands consist of a set of three curves drawn in relation to securities prices.
The middle band is a measure of the intermediate-term trend, usually a simple moving average, that serves as the base for the upper and lower bands.
The interval between the upper and lower bands and the middle band is determined by volatility,typically the standard deviation of the same data that are used for the average.
The default parameters,are 20day (periods) and two standard deviations:
Middle Bollinger Band = 20-Day simple moving average
Upper Bollinger Band = Middle Bollinger Band + 2 * 20-period standard deviation
Lower Bollinger Band = Middle Bollinger Band - 2 * 20-period standard deviation
the interpretation of the Bollinger Bands is based on the fact that the prices tend to remain in between the top and the bottom line of the bands.
A distinctive feature of the Bollinger Band indicator is its variable width due to the volatility of prices.
In periods of considerable price changes (i.e. of high volatility) the bands widen leaving a lot of room to the prices to move in. During standstill periods, or the periods of low volatility the band contracts keeping the prices within their limits.
Calculation
Bollinger bands are formed by three lines. The middle line (ML) is a usual Moving Average.
ML = SUM[CLOSE, N]/N
The top line, TL, is the same as the middle line a certain number of standard deviations (D) higher than the ML.
TL = ML+(D*StdDev)
The bottom line (BL) is the middle line shifted down by the same number of standard deviations.
BL = ML-(D*StdDev)
Where:
N is the number of periods used in calculation;
SMA = Simple Moving Average;
StdDev = means Standard Deviation.
StdDev = SQRT(SUM[(CLOSE-SMA(CLOSE,N))^2,N]/N)
It is recommended to use 20-period Simple Moving Average as the middle line, and plot top and bottom lines two standard deviations away from it.
To Calculate Bollinger Bands of Nifty or Individual stock in MS Excel:.
Column,values to enter, formulas U have to enter
A = Company Name/date
B = Open
C = High
D = Low
E = LTP/close
F = Volumes
first we have to calculate a 20-day standard deviation:
G = here, we have to calculate mean (or Simple Mov. Aver.) of 20 days, we add all 20 days clsoing prices and divide it by 20.i.e no.of periods we require.so in cell G21(20th day) u have to enter formula,it is =SUM(E2:E22)/20
then,we have to manually copy the mean (ie.Simple Mov. Aver.) of 20 days above the G21.till we complete 20 days.ie. G21+19 cells above it.
H = then,we have to calculate deviation for these 20 day period so subract SMA from closing price we get deviation =E2-G2
I = then have to square the deviation so =POWER(H2,2)
J = standard deviation = then,we divide the sum of the squared deviation by the number of days so formula is =SQRT(SUM(I2:I21)/20)
Bollinger bands are formed by three lines.
G = Middle band
K = Upper band (SMA plus 2 standard deviations) =G21+(2*J21)
L = Lower band (SMA minus 2 standard deviations) =G21-(2*J21)
Conclusions
Even though Bollinger Bands can help generate buy and sell signals, they are not designed to determine the future direction of a security.
Bollinger Bands serve two primary functions:
-To identify periods of high and low volatility
-To identify periods when prices are at extreme, and possibly unsustainable, levels.
Remember that buy and sell signals are not given when prices reach the upper or lower bands. Such levels merely indicate that prices are high or low on a relative basis.
A security can become overbought or oversold for an extended period of time.
Finally,the bands are just bands,not signals.A band of the upper Bollinger Band is NOT a sell signal. A bands of the lower Bollinger Band is NOT a buy signal.
Trading Posts:
Entities and Condition in Trading System
Settlement of Futures and Options
Understanding Futures Contracts
Understanding Options Contracts
Comparison between Futures and Options
Frequently Asked Questions about Futures Contracts - part 1
Frequently Asked Questions about Futures Contracts - part 2
Frequently Asked Questions about Futures Contracts - part 3
Frequently Asked Questions about Options Contracts - Part 1
Frequently Asked Questions about Options Contracts - Part 2
Frequently Asked Questions about Options Contracts - Part 3
Frequently Asked Questions about Options Contracts - Part 4
Frequently Asked Questions about Options Contracts - Part 5 (Options Strategies)
Technical Analysis-BasicsTechnical Analysis - Support and resistance
Evergreen Posts
Popular Posts for last 7 days
-
Unrelated Headlines just for Humor Take a deep breath, but don’t count on it | I am a lousy politician: Omar Abdullah Students in dock for...
-
Unrelated Headlines just for Humor Alagiri,Mamata Banerjee tops list of absentee Cabinet ministers | India highest consumer of heroin in So...
-
Unrelated Headlines just for Humor Doppler officials pray for sunshine | ‘Monsoon 11% less so far’ Grains pile up, no relief for people |...
-
Nifty Technicals forecast for Friday 30-October-2015 On 29-October-2015, Nifty closed at:8,111.75(-59.45) for 30-October-2015, Its Fr...
All Time Popular Posts
-
Lucky leopard escaped from Mysore Infosys. infosys mysore campus had an unusual drama early Wednesday morning. The jobless leopard(in sear...
-
Flyers Trapped, Robbers on loot. In an unprecedented occurrence, passengers flying or booked on Kingfisher flights were stuck in aircra...
-
Pakistani actress Veena Malik may be upping the TRPs by being part of the 'Bigg Boss' household in India, but in her country she is ...
-
Pakistani actor Veena Malik was injured in a car accident in Pakistan. Veena was travelling from Islamabad to Lahore. (Flashback: Veena Mali...
No comments :
Post a Comment