Power Query website - based on date input

Hi all,

Apologies if this has been discussed before but I can't find the answer anywhere.

I just want to pull exchange rates into excel from a website such as xe.com based on a date entered into a cell.

So, for example, if I were to enter 12/31/2022 in cell A1 I would like the query to output the exchange rates into a table as of that date.

I've been trying to extract the data from a URL which contains the date within the URL.

I'm certain there's a way to make the date embedded in the URL ("2024-05-30") referenced to a cell in my worksheet but I don't know how to do that.

I'd really appreciate help in putting me in the right direction.

Many thanks

Steven

TEST.xlsx

Give full URL example and what data you want to extract and/or your existing query code. Without that info, I'll be stubbing in the dark.