'%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)
Why Excel STOCKHISTORY Volume Differs from Yahoo Finance
Question details
Users notice significant discrepancies in trading volume data when comparing Excel's STOCKHISTORY function with Yahoo Finance for certain stocks.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Analyzing historical stock market data using the STOCKHISTORY function.
- Observed behavior
- The trading volume reported by Excel's STOCKHISTORY function differs significantly from the volume displayed on Yahoo Finance for identical stocks and dates.
Ensure you are comparing the exact same date range, ticker symbol, and trading interval (daily, weekly, monthly) across both platforms before investigating data discrepancies.
Verify Market Data Parameters and Vendor Methodologies
Aligning your function parameters and understanding the differences in data source methodologies can explain and resolve volume discrepancies.
Different market-data providers consolidate exchanges differently, which is the primary cause of volume discrepancies. Some vendors include pre-market and after-hours trading, while others only count regular trading hours.
Verify that the ticker symbol includes the correct exchange prefix or suffix in your STOCKHISTORY formula (e.g., specifying the exact European exchange for EON.DE) to match the exact market Yahoo Finance is tracking.
Determine if Yahoo Finance is including extended hours trading volume. Excel's data provider may only report standard market hours volume, naturally resulting in a lower daily total.
Check if the volume represents a single primary exchange or a consolidated tape of all exchanges where the stock trades. Vendors often differ in how they aggregate volume across multiple routing networks.
Analyze Financial Data Seamlessly with WPS Office
While external market data discrepancies depend on the specific data vendor, you can rely on WPS Spreadsheet for robust financial modeling, data analysis, and seamless compatibility with Microsoft Excel formats. Enjoy a lightweight, free alternative for all your everyday financial tasks.
- 1. Download and Install: Download WPS Office from the official website and install it on your computer.
- 2. Open Your Financial Data: Launch WPS Spreadsheet and open your existing .xlsx workbook or import a CSV file downloaded from Yahoo Finance.
- 3. Analyze and Visualize: Use built-in financial formulas, pivot tables, and charting tools to continue your market analysis seamlessly.
Frequently Asked Questions
What data provider does Excel use for the STOCKHISTORY function?
Microsoft Excel typically partners with Refinitiv (formerly Refinitiv, now an LSEG business) to provide financial and market data for the STOCKHISTORY function and Data Types.
Can I change the data provider used in Excel's STOCKHISTORY?
No, the data provider is integrated natively into Microsoft Excel's backend and cannot be manually changed to Yahoo Finance or other third-party sources.
Does STOCKHISTORY include after-hours trading volume?
Excel's market data generally focuses on standard trading hours. This is a common reason why its reported volume might appear lower than platforms that consolidate extended trading sessions into the daily total.
How can I manually import Yahoo Finance data into my spreadsheet?
You can download historical data as a CSV file directly from the Yahoo Finance website. Once downloaded, open the CSV file in your spreadsheet software or use the Data import tools to integrate it into your existing workbook.
