VBA - Data Extract from Website

[AM742]

Hi There,

I have an overdraft facility and have prepared a loan amortization schedule.

I am looking for VBA to extract overnight interest rates from central Bank's website to do interest calculations.

Can anyone assist me on this?

Thanks in advance for your time.

Regards

 

[AlanSidman]

Please provide a link to the web site you wish to query.

 

[AM742]

Please provide a link to the web site you wish to query.

Hi below is the link

CBUAE | EIBOR Rates

The Central Bank of the UAE (CBUAE) promotes financial and monetary stability, efficiency and resilience in the financial system, while also working to protect consumers.

www.centralbank.ae

 

[Hui]

have a look at this new post by Paul Kelly just yesterday

 

[AlanSidman]

Using Power Query, the results and Mcode follow

let
    Source = Web.Page(Web.Contents("https://www.centralbank.ae/en/services/eibor-prices")),
    Data1 = Source{1}[Data]
in
    Data1