Sabtu, 13 September 2014

[smf_addin] Digest Number 3178

15 Messages

Digest #3178
1d
Re: Element 992 - Div Ex Date by "Kaloyan N. Kenov" isabella.ascione
1g
Re: Element 992 - Div Ex Date by "Kermit W. Prather" kermitpra
1i
Re: Element 992 - Div Ex Date by "Kaloyan N. Kenov" isabella.ascione
1k
Re: Element 992 - Div Ex Date by "Kermit W. Prather" kermitpra
1l
Re: Element 992 - Div Ex Date by "Randy Harmelink" rharmelink
3a
Mac Yahoo by minding0
3b
Re: Mac Yahoo by "Randy Harmelink" rharmelink

Messages

Sat Sep 13, 2014 9:37 am (PDT) . Posted by:

ssztaba

Dear Randy,

I've been using the RCHGetElementNumber(Symbol,992) to get the Ex Dividend dates for a list of stocks. I've been noticing that many (most) of the dates returned are old -- that is, they are not even the most recent Ex date.

For example element 992 for WY returns a date of May 7, 2014. Yes, that's true, but there was also an Ex date on August 27. Similarly for WAG, element 992 returns May 19th, but not the more recent date of August 19.

Of my list of about 180 stocks with dividends, only about 60 of them show dates later than July 2014.

Is there something about the way Yahoo stores data that causes element 992 to return old dates ?? Is there another element # that would be better?

In contrast with the old Ex dates from element 992, element 1285 (for the Next Earnings date) provides only future dates.

Thanks, as always,

Stan





Sat Sep 13, 2014 11:00 am (PDT) . Posted by:

elderbands

Stan: I would appreciate it if you would send the web site to get ex
dividend dates to me. The one I use does not give it unless it has been
announced a few days in advance.(dividend.com)
Thank you,
Manny
(_elderbands@aol.com_ (mailto:elderbands@aol.com) )


In a message dated 9/13/2014 12:37:54 P.M. Eastern Daylight Time,
smf_addin@yahoogroups.com writes:

Dear Randy,

I've been using the RCHGetElementNumber(Symbol,992) to get the Ex Dividend
dates for a list of stocks. I've been noticing that many (most) of the
dates returned are old -- that is, they are not even the most recent Ex
date.

For example element 992 for WY returns a date of May 7, 2014. Yes,
that's true, but there was also an Ex date on August 27. Similarly for WAG,
element 992 returns May 19th, but not the more recent date of August 19.

Of my list of about 180 stocks with dividends, only about 60 of them show
dates later than July 2014.

Is there something about the way Yahoo stores data that causes element 992
to return old dates ?? Is there another element # that would be better?

In contrast with the old Ex dates from element 992, element 1285 (for the
Next Earnings date) provides only future dates.

Thanks, as always,

Stan

Sat Sep 13, 2014 11:01 am (PDT) . Posted by:

elderbands



In a message dated 9/13/2014 2:00:44 P.M. Eastern Daylight Time,
smf_addin@yahoogroups.com writes:

Stan: I would appreciate it if you would send the web site to get ex
dividend dates to me. The one I use does not give it unless it has been
announced a few days in advance.(dividend.com)
Thank you,
Manny
(_elderbands@aol.com_ (mailto:elderbands@aol.com) )


In a message dated 9/13/2014 12:37:54 P.M. Eastern Daylight Time,
smf_addin@yahoogroups.com writes:

Dear Randy,

I've been using the RCHGetElementNumber(Symbol,992) to get the Ex Dividend
dates for a list of stocks. I've been noticing that many (most) of the
dates returned are old -- that is, they are not even the most recent Ex
date.

For example element 992 for WY returns a date of May 7, 2014. Yes,
that's true, but there was also an Ex date on August 27. Similarly for WAG,
element 992 returns May 19th, but not the more recent date of August 19.

Of my list of about 180 stocks with dividends, only about 60 of them show
dates later than July 2014.

Is there something about the way Yahoo stores data that causes element 992
to return old dates ?? Is there another element # that would be better?

In contrast with the old Ex dates from element 992, element 1285 (for the
Next Earnings date) provides only future dates.

Thanks, as always,

