[smf_addin] Digest Number 4559

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4559

1a

businessinsider.com by wongkayau

1b

Re: businessinsider.com by "Randy Harmelink" rharmelink

Messages

1a

businessinsider.com

Wed Jun 19, 2019 9:19 am (PDT) . Posted by:

wongkayau

Hi Randy,


Morning. May I ask you whether the following website is downloadable?

https://markets.businessinsider.com/index/historical-prices/hang_seng/19.5.2019_19.6.2019 https://markets.businessinsider.com/index/historical-prices/hang_seng/19.5.2019_19.6.2019


I have tried RCHGetTableCell but no luck.



Thank you very much.


Cheers,
K

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

1b

Re: businessinsider.com

Wed Jun 19, 2019 12:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, the data is not delivered within the source code of the web
page, but delivered via an Ajax file that requires credentials and then the
data is used to dynamically build the displayed web page.

You can use the experimental web page retrieval process, which is slow and
can be unreliable. Array-entering this over a range returns data:

=RCHGetHTMLTable("
https://markets.businessinsider.com/index/historical-prices/hang_seng/19.5.2019_19.6.2019",">Daily
High",,,,,,,2)

On Wed, Jun 19, 2019 at 9:19 AM wongkayau@... wrote:

> Morning. May I ask you whether the following website is downloadable?
>
>
> https://markets.businessinsider.com/index/historical-prices/hang_seng/19.5.2019_19.6.2019
>
> I have tried RCHGetTableCell but no luck.
>
>
>

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use