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

andysinclair

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: Additional Free Cash flow formulas

We recently added two new formulas to the Add-in for retrieving Free Cash flow figures:

  • EPF.Yahoo.TTMFreeCashFlow: takes as input a stock ticker
  • EPF.Yahoo.QuarterlyFreeCashFlow: takes as input a stock ticker and quarter

We already had formulas for Annual Free Cash flow available.

Here is an example of the new formulas used in a sheet. This dataset is for Exxon Mobil stock.

And here are the formulas we used:

=EPF.Yahoo.TTMFreeCashFlow("XOM")/1000
=EPF.Yahoo.AnnualFreeCashFlow("XOM",2024)/1000
=EPF.Yahoo.QuarterlyFreeCashFlow("XOM",0)/1000

For more details please see the Excel Formula Reference: Cash Flow section in the User Guide.

Yahoo Finance: Additional TTM formulas

We also added some additional formulas for retrieving Trailing 12 Months figures, which all take as inputs a stock ticker:

  • EPF.Yahoo.TTMBasicEPS
  • EPF.Yahoo.TTMDilutedEPS
  • EPF.Yahoo.TTMBasicAverageShares
  • EPF.Yahoo.TTMDilutedAverageShares

Here is an example of these formulas in action:

This dataset is for Exxon Mobil stock.

And here are the new formulas we used:

=EPF.Yahoo.TTMBasicEPS("XOM")
=EPF.Yahoo.TTMDilutedEPS("XOM")
=EPF.Yahoo.TTMBasicAverageShares("XOM")/1000
=EPF.Yahoo.TTMDilutedAverageShares("XOM")/1000

For more details please see the Excel Formula Reference: Income Statement section in the User Guide.

Leave a comment