Fix Excel STOCKHISTORY Returning VALUE for UK Mutual Funds
Question details
The user is attempting to retrieve pricing data for UK mutual funds and OEICs using the Excel STOCKHISTORY function but is encountering a #VALUE! or Not Found error.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tracking historical financial data and portfolio performance for UK mutual funds and Open-Ended Investment Companies (OEICs).
- Observed behavior
- The STOCKHISTORY function and Stocks data type fail to retrieve the requested data, returning '#VALUE!' or 'Not found' due to incomplete coverage by the underlying data provider.
Verify that your internet connection is active and that your Microsoft 365 subscription is fully updated, as the Stocks data type relies on live cloud services.
Understand the Limitation and Use Alternative Data Sources
Since Excel's native data provider lacks complete coverage for UK mutual funds and OEICs, you must rely on manual data entry or external web queries.
Excel's Stocks data type and the STOCKHISTORY function rely on a third-party market-data provider. Currently, this provider does not offer complete or consistent coverage for UK mutual funds and Open-Ended Investment Companies (OEICs).
Changing the fund name or ticker symbol will not resolve the issue if the fund simply is not in the database. Because this is a known limitation without a confirmed comprehensive solution, using alternative methods to import financial data is required.
Sometimes UK funds are listed under different exchanges or identifiers (e.g., adding 'LON:' before the ticker). Try searching the exact ISIN or Bloomberg ticker in the Data selector to see if a variation is supported.
Go to the 'Data' tab and select 'From Web'. Enter the URL of a financial website (like Yahoo Finance or Morningstar) that tracks your specific UK mutual fund to pull the table data directly into your spreadsheet.
Consider installing a dedicated financial market Add-in from the 'Insert' > 'Get Add-ins' menu that specializes in UK and European mutual funds.
Manage Your Financial Portfolios Seamlessly with WPS Office
While Microsoft Excel struggles with specific UK mutual fund data feeds, managing your financial spreadsheets doesn't have to be frustrating. WPS Office provides a free, lightweight, and highly compatible alternative for organizing your investment portfolios without the premium subscription cost.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Install and Launch: Follow the on-screen instructions to install the software, then open WPS Spreadsheets.
- 3. Open Your Portfolio: Click 'Open' and select your existing Excel (.xlsx) financial tracker. Your formatting and standard formulas will load seamlessly.
Frequently Asked Questions
Why does STOCKHISTORY return a #VALUE! error?
The #VALUE! error in STOCKHISTORY usually means the financial instrument, such as a specific UK mutual fund, is not supported or recognized by Excel's underlying financial data provider.
Will changing the ticker symbol fix the 'Not found' error for UK OEICs?
In most cases, no. If the fund is not covered by the market-data provider, modifying the name, ISIN, or ticker symbol will not retrieve the missing data.
Is there an official fix for missing UK mutual fund data in Excel?
Currently, there is no official comprehensive solution. Microsoft acknowledges this as a known limitation regarding their third-party data provider's coverage.
How can I pull mutual fund prices into a spreadsheet without STOCKHISTORY?
You can use the 'Data' > 'From Web' feature to scrape pricing tables directly from public financial websites, or install specialized third-party financial add-ins designed for the European market.
