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/quote/AAPL:NASDAQ?fstype=ii
You can copy row names from Google Finance web pages directly.
Also, you can 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 Column | Excel Formula |
|---|---|
| Symbol | AAPL |
| Column | 1 |
| 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 Column | Excel Formula |
|---|---|
| Symbol | AAPL |
| Column | 1 |
| 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 Column | Excel Formula |
|---|---|
| Symbol | AAPL |
| Column | 1 |
| 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 Column | Excel Formula |
|---|---|
| Symbol | AAPL |
| Column | 1 |
| 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 Column | Excel Formula |
|---|---|
| Symbol | AAPL |
| Column | 1 |
| 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 Column | Excel Formula |
|---|---|
| Symbol | AAPL |
| Column | 1 |
| 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 Row | Yahoo Finance Row |
|---|---|
| Cost of Revenue, Total | Cost of Revenue |
| Research & Development | Research Development |
| Total Operating Expense | Total Operating Expenses |
| Operating Income | Operating Income or Loss |
| Net Income Before Extra. Items | Net Income From Continuing Ops |
| Total Equity | Total Stockholder Equity |
| Net Income/Starting Line | Net Income |
| Depreciation/Depletion | Depreciation |
| Cash from Operating Activities | Total Cash Flow From Operating Activities |
| Cash from Investing Activities | Total Cash Flows From Investing Activities |
| Cash from Financing Activities | Total Cash Flows From Financing Activities |
| Net Change in Cash | Change 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.
| Parameter | Value |
|---|---|
| RefreshInterval | 12:00:00, 12 hours |
| NextRequestDelay | 1000, one second |
| DataStartTime | 00:00:00 -05:00 |
| DataEndTime | 24:00:00 -05:00 |
| LoadEndTime | 24:00:00 -05:00 |
| LoadOnSaturday | 1, loading Friday's data once. |
| LoadOnSunday | 1, loading Friday's data once. |
Data Source
The provider parses Google Finance Financials web pages.
All reports are loaded as a single page.