LME copper in Excel

[tminhv]

Is there a nice easy way to get copper prices into excel? (the London metal exchange numbers)
ie these here https://www.lme.com/Metals/Non-ferrous/LME-Copper#Trading+day+summary
or Copper Prices - 45 Year Historical Chart current price

Excel has the functionality for Stocks and Currencies built in. So maybe there is something in there?

I'm using O365, so vba won't be a viable option.

 

[alansidman]

Using Power Query/Get and Transform Data found on the Data Tab you can easily get the 45 year prices. No coding required. It can all be done in the user interface,