Pulling Closing Prices of CCY from Web

H

hkese

New Member
Joined
Jun 17, 2014
Messages
15
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
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
Anyone has a better suggestion, or another website that can help me accomplish the same result?
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question Question
Pulling Data from Web based on VBA
Replies
0
Views
527
leigh123
L
J
  • Question Question
Power Query editor OR VBA to extract data from Grants.gov
Replies
3
Views
294
Jagadeshrao
J
E
  • Question Question
Can anyone help me get my VBA code working? I have spent tons of time but can't quite fix it.
Replies
3
Views
3K
profray
P
C
  • Question Question
Create code that sends emails and creates a log
Replies
1
Views
265
cokeoverpepsi123
C
L
  • Question Question
Need help copying data from open workbook to closed workbook
Replies
0
Views
328
Lil Stinker
L

Forum statistics

Threads
1,223,237
Messages
6,170,924
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top