logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
bobylam  
#1 Posted : Sunday, September 13, 2009 3:05:14 AM(UTC)
bobylam

Rank: Member

Groups: Registered, Registered Users
Joined: 6/25/2009(UTC)
Posts: 10

How to find out security with the most narrow bollinger band in X period.

for example: X=300

thanks for your supports.
Data  
#2 Posted : Sunday, September 13, 2009 7:11:59 AM(UTC)
Data

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 5/20/2008(UTC)
Posts: 53

Here's one way to do that for a 20-periods bollinger bands.

Open the Explorer. Create the new exploration " Most narrow Boll" (spaces are important).
Name ColA "Lowest". Then put in this formula :
X:=300;
LLV(stdev(C,20),X)

Then run the exploration on your securities, look at the reports and double-click on the lowest column to sort the securities by the lowest value of bollinger bands.

That being said, it's not really usefull because security prices are different which means you can't compare the bollinger bands of a security to that of an other. I'd create a column B named "ratio" with this formula :
X:=300;
LLV(StDev(C,20)/mov(StDev(C,20),100,E),X)
bobylam  
#3 Posted : Sunday, September 13, 2009 8:52:14 AM(UTC)
bobylam

Rank: Member

Groups: Registered, Registered Users
Joined: 6/25/2009(UTC)
Posts: 10

data,

thanks for your useful supports.
lifelongfool  
#4 Posted : Thursday, November 26, 2009 6:40:53 AM(UTC)
lifelongfool

Rank: Newbie

Groups: Registered, Registered Users
Joined: 11/26/2009(UTC)
Posts: 1

Dear,
I'm a newbie looking for help. I'd like to explore securities with following criteria:
Bollinger bands: the narrowest the best (just compared with itself)
EMA (20 and 40): sideways and moving in nearly the same line
tks a lot
johnl  
#5 Posted : Thursday, November 26, 2009 8:08:28 AM(UTC)
johnl

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602


Try coding like this:

{My variables}
a1:=BBandBot(C,20,S,4)-BBandTop(C,20,S,4);
a2:=Mov(C,20,E);
a3:=Mov(C,40,E);
{------------------------------------}
{Bollinger bands: the narrowest}
b1:=LLV(a1,100);
b2:=((a1-b1)/b1)*100;
b3:=(b2<5);
{------------------------------------}
{sideways}
c1:=HHV(a2,20)-LLV(a3,20);
c2:=c1<(0.1*C);
{------------------------------------}
{and moving in nearly the same line}
d1:=Mov(c1,20,S);
d2:=(Stdev(d1,20)<5);
b3*c2*d2

Write a sentence of what you want, break it out into segments, bracket the English,
then code each segment. This keeps you organized and it is easier to maintain and
change since the English is easier to read. Try plotting each b3,c2,d2 separately to
see if you want to change one, then just change the code.

Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.