How to load page with specific date?

E

Eric

Does anyone have any suggestions on how to load page with specific date?
For example, https://fx2.oanda.com/user/interestrate.html, I need to
manually input
date, which starting from 1/1/1970 to today() or 2/2/2010.
Does anyone have any suggestions on how to load this page into excel?
Thanks in advance for any suggestions
Eric
 
E

Eric

Thank you very much for your suggestions

Will it be possible to add a loop for different currencies? such as
Australian Dollar, Japanese Yen, US Dollar, and insert those data into
specific country sheet, Japanese Yen into Japan Sheet, Australian Dollar into
Australian, US Dollar into US sheet etc.
I can copy all the codes and paste one time for Japanese Yen and another
time for Australian Dollar, but it will make this macro very long,
Do you have any suggestions?
Thank you very much for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top