Google Finance Financials

Google Finance Financials

Usage

Excel formula:

=RTD("gartle.rtd",,"GoogleFinanceFinancials",<Ticker>,<Report>,<Column>,<Row>)

Examples:

=RTD("gartle.rtd",,"GoogleFinanceFinancials","GOOGL","IncomeStatement",1,"Revenue")
=RTD("gartle.rtd",,"GoogleFinanceFinancials","GOOGL","BalanceSheet",1,"Goodwill, Net")
=RTD("gartle.rtd",,"GoogleFinanceFinancials","GOOGL","CashFlow",1,"Cash from Operating Activities")

Available reports:

  • IncomeStatement
  • IncomeStatementAnnual
  • BalanceSheet
  • BalanceSheetAnnual
  • CashFlow
  • CashFlowAnnual

See available rows and columns at Google Finance Financials web pages:

https://www.google.com/finance?q=AAPL&fstype=ii

You may copy row names from Google Finance web pages directly.

Also, you may copy ready-to-use formulas from the tables below.
See Copying formulas about inserting formulas into Excel spreadsheets.

Also, see ready-to-use workbook templates in the downloaded package.

Income Statement Quarterly Data

Excel ColumnExcel Formula
SymbolAAPL
Column1
Period Ending=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Period Ending")
In Millions of USD (except for per share items)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"In Millions of USD (except for per share items)")
Revenue=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Revenue")
Other Revenue, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Other Revenue, Total")
Total Revenue=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Total Revenue")
Cost of Revenue, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Cost of Revenue, Total")
Gross Profit=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Gross Profit")
Selling/General/Admin. Expenses, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Selling/General/Admin. Expenses, Total")
Research & Development=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Research & Development")
Depreciation/Amortization=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Depreciation/Amortization")
Interest Expense(Income) - Net Operating=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Interest Expense(Income) - Net Operating")
Unusual Expense (Income)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Unusual Expense (Income)")
Other Operating Expenses, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Other Operating Expenses, Total")
Total Operating Expense=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Total Operating Expense")
Operating Income=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Operating Income")
Interest Income(Expense), Net Non-Operating=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Interest Income(Expense), Net Non-Operating")
Gain (Loss) on Sale of Assets=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Gain (Loss) on Sale of Assets")
Other, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Other, Net")
Income Before Tax=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Income Before Tax")
Income After Tax=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Income After Tax")
Minority Interest=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Minority Interest")
Equity In Affiliates=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Equity In Affiliates")
Net Income Before Extra. Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Net Income Before Extra. Items")
Accounting Change=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Accounting Change")
Discontinued Operations=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Discontinued Operations")
Extraordinary Item=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Extraordinary Item")
Net Income=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Net Income")
Preferred Dividends=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Preferred Dividends")
Income Available to Common Excl. Extra Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Income Available to Common Excl. Extra Items")
Income Available to Common Incl. Extra Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Income Available to Common Incl. Extra Items")
Basic Weighted Average Shares=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Basic Weighted Average Shares")
Basic EPS Excluding Extraordinary Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Basic EPS Excluding Extraordinary Items")
Basic EPS Including Extraordinary Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Basic EPS Including Extraordinary Items")
Dilution Adjustment=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Dilution Adjustment")
Diluted Weighted Average Shares=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Diluted Weighted Average Shares")
Diluted EPS Excluding Extraordinary Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Diluted EPS Excluding Extraordinary Items")
Diluted EPS Including Extraordinary Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Diluted EPS Including Extraordinary Items")
Dividends per Share - Common Stock Primary Issue=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Dividends per Share - Common Stock Primary Issue")
Gross Dividends - Common Stock=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Gross Dividends - Common Stock")
Net Income after Stock Based Comp. Expense=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Net Income after Stock Based Comp. Expense")
Basic EPS after Stock Based Comp. Expense=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Basic EPS after Stock Based Comp. Expense")
Diluted EPS after Stock Based Comp. Expense=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Diluted EPS after Stock Based Comp. Expense")
Depreciation, Supplemental=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Depreciation, Supplemental")
Total Special Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Total Special Items")
Normalized Income Before Taxes=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Normalized Income Before Taxes")
Effect of Special Items on Income Taxes=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Effect of Special Items on Income Taxes")
Income Taxes Ex. Impact of Special Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Income Taxes Ex. Impact of Special Items")
Normalized Income After Taxes=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Normalized Income After Taxes")
Normalized Income Avail to Common=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Normalized Income Avail to Common")
Basic Normalized EPS=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Basic Normalized EPS")
Diluted Normalized EPS=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"Diluted Normalized EPS")
rtd_LastError=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatement",[Column],"rtd_LastUpdateTime")

