3 New Messages
Digest #2562
Messages
Wed Mar 27, 2013 11:12 am (PDT) . Posted by:
"iamruf" iamruf
Hi Randy,
The following Yahoo screen displays 7500+ stock betas.
Is there any information on how they calculate beta - time period etc.
Also, is there a way to download the data?
Regards
http://screener.finance.yahoo.com/b?beta=0/&b=1&s=tk&db=stocks&vw=1
The following Yahoo screen displays 7500+ stock betas.
Is there any information on how they calculate beta - time period etc.
Also, is there a way to download the data?
Regards
http://screener.
Wed Mar 27, 2013 11:23 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You could grab the data, one page at a time, using the RCHGetHTMLTable() or
RCHGetTableCell() functions.
For definition of beta, click on "Help" and then search on beta. You'll
find it on the "Understanding Key Statistics" page entry.
It would be easier to get it from FinViz (see LINKS area of group for more
details), but I don't know what their definition is.
On Wed, Mar 27, 2013 at 11:12 AM, iamruf <iamruf@yahoo.com > wrote:
> Hi Randy,
> The following Yahoo screen displays 7500+ stock betas.
> Is there any information on how they calculate beta - time period etc.
> Also, is there a way to download the data?
> Regards
> http://screener.finance.yahoo.com/b?beta=0/&b=1&s=tk&db=stocks&vw=1
>
RCHGetTableCell(
For definition of beta, click on "Help" and then search on beta. You'll
find it on the "Understanding Key Statistics" page entry.
It would be easier to get it from FinViz (see LINKS area of group for more
details), but I don't know what their definition is.
On Wed, Mar 27, 2013 at 11:12 AM, iamruf <iamruf@yahoo.
> Hi Randy,
> The following Yahoo screen displays 7500+ stock betas.
> Is there any information on how they calculate beta - time period etc.
> Also, is there a way to download the data?
> Regards
> http://screener.
>
Wed Mar 27, 2013 1:46 pm (PDT) . Posted by:
"Ricky Steed" rickysteed79
Thanks Randy for taking the time to explain that. IT makes more sense to me now.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Well, it's not really intended for scanning, but for retrieving ad hoc data
> on a small set of stocks. That's why I was stressing using a screener like
> Zacks to first get down to that small set of stocks, where you can then get
> more detailed information on them. Information that WASN'T available in the
> screening tool. In this case, both declared ex-dividend date and an
> estimate of the next ex-dividend date based on when the stock went
> ex-dividend last year.
>
> The add-in itself is primarily a collection of user-defined functions that
> can take data off of the Internet and put it into EXCEL cells. Similar to
> an EXCEL Web Query, but with more flexibility and precision.
>
> For example, when I was looking to see what the ex-dividend date of a stock
> was from the previous year, I was using a formula that looked like this:
>
> =RCHGetYahooHistory(rTicker,YEAR(rBegDate)-1,MONTH(rBegDate),DAY(rBegDate),
> YEAR(rEndDate)-1,MONTH(rEndDate),DAY(rEndDate),"v",,0)
>
> ...which works on these yellow-shaded cells and returns the dividend date,
> if any, from the previous year, that would be between the two specified
> dates:
>
> BegDate EndDate *Ticker* *Prev Ex-Div* 2013-03-26 2013-04-20 FCX
> 2012-04-11
> The last declared ex-dividend date is retrieved with:
>
> =DATEVALUE(smfGetTagContent("
> http://research.tdameritrade.com/public/stocks/overview/overview.asp?symbol=
> "&rTicker,"div",1,">Ex-Dividend"))
>
> ...and so forth and so on.
>
> It can't retrieve data from every web page, but it can access almost any
> web page the EXCEL web query process can go after -- because both processes
> use the Microsoft Window libraries for Internet web page retrieval.
>
> On Tue, Mar 26, 2013 at 10:36 PM, Ricky Steed <rickysteed79@...>wrote:
>
> >
> > Will your program work for finding stocks with dividends that we were
> > talking about on the other newsgroup? Can you also tell me what I can do
> > with your program. Thanks
> >
>
--- In smf_addin@yahoogrou
>
> Well, it's not really intended for scanning, but for retrieving ad hoc data
> on a small set of stocks. That's why I was stressing using a screener like
> Zacks to first get down to that small set of stocks, where you can then get
> more detailed information on them. Information that WASN'T available in the
> screening tool. In this case, both declared ex-dividend date and an
> estimate of the next ex-dividend date based on when the stock went
> ex-dividend last year.
>
> The add-in itself is primarily a collection of user-defined functions that
> can take data off of the Internet and put it into EXCEL cells. Similar to
> an EXCEL Web Query, but with more flexibility and precision.
>
> For example, when I was looking to see what the ex-dividend date of a stock
> was from the previous year, I was using a formula that looked like this:
>
> =RCHGetYahooHistory
> YEAR(rEndDate)
>
> ...which works on these yellow-shaded cells and returns the dividend date,
> if any, from the previous year, that would be between the two specified
> dates:
>
> BegDate EndDate *Ticker* *Prev Ex-Div* 2013-03-26 2013-04-20 FCX
> 2012-04-11
> The last declared ex-dividend date is retrieved with:
>
> =DATEVALUE(smfGetTa
> http://research.
> "&rTicker,
>
> ...and so forth and so on.
>
> It can't retrieve data from every web page, but it can access almost any
> web page the EXCEL web query process can go after -- because both processes
> use the Microsoft Window libraries for Internet web page retrieval.
>
> On Tue, Mar 26, 2013 at 10:36 PM, Ricky Steed <rickysteed79@
>
> >
> > Will your program work for finding stocks with dividends that we were
> > talking about on the other newsgroup? Can you also tell me what I can do
> > with your program. Thanks
> >
>
Tidak ada komentar:
Posting Komentar