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

Notification

Icon
Error

Options
Go to last post Go to first unread
Nevadagold  
#1 Posted : Tuesday, November 9, 2010 10:11:48 AM(UTC)
Nevadagold

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 9/13/2010(UTC)
Posts: 7

Michael Carr's Smarter Investing in Any Economy: The Definitive Guide to Relative Strength Investing; recommends calculating Relative Strength using Alpha. Using Excel and weekly closing data of Percentage Change of Stock and Percentage Change of Index, he plots a scattergraph of results. Using linear regression a best fit line is drawn and displayed as a slope y=mx+b. The y-intercept (b) is Alpha. He then divides this by the 26 period standard deviation to express a volatility based RS.

He sorts his buy list in this manner ranking the highest Alpha's as percentiles. He buys the top couple percent and sells when they drop below a certain percentile.

I'm trying to put together an Exploration to do this. Has anyone attempted this? Anyone at all??

The canned Alpha in Metastock doesn't seem to deliver this--has anyone coded it?

thanks

Glen

MS Support  
#2 Posted : Monday, November 15, 2010 3:08:49 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,967

Thanks: 93 times
Was thanked: 156 time(s) in 151 post(s)
The Alpha formula in MetaStock is a standard investment calculation. It is described here:
http://en.wikipedia.org/wiki/Alpha_(finance)

Michael Carr's usage is more of the math and science notation where alpha is commonly a reference to quantities such as angles.

At this time, I'm not aware of a MetaStock formula for Mr. Carr's "Relative Strength using Alpha"
wabbit  
#3 Posted : Monday, November 15, 2010 6:41:49 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)

Although I believe there is an outside chance this functionality might be able to be coded in MSFL; like always, if I have to think for more than just a moment about how to workaround the limitations of the MSFL then I just write an external function.

From a programmers' perspective, the project needs some more definition but it is most certainly achievable in C/C++/Pascal/Powerbasic.

wabbit [:D]

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.