ca.moazzam
Board Regular
- Joined
- Jan 2, 2011
- Messages
- 182
Hello all,
Bank of Canada recently redesigned its website from which I used to pull daily exchange rates and now refreshing my file doesn't work any more. I now need to first specify the currencies I need along with my target date on the new site and then it displays the target rates. If I create a web query and try to refresh it the next day, it won't work because my target date has changed. Wondering if someone could guide how to create an Excel file wherein I could just change my target date every day, refresh and it could pull exchange rates for the 4 currencies I am interested in (which are AUD, EUR, GBP and USD). Here's the link:
https://www.bankofcanada.ca/rates/e...017-11-06&dTo=2017-11-06&submit_button=Submit
Many thanks,
Moazzam
Bank of Canada recently redesigned its website from which I used to pull daily exchange rates and now refreshing my file doesn't work any more. I now need to first specify the currencies I need along with my target date on the new site and then it displays the target rates. If I create a web query and try to refresh it the next day, it won't work because my target date has changed. Wondering if someone could guide how to create an Excel file wherein I could just change my target date every day, refresh and it could pull exchange rates for the 4 currencies I am interested in (which are AUD, EUR, GBP and USD). Here's the link:
https://www.bankofcanada.ca/rates/e...017-11-06&dTo=2017-11-06&submit_button=Submit
Many thanks,
Moazzam