Income Statement Annual Data

Excel ColumnExcel Formula
SymbolAAPL
Column1
Period Ending=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Period Ending")
In Millions of USD (except for per share items)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"In Millions of USD (except for per share items)")
Revenue=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Revenue")
Other Revenue, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Other Revenue, Total")
Total Revenue=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Total Revenue")
Cost of Revenue, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Cost of Revenue, Total")
Gross Profit=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Gross Profit")
Selling/General/Admin. Expenses, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Selling/General/Admin. Expenses, Total")
Research & Development=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Research & Development")
Depreciation/Amortization=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Depreciation/Amortization")
Interest Expense(Income) - Net Operating=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Interest Expense(Income) - Net Operating")
Unusual Expense (Income)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Unusual Expense (Income)")
Other Operating Expenses, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Other Operating Expenses, Total")
Total Operating Expense=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Total Operating Expense")
Operating Income=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Operating Income")
Interest Income(Expense), Net Non-Operating=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Interest Income(Expense), Net Non-Operating")
Gain (Loss) on Sale of Assets=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Gain (Loss) on Sale of Assets")
Other, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Other, Net")
Income Before Tax=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Income Before Tax")
Income After Tax=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Income After Tax")
Minority Interest=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Minority Interest")
Equity In Affiliates=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Equity In Affiliates")
Net Income Before Extra. Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Net Income Before Extra. Items")
Accounting Change=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Accounting Change")
Discontinued Operations=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Discontinued Operations")
Extraordinary Item=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Extraordinary Item")
Net Income=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Net Income")
Preferred Dividends=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Preferred Dividends")
Income Available to Common Excl. Extra Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Income Available to Common Excl. Extra Items")
Income Available to Common Incl. Extra Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Income Available to Common Incl. Extra Items")
Basic Weighted Average Shares=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Basic Weighted Average Shares")
Basic EPS Excluding Extraordinary Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Basic EPS Excluding Extraordinary Items")
Basic EPS Including Extraordinary Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Basic EPS Including Extraordinary Items")
Dilution Adjustment=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Dilution Adjustment")
Diluted Weighted Average Shares=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Diluted Weighted Average Shares")
Diluted EPS Excluding Extraordinary Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Diluted EPS Excluding Extraordinary Items")
Diluted EPS Including Extraordinary Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Diluted EPS Including Extraordinary Items")
Dividends per Share - Common Stock Primary Issue=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Dividends per Share - Common Stock Primary Issue")
Gross Dividends - Common Stock=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Gross Dividends - Common Stock")
Net Income after Stock Based Comp. Expense=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Net Income after Stock Based Comp. Expense")
Basic EPS after Stock Based Comp. Expense=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Basic EPS after Stock Based Comp. Expense")
Diluted EPS after Stock Based Comp. Expense=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Diluted EPS after Stock Based Comp. Expense")
Depreciation, Supplemental=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Depreciation, Supplemental")
Total Special Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Total Special Items")
Normalized Income Before Taxes=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Normalized Income Before Taxes")
Effect of Special Items on Income Taxes=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Effect of Special Items on Income Taxes")
Income Taxes Ex. Impact of Special Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Income Taxes Ex. Impact of Special Items")
Normalized Income After Taxes=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Normalized Income After Taxes")
Normalized Income Avail to Common=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Normalized Income Avail to Common")
Basic Normalized EPS=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Basic Normalized EPS")
Diluted Normalized EPS=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"Diluted Normalized EPS")
rtd_LastError=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"IncomeStatementAnnual",[Column],"rtd_LastUpdateTime")

Balance Sheet Quarterly Data