Stan

Sat Sep 13, 2014 11:05 am (PDT) . Posted by:

"Kaloyan N. Kenov" isabella.ascione

Elderbands,

Please check this one for ex-dividends, hope it is of help
http://research.investors.com/options-center/reports/dividends

Thanks

On Sat, Sep 13, 2014 at 7:01 PM, elderbands@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
>
>
> In a message dated 9/13/2014 2:00:44 P.M. Eastern Daylight Time,
> smf_addin@yahoogroups.com writes:
>
>
>
> Stan: I would appreciate it if you would send the web site to get ex
> dividend dates to me. The one I use does not give it unless it has been
> announced a few days in advance.(dividend.com)
> Thank you,
> Manny (
> elderbands@aol.com)
>
> In a message dated 9/13/2014 12:37:54 P.M. Eastern Daylight Time,
> smf_addin@yahoogroups.com writes:
>
>
>
> Dear Randy,
>
> I've been using the RCHGetElementNumber(Symbol,992) to get the Ex Dividend
> dates for a list of stocks. I've been noticing that many (most) of the
> dates returned are old -- that is, they are not even the most recent Ex
> date.
>
> For example element 992 for WY returns a date of May 7, 2014. Yes,
> that's true, but there was also an Ex date on August 27. Similarly for
> WAG, element 992 returns May 19th, but not the more recent date of August
> 19.
>
> Of my list of about 180 stocks with dividends, only about 60 of them show
> dates later than July 2014.
>
> Is there something about the way Yahoo stores data that causes element 992
> to return old dates ?? Is there another element # that would be better?
>
> In contrast with the old Ex dates from element 992, element 1285 (for the
> Next Earnings date) provides only future dates.
>
> Thanks, as always,
>
> Stan
>
>
>
>
>

Sat Sep 13, 2014 11:08 am (PDT) . Posted by:

elderbands

Thank you very much,
Manny


In a message dated 9/13/2014 2:05:37 P.M. Eastern Daylight Time,
smf_addin@yahoogroups.com writes:

Elderbands,

Please check this one for ex-dividends, hope it is of help
http://research.investors.com/options-center/reports/dividends

Thanks

On Sat, Sep 13, 2014 at 7:01 PM, _elderbands@aol.com_
(mailto:elderbands@aol.com) [smf_addin] <_smf_addin@yahoogroups.com_
(mailto:smf_addin@yahoogroups.com) > wrote:

In a message dated 9/13/2014 2:00:44 P.M. Eastern Daylight Time,
_smf_addin@yahoogroups.com_ (mailto:smf_addin@yahoogroups.com) writes:

