Today we released a new version of Excel Price Feed. To update your Add-in, please follow the instructions in the User Guide.
This release includes the following changes:
Yahoo Finance: EPF.Yahoo.HistoricDatePeriod formula
We’ve made several improvements to this formula.
We have fixed an issue which affected certain stock/date combinations which returned additional data points outside the requested date range.
We have also added an additional optional parameter includePrePost which if set will include pre and post market data in the returned time series (for periods less than daily).
We have also made 3 of the parameters optional so you just need to specify a ticker, period and start/end date.
For example, this formula will return hourly data for Apple from 1 to 4 October; it will return headers, date in descending date order and not include pre or post market data:
=EPF.Yahoo.HistoricDatePeriod("APPL","Hourly","2025-10-01","2025-10-04")The other parameters: order, includeHeaders and includePrePost are optional.
For more details please see the Excel Formula Reference: Historical Array Formulas section in the User Guide.
Yahoo Finance: fix EPF.Yahoo.PEGRatio formula
This formula has been fixed:
The Excel Price Feed Blog 