Sabtu, 16 Januari 2016

[smf_addin] Digest Number 3609

3 Messages

Digest #3609
1a
Need help with dividata webpage by "Kermit W. Prather" kermitpra
1b
Re: Need help with dividata webpage by "Randy Harmelink" rharmelink
1c
Re: Need help with dividata webpage by "Kermit W. Prather" kermitpra

Messages

Fri Jan 15, 2016 7:58 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

It appears dividata has changed the format of their webpage that I use to
get dividend yield

My current formula that works but does not work now: Cell F7 has CPLP

=RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend
Yield:",,,,,,,,2)

This is the part of the webpage I think contains that Dividend yield:

.">Annual Dividend</abbr><span class="nobadge bigstat">$0.96</span></li>
<li class="list-group-item"><abbr title="Value of latest dividend multiplied
by number of times dividends are typically paid per year, divided by closing
price of stock on prior trading day.">Dividend Yield</abbr><span
class="nobadge bigstat">24.43%</span></li>
<li class="list-group-item"><abbr title="Number of years a stock has paid a
dividend.">Years Paying</abbr><span class="nobadge bigstat">8</


Thanks, Kermit

Fri Jan 15, 2016 10:06 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("http://dividata.com/stock/"&F7,"span",1,">Dividend
Yield",,,,1,,2)

On Fri, Jan 15, 2016 at 8:58 AM, 'Kermit W. Prather' kermitp@... wrote:

>
> It appears dividata has changed the format of their webpage that I use
> to get dividend yield
>
>
>
> My current formula that works but does not work now: Cell F7 has CPLP
>
>
>
> =RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend
> Yield:",,,,,,,,2)
>
>
>
> This is the part of the webpage I think contains that Dividend yield:
>
>
>
> .">Annual Dividend</abbr><span class="nobadge bigstat">$0.96</span></li>
>
> <li class="list-group-item"><abbr title="Value of latest dividend
> multiplied by number of times dividends are typically paid per year,
> divided by closing price of stock on prior trading day.">Dividend Yield</
> abbr><span class="nobadge bigstat">24.43%</span></li>
>
> <li class="list-group-item"><abbr title="Number of years a stock has paid
> a dividend.">Years Paying</abbr><span class="nobadge bigstat">8</
>
>
>
>
>

Fri Jan 15, 2016 11:50 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Worked great

Thanks, Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, January 15, 2016 1:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Need help with dividata webpage


Try:

=smfGetTagContent("http://dividata.com/stock/"&F7,"span",1,">Dividend Yield",,,,1,,2)

On Fri, Jan 15, 2016 at 8:58 AM, 'Kermit W. Prather' kermitp@... wrote:

It appears dividata has changed the format of their webpage that I use to get dividend yield

My current formula that works but does not work now: Cell F7 has CPLP

=RCHGetTableCell("http://dividata.com/stock/"&F7,1,"Dividend Yield:",,,,,,,,2)

This is the part of the webpage I think contains that Dividend yield:

.">Annual Dividend</abbr><span class="nobadge bigstat">$0.96</span></li>
<li class="list-group-item"><abbr title="Value of latest dividend multiplied by number of times dividends are typically paid per year, divided by closing price of stock on prior trading day.">Dividend Yield</abbr><span class="nobadge bigstat">24.43%</span></li>
<li class="list-group-item"><abbr title="Number of years a stock has paid a dividend.">Years Paying</abbr><span class="nobadge bigstat">8</




For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar