4 Messages

Digest #3730

Finding 'Ex dividend date' at MarketWatch by john_hoel

Re: Finding 'Ex dividend date' at MarketWatch by john_hoel

Re: Finding 'Ex dividend date' at MarketWatch by "Randy Randall" randyr_cds

Re: Finding 'Ex dividend date' at MarketWatch by john_hoel

Messages

1a

Finding 'Ex dividend date' at MarketWatch

Sat Jun 18, 2016 11:16 am (PDT) . Posted by:

john_hoel

I am trying to get ex-dividend date from MarketWatch.com. So far I have located the security page, but searching the page has found the wrong text. This is the function call:

=smfGetTagContent("http://www.marketwatch.com/investing/stock/"&L71,"div",1,"Ex dividend date",,,,2)

I am stumbling over the Tag argument, which is think is the problem. The function documentation does not describe what the various choices mean. I have the page source if that will help. Can anyone help?

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1b

Re: Finding 'Ex dividend date' at MarketWatch

Sat Jun 18, 2016 12:12 pm (PDT) . Posted by:

john_hoel

This is the HTML that should be found:

<div class="section heavy">
<p class="column">Ex dividend date</p>
<p class="data lastcolumn">6/28/16</p>
</div>

The result is blanks.

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1c

Re: Finding 'Ex dividend date' at MarketWatch

Sat Jun 18, 2016 5:09 pm (PDT) . Posted by:

"Randy Randall" randyr_cds

Try

=smfGetTagContent("http://www.marketwatch.com/investing/stock/"&L71,"p",1,"Ex
dividend date")

Randy Randall

On Sat, Jun 18, 2016 at 3:12 PM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> This is the HTML that should be found:
>
> <div class="section heavy"> <p class="column">Ex dividend date</p> <p class="data lastcolumn">6/28/16</p> </div>
>
> The result is blanks.
>
>
>