Excel ColumnExcel Formula
SymbolAAPL
Column1
Period Ending=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Period Ending")
In Millions of USD (except for per share items)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"In Millions of USD (except for per share items)")
Cash & Equivalents=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Cash & Equivalents")
Short Term Investments=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Short Term Investments")
Cash and Short Term Investments=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Cash and Short Term Investments")
Accounts Receivable - Trade, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Accounts Receivable - Trade, Net")
Receivables - Other=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Receivables - Other")
Total Receivables, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Receivables, Net")
Total Inventory=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Inventory")
Prepaid Expenses=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Prepaid Expenses")
Other Current Assets, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Other Current Assets, Total")
Total Current Assets=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Current Assets")
Property/Plant/Equipment, Total - Gross=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Property/Plant/Equipment, Total - Gross")
Accumulated Depreciation, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Accumulated Depreciation, Total")
Goodwill, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Goodwill, Net")
Intangibles, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Intangibles, Net")
Long Term Investments=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Long Term Investments")
Other Long Term Assets, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Other Long Term Assets, Total")
Total Assets=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Assets")
Accounts Payable=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Accounts Payable")
Accrued Expenses=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Accrued Expenses")
Notes Payable/Short Term Debt=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Notes Payable/Short Term Debt")
Current Port. of LT Debt/Capital Leases=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Current Port. of LT Debt/Capital Leases")
Other Current liabilities, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Other Current liabilities, Total")
Total Current Liabilities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Current Liabilities")
Long Term Debt=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Long Term Debt")
Capital Lease Obligations=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Capital Lease Obligations")
Total Long Term Debt=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Long Term Debt")
Total Debt=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Debt")
Deferred Income Tax=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Deferred Income Tax")
Minority Interest=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Minority Interest")
Other Liabilities, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Other Liabilities, Total")
Total Liabilities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Liabilities")
Redeemable Preferred Stock, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Redeemable Preferred Stock, Total")
Preferred Stock - Non Redeemable, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Preferred Stock - Non Redeemable, Net")
Common Stock, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Common Stock, Total")
Additional Paid-In Capital=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Additional Paid-In Capital")
Retained Earnings (Accumulated Deficit)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Retained Earnings (Accumulated Deficit)")
Treasury Stock - Common=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Treasury Stock - Common")
Other Equity, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Other Equity, Total")
Total Equity=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Equity")
Total Liabilities & Shareholders' Equity=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Liabilities & Shareholders' Equity")
Shares Outs - Common Stock Primary Issue=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Shares Outs - Common Stock Primary Issue")
Total Common Shares Outstanding=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"Total Common Shares Outstanding")
rtd_LastError=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheet",[Column],"rtd_LastUpdateTime")

Balance Sheet Annual Data

Excel ColumnExcel Formula
SymbolAAPL
Column1
Period Ending=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Period Ending")
In Millions of USD (except for per share items)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"In Millions of USD (except for per share items)")
Cash & Equivalents=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Cash & Equivalents")
Short Term Investments=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Short Term Investments")
Cash and Short Term Investments=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Cash and Short Term Investments")
Accounts Receivable - Trade, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Accounts Receivable - Trade, Net")
Receivables - Other=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Receivables - Other")
Total Receivables, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Receivables, Net")
Total Inventory=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Inventory")
Prepaid Expenses=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Prepaid Expenses")
Other Current Assets, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Other Current Assets, Total")
Total Current Assets=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Current Assets")
Property/Plant/Equipment, Total - Gross=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Property/Plant/Equipment, Total - Gross")
Accumulated Depreciation, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Accumulated Depreciation, Total")
Goodwill, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Goodwill, Net")
Intangibles, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Intangibles, Net")
Long Term Investments=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Long Term Investments")
Other Long Term Assets, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Other Long Term Assets, Total")
Total Assets=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Assets")
Accounts Payable=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Accounts Payable")
Accrued Expenses=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Accrued Expenses")
Notes Payable/Short Term Debt=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Notes Payable/Short Term Debt")
Current Port. of LT Debt/Capital Leases=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Current Port. of LT Debt/Capital Leases")
Other Current liabilities, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Other Current liabilities, Total")
Total Current Liabilities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Current Liabilities")
Long Term Debt=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Long Term Debt")
Capital Lease Obligations=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Capital Lease Obligations")
Total Long Term Debt=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Long Term Debt")
Total Debt=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Debt")
Deferred Income Tax=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Deferred Income Tax")
Minority Interest=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Minority Interest")
Other Liabilities, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Other Liabilities, Total")
Total Liabilities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Liabilities")
Redeemable Preferred Stock, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Redeemable Preferred Stock, Total")
Preferred Stock - Non Redeemable, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Preferred Stock - Non Redeemable, Net")
Common Stock, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Common Stock, Total")
Additional Paid-In Capital=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Additional Paid-In Capital")
Retained Earnings (Accumulated Deficit)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Retained Earnings (Accumulated Deficit)")
Treasury Stock - Common=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Treasury Stock - Common")
Other Equity, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Other Equity, Total")
Total Equity=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Equity")
Total Liabilities & Shareholders' Equity=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Liabilities & Shareholders' Equity")
Shares Outs - Common Stock Primary Issue=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Shares Outs - Common Stock Primary Issue")
Total Common Shares Outstanding=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"Total Common Shares Outstanding")
rtd_LastError=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"BalanceSheetAnnual",[Column],"rtd_LastUpdateTime")

