3 Messages
Digest #3609
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
get dividend yield
My current formula that works but does not work now: Cell F7 has CPLP
=RCHGetTableCell("http://dividata.com/stock/"&F7,1,
Yield:"
This is the part of the webpage I think contains that Dividend yield:
.">Annual Dividend<
<li class="
by number of times dividends are typically paid per year, divided by closing
price of stock on prior trading day.">
class="
<li class="
dividend."
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</
>
>
>
>
>
=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,
> Yield:"
>
>
>
> This is the part of the webpage I think contains that Dividend yield:
>
>
>
> .">Annual Dividend<
>
> <li class="
> multiplied by number of times dividends are typically paid per year,
> divided by closing price of stock on prior trading day.">
> abbr><
>
> <li class="
> a dividend."
>
>
>
>
>
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</
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,
This is the part of the webpage I think contains that Dividend yield:
.">Annual Dividend<
<li class="
<li class="
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar