2 Messages
Digest #4586
Messages
Thu Jul 25, 2019 7:04 am (PDT) . Posted by:
"Tom glenn" tom.glenn@optonline.net
Hi Randy,
For mutual funds, Marketwatch has a 8 or so tables - Key Data, Fund
Details, Fees & Expenses etc.
I cannot seem to get a return on any data in the "Key Data" table. For
example, a 6x40 array with
=RCHGetHTMLTable(CONCATENATE("https://www.marketwatch.com/investing/fund/","pttrx","?ns=prod/accounts-mw"),"Key
Data",1,,7)
will return all tables except the very first one - Key Data (which, of
course, is what I want most).
Any help would be greatly appreciated.
tom
For mutual funds, Marketwatch has a 8 or so tables - Key Data, Fund
Details, Fees & Expenses etc.
I cannot seem to get a return on any data in the "Key Data" table. For
example, a 6x40 array with
=RCHGetHTMLTable(CONCATENATE("https://www.marketwatch.com/investing/fund/","
Data",1,
will return all tables except the very first one - Key Data (which, of
course, is what I want most).
Any help would be greatly appreciated.
tom
Thu Jul 25, 2019 8:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That data isn't in an HTML table. It's created using "li" and "span" HTML
tags.
On Thu, Jul 25, 2019 at 7:05 AM Tom glenn tom.glenn@... wrote:
>
> For mutual funds, Marketwatch has a 8 or so tables - Key Data, Fund
> Details, Fees & Expenses etc.
>
> I cannot seem to get a return on any data in the "Key Data" table. For
> example, a 6x40 array with
>
> =RCHGetHTMLTable(CONCATENATE("https://www.marketwatch.com/investing/fund/","pttrx","?ns=prod/accounts-mw"),"Key
>
> Data",1,,7)
>
> will return all tables except the very first one - Key Data (which, of
> course, is what I want most).
>
> Any help would be greatly appreciated.
>
>
>
tags.
On Thu, Jul 25, 2019 at 7:05 AM Tom glenn tom.glenn@... wrote:
>
> For mutual funds, Marketwatch has a 8 or so tables - Key Data, Fund
> Details, Fees & Expenses etc.
>
> I cannot seem to get a return on any data in the "Key Data" table. For
> example, a 6x40 array with
>
> =RCHGetHTMLTable(CONCATENATE("https://www.marketwatch.com/investing/fund/","
>
> Data",1,
>
> will return all tables except the very first one - Key Data (which, of
> course, is what I want most).
>
> Any help would be greatly appreciated.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar