Get Currency Data into Excel with VBA
Budget: $20 – $50 USD
Refer attached image. This will be the base excel sheet to work from. I will share the file later.
From this site: https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html
Download the Time Series -- XML file to a file.
Parse the file for *new* data after the date of the last populated row in Excel.
Populate the excel sheet for the currencies for new dates (since the last date) to the latest available date (from downloaded file).
As the currency base is EUR we need to do simple calculation = Base Rate (row 11 in image) / Target Rate (row 12 in image).
From this site: https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html
Download the Time Series -- XML file to a file.
Parse the file for *new* data after the date of the last populated row in Excel.
Populate the excel sheet for the currencies for new dates (since the last date) to the latest available date (from downloaded file).
As the currency base is EUR we need to do simple calculation = Base Rate (row 11 in image) / Target Rate (row 12 in image).
Related categories:
Excel VBA