Excel Price Feed Add-in Release (v1.127)

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:

Earnings Estimates: New formulas

We have added the following new formulas:

For example, this formula retrieves the number of analysts providing “next quarter” earnings estimates for Apple stock:

=EPF.Yahoo.Earnings.Estimate.NoAnalysts.Quarter("AAPL",0)

For more details please see the Excel Price Feed User Guide.

We have added an “Order” by option on the Yahoo Finance historical data download screen:

We have added 3 new lookback formulas for historical data, and all 3 include a pre-post market option:

For example, to retrieve 200 x 1 minute periods including pre-post market data, you can now use this formula:

=EPF.Yahoo.Historic1MinuteLookback("AAPL",200,"DESC",1,1)

For more details please see the Excel Price Feed User Guide.

Task Pane: fixed text colour.