UK Share prices in Excel

Question

How can I get UK share prices in Excel? I found this https://www.thespreadsheetguru.com/blog/add-real-time-stock-prices-and-metrics-to-excel which says that the facility was introduced in 2019, but my version of Excel dates to 2018 and I don't see the button they mention in Data. Can I update Excel easily to include this?

I found this https://www.michael-saunders.com/stocksapp/pages/info.html for US shares,

riny_van_eekelen · Answer

RobU123&nbsp;The links below describe the Stock features in Excel. As you can read in these, it requires MS365 use them.https://support.microsoft.com/en-us/office/excel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877&nbsp;https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8&nbsp;

robu123 · Answer

I see. £60/year if I understand correctly.

Forum Discussion

UK Share prices in Excel

2 Replies

Resources