Senin, 28 Januari 2013

[smf_addin] Digest Number 2484

5 New Messages

Digest #2484
1a
Re: Historical Stock screener by "Kermit W. Prather" kermitpra
1b
Re: Historical Stock screener by "Randy Harmelink" rharmelink
2a
Re: Ex-Dividend Dates with RCHGetYahooQuotes by "Kermit W. Prather" kermitpra
2b
Re: Ex-Dividend Dates with RCHGetYahooQuotes by "Randy Harmelink" rharmelink
3a
Re: Industry and sector group by "y_charles_2000" y_charles_2000

Messages

Mon Jan 28, 2013 6:35 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

I list 4 really good stockscreener on the link page of my website. I, also, have lots of other useful links.

http://tradingourway.com/Site_linkage.html

I use Worden's TC2000.com but it is not free. http://www.worden.com/CURRENTAFPROMO.aspx?AFCODE=131



From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Simona G
Sent: Monday, January 28, 2013 9:11 AM
To: smf_addin@yahoogroups.com
Cc: smf_addin@yahoogroups.com
Subject: [smf_addin] Historical Stock screener


Hello
Does anybody know of a good reliable stockscreener, linked to historical finance data where one can screen go multiple value parameters based on historical finance data from 10 years ago?
Many thanks
Simona

Sent from my iPhone

On 28.01.2013, at 14:09, "tenenbaum88" kenneth.dooley@gmail.com> wrote:

Good catch, thanks ... however, we should add preferred shares and minority interest to be accurate. I might have to use data from a few sites in order to get at it.

Thanks

--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> I've never looked at the details of it. Just used the value as is.
>
> But everything you need is right there on the Key Statistics page, right?
>
> EV = Market Cap + Total Cash - Total Debt
>
> That matches for MMM:
>
> EV = 69.11B + 4.53B - 6.00B = 70.58B
>
> All four of those amounts are there.
>
> On Sun, Jan 27, 2013 at 11:21 PM, tenenbaum88 wrote:
>
> >
> > This question is not specific to the smf addon, but I have a feeling you
> > more than anyone might have a decent sense of the quality of data found on
> > the main free financial data sites. Do you have a sense of how good the
> > 'enterprise value' data is from Yahoo? I ask because it is noted on their
> > site that the data is "derived from multiple sources or calculated by
> > Yahoo! Finance" ... which sounds potentially dubious to me.
> >
>

Mon Jan 28, 2013 6:55 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Portfolio123.com and StockScreen123.com both have backtesters with
point-in-time data back to 1999. And they have a number of data items that
refer to financial statement items, which can go back for 10 annual periods
or 20 quarterly periods at each point-in-time.

However, they're not cheap. They currently use CompuStat data.

On Mon, Jan 28, 2013 at 7:10 AM, Simona G simona4051@yahoo.com> wrote:

> Does anybody know of a good reliable stockscreener, linked to historical
> finance data where one can screen go multiple value parameters based on
> historical finance data from 10 years ago?
>

Mon Jan 28, 2013 6:38 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

There is a template in the files section for http://dividata.com I have
used this site for a long time and they are fairly accurate.

RCHGetTableCell-Template-DivData-Upcoming-Ex-Dividend

Or try this site: http://www.dividendium.com/ it is a $20/yr charge for
prediction of future ex-dividend date

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of D DAR
Sent: Sunday, January 27, 2013 11:17 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Ex-Dividend Dates with RCHGetYahooQuotes


The daily page presents the all of the tickers on the same page, so the
links for each company link wouldn't need to be followed. But, it wouldn't
account for missing companies such as HCP or MSEX.
On Sun, Jan 27, 2013 at 10:30 PM, Randy Harmelink rharmelink@gmail.com>
wrote:

It would be better to get it by the week, instead of by the day:

http://earnings.com/dividend_week.asp?date=20130128
http://earnings.com/dividend_week.asp?date=20130128&client=cb> &client=cb

...but right now it doesn't have either the HCP or MSEX ex-dividend date.
But there are a lot of tickers to be extracted from the web page, and not a
trivial extraction because it would need to be from the links on the web
page.

On Sun, Jan 27, 2013 at 7:59 PM, D DAR positive.theta@gmail.com> wrote:

Instead of doing a ticker-based retrieval, could you aggregate multiple
date-based retrievals from earnings.com? I don't know how accurate their
data is.

http://earnings.com/dividend.asp?date=20130128
http://earnings.com/dividend.asp?date=20130128&client=cb> &client=cb


Mon Jan 28, 2013 6:57 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It was also missing the HCP and MSEX dividends when I check over the
weekend.

Might be interesting to track how long it takes them to add the new
ex-dividend date for HCP, since it is coming up on Feb 2nd.

On Mon, Jan 28, 2013 at 7:34 AM, Kermit W. Prather
kermitp@tampabay.rr.com>wrote:

>
>
> There is a template in the files section for http://dividata.com I
> have used this site for a long time and they are fairly accurate.****
>
> ** **
>
> RCHGetTableCell-Template-DivData-Upcoming-Ex-Dividend****
>
> ** **
>
> Or try this site: http://www.dividendium.com/ it is a $20/yr charge for
> prediction of future ex-dividend date
>

Mon Jan 28, 2013 7:14 am (PST) . Posted by:

"y_charles_2000" y_charles_2000

Thanks a lot!

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> You can use RCHGetElementNumber() to get it from Yahoo:
>
> *#* *Source* *Element* *Example: IBM* 13865 YahooIN Sector Name Technology
> 13867 YahooIN Industry Name Diversified Computer Systems
> But be aware that different data providers have different groupings.
>
> On Fri, Jan 25, 2013 at 9:05 AM, y_charles_2000 wrote:
>
> >
> > I need a hand to retrieve from yahoo or google finance the sector or the
> > industry for a given stock on excel?
> > Any help would be greatly appreciate !!
> >
>

Tidak ada komentar:

Posting Komentar