Function reference

Every formula in FINANCE for Yahoo, with syntax, parameters and the full list of attributes. Tip: Extensions → FINANCE for Yahoo → Formula Builder builds these formulas for you.

=FINANCE

Fetches real-time and fundamental data for a single ticker. Works like GOOGLEFINANCE, with many more attributes.

Syntax

FINANCE(ticker, [attributes], [show_header])

Examples

=FINANCE("AAPL")
=FINANCE(A1,"*.*")
=FINANCE("BTC-USD","price.*",FALSE)
=FINANCE("GLD","yield,beta")

Parameters

ParameterDescription
tickerThe ticker symbol, as used on Yahoo Finance (for example "AAPL", "BTC-USD", "EURUSD=X"), or a cell reference.
attributesoptionalOne attribute or a comma-separated list. "regularMarketPrice" by default. Use "*.*" for all attributes, or a group wildcard such as "summary.*".
show_headeroptionalShow or hide the header row. TRUE by default.

Attributes

price.*price and market state
  • symbol
  • longName
  • quoteType
  • quoteSourceName
  • marketState
  • currency
  • regularMarketTime
  • regularMarketPrice
  • regularMarketDayHigh
  • regularMarketDayLow
  • regularMarketVolume
  • regularMarketChange
  • regularMarketChangePercent
  • regularMarketOpen
  • regularMarketPreviousClose
  • preMarketTime
  • preMarketPrice
  • preMarketChange
  • preMarketChangePercent
  • postMarketTime
  • postMarketPrice
  • postMarketChange
  • postMarketChangePercent
summary.*dividends, ratios, volume, ranges
  • previousClose
  • open
  • dayLow
  • dayHigh
  • dividendRate
  • dividendYield
  • exDividendDate
  • payoutRatio
  • fiveYearAvgDividendYield
  • trailingPE
  • forwardPE
  • volume
  • averageVolume
  • averageVolume10days
  • averageDailyVolume10Day
  • bid
  • ask
  • bidSize
  • askSize
  • marketCap
  • fiftyTwoWeekLow
  • fiftyTwoWeekHigh
  • priceToSalesTrailing12Months
  • fiftyDayAverage
  • twoHundredDayAverage
  • trailingAnnualDividendRate
  • trailingAnnualDividendYield
  • navPrice
  • volume24Hr
  • volumeAllCurrencies
  • circulatingSupply
statistics.*shares, short interest, valuation
  • enterpriseValue
  • floatShares
  • sharesOutstanding
  • sharesShort
  • sharesShortPriorMonth
  • sharesPercentSharesOut
  • heldPercentInsiders
  • heldPercentInstitutions
  • shortRatio
  • shortPercentOfFloat
  • beta
  • bookValue
  • priceToBook
  • ytdReturn
  • totalAssets
  • yield
  • fiveYearAverageReturn
  • lastFiscalYearEnd
  • nextFiscalYearEnd
  • mostRecentQuarter
  • earningsQuarterlyGrowth
  • netIncomeToCommon
  • trailingEps
  • forwardEps
  • pegRatio
  • lastSplitFactor
  • lastSplitDate
  • enterpriseToRevenue
  • enterpriseToEbitda
  • 52WeekChange
  • lastDividendValue
  • lastDividendDate
financial.*analyst targets, margins, cash
  • currentPrice
  • targetHighPrice
  • targetLowPrice
  • targetMeanPrice
  • targetMedianPrice
  • recommendationMean
  • recommendationKey
  • numberOfAnalystOpinions
  • totalCash
  • totalCashPerShare
  • ebitda
  • totalDebt
  • quickRatio
  • currentRatio
  • totalRevenue
  • debtToEquity
  • revenuePerShare
  • returnOnAssets
  • returnOnEquity
  • grossProfits
  • freeCashflow
  • operatingCashflow
  • earningsGrowth
  • revenueGrowth
  • grossMargins
  • ebitdaMargins
  • operatingMargins
  • profitMargins
esg.*environment, social and governance
  • totalEsg
  • environmentScore
  • socialScore
  • governanceScore
  • esgPerformance
profile.*company profile
  • industry
  • sector
  • fullTimeEmployees

=FINANCE_QUOTES

Fetches quotes for many tickers in one call, one row per ticker. Use it instead of many FINANCE cells to keep large sheets fast.

Syntax

FINANCE_QUOTES(tickers, [attributes], [show_header])

Examples

=FINANCE_QUOTES("AAPL,BTC-USD,EURUSD=X")
=FINANCE_QUOTES(A1:A3,"*.*")
=FINANCE_QUOTES("GLD","marketCap,sharesOutstanding",FALSE)

Parameters

ParameterDescription
tickersComma-separated ticker symbols or a cell range. Up to 50 tickers.
attributesoptionalOne attribute or a comma-separated list. "regularMarketPrice" by default. Use "*.*" for all attributes.
show_headeroptionalShow or hide the header row. TRUE by default.

Attributes

