2 Messages

Digest #4432

Getting Stock Quote from Investing.com by alankc_mok

Re: Getting Stock Quote from Investing.com by "Randy Harmelink" rharmelink

Messages

1a

Getting Stock Quote from Investing.com

Sun Dec 2, 2018 7:00 pm (PST) . Posted by:

alankc_mok

Dear Randy,

Is there a way to get the historical stock price from investing.com ?

For example, I want to the get the Price, Open, High, Low for Hang Seng (HSI) https://www.investing.com/indices/hang-sen-40-historical-data https://www.investing.com/indices/hang-sen-40-historical-data on 30 Nov 2018.

Reagrds

Alan

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

1b

Re: Getting Stock Quote from Investing.com

Sun Dec 2, 2018 8:10 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

To grab those four items specifically:

=RCHGetTableCell("
https://www.investing.com/indices/hang-sen-40-historical-data",1,">Nov 30,
2018")
=RCHGetTableCell("
https://www.investing.com/indices/hang-sen-40-historical-data",2,">Nov 30,
2018")
=RCHGetTableCell("
https://www.investing.com/indices/hang-sen-40-historical-data",3,">Nov 30,
2018")
=RCHGetTableCell("
https://www.investing.com/indices/hang-sen-40-historical-data",4,">Nov 30,
2018")

On Sun, Dec 2, 2018 at 8:00 PM alankc_mok@... wrote:

>
> Is there a way to get the historical stock price from investing.com ?
>
> For example, I want to the get the Price, Open, High, Low for Hang Seng
> (HSI) https://www.investing.com/indices/hang-sen-40-historical-data on 30
> Nov 2018.
>
>
>