'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Get the Current London Stock Exchange Price in Excel
Question details
The user wants to retrieve and display the current London Stock Exchange (LSE) price for specific companies (like easyJet PLC) within an Excel spreadsheet and refresh it as needed.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tracking real-time or updated stock prices from the London Stock Exchange in a spreadsheet.
- Observed behavior
- The user needs to use the Stocks data type and specific ticker symbols (like XLON:EZJ) to fetch and display the stock price, with options to refresh the data automatically or manually.
Ensure you have an active internet connection and are logged into a Microsoft 365 account, as the linked Stocks data type is a premium feature that requires cloud connectivity.
Use the Stocks Data Type to Fetch LSE Prices
Convert standard text into the linked Stocks data type to extract real-time prices and other financial metrics directly into your worksheet.
Microsoft Excel's built-in Stocks data type connects directly to financial databases to pull live metrics. Specifying the exchange prefix (like XLON for London) ensures you get the exact listing you need.
Type the specific ticker symbol with the exchange prefix (e.g., 'XLON:EZJ' for easyJet PLC) or just the company name into a blank cell (such as A1).
Select the cell containing your text, navigate to the 'Data' tab on the top ribbon, and click on 'Stocks'. If prompted by the Data Selector pane on the right, select the correct company listing.
Click the small 'Insert Data' icon that appears in the top-right corner of the selected cell. Choose 'Price' from the dropdown list, and the current stock price will populate in the adjacent cell.
To update the stock prices at any time, go to the 'Data' tab and click 'Refresh All' under the Queries & Connections group.
Try WPS Office for Your Financial Data Management
While the linked Stocks data type is specific to Microsoft 365 subscriptions, WPS Office provides a lightweight, fully compatible, and free alternative for managing complex financial spreadsheets, CSV imports, and data analysis without expensive recurring fees.
- 1. Download and Install: Download WPS Office Free from the official website and install it on your device.
- 2. Open Your Financial Workbook: Launch WPS Spreadsheet and easily open any existing .xlsx or .csv files containing your stock portfolios.
- 3. Import Web Data: Use the Data > Import Data feature to connect to external web sources or import downloaded CSV stock histories for your financial analysis.
Frequently Asked Questions
How do I refresh the stock prices automatically when I open the file?
You can configure the connection properties to refresh on open. Go to Data > Queries & Connections, right-click the stock data connection, select Properties, and check the box for 'Refresh data when opening the file'.
What is the correct format for a London Stock Exchange ticker in Excel?
For the London Stock Exchange, use the prefix 'XLON:' followed by the company's ticker symbol. For example, use 'XLON:EZJ' for easyJet PLC to ensure Excel fetches the correct exchange data.
Why is the Stocks data type button missing in my Excel?
The Stocks data type is a cloud-connected feature only available to Microsoft 365 subscribers. If you are using an older, standalone version of Excel (like Excel 2016 or 2019) or are not signed in, the feature will not appear.
