Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/24/2005(UTC)
Posts: 1
Location: Sun Prairie, Wisconsin
|
I am very impressed with the work you guys are doing on the SAR. This week, as I was studying some charts, I gained a real interest in the SAR, which led me to this forum.
Patrick, do you think it's possible to wrestle this code into a Metastock usable trading system? If so, I know you would make a lot of us very happy. I wish I could be of more help, but all I can offer at this point is encouragement!
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/21/2005(UTC)
Posts: 74
Location: Oklahoma USA
|
Here are my formulas I use in an Excel worksheet to compute the SAR. I based this on Wilder's book Source: New Concepts in Techinical Trading Systems by J.. Welles Wilder - Pages 13 & 14. The formulas are from line 5 (item number 4) of the worksheet because you need 3 prior days to get the computation started. I charted it against the Metastock SAR and it does not agree totally, but it is close. Perhaps someone may want to improve on my work. The security is the NDX for 06/29/2005. Charley
Column Column Description Formula/Value
A Date 38532
B Item Number 4
C Trade Position =IF(O4<F5,1,-1)
D
E High 1512.77
F Low 1501.72
G
H Max =MAX(E2:E5)
I Min =MIN(F2:F5)
J EP =IF(C5=1,H5,I5)
K SAR t-1 =+O4
L EP +-SAR =ABS(J5-K5)
M AF =IF(C4<>C3,IF(J4=J5,M4,M4+0.02),0.02)
N AF*Diff =ROUND(M5*L5,2)
O SAR t =+N5+O4
P MS SAR 1544.9482
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Quote:
Patrick, do you think it's possible to wrestle this code into a Metastock usable trading system?
I don't know ... I tried a few weeks back with no success ... But I should have more time for this and the dll soon ...
Patrick :mrgreen:
|
|
|
|
|
|
| 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.
