Pulling Closing Prices of CCY from Web

[hkese]

Hi,

I need to keep track of the closing price for a list of currency pairs of any specific date.

For example:
USDHKD
USDHKD Historical Currency Quotes - Hong Kong Dollar Historical Currency Quotes - MarketWatch

HKDCNH
HKDCNH Historical Currency Quotes - Hong Kong Dollar/Chinese Yuan Offshore Historical Currency Quotes - MarketWatch

Right now I have to go to the above links one by one and select the date to get the closing price.

Is there a way that I can do a web query whereby I can input the date in the excel and the closing prices would be automatically queried from the above websites?

Thanks.
B

 

[hkese]

Anyone? Or is this doable at all?

 

[John_w]

Have a look at IE automation or XMLhttp/WinHttp requests and HTMLDocument parsing.

 

[hkese]

Anyone has a better suggestion, or another website that can help me accomplish the same result?