Cash Flow Quarterly Data

Excel ColumnExcel Formula
SymbolAAPL
Column1
Period Ending=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Period Ending")
In Millions of USD (except for per share items)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"In Millions of USD (except for per share items)")
Net Income/Starting Line=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Net Income/Starting Line")
Depreciation/Depletion=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Depreciation/Depletion")
Amortization=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Amortization")
Deferred Taxes=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Deferred Taxes")
Non-Cash Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Non-Cash Items")
Changes in Working Capital=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Changes in Working Capital")
Cash from Operating Activities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Cash from Operating Activities")
Capital Expenditures=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Capital Expenditures")
Other Investing Cash Flow Items, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Other Investing Cash Flow Items, Total")
Cash from Investing Activities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Cash from Investing Activities")
Financing Cash Flow Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Financing Cash Flow Items")
Total Cash Dividends Paid=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Total Cash Dividends Paid")
Issuance (Retirement) of Stock, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Issuance (Retirement) of Stock, Net")
Issuance (Retirement) of Debt, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Issuance (Retirement) of Debt, Net")
Cash from Financing Activities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Cash from Financing Activities")
Foreign Exchange Effects=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Foreign Exchange Effects")
Net Change in Cash=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Net Change in Cash")
Cash Interest Paid, Supplemental=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Cash Interest Paid, Supplemental")
Cash Taxes Paid, Supplemental=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"Cash Taxes Paid, Supplemental")
rtd_LastError=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlow",[Column],"rtd_LastUpdateTime")

Cash Flow Annual Data

Excel ColumnExcel Formula
SymbolAAPL
Column1
Period Ending=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Period Ending")
In Millions of USD (except for per share items)=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"In Millions of USD (except for per share items)")
Net Income/Starting Line=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Net Income/Starting Line")
Depreciation/Depletion=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Depreciation/Depletion")
Amortization=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Amortization")
Deferred Taxes=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Deferred Taxes")
Non-Cash Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Non-Cash Items")
Changes in Working Capital=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Changes in Working Capital")
Cash from Operating Activities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Cash from Operating Activities")
Capital Expenditures=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Capital Expenditures")
Other Investing Cash Flow Items, Total=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Other Investing Cash Flow Items, Total")
Cash from Investing Activities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Cash from Investing Activities")
Financing Cash Flow Items=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Financing Cash Flow Items")
Total Cash Dividends Paid=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Total Cash Dividends Paid")
Issuance (Retirement) of Stock, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Issuance (Retirement) of Stock, Net")
Issuance (Retirement) of Debt, Net=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Issuance (Retirement) of Debt, Net")
Cash from Financing Activities=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Cash from Financing Activities")
Foreign Exchange Effects=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Foreign Exchange Effects")
Net Change in Cash=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Net Change in Cash")
Cash Interest Paid, Supplemental=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Cash Interest Paid, Supplemental")
Cash Taxes Paid, Supplemental=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"Cash Taxes Paid, Supplemental")
rtd_LastError=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"GoogleFinanceFinancials",[Symbol],"CashFlowAnnual",[Column],"rtd_LastUpdateTime")

Synonyms

Google Finance and Yahoo! Finance have different sets of indicators and different names for the same indicators.

The Google Finance Financials provider adds synonym rows to be compatible with Yahoo! Finances on major indicators.

Google Finance RowYahoo Finance Row
Cost of Revenue, TotalCost of Revenue
Research & DevelopmentResearch Development
Total Operating ExpenseTotal Operating Expenses
Operating IncomeOperating Income or Loss
Net Income Before Extra. ItemsNet Income From Continuing Ops
Total EquityTotal Stockholder Equity
Net Income/Starting LineNet Income
Depreciation/DepletionDepreciation
Cash from Operating ActivitiesTotal Cash Flow From Operating Activities
Cash from Investing ActivitiesTotal Cash Flows From Investing Activities
Cash from Financing ActivitiesTotal Cash Flows From Financing Activities
Net Change in CashChange In Cash and Cash Equivalents

Data Provider Settings

The data provider is configured to loading data every 12 hours when the Excel workbook is open.

See Data provider settings.

ParameterValue
RefreshInterval12:00:00, 12 hours
NextRequestDelay1000, one second
DataStartTime00:00:00 -05:00
DataEndTime24:00:00 -05:00
LoadEndTime24:00:00 -05:00
LoadOnSaturday1, loading Friday's data once.
LoadOnSunday1, loading Friday's data once.

Data Source

The provider parses Google Finance Financials web pages.
All reports are loaded as a single page.