Jumat, 19 Februari 2016

[smf_addin] Digest Number 3643

5 Messages

Digest #3643
1a
M&A analysis? by jharlan
1b
Re: M&A analysis? by "Randy Harmelink" rharmelink
2a
update table data by "Darryl Bonfessuto"
2b
Re: update table data by "Randy Harmelink" rharmelink

Messages

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,

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

"Randy Harmelink" rharmelink

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.
>
>

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

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?
>
>

Thu Feb 18, 2016 9:12 pm (PST) . Posted by:

joelfp2000

Looks like Quicktake is working again! Ya!

Thanks again for your insight.


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

Tidak ada komentar:

Poskan Komentar