Sabtu, 04 Mei 2019

[smf_addin] Digest Number 4535

6 Messages

Digest #4535

Messages

Fri May 3, 2019 5:49 am (PDT) . Posted by:

tzewei_79

Hi,


I like to get the dividend payout ratio from https://www.dividendinvestor.com/dividend-quote/sig/ https://www.dividendinvestor.com/dividend-quote/sig/
I checked the elements and it is not exactly under the class "dividend payout ratio" but it is on the next line. Is there a way to extract this percentage out?

Fri May 3, 2019 8:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There is. But, as I recall, unless you are a subscriber, you're limited to
10 or so extractions?

=smfGetTagContent("https://www.dividendinvestor.com/dividend-quote/sig/","span",1,">Dividend
Payout Ratio",,,,1)

On Fri, May 3, 2019 at 5:49 AM tzewei_79@... wrote:

> I like to get the dividend payout ratio from
> https://www.dividendinvestor.com/dividend-quote/sig/
>
> I checked the elements and it is not exactly under the class "dividend
> payout ratio" but it is on the next line. Is there a way to extract this
> percentage out?
>
>

Fri May 3, 2019 9:22 am (PDT) . Posted by:

tzewei_79

Thanks!

I just tried to extractin about 200 symbols. It seems ok without subscription.

Fri May 3, 2019 5:57 am (PDT) . Posted by:

tzewei_79

I think the dividend payout ratio from yahoo is not updated. Comparing dividendInvestor.com for example SIG, we can see the ratio there,

Fri May 3, 2019 9:28 am (PDT) . Posted by:

tzewei_79

Hi,


I was able to extract dividend payout ratio with =smfGetTagContent("https://www.dividendinvestor.com/dividend-quote/"&A3,"span",1,">Dividend Payout Ratio",,,,1)


But I can't extract "consecutive-increases".
From the elements, it looks like this:
<span class="description";><a href="/consecutive-increases/">Consecutive Dividend Increases</a></span>



The description is different from "Dividend Payout Ratio". Are we still able to extract this information?

Fri May 3, 2019 9:52 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You just need to change the search term:

=smfGetTagContent("https://www.dividendinvestor.com/dividend-quote/"&$A3,"span",1,">Consecutive
Dividend Increases",,,,1)

To get the value independent of the period description, you'd need to
extract it:

=smfStrExtr(smfGetTagContent("
https://www.dividendinvestor.com/dividend-quote/"&$A3,"span",1,">Consecutive
Dividend Increases",,,,1),"~"," ",1)

If you're doing these extracts as a table, you may want to look at the
smfUpdateDownloadTable process. Then you are in control of recalculation.
It stores values in the worksheet instead of always having to recalculate
everything when the workbook is opened. Since most items only need to be
updated once a quarter, there's no reason to be pulling so many pages from
the site every time you open the workbook. See the "FAQs and Tips" page for
more information on this routine.

I've attached an example. I basically took the sample template and just
copied over the formulas in text mode, changing the ticker reference to
"~~~~~". Only took a minute or so.

On Fri, May 3, 2019 at 9:28 AM tzewei_79@... wrote:

> I was able to extract dividend payout ratio with =smfGetTagContent("
> https://www.dividendinvestor.com/dividend-quote/"&A3,"span",1,">Dividend
> Payout Ratio",,,,1)
>
> But I can't extract "consecutive-increases".
>
> From the elements, it looks like this:
>
> <span class="description";><a href="/consecutive-increases/">Consecutive
> Dividend Increases</a></span>
>
> The description is different from "Dividend Payout Ratio". Are we still
> able to extract this information?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 05.36

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)