15 Messages
Digest #3061
Messages
Wed May 7, 2014 8:55 am (PDT) . Posted by:
confederate_yankee1965
I understand the F9 function and such, I have not messed with the functions either. I keep track of my purchases, do a little forecasting, do some what-if scenarios, all of which causes the spreadsheet to recalculate when a change is made. If I find an error in my formula and make a correction, the spreadsheet bogs down. What I was wondering was to see if there was a way to set it up so that the functions do not update every time the spreadsheet has been changed or modified.
Wed May 7, 2014 9:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You could change EXCEL to manual calculation.
What I'm saying is the functions SHOULDN'T update every time the
spreadsheet is modified -- unless you made them that way by adding a
volatile parameter to the function (e.g. NOW()).
If the volatile parameter is the issue, you could use a cell reference,
with NOW() in the cell. Then, if you change the cell to a value, the
functions that use the cell are no longer volatile. And they will update
any time you change that cell value.
On Wed, May 7, 2014 at 8:55 AM, <cyankee65@gmail.com> wrote:
>
> I understand the F9 function and such, I have not messed with the
> functions either. I keep track of my purchases, do a little forecasting,
> do some what-if scenarios, all of which causes the spreadsheet to
> recalculate when a change is made. If I find an error in my formula and
> make a correction, the spreadsheet bogs down. What I was wondering was to
> see if there was a way to set it up so that the functions do not update
> every time the spreadsheet has been changed or modified.
>
What I'm saying is the functions SHOULDN'T update every time the
spreadsheet is modified -- unless you made them that way by adding a
volatile parameter to the function (e.g. NOW()).
If the volatile parameter is the issue, you could use a cell reference,
with NOW() in the cell. Then, if you change the cell to a value, the
functions that use the cell are no longer volatile. And they will update
any time you change that cell value.
On Wed, May 7, 2014 at 8:55 AM, <cyankee65@gmail.com> wrote:
>
> I understand the F9 function and such, I have not messed with the
> functions either. I keep track of my purchases, do a little forecasting,
> do some what-if scenarios, all of which causes the spreadsheet to
> recalculate when a change is made. If I find an error in my formula and
> make a correction, the spreadsheet bogs down. What I was wondering was to
> see if there was a way to set it up so that the functions do not update
> every time the spreadsheet has been changed or modified.
>
Thu May 8, 2014 7:13 am (PDT) . Posted by:
confederate_yankee1965
I am not using Now() in the function.
Wed May 7, 2014 9:22 am (PDT) . Posted by:
"Pat Rosenheim" panda317
On 5/7/2014 10:48 AM, Randy Harmelink wrote:
> What source do you normally use?
finviz, which is wrong on some occasions, and unresponsive to emails to
their 'customer service'.
>
> Were the error items stocks, or ETFs? That element number won't work
> for ETFs. They don't have Key Statistics web pages.
Stocks. I only have 2 ETFs, CEFL & MORL.
I went back to finviz. Takes forever, and I manually correct the errors.
There is no automatic updating of Ex-div and pay dates, or amounts, just
annual yield and return. Oh, well. I'll live with it.
Thank you for everything.
pat
>
> On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com
> <mailto:pat@patrosenheim.com>> wrote:
>
> And it turns out that yahoo returns ERROR for at least 10 of my
> stocks with just this one function;
> =RCHGetElementNumber(D2,992)
>
> So now my question is, is there a site that provides reliable
> information?
>
>
>
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
http://www.patrosenheim.com
> What source do you normally use?
finviz, which is wrong on some occasions, and unresponsive to emails to
their 'customer service'.
>
> Were the error items stocks, or ETFs? That element number won't work
> for ETFs. They don't have Key Statistics web pages.
Stocks. I only have 2 ETFs, CEFL & MORL.
I went back to finviz. Takes forever, and I manually correct the errors.
There is no automatic updating of Ex-div and pay dates, or amounts, just
annual yield and return. Oh, well. I'll live with it.
Thank you for everything.
pat
>
> On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com
> <mailto:pat@patrosenheim.com>> wrote:
>
> And it turns out that yahoo returns ERROR for at least 10 of my
> stocks with just this one function;
> =RCHGetElementNumber(D2,992)
>
> So now my question is, is there a site that provides reliable
> information?
>
>
>
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
http://www.patrosenheim.com
Wed May 7, 2014 11:37 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
If you are looking for Ex-Dividend dates and payouts you might try
www.dividata.com it is free but they do not have all stock – several sample spreadsheets in the unloaded by user folder
www.dividend.com it has free but fee also. Their premium service is reasonable somewhere around $149 per year.
www.dividendchannel.com it is free but you can't use the SMF-ADDIN with it because their web pages are java scripted.
These 3 are fairly quick updating to the latest dividend news. Each site has it way of ranking or rating the dividend stocks.
Dividendchannel changes its ranking every day.
I use all 3 sites. I use Dividend.com's premium watchlist facility to notify me of events for the 49 high yield stocks I follow. The email comes a few days prior to the event so it gives me time to react.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 12:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
On 5/7/2014 10:48 AM, Randy Harmelink wrote:
What source do you normally use?
finviz, which is wrong on some occasions, and unresponsive to emails to their 'customer service'.
Were the error items stocks, or ETFs? That element number won't work for ETFs. They don't have Key Statistics web pages.
Stocks. I only have 2 ETFs, CEFL & MORL.
I went back to finviz. Takes forever, and I manually correct the errors. There is no automatic updating of Ex-div and pay dates, or amounts, just annual yield and return. Oh, well. I'll live with it.
Thank you for everything.
pat
On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com> wrote:
And it turns out that yahoo returns ERROR for at least 10 of my stocks with just this one function;
=RCHGetElementNumber(D2,992)
So now my question is, is there a site that provides reliable information?
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
www.dividata.com it is free but they do not have all stock – several sample spreadsheets in the unloaded by user folder
www.dividend.com it has free but fee also. Their premium service is reasonable somewhere around $149 per year.
www.dividendchannel.com it is free but you can't use the SMF-ADDIN with it because their web pages are java scripted.
These 3 are fairly quick updating to the latest dividend news. Each site has it way of ranking or rating the dividend stocks.
Dividendchannel changes its ranking every day.
I use all 3 sites. I use Dividend.com's premium watchlist facility to notify me of events for the 49 high yield stocks I follow. The email comes a few days prior to the event so it gives me time to react.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 12:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
On 5/7/2014 10:48 AM, Randy Harmelink wrote:
What source do you normally use?
finviz, which is wrong on some occasions, and unresponsive to emails to their 'customer service'.
Were the error items stocks, or ETFs? That element number won't work for ETFs. They don't have Key Statistics web pages.
Stocks. I only have 2 ETFs, CEFL & MORL.
I went back to finviz. Takes forever, and I manually correct the errors. There is no automatic updating of Ex-div and pay dates, or amounts, just annual yield and return. Oh, well. I'll live with it.
Thank you for everything.
pat
On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com> wrote:
And it turns out that yahoo returns ERROR for at least 10 of my stocks with just this one function;
=RCHGetElementNumber(D2,992)
So now my question is, is there a site that provides reliable information?
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
Wed May 7, 2014 12:07 pm (PDT) . Posted by:
"Pat Rosenheim" panda317
thank you, I will try the first one and the last one. dividend.com did
not have 6 stock dividends listed recently, and quite a few more over
the last year. I emailed them each time. Their response was curt, and
downright rude. It was much better before Paul Rubillo sold it. They
asked if I wanted a full refund if I was unhappy, so I said yes. I was
paying $99/year, but I found that lately I was telling them about
ex-dividend dates, and not the other way around.
thanks again
pat
On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
>
> If you are looking for Ex-Dividend dates and payouts you might try
>
> www.dividata.com <http://www.dividata.com>it is free but they do not
> have all stock – several sample spreadsheets in the unloaded by user
> folder
>
> www.dividend.com <http://www.dividend.com> it has free but fee also.
> Their premium service is reasonable somewhere around $149 per year.
>
> www.dividendchannel.com <http://www.dividendchannel.com>it is free but
> you can't use the SMF-ADDIN with it because their web pages are java
> scripted.
>
> These 3are fairly quick updating to the latest dividend news. Each
> site has it way of ranking or rating the dividend stocks.
>
> Dividendchannelchanges its ranking every day.
>
> I use all 3 sites. I use Dividend.com's premium watchlist facility to
> notify me of events for the 49 high yield stocks I follow. The email
> comes a few days prior to the event so it gives me time to react.
>
> *From:*smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 12:22 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> On 5/7/2014 10:48 AM, Randy Harmelink wrote:
>
> What source do you normally use?
>
> finviz, which is wrong on some occasions, and unresponsive to emails
> to their 'customer service'.
>
>
> Were the error items stocks, or ETFs? That element number won't work
> for ETFs. They don't have Key Statistics web pages.
>
> Stocks. I only have 2 ETFs, CEFL & MORL.
>
> I went back to finviz. Takes forever, and I manually correct the
> errors. There is no automatic updating of Ex-div and pay dates, or
> amounts, just annual yield and return. Oh, well. I'll live with it.
>
> Thank you for everything.
>
> pat
>
> On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com
> <mailto:pat@patrosenheim.com>> wrote:
>
> And it turns out that yahoo returns ERROR for at least 10 of my stocks
> with just this one function;
> =RCHGetElementNumber(D2,992)
>
> So now my question is, is there a site that provides reliable information?
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
>
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
http://www.patrosenheim.com
not have 6 stock dividends listed recently, and quite a few more over
the last year. I emailed them each time. Their response was curt, and
downright rude. It was much better before Paul Rubillo sold it. They
asked if I wanted a full refund if I was unhappy, so I said yes. I was
paying $99/year, but I found that lately I was telling them about
ex-dividend dates, and not the other way around.
thanks again
pat
On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
>
> If you are looking for Ex-Dividend dates and payouts you might try
>
> www.dividata.com <http://www.dividata.com>it is free but they do not
> have all stock – several sample spreadsheets in the unloaded by user
> folder
>
> www.dividend.com <http://www.dividend.com> it has free but fee also.
> Their premium service is reasonable somewhere around $149 per year.
>
> www.dividendchannel.com <http://www.dividendchannel.com>it is free but
> you can't use the SMF-ADDIN with it because their web pages are java
> scripted.
>
> These 3are fairly quick updating to the latest dividend news. Each
> site has it way of ranking or rating the dividend stocks.
>
> Dividendchannelchanges its ranking every day.
>
> I use all 3 sites. I use Dividend.com's premium watchlist facility to
> notify me of events for the 49 high yield stocks I follow. The email
> comes a few days prior to the event so it gives me time to react.
>
> *From:*smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 12:22 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> On 5/7/2014 10:48 AM, Randy Harmelink wrote:
>
> What source do you normally use?
>
> finviz, which is wrong on some occasions, and unresponsive to emails
> to their 'customer service'.
>
>
> Were the error items stocks, or ETFs? That element number won't work
> for ETFs. They don't have Key Statistics web pages.
>
> Stocks. I only have 2 ETFs, CEFL & MORL.
>
> I went back to finviz. Takes forever, and I manually correct the
> errors. There is no automatic updating of Ex-div and pay dates, or
> amounts, just annual yield and return. Oh, well. I'll live with it.
>
> Thank you for everything.
>
> pat
>
> On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com
> <mailto:pat@patrosenheim.com>> wrote:
>
> And it turns out that yahoo returns ERROR for at least 10 of my stocks
> with just this one function;
> =RCHGetElementNumber(D2,992)
>
> So now my question is, is there a site that provides reliable information?
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
>
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
http://www.patrosenheim.com
Thu May 8, 2014 8:00 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Really, I have had great response from Dividend.com. But maybe that is because I sent them 30 premium customers last 2 years. Last year they offered the premium for $99 and I sent them quite a few subscribers.
I have not found a site yet FREE or FEE that has all stocks covered for dividend information. I think it is based on their criteria that they do not list certain stocks.
If you send me a list of stock symbols I'll check dividend.com to see if they now list them in their premium offer.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 3:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
thank you, I will try the first one and the last one. dividend.com did not have 6 stock dividends listed recently, and quite a few more over the last year. I emailed them each time. Their response was curt, and downright rude. It was much better before Paul Rubillo sold it. They asked if I wanted a full refund if I was unhappy, so I said yes. I was paying $99/year, but I found that lately I was telling them about ex-dividend dates, and not the other way around.
thanks again
pat
On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
If you are looking for Ex-Dividend dates and payouts you might try
www.dividata.com it is free but they do not have all stock – several sample spreadsheets in the unloaded by user folder
www.dividend.com it has free but fee also. Their premium service is reasonable somewhere around $149 per year.
www.dividendchannel.com it is free but you can't use the SMF-ADDIN with it because their web pages are java scripted.
These 3 are fairly quick updating to the latest dividend news. Each site has it way of ranking or rating the dividend stocks.
Dividendchannel changes its ranking every day.
I use all 3 sites. I use Dividend.com's premium watchlist facility to notify me of events for the 49 high yield stocks I follow. The email comes a few days prior to the event so it gives me time to react.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 12:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
On 5/7/2014 10:48 AM, Randy Harmelink wrote:
What source do you normally use?
finviz, which is wrong on some occasions, and unresponsive to emails to their 'customer service'.
Were the error items stocks, or ETFs? That element number won't work for ETFs. They don't have Key Statistics web pages.
Stocks. I only have 2 ETFs, CEFL & MORL.
I went back to finviz. Takes forever, and I manually correct the errors. There is no automatic updating of Ex-div and pay dates, or amounts, just annual yield and return. Oh, well. I'll live with it.
Thank you for everything.
pat
On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com> wrote:
And it turns out that yahoo returns ERROR for at least 10 of my stocks with just this one function;
=RCHGetElementNumber(D2,992)
So now my question is, is there a site that provides reliable information?
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
I have not found a site yet FREE or FEE that has all stocks covered for dividend information. I think it is based on their criteria that they do not list certain stocks.
If you send me a list of stock symbols I'll check dividend.com to see if they now list them in their premium offer.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 3:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
thank you, I will try the first one and the last one. dividend.com did not have 6 stock dividends listed recently, and quite a few more over the last year. I emailed them each time. Their response was curt, and downright rude. It was much better before Paul Rubillo sold it. They asked if I wanted a full refund if I was unhappy, so I said yes. I was paying $99/year, but I found that lately I was telling them about ex-dividend dates, and not the other way around.
thanks again
pat
On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
If you are looking for Ex-Dividend dates and payouts you might try
www.dividata.com it is free but they do not have all stock – several sample spreadsheets in the unloaded by user folder
www.dividend.com it has free but fee also. Their premium service is reasonable somewhere around $149 per year.
www.dividendchannel.com it is free but you can't use the SMF-ADDIN with it because their web pages are java scripted.
These 3 are fairly quick updating to the latest dividend news. Each site has it way of ranking or rating the dividend stocks.
Dividendchannel changes its ranking every day.
I use all 3 sites. I use Dividend.com's premium watchlist facility to notify me of events for the 49 high yield stocks I follow. The email comes a few days prior to the event so it gives me time to react.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 12:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
On 5/7/2014 10:48 AM, Randy Harmelink wrote:
What source do you normally use?
finviz, which is wrong on some occasions, and unresponsive to emails to their 'customer service'.
Were the error items stocks, or ETFs? That element number won't work for ETFs. They don't have Key Statistics web pages.
Stocks. I only have 2 ETFs, CEFL & MORL.
I went back to finviz. Takes forever, and I manually correct the errors. There is no automatic updating of Ex-div and pay dates, or amounts, just annual yield and return. Oh, well. I'll live with it.
Thank you for everything.
pat
On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com> wrote:
And it turns out that yahoo returns ERROR for at least 10 of my stocks with just this one function;
=RCHGetElementNumber(D2,992)
So now my question is, is there a site that provides reliable information?
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
Thu May 8, 2014 8:50 am (PDT) . Posted by:
"Pat Rosenheim" panda317
thanks, but all the stocks were listed in their premium offer;
Dividend.com Contact Us Message
A user on is inquiring about Dividend.com: *Comments:*
you missed the MCC dividend, I sent you the link to their press release
earlier.
On 5/2/2014 1:15 PM, Dividend.com Support wrote:
Greetings,
Thanks for reaching out. We will look into this issue.
Have a nice day.
Sincerely,
Dividend Support Team
Date:
5/5/2014 9:12 AM
To:
"Dividend.com Support" <contact@dividend.com>
And, even after telling you about it TWICE, you still haven't updated
the ex-div and pay date for MCC!!!!!!!!
And, I even sent you a link for their press release.
Seriously, why am I paying you $99/year?
On Tue, Dec 24 at 3:43 PM, Pat.rosenheim<pat.rosenheim@gmail.com> wrote:
latest dividend info missing for four symbols, all seem to have declared
on 12/19/2013; PSP, RAS, AI, RSO
On 12/26/2013 8:35 AM, Dividend.com Support wrote:
Mr. Rosenheim,
Thank you for you email. We will look into this issue for you. Have a
nice day.
Sincerely,
Dividend Support Team
Date:
12/30/2013 6:16 AM
To:
"Dividend.com Support" <contact@dividend.com>
latest dividend info still missing for three symbols, all seem to have
declared on 12/19/2013; PSP, AI, RSO
On Mon, 5 May at 9:12 am , Pat.rosenheim <pat.rosenheim@gmail.com>
wrote: And, even after telling you about it TWICE, you still haven't
updated the ex-div and pay date for MCC!!!!!!!!
And, I even sent you a link for their press release.
Seriously, why am I paying you $99/year?
On 5/5/2014 9:43 AM, Dividend.com Support wrote:
Greetings,
We are working on getting the payout on the site. I am currently in
contact with our data provider and will get the information on the site
as soon as possible.
And I only had to contact you 4 times about it. Wonderful.
So, why am I paying you $99/year?
So you can frustrate me with inaccurate and incomplete information?
On one day alone recently, I sent you an email about 4 stocks that you
failed to update. You updated 1, and I had to send even more emails to
get the rest updated.
Your responses have been extremely curt, and not at all apologetic or
even showing any signs of caring.
So, what's up with that?
Sincerely,
A Premium Customer who's bewildered about why he's paying for such
sloppy service and rude responses.
On 5/8/2014 11:00 AM, Kermit W. Prather wrote:
>
> Really, I have had great response from Dividend.com. But maybe that is
> because I sent them 30 premium customers last 2 years. Last year they
> offered the premium for $99 and I sent them quite a few subscribers.
>
> I have not found a site yet FREE or FEE that has all stocks covered
> for dividend information. I think it is based on their criteria that
> they do not list certain stocks.
>
> If you send me a list of stock symbols I'll check dividend.com to see
> if they now list them in their premium offer.
>
> *From:*smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 3:07 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> thank you, I will try the first one and the last one. dividend.com did
> not have 6 stock dividends listed recently, and quite a few more over
> the last year. I emailed them each time. Their response was curt, and
> downright rude. It was much better before Paul Rubillo sold it. They
> asked if I wanted a full refund if I was unhappy, so I said yes. I was
> paying $99/year, but I found that lately I was telling them about
> ex-dividend dates, and not the other way around.
>
> thanks again
>
> pat
>
> On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
>
> If you are looking for Ex-Dividend dates and payouts you might try
>
> www.dividata.com <http://www.dividata.com> it is free but they do
> not have all stock – several sample spreadsheets in the unloaded
> by user folder
>
> www.dividend.com <http://www.dividend.com> it has free but fee
> also. Their premium service is reasonable somewhere around $149
> per year.
>
> www.dividendchannel.com <http://www.dividendchannel.com> it is
> free but you can't use the SMF-ADDIN with it because their web
> pages are java scripted.
>
> These 3 are fairly quick updating to the latest dividend news.
> Each site has it way of ranking or rating the dividend stocks.
>
> Dividendchannelchanges its ranking every day.
>
> I use all 3 sites. I use Dividend.com's premium watchlist facility
> to notify me of events for the 49 high yield stocks I follow. The
> email comes a few days prior to the event so it gives me time to
> react.
>
> *From:*smf_addin@yahoogroups.com
> <mailto:smf_addin@yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com] *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 12:22 PM
> *To:* smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> On 5/7/2014 10:48 AM, Randy Harmelink wrote:
>
> What source do you normally use?
>
> finviz, which is wrong on some occasions, and unresponsive to
> emails to their 'customer service'.
>
>
> Were the error items stocks, or ETFs? That element number won't
> work for ETFs. They don't have Key Statistics web pages.
>
> Stocks. I only have 2 ETFs, CEFL & MORL.
>
> I went back to finviz. Takes forever, and I manually correct the
> errors. There is no automatic updating of Ex-div and pay dates, or
> amounts, just annual yield and return. Oh, well. I'll live with it.
>
> Thank you for everything.
>
> pat
>
> On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim
> <pat@patrosenheim.com <mailto:pat@patrosenheim.com>> wrote:
>
> And it turns out that yahoo returns ERROR for at least 10 of my
> stocks with just this one function;
> =RCHGetElementNumber(D2,992)
>
> So now my question is, is there a site that provides reliable
> information?
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend
> Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
>
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
http://www.patrosenheim.com
Dividend.com Contact Us Message
A user on is inquiring about Dividend.com: *Comments:*
you missed the MCC dividend, I sent you the link to their press release
earlier.
On 5/2/2014 1:15 PM, Dividend.com Support wrote:
Greetings,
Thanks for reaching out. We will look into this issue.
Have a nice day.
Sincerely,
Dividend Support Team
Date:
5/5/2014 9:12 AM
To:
"Dividend.com Support" <contact@dividend.com>
And, even after telling you about it TWICE, you still haven't updated
the ex-div and pay date for MCC!!!!!!!!
And, I even sent you a link for their press release.
Seriously, why am I paying you $99/year?
On Tue, Dec 24 at 3:43 PM, Pat.rosenheim<pat.rosenheim@gmail.com> wrote:
latest dividend info missing for four symbols, all seem to have declared
on 12/19/2013; PSP, RAS, AI, RSO
On 12/26/2013 8:35 AM, Dividend.com Support wrote:
Mr. Rosenheim,
Thank you for you email. We will look into this issue for you. Have a
nice day.
Sincerely,
Dividend Support Team
Date:
12/30/2013 6:16 AM
To:
"Dividend.com Support" <contact@dividend.com>
latest dividend info still missing for three symbols, all seem to have
declared on 12/19/2013; PSP, AI, RSO
On Mon, 5 May at 9:12 am , Pat.rosenheim <pat.rosenheim@gmail.com>
wrote: And, even after telling you about it TWICE, you still haven't
updated the ex-div and pay date for MCC!!!!!!!!
And, I even sent you a link for their press release.
Seriously, why am I paying you $99/year?
On 5/5/2014 9:43 AM, Dividend.com Support wrote:
Greetings,
We are working on getting the payout on the site. I am currently in
contact with our data provider and will get the information on the site
as soon as possible.
And I only had to contact you 4 times about it. Wonderful.
So, why am I paying you $99/year?
So you can frustrate me with inaccurate and incomplete information?
On one day alone recently, I sent you an email about 4 stocks that you
failed to update. You updated 1, and I had to send even more emails to
get the rest updated.
Your responses have been extremely curt, and not at all apologetic or
even showing any signs of caring.
So, what's up with that?
Sincerely,
A Premium Customer who's bewildered about why he's paying for such
sloppy service and rude responses.
On 5/8/2014 11:00 AM, Kermit W. Prather wrote:
>
> Really, I have had great response from Dividend.com. But maybe that is
> because I sent them 30 premium customers last 2 years. Last year they
> offered the premium for $99 and I sent them quite a few subscribers.
>
> I have not found a site yet FREE or FEE that has all stocks covered
> for dividend information. I think it is based on their criteria that
> they do not list certain stocks.
>
> If you send me a list of stock symbols I'll check dividend.com to see
> if they now list them in their premium offer.
>
> *From:*smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 3:07 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> thank you, I will try the first one and the last one. dividend.com did
> not have 6 stock dividends listed recently, and quite a few more over
> the last year. I emailed them each time. Their response was curt, and
> downright rude. It was much better before Paul Rubillo sold it. They
> asked if I wanted a full refund if I was unhappy, so I said yes. I was
> paying $99/year, but I found that lately I was telling them about
> ex-dividend dates, and not the other way around.
>
> thanks again
>
> pat
>
> On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
>
> If you are looking for Ex-Dividend dates and payouts you might try
>
> www.dividata.com <http://www.dividata.com> it is free but they do
> not have all stock – several sample spreadsheets in the unloaded
> by user folder
>
> www.dividend.com <http://www.dividend.com> it has free but fee
> also. Their premium service is reasonable somewhere around $149
> per year.
>
> www.dividendchannel.com <http://www.dividendchannel.com> it is
> free but you can't use the SMF-ADDIN with it because their web
> pages are java scripted.
>
> These 3 are fairly quick updating to the latest dividend news.
> Each site has it way of ranking or rating the dividend stocks.
>
> Dividendchannelchanges its ranking every day.
>
> I use all 3 sites. I use Dividend.com's premium watchlist facility
> to notify me of events for the 49 high yield stocks I follow. The
> email comes a few days prior to the event so it gives me time to
> react.
>
> *From:*smf_addin@yahoogroups.com
> <mailto:smf_addin@yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com] *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 12:22 PM
> *To:* smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> On 5/7/2014 10:48 AM, Randy Harmelink wrote:
>
> What source do you normally use?
>
> finviz, which is wrong on some occasions, and unresponsive to
> emails to their 'customer service'.
>
>
> Were the error items stocks, or ETFs? That element number won't
> work for ETFs. They don't have Key Statistics web pages.
>
> Stocks. I only have 2 ETFs, CEFL & MORL.
>
> I went back to finviz. Takes forever, and I manually correct the
> errors. There is no automatic updating of Ex-div and pay dates, or
> amounts, just annual yield and return. Oh, well. I'll live with it.
>
> Thank you for everything.
>
> pat
>
> On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim
> <pat@patrosenheim.com <mailto:pat@patrosenheim.com>> wrote:
>
> And it turns out that yahoo returns ERROR for at least 10 of my
> stocks with just this one function;
> =RCHGetElementNumber(D2,992)
>
> So now my question is, is there a site that provides reliable
> information?
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend
> Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
>
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
http://www.patrosenheim.com
Thu May 8, 2014 10:37 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I actually had a similar situation with WHX & WHZ in March 2014. They were late getting the Ex-div date updated.
These stocks from Whiting trust only give about 8 days notice. So a 2 -4 days delay is costly.
Both stock ex-div on 5/16/14 and it was declared 5/7/14, 9 days is short. I got the watchlist notice email from dividend.com 8am 5/8/14.
I have the emails forward to my cell phone in case I am not on the computer.
MCC has a 5/23/2014 Ex-div date, declared on 5/1/14, payout 06/13/14
I think Dividend.com is usually quick to post once it is announced. But when stocks only allow 7 – 10 days before they announce the next actual date it makes me nervous.
I trade the high yielding stocks and it is imperative I know the exact Ex-div as soon as possible because traders start bailing out several days prior to Ex-div date.
I don't want to be the last one out. I want to be the first one out before price starts dropping.
Here is their latest on the stocks you listed:
Symbol
Company Name
DARS Rating
Annualized Div.
Div. Yield
Curr. Price
Ex. Div. Date
Record Date
Pay Date
Payout Frequency
Next Payout
ADR
Industry
Sector
AI
Arlington Asset Investment Corp Cl A
N/A
3.5
13.28%
26.36
3/27/2014
3/31/2014
4/30/2014
N/A
0.875
N
N/A
N/A
MCC
Medley Capital Corp
N/A
1.48
12.02%
12.31
5/23/2014
5/28/2014
6/13/2014
Q
0.37
N
N/A
N/A
PSP
Invesco PowerShares Listed Private Equity
N/A
1.63
13.83%
11.79
3/21/2014
3/25/2014
3/31/2014
Q
0.14347
N
N/A
N/A
RAS
RAIT Financial Trust
N/A
0.68
8.40%
8.1
4/2/2014
4/4/2014
4/30/2014
Q
0.17
N
Financial
REIT - Diversified
RSO
Resource Capital
2.7
0.8
14.68%
5.45
3/27/2014
3/31/2014
4/28/2014
Q
0.2
N
Financial
Real Estate Development
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Thursday, May 08, 2014 11:50 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
thanks, but all the stocks were listed in their premium offer;
Dividend.com Contact Us Message
A user on is inquiring about Dividend.com: Comments:
you missed the MCC dividend, I sent you the link to their press release earlier.
On 5/2/2014 1:15 PM, Dividend.com Support wrote:
Greetings,
Thanks for reaching out. We will look into this issue.
Have a nice day.
Sincerely,
Dividend Support Team
Date:
5/5/2014 9:12 AM
To:
"Dividend.com Support" <mailto:contact@dividend.com> <contact@dividend.com>
And, even after telling you about it TWICE, you still haven't updated the ex-div and pay date for MCC!!!!!!!!
And, I even sent you a link for their press release.
Seriously, why am I paying you $99/year?
On Tue, Dec 24 at 3:43 PM , Pat.rosenheim <mailto:pat.rosenheim@gmail.com> <pat.rosenheim@gmail.com> wrote: latest dividend info missing for four symbols, all seem to have declared on 12/19/2013; PSP, RAS, AI, RSO
On 12/26/2013 8:35 AM, Dividend.com Support wrote:
Mr. Rosenheim,
Thank you for you email. We will look into this issue for you. Have a nice day.
Sincerely,
Dividend Support Team
Date:
12/30/2013 6:16 AM
To:
"Dividend.com Support" <mailto:contact@dividend.com> <contact@dividend.com>
latest dividend info still missing for three symbols, all seem to have declared on 12/19/2013; PSP, AI, RSO
On Mon, 5 May at 9:12 am , Pat.rosenheim <mailto:pat.rosenheim@gmail.com> <pat.rosenheim@gmail.com> wrote: And, even after telling you about it TWICE, you still haven't updated the ex-div and pay date for MCC!!!!!!!!
And, I even sent you a link for their press release.
Seriously, why am I paying you $99/year?
On 5/5/2014 9:43 AM, Dividend.com Support wrote:
Greetings,
We are working on getting the payout on the site. I am currently in contact with our data provider and will get the information on the site as soon as possible.
And I only had to contact you 4 times about it. Wonderful.
So, why am I paying you $99/year?
So you can frustrate me with inaccurate and incomplete information?
On one day alone recently, I sent you an email about 4 stocks that you failed to update. You updated 1, and I had to send even more emails to get the rest updated.
Your responses have been extremely curt, and not at all apologetic or even showing any signs of caring.
So, what's up with that?
Sincerely,
A Premium Customer who's bewildered about why he's paying for such sloppy service and rude responses.
On 5/8/2014 11:00 AM, Kermit W. Prather wrote:
Really, I have had great response from Dividend.com. But maybe that is because I sent them 30 premium customers last 2 years. Last year they offered the premium for $99 and I sent them quite a few subscribers.
I have not found a site yet FREE or FEE that has all stocks covered for dividend information. I think it is based on their criteria that they do not list certain stocks.
If you send me a list of stock symbols I'll check dividend.com to see if they now list them in their premium offer.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 3:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
thank you, I will try the first one and the last one. dividend.com did not have 6 stock dividends listed recently, and quite a few more over the last year. I emailed them each time. Their response was curt, and downright rude. It was much better before Paul Rubillo sold it. They asked if I wanted a full refund if I was unhappy, so I said yes. I was paying $99/year, but I found that lately I was telling them about ex-dividend dates, and not the other way around.
thanks again
pat
On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
If you are looking for Ex-Dividend dates and payouts you might try
www.dividata.com it is free but they do not have all stock – several sample spreadsheets in the unloaded by user folder
www.dividend.com it has free but fee also. Their premium service is reasonable somewhere around $149 per year.
www.dividendchannel.com it is free but you can't use the SMF-ADDIN with it because their web pages are java scripted.
These 3 are fairly quick updating to the latest dividend news. Each site has it way of ranking or rating the dividend stocks.
Dividendchannel changes its ranking every day.
I use all 3 sites. I use Dividend.com's premium watchlist facility to notify me of events for the 49 high yield stocks I follow. The email comes a few days prior to the event so it gives me time to react.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 12:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
On 5/7/2014 10:48 AM, Randy Harmelink wrote:
What source do you normally use?
finviz, which is wrong on some occasions, and unresponsive to emails to their 'customer service'.
Were the error items stocks, or ETFs? That element number won't work for ETFs. They don't have Key Statistics web pages.
Stocks. I only have 2 ETFs, CEFL & MORL.
I went back to finviz. Takes forever, and I manually correct the errors. There is no automatic updating of Ex-div and pay dates, or amounts, just annual yield and return. Oh, well. I'll live with it.
Thank you for everything.
pat
On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com> wrote:
And it turns out that yahoo returns ERROR for at least 10 of my stocks with just this one function;
=RCHGetElementNumber(D2,992)
So now my question is, is there a site that provides reliable information?
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
These stocks from Whiting trust only give about 8 days notice. So a 2 -4 days delay is costly.
Both stock ex-div on 5/16/14 and it was declared 5/7/14, 9 days is short. I got the watchlist notice email from dividend.com 8am 5/8/14.
I have the emails forward to my cell phone in case I am not on the computer.
MCC has a 5/23/2014 Ex-div date, declared on 5/1/14, payout 06/13/14
I think Dividend.com is usually quick to post once it is announced. But when stocks only allow 7 – 10 days before they announce the next actual date it makes me nervous.
I trade the high yielding stocks and it is imperative I know the exact Ex-div as soon as possible because traders start bailing out several days prior to Ex-div date.
I don't want to be the last one out. I want to be the first one out before price starts dropping.
Here is their latest on the stocks you listed:
Symbol
Company Name
DARS Rating
Annualized Div.
Div. Yield
Curr. Price
Ex. Div. Date
Record Date
Pay Date
Payout Frequency
Next Payout
ADR
Industry
Sector
AI
Arlington Asset Investment Corp Cl A
N/A
3.5
13.28%
26.36
3/27/2014
3/31/2014
4/30/2014
N/A
0.875
N
N/A
N/A
MCC
Medley Capital Corp
N/A
1.48
12.02%
12.31
5/23/2014
5/28/2014
6/13/2014
Q
0.37
N
N/A
N/A
PSP
Invesco PowerShares Listed Private Equity
N/A
1.63
13.83%
11.79
3/21/2014
3/25/2014
3/31/2014
Q
0.14347
N
N/A
N/A
RAS
RAIT Financial Trust
N/A
0.68
8.40%
8.1
4/2/2014
4/4/2014
4/30/2014
Q
0.17
N
Financial
REIT - Diversified
RSO
Resource Capital
2.7
0.8
14.68%
5.45
3/27/2014
3/31/2014
4/28/2014
Q
0.2
N
Financial
Real Estate Development
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Thursday, May 08, 2014 11:50 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
thanks, but all the stocks were listed in their premium offer;
Dividend.com Contact Us Message
A user on is inquiring about Dividend.com: Comments:
you missed the MCC dividend, I sent you the link to their press release earlier.
On 5/2/2014 1:15 PM, Dividend.com Support wrote:
Greetings,
Thanks for reaching out. We will look into this issue.
Have a nice day.
Sincerely,
Dividend Support Team
Date:
5/5/2014 9:12 AM
To:
"Dividend.com Support" <mailto:contact@dividend.com> <contact@dividend.com>
And, even after telling you about it TWICE, you still haven't updated the ex-div and pay date for MCC!!!!!!!!
And, I even sent you a link for their press release.
Seriously, why am I paying you $99/year?
On Tue, Dec 24 at 3:43 PM , Pat.rosenheim <mailto:pat.rosenheim@gmail.com> <pat.rosenheim@gmail.com> wrote: latest dividend info missing for four symbols, all seem to have declared on 12/19/2013; PSP, RAS, AI, RSO
On 12/26/2013 8:35 AM, Dividend.com Support wrote:
Mr. Rosenheim,
Thank you for you email. We will look into this issue for you. Have a nice day.
Sincerely,
Dividend Support Team
Date:
12/30/2013 6:16 AM
To:
"Dividend.com Support" <mailto:contact@dividend.com> <contact@dividend.com>
latest dividend info still missing for three symbols, all seem to have declared on 12/19/2013; PSP, AI, RSO
On Mon, 5 May at 9:12 am , Pat.rosenheim <mailto:pat.rosenheim@gmail.com> <pat.rosenheim@gmail.com> wrote: And, even after telling you about it TWICE, you still haven't updated the ex-div and pay date for MCC!!!!!!!!
And, I even sent you a link for their press release.
Seriously, why am I paying you $99/year?
On 5/5/2014 9:43 AM, Dividend.com Support wrote:
Greetings,
We are working on getting the payout on the site. I am currently in contact with our data provider and will get the information on the site as soon as possible.
And I only had to contact you 4 times about it. Wonderful.
So, why am I paying you $99/year?
So you can frustrate me with inaccurate and incomplete information?
On one day alone recently, I sent you an email about 4 stocks that you failed to update. You updated 1, and I had to send even more emails to get the rest updated.
Your responses have been extremely curt, and not at all apologetic or even showing any signs of caring.
So, what's up with that?
Sincerely,
A Premium Customer who's bewildered about why he's paying for such sloppy service and rude responses.
On 5/8/2014 11:00 AM, Kermit W. Prather wrote:
Really, I have had great response from Dividend.com. But maybe that is because I sent them 30 premium customers last 2 years. Last year they offered the premium for $99 and I sent them quite a few subscribers.
I have not found a site yet FREE or FEE that has all stocks covered for dividend information. I think it is based on their criteria that they do not list certain stocks.
If you send me a list of stock symbols I'll check dividend.com to see if they now list them in their premium offer.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 3:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
thank you, I will try the first one and the last one. dividend.com did not have 6 stock dividends listed recently, and quite a few more over the last year. I emailed them each time. Their response was curt, and downright rude. It was much better before Paul Rubillo sold it. They asked if I wanted a full refund if I was unhappy, so I said yes. I was paying $99/year, but I found that lately I was telling them about ex-dividend dates, and not the other way around.
thanks again
pat
On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
If you are looking for Ex-Dividend dates and payouts you might try
www.dividata.com it is free but they do not have all stock – several sample spreadsheets in the unloaded by user folder
www.dividend.com it has free but fee also. Their premium service is reasonable somewhere around $149 per year.
www.dividendchannel.com it is free but you can't use the SMF-ADDIN with it because their web pages are java scripted.
These 3 are fairly quick updating to the latest dividend news. Each site has it way of ranking or rating the dividend stocks.
Dividendchannel changes its ranking every day.
I use all 3 sites. I use Dividend.com's premium watchlist facility to notify me of events for the 49 high yield stocks I follow. The email comes a few days prior to the event so it gives me time to react.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Pat Rosenheim
Sent: Wednesday, May 07, 2014 12:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] asking for help, again [2 Attachments]
On 5/7/2014 10:48 AM, Randy Harmelink wrote:
What source do you normally use?
finviz, which is wrong on some occasions, and unresponsive to emails to their 'customer service'.
Were the error items stocks, or ETFs? That element number won't work for ETFs. They don't have Key Statistics web pages.
Stocks. I only have 2 ETFs, CEFL & MORL.
I went back to finviz. Takes forever, and I manually correct the errors. There is no automatic updating of Ex-div and pay dates, or amounts, just annual yield and return. Oh, well. I'll live with it.
Thank you for everything.
pat
On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim <pat@patrosenheim.com> wrote:
And it turns out that yahoo returns ERROR for at least 10 of my stocks with just this one function;
=RCHGetElementNumber(D2,992)
So now my question is, is there a site that provides reliable information?
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
<mailto:pat.rosenheim@gmail.com> pat@patrosenheim.com
<http://www.patrosenheim.com> http://www.patrosenheim.com
Thu May 8, 2014 11:29 am (PDT) . Posted by:
"Pat Rosenheim" panda317
I *know* they have the correct info *now*, because I sent them so many
emails.
I mean, if I have to look it up myself and tell them, why should I pay them?
I don't pay them anymore, and will not, do not, will never again, rely
on them.
I had the same experience w/them re: WHX & WHZ.
I'll do it myself, that way I'll know it's correct.
On 5/8/2014 1:37 PM, Kermit W. Prather wrote:
>
> I actually had a similar situation with WHX & WHZ in March 2014. They
> were late getting the Ex-div date updated.
>
> These stocks from Whiting trust only give about 8 days notice. So a 2
> -4 days delay is costly.
>
> Both stock ex-div on 5/16/14 and it was declared 5/7/14, 9 days is
> short. I got the watchlist notice email from dividend.com 8am 5/8/14.
>
> I have the emails forward to my cell phone in case I am not on the
> computer.
>
> MCC has a 5/23/2014 Ex-div date, declared on 5/1/14, payout 06/13/14
>
> I think Dividend.com is usually quick to post once it is announced.
> But when stocks only allow 7 – 10 days before they announce the next
> actual date it makes me nervous.
>
> I trade the high yielding stocks and it is imperative I know the exact
> Ex-div as soon as possible because traders start bailing out several
> days prior to Ex-div date.
>
> I don't want to be the last one out. I want to be the first one out
> before price starts dropping.
>
> Here is their latest on the stocks you listed:
>
> Symbol
>
>
>
> Company Name
>
>
>
> DARS Rating
>
>
>
> Annualized Div.
>
>
>
> Div. Yield
>
>
>
> Curr. Price
>
>
>
> Ex. Div. Date
>
>
>
> Record Date
>
>
>
> Pay Date
>
>
>
> Payout Frequency
>
>
>
> Next Payout
>
>
>
> ADR
>
>
>
> Industry
>
>
>
> Sector
>
> AI
>
>
>
> Arlington Asset Investment Corp Cl A
>
>
>
> N/A
>
>
>
> 3.5
>
>
>
> 13.28%
>
>
>
> 26.36
>
>
>
> 3/27/2014
>
>
>
> 3/31/2014
>
>
>
> 4/30/2014
>
>
>
> N/A
>
>
>
> 0.875
>
>
>
> N
>
>
>
> N/A
>
>
>
> N/A
>
> MCC
>
>
>
> Medley Capital Corp
>
>
>
> N/A
>
>
>
> 1.48
>
>
>
> 12.02%
>
>
>
> 12.31
>
>
>
> 5/23/2014
>
>
>
> 5/28/2014
>
>
>
> 6/13/2014
>
>
>
> Q
>
>
>
> 0.37
>
>
>
> N
>
>
>
> N/A
>
>
>
> N/A
>
> PSP
>
>
>
> InvescoPowerShares Listed Private Equity
>
>
>
> N/A
>
>
>
> 1.63
>
>
>
> 13.83%
>
>
>
> 11.79
>
>
>
> 3/21/2014
>
>
>
> 3/25/2014
>
>
>
> 3/31/2014
>
>
>
> Q
>
>
>
> 0.14347
>
>
>
> N
>
>
>
> N/A
>
>
>
> N/A
>
> RAS
>
>
>
> RAIT Financial Trust
>
>
>
> N/A
>
>
>
> 0.68
>
>
>
> 8.40%
>
>
>
> 8.1
>
>
>
> 4/2/2014
>
>
>
> 4/4/2014
>
>
>
> 4/30/2014
>
>
>
> Q
>
>
>
> 0.17
>
>
>
> N
>
>
>
> Financial
>
>
>
> REIT - Diversified
>
> RSO
>
>
>
> Resource Capital
>
>
>
> 2.7
>
>
>
> 0.8
>
>
>
> 14.68%
>
>
>
> 5.45
>
>
>
> 3/27/2014
>
>
>
> 3/31/2014
>
>
>
> 4/28/2014
>
>
>
> Q
>
>
>
> 0.2
>
>
>
> N
>
>
>
> Financial
>
>
>
> Real Estate Development
>
> *From:*smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *On Behalf Of *Pat Rosenheim
> *Sent:* Thursday, May 08, 2014 11:50 AM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> thanks, but all the stocks were listed in their premium offer;
>
>
> Dividend.com Contact Us Message
>
> A user on is inquiring about Dividend.com: *Comments:*
> you missed the MCC dividend, I sent you the link to their press
> release earlier.
>
> On 5/2/2014 1:15 PM, Dividend.com Support wrote:
>
> Greetings,
>
> Thanks for reaching out. We will look into this issue.
>
> Have a nice day.
>
> Sincerely,
> Dividend Support Team
>
> Date:
>
> 5/5/2014 9:12 AM
>
> To:
>
> "Dividend.com Support" <contact@dividend.com>
> <mailto:contact@dividend.com>
>
>
> And, even after telling you about it TWICE, you still haven't updated
> the ex-div and pay date for MCC!!!!!!!!
>
> And, I even sent you a link for their press release.
>
> Seriously, why am I paying you $99/year?
>
> On Tue, Dec 24 at 3:43 PM , Pat.rosenheim<pat.rosenheim@gmail.com>
> <mailto:pat.rosenheim@gmail.com> wrote: latest dividend info missing
> for four symbols, all seem to have declared on 12/19/2013; PSP, RAS,
> AI, RSO
>
> On 12/26/2013 8:35 AM, Dividend.com Support wrote:
>
> Mr. Rosenheim,
>
> Thank you for you email. We will look into this issue for you. Have a
> nice day.
>
> Sincerely,
> Dividend Support Team
>
> Date:
>
> 12/30/2013 6:16 AM
>
> To:
>
> "Dividend.com Support" <contact@dividend.com>
> <mailto:contact@dividend.com>
>
>
> latest dividend info still missing for three symbols, all seem to have
> declared on 12/19/2013; PSP, AI, RSO
>
> On Mon, 5 May at 9:12 am , Pat.rosenheim <pat.rosenheim@gmail.com>
> <mailto:pat.rosenheim@gmail.com> wrote: And, even after telling you
> about it TWICE, you still haven't updated the ex-div and pay date for
> MCC!!!!!!!!
>
> And, I even sent you a link for their press release.
>
> Seriously, why am I paying you $99/year?
>
> On 5/5/2014 9:43 AM, Dividend.com Support wrote:
>
> Greetings,
>
> We are working on getting the payout on the site. I am currently in
> contact with our data provider and will get the information on the
> site as soon as possible.
>
> And I only had to contact you 4 times about it. Wonderful.
>
> So, why am I paying you $99/year?
>
> So you can frustrate me with inaccurate and incomplete information?
>
> On one day alone recently, I sent you an email about 4 stocks that you
> failed to update. You updated 1, and I had to send even more emails to
> get the rest updated.
>
> Your responses have been extremely curt, and not at all apologetic or
> even showing any signs of caring.
>
> So, what's up with that?
>
> Sincerely,
> A Premium Customer who's bewildered about why he's paying for such
> sloppy service and rude responses.
>
> On 5/8/2014 11:00 AM, Kermit W. Prather wrote:
>
> Really, I have had great response from Dividend.com. But maybe
> that is because I sent them 30 premium customers last 2 years.
> Last year they offered the premium for $99 and I sent them quite a
> few subscribers.
>
> I have not found a site yet FREE or FEE that has all stocks
> covered for dividend information. I think it is based on their
> criteria that they do not list certain stocks.
>
> If you send me a list of stock symbols I'll check dividend.com to
> see if they now list them in their premium offer.
>
> *From:*smf_addin@yahoogroups.com
> <mailto:smf_addin@yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com] *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 3:07 PM
> *To:* smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> thank you, I will try the first one and the last one. dividend.com
> did not have 6 stock dividends listed recently, and quite a few
> more over the last year. I emailed them each time. Their response
> was curt, and downright rude. It was much better before Paul
> Rubillo sold it. They asked if I wanted a full refund if I was
> unhappy, so I said yes. I was paying $99/year, but I found that
> lately I was telling them about ex-dividend dates, and not the
> other way around.
>
> thanks again
>
> pat
>
> On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
>
> If you are looking for Ex-Dividend dates and payouts you might
> try
>
> www.dividata.com <http://www.dividata.com> it is free but they
> do not have all stock – several sample spreadsheets in the
> unloaded by user folder
>
> www.dividend.com <http://www.dividend.com> it has free but fee
> also. Their premium service is reasonable somewhere around
> $149 per year.
>
> www.dividendchannel.com <http://www.dividendchannel.com> it is
> free but you can't use the SMF-ADDIN with it because their web
> pages are java scripted.
>
> These 3 are fairly quick updating to the latest dividend
> news. Each site has it way of ranking or rating the dividend
> stocks.
>
> Dividendchannelchanges its ranking every day.
>
> I use all 3 sites. I use Dividend.com's premium watchlist
> facility to notify me of events for the 49 high yield stocks I
> follow. The email comes a few days prior to the event so it
> gives me time to react.
>
> *From:*smf_addin@yahoogroups.com
> <mailto:smf_addin@yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com] *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 12:22 PM
> *To:* smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> On 5/7/2014 10:48 AM, Randy Harmelink wrote:
>
> What source do you normally use?
>
> finviz, which is wrong on some occasions, and unresponsive to
> emails to their 'customer service'.
>
>
> Were the error items stocks, or ETFs? That element number
> won't work for ETFs. They don't have Key Statistics web pages.
>
> Stocks. I only have 2 ETFs, CEFL & MORL.
>
> I went back to finviz. Takes forever, and I manually correct
> the errors. There is no automatic updating of Ex-div and pay
> dates, or amounts, just annual yield and return. Oh, well.
> I'll live with it.
>
> Thank you for everything.
>
> pat
>
> On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim
> <pat@patrosenheim.com <mailto:pat@patrosenheim.com>> wrote:
>
> And it turns out that yahoo returns ERROR for at least 10 of
> my stocks with just this one function;
> =RCHGetElementNumber(D2,992)
>
> So now my question is, is there a site that provides reliable
> information?
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend
> Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend
> Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
>
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
http://www.patrosenheim.com
emails.
I mean, if I have to look it up myself and tell them, why should I pay them?
I don't pay them anymore, and will not, do not, will never again, rely
on them.
I had the same experience w/them re: WHX & WHZ.
I'll do it myself, that way I'll know it's correct.
On 5/8/2014 1:37 PM, Kermit W. Prather wrote:
>
> I actually had a similar situation with WHX & WHZ in March 2014. They
> were late getting the Ex-div date updated.
>
> These stocks from Whiting trust only give about 8 days notice. So a 2
> -4 days delay is costly.
>
> Both stock ex-div on 5/16/14 and it was declared 5/7/14, 9 days is
> short. I got the watchlist notice email from dividend.com 8am 5/8/14.
>
> I have the emails forward to my cell phone in case I am not on the
> computer.
>
> MCC has a 5/23/2014 Ex-div date, declared on 5/1/14, payout 06/13/14
>
> I think Dividend.com is usually quick to post once it is announced.
> But when stocks only allow 7 – 10 days before they announce the next
> actual date it makes me nervous.
>
> I trade the high yielding stocks and it is imperative I know the exact
> Ex-div as soon as possible because traders start bailing out several
> days prior to Ex-div date.
>
> I don't want to be the last one out. I want to be the first one out
> before price starts dropping.
>
> Here is their latest on the stocks you listed:
>
> Symbol
>
>
>
> Company Name
>
>
>
> DARS Rating
>
>
>
> Annualized Div.
>
>
>
> Div. Yield
>
>
>
> Curr. Price
>
>
>
> Ex. Div. Date
>
>
>
> Record Date
>
>
>
> Pay Date
>
>
>
> Payout Frequency
>
>
>
> Next Payout
>
>
>
> ADR
>
>
>
> Industry
>
>
>
> Sector
>
> AI
>
>
>
> Arlington Asset Investment Corp Cl A
>
>
>
> N/A
>
>
>
> 3.5
>
>
>
> 13.28%
>
>
>
> 26.36
>
>
>
> 3/27/2014
>
>
>
> 3/31/2014
>
>
>
> 4/30/2014
>
>
>
> N/A
>
>
>
> 0.875
>
>
>
> N
>
>
>
> N/A
>
>
>
> N/A
>
> MCC
>
>
>
> Medley Capital Corp
>
>
>
> N/A
>
>
>
> 1.48
>
>
>
> 12.02%
>
>
>
> 12.31
>
>
>
> 5/23/2014
>
>
>
> 5/28/2014
>
>
>
> 6/13/2014
>
>
>
> Q
>
>
>
> 0.37
>
>
>
> N
>
>
>
> N/A
>
>
>
> N/A
>
> PSP
>
>
>
> InvescoPowerShares Listed Private Equity
>
>
>
> N/A
>
>
>
> 1.63
>
>
>
> 13.83%
>
>
>
> 11.79
>
>
>
> 3/21/2014
>
>
>
> 3/25/2014
>
>
>
> 3/31/2014
>
>
>
> Q
>
>
>
> 0.14347
>
>
>
> N
>
>
>
> N/A
>
>
>
> N/A
>
> RAS
>
>
>
> RAIT Financial Trust
>
>
>
> N/A
>
>
>
> 0.68
>
>
>
> 8.40%
>
>
>
> 8.1
>
>
>
> 4/2/2014
>
>
>
> 4/4/2014
>
>
>
> 4/30/2014
>
>
>
> Q
>
>
>
> 0.17
>
>
>
> N
>
>
>
> Financial
>
>
>
> REIT - Diversified
>
> RSO
>
>
>
> Resource Capital
>
>
>
> 2.7
>
>
>
> 0.8
>
>
>
> 14.68%
>
>
>
> 5.45
>
>
>
> 3/27/2014
>
>
>
> 3/31/2014
>
>
>
> 4/28/2014
>
>
>
> Q
>
>
>
> 0.2
>
>
>
> N
>
>
>
> Financial
>
>
>
> Real Estate Development
>
> *From:*smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *On Behalf Of *Pat Rosenheim
> *Sent:* Thursday, May 08, 2014 11:50 AM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> thanks, but all the stocks were listed in their premium offer;
>
>
> Dividend.com Contact Us Message
>
> A user on is inquiring about Dividend.com: *Comments:*
> you missed the MCC dividend, I sent you the link to their press
> release earlier.
>
> On 5/2/2014 1:15 PM, Dividend.com Support wrote:
>
> Greetings,
>
> Thanks for reaching out. We will look into this issue.
>
> Have a nice day.
>
> Sincerely,
> Dividend Support Team
>
> Date:
>
> 5/5/2014 9:12 AM
>
> To:
>
> "Dividend.com Support" <contact@dividend.com>
> <mailto:contact@dividend.com>
>
>
> And, even after telling you about it TWICE, you still haven't updated
> the ex-div and pay date for MCC!!!!!!!!
>
> And, I even sent you a link for their press release.
>
> Seriously, why am I paying you $99/year?
>
> On Tue, Dec 24 at 3:43 PM , Pat.rosenheim<pat.rosenheim@gmail.com>
> <mailto:pat.rosenheim@gmail.com> wrote: latest dividend info missing
> for four symbols, all seem to have declared on 12/19/2013; PSP, RAS,
> AI, RSO
>
> On 12/26/2013 8:35 AM, Dividend.com Support wrote:
>
> Mr. Rosenheim,
>
> Thank you for you email. We will look into this issue for you. Have a
> nice day.
>
> Sincerely,
> Dividend Support Team
>
> Date:
>
> 12/30/2013 6:16 AM
>
> To:
>
> "Dividend.com Support" <contact@dividend.com>
> <mailto:contact@dividend.com>
>
>
> latest dividend info still missing for three symbols, all seem to have
> declared on 12/19/2013; PSP, AI, RSO
>
> On Mon, 5 May at 9:12 am , Pat.rosenheim <pat.rosenheim@gmail.com>
> <mailto:pat.rosenheim@gmail.com> wrote: And, even after telling you
> about it TWICE, you still haven't updated the ex-div and pay date for
> MCC!!!!!!!!
>
> And, I even sent you a link for their press release.
>
> Seriously, why am I paying you $99/year?
>
> On 5/5/2014 9:43 AM, Dividend.com Support wrote:
>
> Greetings,
>
> We are working on getting the payout on the site. I am currently in
> contact with our data provider and will get the information on the
> site as soon as possible.
>
> And I only had to contact you 4 times about it. Wonderful.
>
> So, why am I paying you $99/year?
>
> So you can frustrate me with inaccurate and incomplete information?
>
> On one day alone recently, I sent you an email about 4 stocks that you
> failed to update. You updated 1, and I had to send even more emails to
> get the rest updated.
>
> Your responses have been extremely curt, and not at all apologetic or
> even showing any signs of caring.
>
> So, what's up with that?
>
> Sincerely,
> A Premium Customer who's bewildered about why he's paying for such
> sloppy service and rude responses.
>
> On 5/8/2014 11:00 AM, Kermit W. Prather wrote:
>
> Really, I have had great response from Dividend.com. But maybe
> that is because I sent them 30 premium customers last 2 years.
> Last year they offered the premium for $99 and I sent them quite a
> few subscribers.
>
> I have not found a site yet FREE or FEE that has all stocks
> covered for dividend information. I think it is based on their
> criteria that they do not list certain stocks.
>
> If you send me a list of stock symbols I'll check dividend.com to
> see if they now list them in their premium offer.
>
> *From:*smf_addin@yahoogroups.com
> <mailto:smf_addin@yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com] *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 3:07 PM
> *To:* smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> thank you, I will try the first one and the last one. dividend.com
> did not have 6 stock dividends listed recently, and quite a few
> more over the last year. I emailed them each time. Their response
> was curt, and downright rude. It was much better before Paul
> Rubillo sold it. They asked if I wanted a full refund if I was
> unhappy, so I said yes. I was paying $99/year, but I found that
> lately I was telling them about ex-dividend dates, and not the
> other way around.
>
> thanks again
>
> pat
>
> On 5/7/2014 2:37 PM, Kermit W. Prather wrote:
>
> If you are looking for Ex-Dividend dates and payouts you might
> try
>
> www.dividata.com <http://www.dividata.com> it is free but they
> do not have all stock – several sample spreadsheets in the
> unloaded by user folder
>
> www.dividend.com <http://www.dividend.com> it has free but fee
> also. Their premium service is reasonable somewhere around
> $149 per year.
>
> www.dividendchannel.com <http://www.dividendchannel.com> it is
> free but you can't use the SMF-ADDIN with it because their web
> pages are java scripted.
>
> These 3 are fairly quick updating to the latest dividend
> news. Each site has it way of ranking or rating the dividend
> stocks.
>
> Dividendchannelchanges its ranking every day.
>
> I use all 3 sites. I use Dividend.com's premium watchlist
> facility to notify me of events for the 49 high yield stocks I
> follow. The email comes a few days prior to the event so it
> gives me time to react.
>
> *From:*smf_addin@yahoogroups.com
> <mailto:smf_addin@yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com] *On Behalf Of *Pat Rosenheim
> *Sent:* Wednesday, May 07, 2014 12:22 PM
> *To:* smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
> *Subject:* Re: [smf_addin] asking for help, again [2 Attachments]
>
> On 5/7/2014 10:48 AM, Randy Harmelink wrote:
>
> What source do you normally use?
>
> finviz, which is wrong on some occasions, and unresponsive to
> emails to their 'customer service'.
>
>
> Were the error items stocks, or ETFs? That element number
> won't work for ETFs. They don't have Key Statistics web pages.
>
> Stocks. I only have 2 ETFs, CEFL & MORL.
>
> I went back to finviz. Takes forever, and I manually correct
> the errors. There is no automatic updating of Ex-div and pay
> dates, or amounts, just annual yield and return. Oh, well.
> I'll live with it.
>
> Thank you for everything.
>
> pat
>
> On Wed, May 7, 2014 at 7:19 AM, Pat Rosenheim
> <pat@patrosenheim.com <mailto:pat@patrosenheim.com>> wrote:
>
> And it turns out that yahoo returns ERROR for at least 10 of
> my stocks with just this one function;
> =RCHGetElementNumber(D2,992)
>
> So now my question is, is there a site that provides reliable
> information?
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend
> Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend
> Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
> --
>
>
> Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
> pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
> http://www.patrosenheim.com
>
>
--
Pat Rosenheim (PandA Trader) High Yield, High Return Dividend Portfolio
pat@patrosenheim.com <mailto:pat.rosenheim@gmail.com>
http://www.patrosenheim.com
Wed May 7, 2014 9:39 pm (PDT) . Posted by:
sethm1225
Hi All,
I'm trying to populate a worksheet with financial data and was using AdvFn to get this data, which is working great, with the exception of the two most recent quarters. For instance if I'm looking for the Total Revenue of PG, and I look this up using RCHGetElementNumber() and look for element 8206, it's returning 64,044 vs. the actual revenue of 20,559. This seems to be consistent across any tickers I try, and also returns similar results if I use SMFGetADVFNElement().
Browsing through some of these conversations, it sounds like there may have been a change to AdvFn and this is what's causing my issue, but it's strange since the number doesn't resemble any other financial data that I can find. Is this a known issue? If so, is there a workaround?
If this doesn't work anymore, and you recommend not using AdvFn for financial data, what would you recommend instead?
Thanks!
I'm trying to populate a worksheet with financial data and was using AdvFn to get this data, which is working great, with the exception of the two most recent quarters. For instance if I'm looking for the Total Revenue of PG, and I look this up using RCHGetElementNumber
Browsing through some of these conversations, it sounds like there may have been a change to AdvFn and this is what's causing my issue, but it's strange since the number doesn't resemble any other financial data that I can find. Is this a known issue? If so, is there a workaround?
If this doesn't work anymore, and you recommend not using AdvFn for financial data, what would you recommend instead?
Thanks!
Wed May 7, 2014 9:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I go to the AdvFN web page, I see 64,044 -- so the add-in is returning
correctly what AdvFN is displaying.
Comparing it to Yahoo, it looks like AdvFN is posting a YTD Total Revenue...
On Wed, May 7, 2014 at 9:06 PM, <seth.a.markowitz@gmail.com> wrote:
>
> I'm trying to populate a worksheet with financial data and was using AdvFn
> to get this data, which is working great, with the exception of the two
> most recent quarters. For instance if I'm looking for the Total Revenue of
> PG, and I look this up using RCHGetElementNumber() and look for element
> 8206, it's returning 64,044 vs. the actual revenue of 20,559. This seems
> to be consistent across any tickers I try, and also returns similar results
> if I use SMFGetADVFNElement().
>
> Browsing through some of these conversations, it sounds like there may
> have been a change to AdvFn and this is what's causing my issue, but it's
> strange since the number doesn't resemble any other financial data that I
> can find. Is this a known issue? If so, is there a workaround?
>
> If this doesn't work anymore, and you recommend not using AdvFn for
> financial data, what would you recommend instead?
>
correctly what AdvFN is displaying.
Comparing it to Yahoo, it looks like AdvFN is posting a YTD Total Revenue...
On Wed, May 7, 2014 at 9:06 PM, <seth.a.markowitz@gmail.com> wrote:
>
> I'm trying to populate a worksheet with financial data and was using AdvFn
> to get this data, which is working great, with the exception of the two
> most recent quarters. For instance if I'm looking for the Total Revenue of
> PG, and I look this up using RCHGetElementNumber
> 8206, it's returning 64,044 vs. the actual revenue of 20,559. This seems
> to be consistent across any tickers I try, and also returns similar results
> if I use SMFGetADVFNElement(
>
> Browsing through some of these conversations, it sounds like there may
> have been a change to AdvFn and this is what's causing my issue, but it's
> strange since the number doesn't resemble any other financial data that I
> can find. Is this a known issue? If so, is there a workaround?
>
> If this doesn't work anymore, and you recommend not using AdvFn for
> financial data, what would you recommend instead?
>
Thu May 8, 2014 6:54 am (PDT) . Posted by:
sethm1225
So is this related to the advfn current site vs. their beta site? i.e. this:
http://www.advfn.com/exchanges/NYSE/PG/financials?btn=quarterly_reports&mode=company_data http://www.advfn.com/exchanges/NYSE/PG/financials?btn=quarterly_reports&mode=company_data
vs. this:
http://uk.advfn.com/common/financial/NYSE/procter-gamble-PG/income-statement?pm=Q http://uk.advfn.com/common/financial/NYSE/procter-gamble-PG/income-statement?pm=Q
?
I've read in other threads that you wouldn't want to change the add-in if it's not certain that the new advfn design is final (which is completely reasonable). In the interim, what other sources would you (or other users) recommend for similar data?
Thanks again!
http://www.advfn.com/exchanges/NYSE/PG/financials?btn=quarterly_reports&mode=company_data http://www.advfn.com/exchanges/NYSE/PG/financials?btn=quarterly_reports&mode=company_data
vs. this:
http://uk.advfn.com/common/financial/NYSE/procter-gamble-PG/income-statement?pm=Q http://uk.advfn.com/common/financial/NYSE/procter-gamble-PG/income-statement?pm=Q
?
I've read in other threads that you wouldn't want to change the add-in if it's not certain that the new advfn design is final (which is completely reasonable). In the interim, what other sources would you (or other users) recommend for similar data?
Thanks again!
Thu May 8, 2014 7:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
A lot of people moved to GuruFocus when we had problems with AdvFN last
year.
On Thu, May 8, 2014 at 6:54 AM, <seth.a.markowitz@gmail.com> wrote:
>
> So is this related to the advfn current site vs. their beta site? i.e.
> this:
>
>
> http://www.advfn.com/exchanges/NYSE/PG/financials?btn=quarterly_reports&mode=company_data
>
> vs. this:
>
>
> http://uk.advfn.com/common/financial/NYSE/procter-gamble-PG/income-statement?pm=Q
>
> ?
>
> I've read in other threads that you wouldn't want to change the add-in if
> it's not certain that the new advfn design is final (which is completely
> reasonable). In the interim, what other sources would you (or other users)
> recommend for similar data?
>
year.
On Thu, May 8, 2014 at 6:54 AM, <seth.a.markowitz@gmail.com> wrote:
>
> So is this related to the advfn current site vs. their beta site? i.e.
> this:
>
>
> http://www.advfn.com/exchanges/NYSE/PG/financials?btn=quarterly_reports&mode=company_data
>
> vs. this:
>
>
> http://uk.advfn.com/common/financial/NYSE/procter-gamble-PG/income-statement?pm=Q
>
> ?
>
> I've read in other threads that you wouldn't want to change the add-in if
> it's not certain that the new advfn design is final (which is completely
> reasonable). In the interim, what other sources would you (or other users)
> recommend for similar data?
>
Fri May 9, 2014 1:51 pm (PDT) . Posted by:
mail_to_subu
Hi Pete
I'm back here after ages, and lo and behold, you have already posted my favorite "F wall street" sp sheet
I thank my stars, start using it, encounter some errors on GF pages, change RCHGetTableCell formula as gurufocus seems to have changed some descriptions
I thank you, Randy and other gurus here, for this excellent community and your hard work
some questions
~~~~~~~~~~~~~~~
1. would my version be of any use ? : Is there some place on this group files section, I can upload my (version of) sp sheet on a " _purely_ for review" basis (not for all to download or depend on at this stage)
1.1. Temporarily it's uploaded to http://1drv.ms/1mKwAQm http://1drv.ms/1mKwAQm
1.2. mods / changes made to Gf sheet
2. why's Xl forgetting the data collected : I always thought that XL remembered the values that I picked up from the web. What do I mean, I mean IF I ran this sp sheet for tickers, WDC and XRX (default ones), and then without closing XL , if I came back and ran this sp sheet a second time for tickers WDC, XRX and MSFT, in the old scheme of things, Xl remembered the values it picked up for WDC, XRX and went searching the web only for the new tickers. However this time though it seems to be doing it all over again. what should I tweak in XL to improve it's memory ?
2.1. I'm using XL 2010, version 14.0.7106.... blah ..blah on a win 7 machine
3. Max download of data, infuriating website owners, increasing blood pressure !!: To avoid all that , I used to download critical info once in three months for my standard set of tickers, keep it some place, use V lookup for the next n runs, and update only current price . I seem to have lost that magic sp sheet to download data and throw it some place ....
==========
regards
Subu
--In smf_addin@yahoogroups.com, <dan-carroll@...> wrote :
I think I've fixed the GF problems. GuruFocus changed the description of a few terms & I've updated it.
I haven't done a line-by-line check, so caveat emptor. If you spot any issues, let me know and I'll fix and update it.
I'm back here after ages, and lo and behold, you have already posted my favorite "F wall street" sp sheet
I thank my stars, start using it, encounter some errors on GF pages, change RCHGetTableCell formula as gurufocus seems to have changed some descriptions
I thank you, Randy and other gurus here, for this excellent community and your hard work
some questions
~~~~~~~~~~~~~~~
1. would my version be of any use ? : Is there some place on this group files section, I can upload my (version of) sp sheet on a " _purely_ for review" basis (not for all to download or depend on at this stage)
1.1. Temporarily it's uploaded to http://1drv.ms/1mKwAQm http://1drv.ms/1mKwAQm
1.2. mods / changes made to Gf sheet
2. why's Xl forgetting the data collected : I always thought that XL remembered the values that I picked up from the web. What do I mean, I mean IF I ran this sp sheet for tickers, WDC and XRX (default ones), and then without closing XL , if I came back and ran this sp sheet a second time for tickers WDC, XRX and MSFT, in the old scheme of things, Xl remembered the values it picked up for WDC, XRX and went searching the web only for the new tickers. However this time though it seems to be doing it all over again. what should I tweak in XL to improve it's memory ?
2.1. I'm using XL 2010, version 14.0.7106.... blah ..blah on a win 7 machine
3. Max download of data, infuriating website owners, increasing blood pressure !!: To avoid all that , I used to download critical info once in three months for my standard set of tickers, keep it some place, use V lookup for the next n runs, and update only current price . I seem to have lost that magic sp sheet to download data and throw it some place ....
==========
regards
Subu
--In smf_addin@yahoogroups.com, <dan-carroll@
I think I've fixed the GF problems. GuruFocus changed the description of a few terms & I've updated it.
I haven't done a line-by-line check, so caveat emptor. If you spot any issues, let me know and I'll fix and update it.
Tidak ada komentar:
Posting Komentar