Messages In This Digest (2 Messages)

1a.: Re: Is there a parameter for a stock's Beta for the RCHGetYahooQuote From: paul messerschmidt
1b.: Re: Is there a parameter for a stock's Beta for the RCHGetYahooQuote From: Ron Spruell

View All Topics | Create New Topic

Messages

1a.: Re: Is there a parameter for a stock's Beta for the RCHGetYahooQuote

Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul

Wed Oct 19, 2011 7:08 am (PDT)

be very careful about using beta values reported by yahoo, reuters, tos, and
others.

it is often 'hard-coded', especially when it's for inverse or leveraged
products.

beta is a slow moving metric, technically the 60-period, monthly co-variance
with SPX (and only closed periods, so the inter-month stock value is not
captured until the month/period has closed. so any october information
won't be captured until after the month is over.)

you can plot this value on tos using 'studies' and 'beta', making sure you
are using 'monthly' data and viewing the latest 'closed' bar (e.g.,
september 2011, as of today), and resetting the period from the default
value of 21 to 60.

unless you have a long term trading strategy, beta has little value for
short-term, hi frequency trades.

and, of course, be sure to know if the beta calculation uses 'adjusted' or
'un-adjusted' stock values (i.e., adjusted for dividends).

tos uses 'un-adjusted' values, while prophet 'adjusts' for dividends -- just
take a look at MO for an example.

know what you trade; trade what you know...

On Tue, Oct 18, 2011 at 11:13 AM, pjwdoyle <pjwdoyle@yahoo.com> wrote:

> **
>
>
> Beta is available on the Yahoo! finance "Key Statistics" page, but I can't
> figure out how to import it into a cell.
>
> Thanks.
>
>
>

--
-----------------------------------------
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1b.: Re: Is there a parameter for a stock's Beta for the RCHGetYahooQuote

Posted by: "Ron Spruell" hashky@yahoo.com hashky

Wed Oct 19, 2011 9:50 am (PDT)

=RCHGetElementNumber("MO",972)

This should get it for you. Beware that it may not be accurate.

Ron

>________________________________
>From: paul messerschmidt <financepaul@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, October 19, 2011 9:08 AM
>Subject: Re: [smf_addin] Is there a parameter for a stock's Beta for the RCHGetYahooQuotes function?
>
>
>
>be very careful about using beta values reported by yahoo, reuters, tos, and others.
>
>
>it is often 'hard-coded', especially when it's for inverse or leveraged products.
>
>
>beta is a slow moving metric, technically the 60-period, monthly co-variance with SPX (and only closed periods, so the inter-month stock value is not captured until the month/period has closed. so any october information won't be captured until after the month is over.)
>
>
>you can plot this value on tos using 'studies' and 'beta', making sure you are using 'monthly' data and viewing the latest 'closed' bar (e.g., september 2011, as of today), and resetting the period from the default value of 21 to 60.
>
>
>unless you have a long term trading strategy, beta has little value for short-term, hi frequency trades.
>
>
>and, of course, be sure to know if the beta calculation uses 'adjusted' or 'un-adjusted' stock values (i.e., adjusted for dividends).
>
>
>tos uses 'un-adjusted' values, while prophet 'adjusts' for dividends -- just take a look at MO for an example.
>
>
>know what you trade; trade what you know...
>
>
>On Tue, Oct 18, 2011 at 11:13 AM, pjwdoyle <pjwdoyle@yahoo.com> wrote:
>
>
>>
>>Beta is available on the Yahoo! finance "Key Statistics" page, but I can't figure out how to import it into a cell.
>>
>>Thanks.
>>
>>
>
>
>
>--
>-----------------------------------------
>Paul Messerschmidt
>paul.messerschmidt (skype)
>+1-813-334-8682 (mobile)
>
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)