*.*all quote attributes
  • symbol
  • longName
  • quoteType
  • quoteSourceName
  • marketState
  • currency
  • regularMarketTime
  • regularMarketPrice
  • regularMarketDayHigh
  • regularMarketDayLow
  • regularMarketVolume
  • regularMarketChange
  • regularMarketChangePercent
  • regularMarketOpen
  • regularMarketPreviousClose
  • preMarketTime
  • preMarketPrice
  • preMarketChange
  • preMarketChangePercent
  • postMarketTime
  • postMarketPrice
  • postMarketChange
  • postMarketChangePercent
  • bid
  • ask
  • bidSize
  • askSize
  • marketCap
  • sharesOutstanding
  • averageAnalystRating
  • fiftyTwoWeekRange
  • fiftyTwoWeekLow
  • fiftyTwoWeekLowChange
  • fiftyTwoWeekLowChangePercent
  • fiftyTwoWeekHigh
  • fiftyTwoWeekHighChange
  • fiftyTwoWeekHighChangePercent
  • fiftyDayAverage
  • fiftyDayAverageChange
  • fiftyDayAverageChangePercent
  • twoHundredDayAverage
  • twoHundredDayAverageChange
  • twoHundredDayAverageChangePercent
  • averageDailyVolume3Month
  • averageDailyVolume10Day
  • dividendDate
  • trailingAnnualDividendRate
  • trailingAnnualDividendYield

=FINANCE_HISTORY

Returns dates and closing prices for a ticker over a relative range, at the interval you choose.

Syntax

FINANCE_HISTORY(ticker, [interval], [range])

Examples

=FINANCE_HISTORY("AAPL")
=FINANCE_HISTORY(A1,"1d")
=FINANCE_HISTORY("GLD","1d","3mo")

Parameters

ParameterDescription
tickerThe ticker symbol, as used on Yahoo Finance (for example "AAPL", "BTC-USD", "EURUSD=X"), or a cell reference.
intervaloptionalBar size. "1d" by default. One of "1m", "2m", "5m", "15m", "30m", "60m", "90m", "1h", "1d", "5d", "1wk", "1mo", "3mo".
rangeoptionalHow far back to go. "3mo" by default. One of "1d", "5d", "7d", "60d", "1mo", "3mo", "6mo", "1y", "2y", "5y", "10y", "ytd", "max".

Yahoo Finance limits intraday history: minute intervals are only available for recent ranges (for example "1m" for the last 7 days).

=FINANCE_STATEMENTS

Returns income statement, balance sheet and cash flow data, yearly or quarterly.

Syntax

FINANCE_STATEMENTS(ticker, [attributes], [interval], [show_header])

Examples

=FINANCE_STATEMENTS("AAPL")
=FINANCE_STATEMENTS(A1,"*.*")
=FINANCE_STATEMENTS("MSFT","cashflow.*","YEARLY",FALSE)
=FINANCE_STATEMENTS("T","cash,ebit","QUARTERLY",TRUE)

Parameters

ParameterDescription
tickerThe ticker symbol, as used on Yahoo Finance (for example "AAPL", "BTC-USD", "EURUSD=X"), or a cell reference.
attributesoptionalOne attribute or a comma-separated list. "*.*" (all statements) by default. Use "income.*", "balance.*" or "cashflow.*" for one statement.
intervaloptional"YEARLY" (default) or "QUARTERLY".
show_headeroptionalShow or hide the header row. TRUE by default.

Attributes

income.*income statement
  • totalRevenue
  • costOfRevenue
  • grossProfit
  • researchDevelopment
  • sellingGeneralAdministrative
  • totalOperatingExpenses
  • operatingIncome
  • totalOtherIncomeExpenseNet
  • ebit
  • interestExpense
  • incomeBeforeTax
  • incomeTaxExpense
  • netIncomeFromContinuingOps
  • netIncome
  • netIncomeApplicableToCommonShares
balance.*balance sheet
  • cash
  • shortTermInvestments
  • longTermInvestments
  • netReceivables
  • inventory
  • otherCurrentAssets
  • totalCurrentAssets
  • propertyPlantEquipment
  • otherAssets
  • totalAssets
  • accountsPayable
  • shortLongTermDebt
  • longTermDebt
  • otherCurrentLiab
  • otherLiab
  • totalCurrentLiabilities
  • totalLiab
  • commonStock
  • retainedEarnings
  • treasuryStock
  • otherStockholderEquity
  • totalStockholderEquity
  • netTangibleAssets
cashflow.*cash flow statement
  • netIncome
  • depreciation
  • changeToNetincome
  • changeToAccountReceivables
  • changeToLiabilities
  • changeToInventory
  • changeToOperatingActivities
  • totalCashFromOperatingActivities
  • capitalExpenditures
  • investments
  • otherCashflowsFromInvestingActivities
  • totalCashflowsFromInvestingActivities
  • dividendsPaid
  • netBorrowings
  • otherCashflowsFromFinancingActivities
  • totalCashFromFinancingActivities
  • changeInCash
  • repurchaseOfStock
  • issuanceOfStock

=FINANCE_OPTIONS

Returns the option chain (calls and puts) for a ticker, with strike, last price, bid, ask, volume, open interest and implied volatility.

Syntax

FINANCE_OPTIONS(ticker, [date], [show_exp_dates])

Examples

=FINANCE_OPTIONS("AAPL")
=FINANCE_OPTIONS("AMZN", A1)

Parameters

ParameterDescription
tickerThe ticker symbol, as used on Yahoo Finance (for example "AAPL", "BTC-USD", "EURUSD=X"), or a cell reference.
dateoptionalThe expiration date. The nearest expiration is used by default.
show_exp_datesoptionalShow or hide the row listing all available expiration dates. TRUE by default.