Getting Started

• Introduction
• Download
• Installation & Activation
• Troubleshooting
• Data Refresh/Updates
• Software Updates
• Manage Your Subscription
• Example Spreadsheets

General Formulas

• Black-Scholes Option Pricing
• Instrument Identifier Conversions
• Miscellaneous

Technical Analysis Toolkit

• Introduction
• Simple Moving Average (SMA)
• Exponential Moving Average (EMA)
• Volume Weighted Average Price (VWAP)
• Average True Range (ATR)
• Bollinger Bands
• Aroon

Federal Reserve Economic Data
(FRED)

• Overview
• Formula Reference

Yahoo Finance

• Formula Reference
• • All Formulas
  • Stocks
  • Stocks: Income Statement
  • Stocks: Balance Sheet
  • Stocks: Cash Flow
  • Stocks: Analysis
  • Stocks: ESG Risk Ratings
  • Options Chain
  • Stock Options
  • Mutual Funds
  • ETFs
  • FX Rates
  • Cryptocurrencies
  • Commodities
  • Historical Market Data
  • News
• Historical Array Formulas
• Historical Data Download
• VBA Functions Reference

IG Index / IG Markets

• Account Setup
• Formula Reference
• VBA Functions Reference
• Historical Price Data Download To Excel
• Historical Price Data Download To File
• Historical Client Sentiment Data Download
• Watchlists
• Live Positions, Transactions & Activity History

EODHistoricalData.com

• Overview & Setup
• Historical Price Data
• Stocks Fundamental Data
• Stocks Financial Analysis

Nasdaq Data Link

• Overview & Setup
• Formula Reference

Excel Formula Reference: Cash Flow

All these formulas require both a stock ticker and reporting year, for example: =EPF.Yahoo.AnnualEarnings("MSFT",2019)

Yahoo Finance generally provides the past 4 years of reported data.

Click on a category below to view the formulas:

• Cash Flows from Operating Activities
• Cash Flows from Investing Activities
• Cash Flows from Financing Activities
• Other Cash Flows

Cash Flows from Operating Activities

Formula	Description
EPF.Yahoo.AnnualTotalCashflowsFromOperatingActivities	Total Cashflows from operating activities.
EPF.Yahoo.AnnualEarnings	Net Income / Earnings.
EPF.Yahoo.AnnualDepreciationAndAmortization	Depreciation & Amortization.
EPF.Yahoo.AnnualDeferredIncomeTax	Deferred Income Tax.
EPF.Yahoo.AnnualStockBasedCompensation	Stock based compensation.
EPF.Yahoo.AnnualOtherNonCashItems	Other non cash items.
EPF.Yahoo.AnnualChangeInWorkingCapital	Change in working capital.
EPF.Yahoo.AnnualAccountsReceivableChange	Change in Accounts Receivable.
EPF.Yahoo.AnnualInventoryChange	Change in Inventory.
EPF.Yahoo.AnnualAccountsPayableChange	Change in Accounts Payable.

Cash Flows from Investing Activities

Formula	Description
EPF.Yahoo.AnnualTotalCashflowsFromInvestingActivities	Total Cashflows from investing activities.
EPF.Yahoo.AnnualCapitalExpenditures	Investments in property, plant and equipment / Capital Expenditures.
EPF.Yahoo.AnnualAcquisitions	Acquisitions / purchases of businesses.
EPF.Yahoo.AnnualPurchasesOfInvestments	Purchases of investments.
EPF.Yahoo.AnnualSalesOfInvestments	Sales / maturities of investments.
EPF.Yahoo.AnnualOtherCashflowsFromInvestingActivities	Other Cashflows from investing activities.

Cash Flows from Financing Activities

Formula	Description
EPF.Yahoo.AnnualTotalCashflowsFromFinancingActivities	Total Cashflows from financing activities.
EPF.Yahoo.AnnualDebtRepayment	Debt repayment.
EPF.Yahoo.AnnualCommonStockIssued	Common stock issued.
EPF.Yahoo.AnnualCommonStockRepurchased	Common stock repurchased.
EPF.Yahoo.AnnualDividendsPaid	Total dividends paid.
EPF.Yahoo.AnnualOtherFinancingActivities	Other financing activities.

Other Cash Flow Data

Formula	Description
EPF.Yahoo.AnnualChangeInCash	Annual change in cash.
EPF.Yahoo.AnnualBeginningCashPosition	Annual beginning cash position.
EPF.Yahoo.AnnualEndCashPosition	Annual end cash position.
EPF.Yahoo.AnnualCapitalExpenditures	Investments in property, plant and equipment / Capital Expenditures.
EPF.Yahoo.AnnualFreeCashFlow	Free cash flow / other working capital.