Stan: I would appreciate it if you would send the web site to get ex
dividend dates to me. The one I use does not give it unless it has been
announced a few days in advance.(_dividend.com_ (http://dividend.com/) )
Thank you,
Manny
(_elderbands@aol.com_ (mailto:elderbands@aol.com) )


In a message dated 9/13/2014 12:37:54 P.M. Eastern Daylight Time,
_smf_addin@yahoogroups.com_ (mailto:smf_addin@yahoogroups.com) writes:

Dear Randy,

I've been using the RCHGetElementNumber(Symbol,992) to get the Ex Dividend
dates for a list of stocks. I've been noticing that many (most) of the
dates returned are old -- that is, they are not even the most recent Ex
date.

For example element 992 for WY returns a date of May 7, 2014. Yes,
that's true, but there was also an Ex date on August 27. Similarly for WAG,
element 992 returns May 19th, but not the more recent date of August 19.

Of my list of about 180 stocks with dividends, only about 60 of them show
dates later than July 2014.

Is there something about the way Yahoo stores data that causes element 992
to return old dates ?? Is there another element # that would be better?

In contrast with the old Ex dates from element 992, element 1285 (for the
Next Earnings date) provides only future dates.

Thanks, as always,

Stan

Sat Sep 13, 2014 11:10 am (PDT) . Posted by:

elderbands



In a message dated 9/13/2014 2:08:54 P.M. Eastern Daylight Time,
smf_addin@yahoogroups.com writes:

Thank you very much,
Manny


In a message dated 9/13/2014 2:05:37 P.M. Eastern Daylight Time,
smf_addin@yahoogroups.com writes:

Elderbands,

Please check this one for ex-dividends, hope it is of help
http://research.investors.com/options-center/reports/dividends

Thanks

On Sat, Sep 13, 2014 at 7:01 PM, _elderbands@aol.com_
(mailto:elderbands@aol.com) [smf_addin] <_smf_addin@yahoogroups.com_
(mailto:smf_addin@yahoogroups.com) > wrote:

In a message dated 9/13/2014 2:00:44 P.M. Eastern Daylight Time,
_smf_addin@yahoogroups.com_ (mailto:smf_addin@yahoogroups.com) writes:

Stan: I would appreciate it if you would send the web site to get ex
dividend dates to me. The one I use does not give it unless it has been
announced a few days in advance.(_dividend.com_ (http://dividend.com/) )
Thank you,
Manny
(_elderbands@aol.com_ (mailto:elderbands@aol.com) )


In a message dated 9/13/2014 12:37:54 P.M. Eastern Daylight Time,
_smf_addin@yahoogroups.com_ (mailto:smf_addin@yahoogroups.com) writes:

Dear Randy,

I've been using the RCHGetElementNumber(Symbol,992) to get the Ex Dividend
dates for a list of stocks. I've been noticing that many (most) of the
dates returned are old -- that is, they are not even the most recent Ex
date.

For example element 992 for WY returns a date of May 7, 2014. Yes,
that's true, but there was also an Ex date on August 27. Similarly for WAG,
element 992 returns May 19th, but not the more recent date of August 19.

Of my list of about 180 stocks with dividends, only about 60 of them show
dates later than July 2014.

Is there something about the way Yahoo stores data that causes element 992
to return old dates ?? Is there another element # that would be better?

In contrast with the old Ex dates from element 992, element 1285 (for the
Next Earnings date) provides only future dates.

Thanks, as always,

Stan

Sat Sep 13, 2014 11:37 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I have tried most of the sites that specialize in dividends and none of them can provide the ex-dividend date very far into the future.
Dividend.com premium provides the ex-dividend date with a day of the company making the announcement.
I subscribe to dividend.com and have watchlist setup with over 200 dividend stocks I follow. I get an email as soon as the next ex-dividend date announcement is made.
Dividata.com also has the ex-dividend date within a few days of announcement but dividata does not cover all stocks.
There is a few spreadsheet on SMF-Addin for dividata's upcoming dividend dates. That might be helpful if it covers your list of stocks.

Divdendchannel has a best guess projection based on previous dates.

https://www.dividendchannel.com/symbol/ainv/next-dividend-date/
AINV Next Dividend Date Projection
Last known ex-date: 09/17/14
Last known frequency: Quarterly
Last known quarterly dividend: 0.20
Expected annual yield: 9.06%
Typical ex-date schedule:
* February 15th
* March 19th
* June 18th
* September 13th
* December 14th


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, September 13, 2014 2:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Element 992 - Div Ex Date


Elderbands,

Please check this one for ex-dividends, hope it is of help http://research.investors.com/options-center/reports/dividends

Thanks


On Sat, Sep 13, 2014 at 7:01 PM, elderbands@aol.com [smf_addin] <smf_addin@yahoogroups.com> wrote:



In a message dated 9/13/2014 2:00:44 P.M. Eastern Daylight Time, smf_addin@yahoogroups.com writes:

Stan: I would appreciate it if you would send the web site to get ex dividend dates to me. The one I use does not give it unless it has been announced a few days in advance.(dividend.com)
Thank you,
Manny (elderbands@aol.com)

In a message dated 9/13/2014 12:37:54 P.M. Eastern Daylight Time, smf_addin@yahoogroups.com writes:

Dear Randy,

I've been using the RCHGetElementNumber(Symbol,992) to get the Ex Dividend dates for a list of stocks. I've been noticing that many (most) of the dates returned are old -- that is, they are not even the most recent Ex date.

For example element 992 for WY returns a date of May 7, 2014. Yes, that's true, but there was also an Ex date on August 27. Similarly for WAG, element 992 returns May 19th, but not the more recent date of August 19.

Of my list of about 180 stocks with dividends, only about 60 of them show dates later than July 2014.

Is there something about the way Yahoo stores data that causes element 992 to return old dates ?? Is there another element # that would be better?

In contrast with the old Ex dates from element 992, element 1285 (for the Next Earnings date) provides only future dates.

Thanks, as always,

Stan

Sat Sep 13, 2014 11:47 am (PDT) . Posted by:

ssztaba

Dear Manny, and Kaloyan,

There are many sites for getting Dividend info. In addition to the Investors.com site mentioned by Kaloyan there is also Dividendinvestor.com

However, I find using Randy's smf add-in far superior. Using the element #s, I can get in one pass the data for hundreds of stocks into an Excel worksheet for five items; the Ex date; the Pay date; the Dividend $ per year; the Dividend Yield per year; and the Next Earnings Date.

There are many more items which are available to me via the smf add-in using element #s, but those five were the one's I was interested in.

Stan

Sat Sep 13, 2014 11:50 am (PDT) . Posted by:

"Kaloyan N. Kenov" isabella.ascione

Thank you Stan.

On Sat, Sep 13, 2014 at 7:47 PM, ssjurik@optonline.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Dear Manny, and Kaloyan,
>
> There are many sites for getting Dividend info. In addition to the
> Investors.com site mentioned by Kaloyan there is also Dividendinvestor.com
>
> However, I find using Randy's smf add-in far superior. Using the
> element #s, I can get in one pass the data for hundreds of stocks into an
> Excel worksheet for five items; the Ex date; the Pay date; the Dividend $
> per year; the Dividend Yield per year; and the Next Earnings Date.
>
> There are many more items which are available to me via the smf add-in
> using element #s, but those five were the one's I was interested in.
>
> Stan
>
>

Sat Sep 13, 2014 11:55 am (PDT) . Posted by:

ssztaba

Thanks for the Dividend Channel info.

Do you have the location of the info for using the smf add-in with Dividata ?? (I always get lost looking around for the treasures)

Stan

Sat Sep 13, 2014 12:58 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

First, If you are going to use dividata.com you might want to check if they support your stocks.
You can get a list of stocks with http://dividata.com/stocklist/A where "A" is the first letter of the stock symbol.
For example, If you were looking for ILMN then the URL would be http://dividata.com/stocklist/I
You will have to search the webpage because they are not listed in symbol but are list by company name.
I used ILMN as an example because it had 1 stock split and grossed $347.75 per share purchased for the last 10 years.
If you had bought and held it your returned on a $6.53 would be 5,325%. What do you know, sometimes buy and hold works
Too bad, I am a short term trader.


My stock list
Number of Shares Purchased
Purchase Date
Sell Date or last Close Date
Closing Price date of Purchase
Total purchase price
Close price on sell date
Number Shares after Splits
Total value at sell date
Total Profit with Stock Splits
% Profit with Stock Splits
Total Dividend payout after purchased date
Total profit including Dividend payouts after purchased date
% Profit with Stock Splits and Dividend payouts
Number of Stock splits
Dividend Yield (N/A) means that is what dividata.om returns

ILMN
1
9/14/2004
9/11/2014
6.53
6.53
177.14
2.00
354.28
347.75
5325.4%
0.00
347.75
5325.4%
1
N/A

I told you the above to impress on you the important of knowing what stocks a website supports. Because if you just use SMF-SDDIN to capture the data you can be mislead.
I have found that there isn't any site that covers 100% of the stocks.

Actually, Randy has made it super easy for us lazy people.


Just go to his new site http://ogres-crypt.com/SMF/
Find the http://ogres-crypt.com/SMF/SMF-All-Files.csv on home page

click on it. Then search for whatever you are looking for in this case Upcoming
You'll get 2 hits both in row 60
Column1 gives you Folder name and column 2 the file name.

Templates
RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls
xls
55808
7/10/2012
An undocumented template showing how to extract the upcoming ex-dividend stocks with a top DiviData rating from http://dividata.com. Uploaded by request.
Updated to allow for weekly options.


If you still can't find then look below

RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls

Maybe this will help others locate files easier. It certainly does for me.


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, September 13, 2014 2:56 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Element 992 - Div Ex Date


Thanks for the Dividend Channel info.

Do you have the location of the info for using the smf add-in with Dividata ?? (I always get lost looking around for the treasures)

Stan

Sat Sep 13, 2014 1:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't know of any website that lists estimated ex-dividend dates, as they
do next earnings report date.

I haven't used the Yahoo ex-dividend dates for some time, because they are
usually not up to date. And, often enough, the dividends aren't even
declared until shortly before they are to be paid. Because of this, I've
taken to creating my own estimated ex-dividend dates. However, I hesitate
making it available because it uses a bit of resources from the free data
sources. It's fine for my limited use, but too many people then want to
apply it to hundreds, even thousands, of stocks. And the method would
really only apply to specific stocks that regularly pay dividends, such as
the dividend champions or dividend aristocrats -- a very small portion of
the stock market.

What I've done in one of my dividend applications is to store the previous
year's ex-dividend date (text, without the year: xxxx-09-27), then update
that manually when the actual ex-dividend date is known. For example:

*Ticker* *Source* *Ex-dividend date* *Week* *Yield* *Ex-Date* *Warning*
CINF Dividend Champion xxxx-09-15 1 3.66% 2014-09-15 PNY Dividend
Champion xxxx-09-22 2 3.61% 2014-09-22 SYY Dividend Champion xxxx-10-01 3
3.07% 2014-10-01 T Dividend Champion xxxx-10-06 4 5.33% 2014-07-08 <==
WGL Dividend Champion xxxx-10-06 4 4.06% 2014-07-08 <== BRC Dividend
Champion xxxx-10-08 4 3.28% 2014-10-08 UVV Dividend Champion xxxx-10-09 4
3.98% 2014-10-09 COP Kahuna-24 xxxx-10-13 5 3.72% 2014-07-17 <==
PG Dividend
Champion xxxx-10-16 5 3.09% 2014-07-16 <==
The "Warning" column tells me when my estimated ex-dividend date is not the
same as the retrieved ex-dividend date (i.e. "Ex-Date"). And I sort by the
estimated week into the future, so that I'm only retrieving data for stocks
in the next estimated weeks. If the estimated ex-dividend date is only
several days different from the retrieved ex-dividend date, then I manually
update it to match the retrieved date -- so that when it comes around next
year, it will be based on the previous year.

On Sat, Sep 13, 2014 at 9:37 AM, ssjurik@optonline.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I've been using the RCHGetElementNumber(Symbol,992) to get the Ex Dividend
> dates for a list of stocks. I've been noticing that many (most) of the
> dates returned are old -- that is, they are not even the most recent Ex
> date.
>
> For example element 992 for WY returns a date of May 7, 2014. Yes,
> that's true, but there was also an Ex date on August 27. Similarly for
> WAG, element 992 returns May 19th, but not the more recent date of August
> 19.
>
> Of my list of about 180 stocks with dividends, only about 60 of them show
> dates later than July 2014.
>
> Is there something about the way Yahoo stores data that causes element 992
> to return old dates ?? Is there another element # that would be better?
>
> In contrast with the old Ex dates from element 992, element 1285 (for the
> Next Earnings date) provides only future dates.
>
>

Sat Sep 13, 2014 11:50 am (PDT) . Posted by:

Hi,


Does anyone know a site from which to get Accumulation/Distribution ratio for a stock or ETF? Or perhaps a Data Element?
Thanks
Armando

Sat Sep 13, 2014 1:53 pm (PDT) . Posted by:

minding0

Can anyone point me to conversations or files here for retrieving financial data from Yahoo using a MacBook Pro and Excel for the Mac?

Many thanks,
George

Sat Sep 13, 2014 2:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

All I can suggest is search the message archives. I don't think we've had
too many people cite the details of getting the add-in to work on the Mac.
I know little about the Mac, never having used one. But, as I understand
it, you do need to run it under an emulated Windows environment, because it
uses Windows dynamic load libraries.

On Sat, Sep 13, 2014 at 1:34 PM, george@... wrote:

>
> Can anyone point me to conversations or files here for retrieving
> financial data from Yahoo using a MacBook Pro and Excel for the Mac?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar