5 Messages

Digest #3643

M&A analysis? by jharlan

Re: M&A analysis? by "Randy Harmelink" rharmelink

update table data by "Darryl Bonfessuto"

Re: update table data by "Randy Harmelink" rharmelink

Re: Elements not working by joelfp2000

Messages

1a

M&A analysis?

Thu Feb 18, 2016 1:47 pm (PST) . Posted by:

jharlan

Hi,

I was wondering if there is an M&A file that will compare a number of public companies based on whatever criteria available via this macro?

Not sure how helpful that is.

Thanks,

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

1b

Not an existing one that I'm aware of -- you'd have to build one, based on
your criteria...

On Thu, Feb 18, 2016 at 2:47 PM, jharlan@... wrote:

> I was wondering if there is an M&A file that will compare a number of
> public companies based on whatever criteria available via this macro?
>
> Not sure how helpful that is.
>
>

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

2a

update table data

Thu Feb 18, 2016 1:57 pm (PST) . Posted by:

"Darryl Bonfessuto"

Randy,

When using the array formula {
=RCHGetHTMLTable("http://online.wsj.com/mdc/public/page/2_3022-bondbnchmrk.h
tml",">Latest",-1,"",1)}

Is there a where to update the table data information into excel?

Thanks

Darryl

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

2b

Re: update table data

Thu Feb 18, 2016 3:22 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Use the smfForceRecalculation macro to update the table data. See the "Tips
and FAQs" page for more info on the macro.

On Thu, Feb 18, 2016 at 2:49 PM, Darryl Bonfessuto dmb7111@... wrote:

>
> When using the array formula { =RCHGetHTMLTable("
> http://online.wsj.com/mdc/public/page/2_3022-bondbnchmrk.html
> ",">Latest",-1,"",1)}
>
> Is there a where to update the table data information into excel?
>
>