Exchange rate extraction from Bloomberg - VBA

[horatiu00]

Hello,


Can someone help me with VBA to extract exchange rates from Bloomberg?
I leave here an example of parity

Bloomberg - Are you a robot?

I need to extract the pairs, exchange rate and the date they are extracted in excel.

Thank you in advance!

View attachment 78726

 

[jdellasala]

Perhaps a different site that Power Query can easily import without VBA?
https://www.exchange-rates.org/Rate/USD/EUR/9-30-2022
Another alternative - MS 365 has Exchange Rates built in.