[smf_addin] Digest Number 4404

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #4404

1a

WSJ Div Page by carmine288

1b

Re: WSJ Div Page by "Randy Harmelink" rharmelink

2

WSJ Dividend Page by carmine288

Messages

1a

WSJ Div Page

Mon Oct 1, 2018 11:49 am (PDT) . Posted by:

carmine288

What is the best way to capture the "DIVIDENDS DECLARATIONS" page and the "STOCKS EX-DIVIDEND" page from:


http://www.wsj.com/mdc/public/page/2_3022-dividends-20180926.html?mod=mdc_pastcalendar http://www.wsj.com/mdc/public/page/2_3022-dividends-20180926.html?mod=mdc_pastcalendar

and
http://www.wsj.com/mdc/public/page/2_3022-dividends-20180911.html?mod=mdc_pastcalendar http://www.wsj.com/mdc/public/page/2_3022-dividends-20180911.html?mod=mdc_pastcalendar



Thanks,
Carmine

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

1b

Re: WSJ Div Page

Mon Oct 1, 2018 12:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("
http://www.wsj.com/mdc/public/page/2_3022-dividends-20180926.html?mod=mdc_pastcalendar
",">Ex-Div")

=RCHGetHTMLTable("
http://www.wsj.com/mdc/public/page/2_3022-dividends-20180911.html?mod=mdc_pastcalendar
",">Factor")

On Mon, Oct 1, 2018 at 11:49 AM carmine.nicoletta@... wrote:

> What is the best way to capture the "DIVIDENDS DECLARATIONS" page and the
> "STOCKS EX-DIVIDEND" page from:
>
>
> http://www.wsj.com/mdc/public/page/2_3022-dividends-20180926.html?mod=mdc_pastcalendar
>
> and
>
>
> http://www.wsj.com/mdc/public/page/2_3022-dividends-20180911.html?mod=mdc_pastcalendar
>
>
>

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

2

WSJ Dividend Page

Mon Oct 1, 2018 11:52 am (PDT) . Posted by:

carmine288

What is the best way to capture the DIVIDENDS DECLARATIONS page and STOCKS EX-DIVIDEND page from these links:


http://www.wsj.com/mdc/public/page/2_3022-dividends-20180926.html?mod=mdc_pastcalendar http://www.wsj.com/mdc/public/page/2_3022-dividends-20180926.html?mod=mdc_pastcalendar

and
http://www.wsj.com/mdc/public/page/2_3022-dividends-20180911.html?mod=mdc_pastcalendar http://www.wsj.com/mdc/public/page/2_3022-dividends-20180911.html?mod=mdc_pastcalendar



Thanks,

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

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

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use