[smf_addin] Digest Number 4474

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4474

1a

Data from HKEX by alankc_mok

1b

Re: Data from HKEX by "Randy Harmelink" rharmelink

Messages

1a

Data from HKEX

Tue Jan 29, 2019 5:01 pm (PST) . Posted by:

alankc_mok

Randy,


I can use copy and paste to get the data from this site http://www.hkexnews.hk/sdw/search/mutualmarket.aspx?t=hk http://www.hkexnews.hk/sdw/search/mutualmarket.aspx?t=hk


Apart from that, is there any add-in that I can use so as to extract the associated data ?


Regards


Alan

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

1b

Re: Data from HKEX

Tue Jan 29, 2019 7:48 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

This downloads the table, but it's got labels in every cell because of the
way they code the table:

=RCHGetHTMLTable("http://www.hkexnews.hk/sdw/search/mutualmarket.aspx?t=hk",">Stock
Code")

On Tue, Jan 29, 2019 at 6:02 PM alankc_mok@... wrote:

> I can use copy and paste to get the data from this site
> http://www.hkexnews.hk/sdw/search/mutualmarket.aspx?t=hk
>
> Apart from that, is there any add-in that I can use so as to extract the
> associated data ?
>
>
>

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