Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
AI:=Security("c:\\Metastock Data\\indices & indicators\\market indicators\\X.NYSE-A",C);
AV:=Security("c:\\Metastock Data\\indices & indicators\\market indicators\\X.NYSE-A",V);
DECI:=Security("c:\\Metastock Data\\indices & indicators\\market indicators\\X.NYSE-D",C);
DECV:=Security("c:\\Metastock Data\\indices & indicators\\market indicators\\X.NYSE-D",V);
A:=(AI/DECI)/(AV/DECV);
M4:=Mov(A,4,S);
M21:=Mov(A,21,S);
M55:=Mov(A,55,S);
.7;1.25;.85;1.1;.9;1.05;M4;M21;M55;
Just make sure that the securities are in the proper folders
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Three questions about the ARM's Index:
1) I am using QC data feed. Is this a correct conversion of Henry's formula?
AI:=Security("c:\\Metastock Data\\BM Data\\US&ADVN",C);
AV:=Security("c:\\Metastock Data\\BM Data\\US&UVOL",V);
DECI:=Security("c:\\Metastock Data\\BM Data\\US&DECN",C);
DECV:=Security("c:\\Metastock Data\\BM Data\\US&DVOL",V);
A:=(AI/DECI)/(AV/DECV);
M4:=Mov(A,4,S);
M21:=Mov(A,21,S);
M55:=Mov(A,55,S);
.7;1.25;.85;1.1;.9;1.05;M4;M21;M55
2) There is a Reuter's symbol for the NYSE Trin: "us&trin'. Can the formula somehow be abbreviated to something like this? (The plots are different, so I'm figuring I don't have it right yet).
A:=Security("c:\\Metastock Data\\BM Data\\US&TRIN",C);
M4:=Mov(A,4,S);
M21:=Mov(A,21,S);
M55:=Mov(A,55,S);
.7;1.25;.85;1.1;.9;1.05;M4;M21;M55
3) No matter which of the 2 methods I use above, I keep getting a divide by zero error on each of the moving average lines. How do I correct this?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
AI:=Security("c:\\Metastock Data\\indices & indicators\\market indicators\\X.NASD-A",C);
AV:=Security("c:\\Metastock Data\\indices & indicators\\market indicators\\X.NASD-A",V);
DECI:=Security("c:\\Metastock Data\\indices & indicators\\market indicators\\X.NASD-D",C);
DECV:=Security("c:\\Metastock Data\\indices & indicators\\market indicators\\X.NASD-D",V);
A:=(If(AI=0,.001,AI)/If(DECI=0,.001,DECI))/(If(AV=0,.001,AV)/If(DECV=0,.001,DECV));
M4:=Mov(A,4,S);
M21:=Mov(A,21,S);
M55:=Mov(A,55,S);
.75;1.25;.85;1.15;.9;1.1;M4;M21;M55;
The changes are in Line A
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Thanks Henry! That worked like a charm. :D
For QC data, this is the working formula:
AI:=Security("c:\\Metastock Data\\BM Data\\US&ADVN",C);
AV:=Security("c:\\Metastock Data\\BM Data\\US&UVOL",V);
DECI:=Security("c:\\Metastock Data\\BM Data\\US&DECN",C);
DECV:=Security("c:\\Metastock Data\\BM Data\\US&DVOL",V);
A:=(If(AI=0,.001,AI)/If(DECI=0,.001,DECI))/(If(AV=0,.001,AV)/If(DECV=0,.001,DECV));
M4:=Mov(A,4,S);
M21:=Mov(A,21,S);
M55:=Mov(A,55,S);
.7;1.25;.85;1.1;.9;1.05;M4;M21;M55
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Any idea about what the us&trin is plotting? It looks different; in some places almost a mirror... but then again, not really. Hmm... just call me Curious George!
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Originally Posted by: ONLINE:" must be removed from the Security function and you might also need to change the symbols. The symbols used below are QuoteCenter specific.}
NYSEAdvDecI:=Security( "ONLINE:us&ADVQ", CLOSE )/Security( "ONLINE:us&DECN",CLOSE ) 
I found this built-in formula in QC. The thing is that it produces totally different results than the earlier formula, even using the same data source. How can I tell which one is right?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
I've compared several of the BM data files from reuters and Quotecenter and have found several discrepencies between the two data providers!
Reuters has several missing dates!
QuoteCenter's numbers are close but normally higher than reuter's.
I would think that the number of new lows reported by an exchange would be the same number reported by both Reuters and QuoteCenter!
The missing dates accounts for the numerous division by zero errors that occur in several indicators!
|
|
|
|
|
|
| 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.
