Skip to content

Financials

Individual

balance_sheet

  • Description: Retrieves balance sheet data for most recent four quarters or most recent four years as well as trailing 12 months.
  • Return: pandas.DataFrame
  • Arguments
Argument Description Type Default Required Options
frequency Display either quarterly or annual data str a optional Annual - a
Quarter - q
trailing Include or exclude trailing twelve month (TTM) data bool True optional True
False
aapl = Ticker('aapl')
aapl.balance_sheet()
symbol asOfDate periodType AccountsPayable AccountsReceivable AccumulatedDepreciation AllowanceForDoubtfulAccountsReceivable AvailableForSaleSecurities CapitalStock CashAndCashEquivalents CashCashEquivalentsAndShortTermInvestments CashEquivalents CashFinancial CommercialPaper CommonStock CommonStockEquity CurrentAccruedExpenses CurrentAssets CurrentDebt CurrentDebtAndCapitalLeaseObligation CurrentDeferredLiabilities CurrentDeferredRevenue CurrentLiabilities GainsLossesNotAffectingRetainedEarnings Goodwill GoodwillAndOtherIntangibleAssets GrossAccountsReceivable GrossPPE Inventory InvestedCapital InvestmentinFinancialAssets InvestmentsAndAdvances LandAndImprovements Leases LongTermDebt LongTermDebtAndCapitalLeaseObligation MachineryFurnitureEquipment NetDebt NetPPE NetTangibleAssets NonCurrentDeferredLiabilities NonCurrentDeferredRevenue NonCurrentDeferredTaxesLiabilities OrdinarySharesNumber OtherCurrentAssets OtherCurrentBorrowings OtherCurrentLiabilities OtherIntangibleAssets OtherNonCurrentAssets OtherNonCurrentLiabilities OtherReceivables OtherShortTermInvestments Payables PayablesAndAccruedExpenses Properties Receivables RetainedEarnings ShareIssued StockholdersEquity TangibleBookValue TotalAssets TotalCapitalization TotalDebt TotalEquityGrossMinorityInterest TotalLiabilitiesNetMinorityInterest TotalNonCurrentAssets TotalNonCurrentLiabilitiesNetMinorityInterest TradeandOtherPayablesNonCurrent WorkingCapital
aapl 2016-09-30 00:00:00 12M 3.7294e+10 1.5754e+10 -3.4235e+10 -5.3e+07 1.7043e+11 3.1251e+10 2.0484e+10 6.7155e+10 1.1883e+10 8.601e+09 8.105e+09 3.1251e+10 1.28249e+11 2.2027e+10 1.06869e+11 1.1605e+10 1.1605e+10 8.08e+09 8.08e+09 7.9006e+10 6.34e+08 5.414e+09 8.62e+09 1.5807e+10 6.1245e+10 2.132e+09 2.15281e+11 1.7043e+11 1.7043e+11 1.0185e+10 6.517e+09 7.5427e+10 7.5427e+10 4.4543e+10 6.6548e+10 2.701e+10 1.19629e+11 2.8949e+10 2.93e+09 2.6019e+10 5.33617e+09 8.283e+09 3.5e+09 nan 3.206e+09 8.757e+09 1.0055e+10 1.3545e+10 4.6671e+10 3.7294e+10 5.9321e+10 0 2.9299e+10 9.6364e+10 5.33617e+09 1.28249e+11 1.19629e+11 3.21686e+11 2.03676e+11 8.7032e+10 1.28249e+11 1.93437e+11 2.14817e+11 1.14431e+11 nan 2.7863e+10
aapl 2017-09-30 00:00:00 12M 4.9049e+10 1.7874e+10 -4.1293e+10 -5.8e+07 1.94714e+11 3.5867e+10 2.0289e+10 7.4181e+10 1.2307e+10 7.982e+09 1.1977e+10 3.5867e+10 1.34047e+11 2.5744e+10 1.28645e+11 1.8473e+10 1.8473e+10 7.548e+09 7.548e+09 1.00814e+11 -1.5e+08 5.717e+09 8.015e+09 1.7932e+10 7.5076e+10 4.855e+09 2.49727e+11 1.94714e+11 1.94714e+11 1.3587e+10 7.279e+09 9.7207e+10 9.7207e+10 5.421e+10 9.5391e+10 3.3783e+10 1.26032e+11 3.434e+10 2.836e+09 3.1504e+10 5.1262e+09 1.3936e+10 6.496e+09 nan 2.298e+09 1.0162e+10 8.911e+09 1.7799e+10 5.3892e+10 4.9049e+10 7.4793e+10 0 3.5673e+10 9.833e+10 5.1262e+09 1.34047e+11 1.26032e+11 3.75319e+11 2.31254e+11 1.1568e+11 1.34047e+11 2.41272e+11 2.46674e+11 1.40458e+11 nan 2.7831e+10
aapl 2018-09-30 00:00:00 12M 5.5888e+10 2.3186e+10 -4.9099e+10 nan 1.70799e+11 4.0201e+10 2.5913e+10 6.6301e+10 1.4338e+10 1.1575e+10 1.1964e+10 4.0201e+10 1.07147e+11 nan 1.31339e+11 2.0748e+10 2.0748e+10 7.543e+09 7.543e+09 1.16866e+11 -3.454e+09 nan nan nan 9.0403e+10 3.956e+09 2.2163e+11 1.70799e+11 1.70799e+11 1.6216e+10 8.205e+09 9.3735e+10 9.3735e+10 6.5982e+10 8.857e+10 4.1304e+10 1.07147e+11 3.223e+09 2.797e+09 4.26e+08 4.75499e+09 1.2087e+10 8.784e+09 3.2687e+10 nan 2.2283e+10 1.1165e+10 2.5809e+10 4.0388e+10 5.5888e+10 5.5888e+10 0 4.8995e+10 7.04e+10 4.75499e+09 1.07147e+11 1.07147e+11 3.65725e+11 2.00882e+11 1.14483e+11 1.07147e+11 2.58578e+11 2.34386e+11 1.41712e+11 3.3589e+10 1.4473e+10
aapl 2019-09-30 00:00:00 12M 4.6236e+10 2.2926e+10 -5.8579e+10 nan 1.05341e+11 4.5174e+10 4.8844e+10 1.00557e+11 3.664e+10 1.2204e+10 5.98e+09 4.5174e+10 9.0488e+10 nan 1.62819e+11 1.624e+10 1.624e+10 5.522e+09 5.522e+09 1.05718e+11 -5.84e+08 nan nan nan 9.5957e+10 4.106e+09 1.98535e+11 1.05341e+11 1.05341e+11 1.7085e+10 9.075e+09 9.1807e+10 9.1807e+10 6.9797e+10 5.9203e+10 3.7378e+10 9.0488e+10 nan nan nan 4.44324e+09 1.2352e+10 1.026e+10 3.772e+10 nan 3.2978e+10 2.0958e+10 2.2878e+10 5.1713e+10 4.6236e+10 4.6236e+10 0 4.5804e+10 4.5898e+10 4.44324e+09 9.0488e+10 9.0488e+10 3.38516e+11 1.82295e+11 1.08047e+11 9.0488e+10 2.48028e+11 1.75697e+11 1.4231e+11 2.9545e+10 5.7101e+10

cash_flow

  • Description: Retrieves cash flow data for most recent four quarters or most recent four years as well as the trailing 12 months
  • Return: pandas.DataFrame
  • Arguments
Argument Description Type Default Required Options
frequency Display either quarterly or annual data str a optional Annual - a
Quarter - q
trailing Include or exclude trailing twelve month (TTM) data bool True optional True
False
aapl = Ticker('aapl')
aapl.cash_flow(trailing=False)
symbol asOfDate periodType BeginningCashPosition CapitalExpenditure CashDividendsPaid CashFlowFromContinuingFinancingActivities ChangeInAccountPayable ChangeInCashSupplementalAsReported ChangeInInventory ChangeInWorkingCapital ChangesInAccountReceivables CommonStockIssuance DeferredIncomeTax DepreciationAndAmortization EndCashPosition FreeCashFlow InvestingCashFlow NetIncome NetOtherFinancingCharges NetOtherInvestingChanges OperatingCashFlow OtherNonCashItems PurchaseOfBusiness PurchaseOfInvestment RepaymentOfDebt RepurchaseOfCapitalStock SaleOfInvestment StockBasedCompensation
aapl 2016-09-30 00:00:00 12M 2.112e+10 -1.3548e+10 -1.215e+10 -2.0483e+10 1.791e+09 -6.36e+08 2.17e+08 4.84e+08 1.095e+09 4.95e+08 4.938e+09 1.0505e+10 2.0484e+10 5.2276e+10 -4.5977e+10 4.5687e+10 -1.163e+09 -1.1e+08 6.5824e+10 nan -2.97e+08 -1.43816e+11 -2.5e+09 -2.9722e+10 1.11794e+11 4.21e+09
aapl 2017-09-30 00:00:00 12M 2.0484e+10 -1.2795e+10 -1.2769e+10 -1.7347e+10 9.618e+09 -1.95e+08 -2.723e+09 -5.55e+09 -2.093e+09 5.55e+08 5.966e+09 1.0157e+10 2.0289e+10 5.0803e+10 -4.6446e+10 4.8351e+10 -1.247e+09 2.2e+08 6.3598e+10 -1.66e+08 -3.29e+08 -1.59881e+11 -3.5e+09 -3.29e+10 1.26339e+11 4.84e+09
aapl 2018-09-30 00:00:00 12M 2.0289e+10 -1.3313e+10 -1.3712e+10 -8.7876e+10 9.175e+09 5.624e+09 8.28e+08 3.4694e+10 -5.322e+09 6.69e+08 -3.259e+10 1.0903e+10 2.5913e+10 6.4121e+10 1.6066e+10 5.9531e+10 -2.527e+09 -7.45e+08 7.7434e+10 -4.44e+08 -7.21e+08 -7.3227e+10 -6.5e+09 -7.2738e+10 1.04072e+11 5.34e+09
aapl 2019-09-30 00:00:00 12M 2.5913e+10 -1.0495e+10 -1.4119e+10 -9.0976e+10 -1.923e+09 2.4311e+10 -2.89e+08 -3.488e+09 2.45e+08 7.81e+08 -3.4e+08 1.2547e+10 5.0224e+10 5.8896e+10 4.5896e+10 5.5256e+10 -2.922e+09 -1.078e+09 6.9391e+10 -6.52e+08 -6.24e+08 -4.0631e+10 -8.805e+09 -6.6897e+10 9.8724e+10 6.068e+09

income_statement

  • Description: Retrieves income statement data for most recent four quarters or most recent four years as well as trailing 12 months.
  • Return: pandas.DataFrame
  • Arguments
Argument Description Type Default Required Options
frequency Display either quarterly or annual data str a optional Annual - a
Quarter - q
trailing Include or exclude trailing twelve month (TTM) data bool True optional True
False
aapl = Ticker('aapl')
aapl.income_statement()
symbol asOfDate periodType BasicAverageShares BasicEPS CostOfRevenue DilutedAverageShares DilutedEPS DilutedNIAvailtoComStockholders EBIT EBITDA GrossProfit InterestExpense InterestExpenseNonOperating InterestIncome InterestIncomeNonOperating NetIncome NetIncomeCommonStockholders NetIncomeContinuousOperations NetIncomeFromContinuingAndDiscontinuedOperation NetIncomeFromContinuingOperationNetMinorityInterest NetIncomeIncludingNoncontrollingInterests NetInterestIncome NetNonOperatingInterestIncomeExpense NormalizedEBITDA NormalizedIncome OperatingExpense OperatingIncome OperatingRevenue OtherIncomeExpense OtherNonOperatingIncomeExpenses PretaxIncome ReconciledCostOfRevenue ReconciledDepreciation ResearchAndDevelopment SellingGeneralAndAdministration TaxEffectOfUnusualItems TaxProvision TaxRateForCalcs TotalExpenses TotalOperatingIncomeAsReported TotalRevenue
aapl 2016-09-30 00:00:00 12M 5.47082e+09 8.35 1.31376e+11 5.50028e+09 8.31 4.5687e+10 6.2828e+10 nan 8.4263e+10 1.456e+09 1.456e+09 3.999e+09 3.999e+09 4.5687e+10 4.5687e+10 4.5687e+10 4.5687e+10 4.5687e+10 4.5687e+10 2.543e+09 2.543e+09 7.3333e+10 4.5687e+10 2.4239e+10 6.0024e+10 2.15639e+11 -1.195e+09 -1.195e+09 6.1372e+10 1.31376e+11 1.0505e+10 1.0045e+10 1.4194e+10 0 1.5685e+10 0.256 1.55615e+11 6.0024e+10 2.15639e+11
aapl 2017-09-30 00:00:00 12M 5.21724e+09 9.27 1.41048e+11 5.25169e+09 9.21 4.8351e+10 6.6412e+10 nan 8.8186e+10 2.323e+09 2.323e+09 5.201e+09 5.201e+09 4.8351e+10 4.8351e+10 4.8351e+10 4.8351e+10 4.8351e+10 4.8351e+10 2.878e+09 2.878e+09 7.6569e+10 4.8351e+10 2.6842e+10 6.1344e+10 2.29234e+11 -1.33e+08 -1.33e+08 6.4089e+10 1.41048e+11 1.0157e+10 1.1581e+10 1.5261e+10 0 1.5738e+10 0.246 1.6789e+11 6.1344e+10 2.29234e+11
aapl 2018-09-30 00:00:00 12M 4.95538e+09 12.01 1.63756e+11 5.00011e+09 11.91 5.9531e+10 7.6143e+10 nan 1.01839e+11 3.24e+09 3.24e+09 5.686e+09 5.686e+09 5.9531e+10 5.9531e+10 5.9531e+10 5.9531e+10 5.9531e+10 5.9531e+10 2.446e+09 2.446e+09 8.7046e+10 5.9531e+10 3.0941e+10 7.0898e+10 2.65595e+11 -4.41e+08 -4.41e+08 7.2903e+10 1.63756e+11 1.0903e+10 1.4236e+10 1.6705e+10 0 1.3372e+10 0.183 1.94697e+11 7.0898e+10 2.65595e+11
aapl 2019-09-30 00:00:00 12M 4.61783e+09 11.97 1.61782e+11 4.64891e+09 11.89 5.5256e+10 6.9313e+10 nan 9.8392e+10 3.576e+09 3.576e+09 4.961e+09 4.961e+09 5.5256e+10 5.5256e+10 5.5256e+10 5.5256e+10 5.5256e+10 5.5256e+10 1.385e+09 1.385e+09 8.186e+10 5.5256e+10 3.4462e+10 6.393e+10 2.60174e+11 4.22e+08 4.22e+08 6.5737e+10 1.61782e+11 1.2547e+10 1.6217e+10 1.8245e+10 0 1.0481e+10 0.159 1.96244e+11 6.393e+10 2.60174e+11
aapl 2020-03-31 00:00:00 TTM nan nan 1.65854e+11 nan nan 5.7215e+10 7.0309e+10 8.2023e+10 1.02127e+11 3.218e+09 3.218e+09 4.39e+09 4.39e+09 5.7215e+10 5.7215e+10 5.7215e+10 5.7215e+10 5.7215e+10 5.7215e+10 1.172e+09 1.172e+09 8.2023e+10 5.7215e+10 3.6536e+10 6.5591e+10 2.67981e+11 3.28e+08 3.28e+08 6.7091e+10 1.65854e+11 1.1714e+10 1.7383e+10 1.9153e+10 0 9.876e+09 0.147203 2.0239e+11 6.5591e+10 2.67981e+11

valuation_measures

  • Description: Retrieves valuation measures for most recent four quarters as well as the most recent date
  • Return: pandas.DataFrame
aapl = Ticker('aapl')
aapl.valuation_measures
symbol asOfDate periodType EnterpriseValue EnterprisesValueEBITDARatio EnterprisesValueRevenueRatio ForwardPeRatio MarketCap PbRatio PeRatio PegRatio PsRatio
aapl 2019-06-30 00:00:00 3M 9.43183e+11 60.0371 17.5283 15.9744 9.10645e+11 8.47207 16.5762 1.4501 3.68445
aapl 2019-09-30 00:00:00 3M 1.00896e+12 50.1569 15.7551 17.2712 9.95152e+11 10.3172 19.0127 2.0355 4.09034
aapl 2019-12-31 00:00:00 3M 1.29513e+12 43.8746 14.1053 22.1729 1.28764e+12 14.23 24.6972 2.0292 5.24708
aapl 2020-03-05 00:00:00 TTM 1.2828e+12 nan nan 22.1239 1.28167e+12 14.3153 23.0646 1.7784 5.00004
aapl 2020-03-08 00:00:00 TTM nan 15.4204 4.79222 nan nan nan nan nan nan
aapl 2020-03-31 00:00:00 3M 1.10068e+12 65.9957 18.8753 19.6464 1.09955e+12 12.2812 20.0228 1.5803 4.34064
aapl 2020-05-08 00:00:00 TTM 1.35966e+12 nan nan 26.178 1.34421e+12 17.14 24.2478 2.171 5.20229
aapl 2020-05-11 00:00:00 TTM nan 16.5766 5.07373 nan nan nan nan nan nan
aapl 2020-05-28 00:00:00 TTM 1.39486e+12 nan nan 26.8097 1.3794e+12 17.5888 24.8827 2.2278 5.3385
aapl 2020-05-29 00:00:00 TTM nan 17.0057 5.20506 nan nan nan nan nan nan
aapl 2020-06-12 00:00:00 TTM 1.48393e+12 nan nan 22.5734 1.46847e+12 18.7245 26.4894 1.8786 5.68322
aapl 2020-06-15 00:00:00 TTM nan 18.0916 5.53744 nan nan nan nan nan nan
aapl 2020-07-14 00:00:00 TTM 1.69817e+12 nan nan 25.8398 1.68272e+12 21.4564 30.3542 2.1527 6.51239
aapl 2020-07-15 00:00:00 TTM nan 20.7036 6.33692 nan nan nan nan nan nan
aapl 2020-07-16 00:00:00 TTM 1.6889e+12 nan nan 26.3158 1.67344e+12 21.3381 30.1869 2.1897 6.47649
aapl 2020-07-18 00:00:00 TTM nan 20.5906 6.30231 nan nan nan nan nan nan
aapl 2020-07-29 00:00:00 TTM 1.6632e+12 nan nan 25.1256 1.64774e+12 21.0104 29.7232 2.0905 6.37702
aapl 2020-07-30 00:00:00 TTM nan 20.2772 6.2064 nan nan nan nan nan nan

Multiple

all_financial_data

  • Description: Retrieve all financial data, including income statement, balance sheet, cash flow, and valuation measures.
  • Return: pandas.DataFrame
  • Arguments
Argument Description Type Default Required Options
frequency Display either quarterly or annual data str a optional Annual - a
Quarter - q

Warning

No trailing twelve month (TTM) data will be returned with this method

aapl = Ticker('aapl')
aapl.all_financial_data()
symbol asOfDate periodType AccountsPayable AccountsReceivable AccumulatedDepreciation AllowanceForDoubtfulAccountsReceivable AvailableForSaleSecurities BasicAverageShares BasicEPS BeginningCashPosition CapitalExpenditure CapitalStock CashAndCashEquivalents CashCashEquivalentsAndShortTermInvestments CashDividendsPaid CashEquivalents CashFinancial CashFlowFromContinuingFinancingActivities ChangeInAccountPayable ChangeInCashSupplementalAsReported ChangeInInventory ChangeInWorkingCapital ChangesInAccountReceivables CommercialPaper CommonStock CommonStockEquity CommonStockIssuance CostOfRevenue CurrentAccruedExpenses CurrentAssets CurrentDebt CurrentDebtAndCapitalLeaseObligation CurrentDeferredLiabilities CurrentDeferredRevenue CurrentLiabilities DeferredIncomeTax DepreciationAndAmortization DilutedAverageShares DilutedEPS DilutedNIAvailtoComStockholders EBIT EndCashPosition EnterpriseValue EnterprisesValueEBITDARatio EnterprisesValueRevenueRatio ForwardPeRatio FreeCashFlow GainsLossesNotAffectingRetainedEarnings Goodwill GoodwillAndOtherIntangibleAssets GrossAccountsReceivable GrossPPE GrossProfit InterestExpense InterestExpenseNonOperating InterestIncome InterestIncomeNonOperating Inventory InvestedCapital InvestingCashFlow InvestmentinFinancialAssets InvestmentsAndAdvances LandAndImprovements Leases LongTermDebt LongTermDebtAndCapitalLeaseObligation MachineryFurnitureEquipment MarketCap NetDebt NetIncome NetIncomeCommonStockholders NetIncomeContinuousOperations NetIncomeFromContinuingAndDiscontinuedOperation NetIncomeFromContinuingOperationNetMinorityInterest NetIncomeIncludingNoncontrollingInterests NetInterestIncome NetNonOperatingInterestIncomeExpense NetOtherFinancingCharges NetOtherInvestingChanges NetPPE NetTangibleAssets NonCurrentDeferredLiabilities NonCurrentDeferredRevenue NonCurrentDeferredTaxesLiabilities NormalizedEBITDA NormalizedIncome OperatingCashFlow OperatingExpense OperatingIncome OperatingRevenue OrdinarySharesNumber OtherCurrentAssets OtherCurrentBorrowings OtherCurrentLiabilities OtherIncomeExpense OtherIntangibleAssets OtherNonCashItems OtherNonCurrentAssets OtherNonCurrentLiabilities OtherNonOperatingIncomeExpenses OtherReceivables OtherShortTermInvestments Payables PayablesAndAccruedExpenses PbRatio PeRatio PegRatio PretaxIncome Properties PsRatio PurchaseOfBusiness PurchaseOfInvestment Receivables ReconciledCostOfRevenue ReconciledDepreciation RepaymentOfDebt RepurchaseOfCapitalStock ResearchAndDevelopment RetainedEarnings SaleOfInvestment SellingGeneralAndAdministration ShareIssued StockBasedCompensation StockholdersEquity TangibleBookValue TaxEffectOfUnusualItems TaxProvision TaxRateForCalcs TotalAssets TotalCapitalization TotalDebt TotalEquityGrossMinorityInterest TotalExpenses TotalLiabilitiesNetMinorityInterest TotalNonCurrentAssets TotalNonCurrentLiabilitiesNetMinorityInterest TotalOperatingIncomeAsReported TotalRevenue TradeandOtherPayablesNonCurrent WorkingCapital
aapl 2016-09-30 00:00:00 12M 3.7294e+10 1.5754e+10 -3.4235e+10 -5.3e+07 1.7043e+11 5.47082e+09 8.35 2.112e+10 -1.3548e+10 3.1251e+10 2.0484e+10 6.7155e+10 -1.215e+10 1.1883e+10 8.601e+09 -2.0483e+10 1.791e+09 -6.36e+08 2.17e+08 4.84e+08 1.095e+09 8.105e+09 3.1251e+10 1.28249e+11 4.95e+08 1.31376e+11 2.2027e+10 1.06869e+11 1.1605e+10 1.1605e+10 8.08e+09 8.08e+09 7.9006e+10 4.938e+09 1.0505e+10 5.50028e+09 8.31 4.5687e+10 6.2828e+10 2.0484e+10 6.26433e+11 8.5423 2.90501 12.6582 5.2276e+10 6.34e+08 5.414e+09 8.62e+09 1.5807e+10 6.1245e+10 8.4263e+10 1.456e+09 1.456e+09 3.999e+09 3.999e+09 2.132e+09 2.15281e+11 -4.5977e+10 1.7043e+11 1.7043e+11 1.0185e+10 6.517e+09 7.5427e+10 7.5427e+10 4.4543e+10 6.03254e+11 6.6548e+10 4.5687e+10 4.5687e+10 4.5687e+10 4.5687e+10 4.5687e+10 4.5687e+10 2.543e+09 2.543e+09 -1.163e+09 -1.1e+08 2.701e+10 1.19629e+11 2.8949e+10 2.93e+09 2.6019e+10 7.3333e+10 4.5687e+10 6.5824e+10 2.4239e+10 6.0024e+10 2.15639e+11 5.33617e+09 8.283e+09 3.5e+09 nan -1.195e+09 3.206e+09 nan 8.757e+09 1.0055e+10 -1.195e+09 1.3545e+10 4.6671e+10 3.7294e+10 5.9321e+10 4.76726 13.1607 2.4275 6.1372e+10 0 2.8598 -2.97e+08 -1.43816e+11 2.9299e+10 1.31376e+11 1.0505e+10 -2.5e+09 -2.9722e+10 1.0045e+10 9.6364e+10 1.11794e+11 1.4194e+10 5.33617e+09 4.21e+09 1.28249e+11 1.19629e+11 0 1.5685e+10 0.256 3.21686e+11 2.03676e+11 8.7032e+10 1.28249e+11 1.55615e+11 1.93437e+11 2.14817e+11 1.14431e+11 6.0024e+10 2.15639e+11 nan 2.7863e+10
aapl 2017-09-30 00:00:00 12M 4.9049e+10 1.7874e+10 -4.1293e+10 -5.8e+07 1.94714e+11 5.21724e+09 9.27 2.0484e+10 -1.2795e+10 3.5867e+10 2.0289e+10 7.4181e+10 -1.2769e+10 1.2307e+10 7.982e+09 -1.7347e+10 9.618e+09 -1.95e+08 -2.723e+09 -5.55e+09 -2.093e+09 1.1977e+10 3.5867e+10 1.34047e+11 5.55e+08 1.41048e+11 2.5744e+10 1.28645e+11 1.8473e+10 1.8473e+10 7.548e+09 7.548e+09 1.00814e+11 5.966e+09 1.0157e+10 5.25169e+09 9.21 4.8351e+10 6.6412e+10 2.0289e+10 8.27645e+11 10.8091 3.61048 14.245 5.0803e+10 -1.5e+08 5.717e+09 8.015e+09 1.7932e+10 7.5076e+10 8.8186e+10 2.323e+09 2.323e+09 5.201e+09 5.201e+09 4.855e+09 2.49727e+11 -4.6446e+10 1.94714e+11 1.94714e+11 1.3587e+10 7.279e+09 9.7207e+10 9.7207e+10 5.421e+10 7.96065e+11 9.5391e+10 4.8351e+10 4.8351e+10 4.8351e+10 4.8351e+10 4.8351e+10 4.8351e+10 2.878e+09 2.878e+09 -1.247e+09 2.2e+08 3.3783e+10 1.26032e+11 3.434e+10 2.836e+09 3.1504e+10 7.6569e+10 4.8351e+10 6.3598e+10 2.6842e+10 6.1344e+10 2.29234e+11 5.1262e+09 1.3936e+10 6.496e+09 nan -1.33e+08 2.298e+09 -1.66e+08 1.0162e+10 8.911e+09 -1.33e+08 1.7799e+10 5.3892e+10 4.9049e+10 7.4793e+10 5.96602 17.4541 2.087 6.4089e+10 0 3.65748 -3.29e+08 -1.59881e+11 3.5673e+10 1.41048e+11 1.0157e+10 -3.5e+09 -3.29e+10 1.1581e+10 9.833e+10 1.26339e+11 1.5261e+10 5.1262e+09 4.84e+09 1.34047e+11 1.26032e+11 0 1.5738e+10 0.246 3.75319e+11 2.31254e+11 1.1568e+11 1.34047e+11 1.6789e+11 2.41272e+11 2.46674e+11 1.40458e+11 6.1344e+10 2.29234e+11 nan 2.7831e+10
aapl 2018-09-30 00:00:00 12M 5.5888e+10 2.3186e+10 -4.9099e+10 nan 1.70799e+11 4.95538e+09 12.01 2.0289e+10 -1.3313e+10 4.0201e+10 2.5913e+10 6.6301e+10 -1.3712e+10 1.4338e+10 1.1575e+10 -8.7876e+10 9.175e+09 5.624e+09 8.28e+08 3.4694e+10 -5.322e+09 1.1964e+10 4.0201e+10 1.07147e+11 6.69e+08 1.63756e+11 nan 1.31339e+11 2.0748e+10 2.0748e+10 7.543e+09 7.543e+09 1.16866e+11 -3.259e+10 1.0903e+10 5.00011e+09 11.91 5.9531e+10 7.6143e+10 2.5913e+10 1.13394e+12 13.0269 4.26942 16.6945 6.4121e+10 -3.454e+09 nan nan nan 9.0403e+10 1.01839e+11 3.24e+09 3.24e+09 5.686e+09 5.686e+09 3.956e+09 2.2163e+11 1.6066e+10 1.70799e+11 1.70799e+11 1.6216e+10 8.205e+09 9.3735e+10 9.3735e+10 6.5982e+10 1.09031e+12 8.857e+10 5.9531e+10 5.9531e+10 5.9531e+10 5.9531e+10 5.9531e+10 5.9531e+10 2.446e+09 2.446e+09 -2.527e+09 -7.45e+08 4.1304e+10 1.07147e+11 3.223e+09 2.797e+09 4.26e+08 8.7046e+10 5.9531e+10 7.7434e+10 3.0941e+10 7.0898e+10 2.65595e+11 4.75499e+09 1.2087e+10 8.784e+09 3.2687e+10 -4.41e+08 nan -4.44e+08 2.2283e+10 1.1165e+10 -4.41e+08 2.5809e+10 4.0388e+10 5.5888e+10 5.5888e+10 9.33797 20.4105 1.2848 7.2903e+10 0 4.49591 -7.21e+08 -7.3227e+10 4.8995e+10 1.63756e+11 1.0903e+10 -6.5e+09 -7.2738e+10 1.4236e+10 7.04e+10 1.04072e+11 1.6705e+10 4.75499e+09 5.34e+09 1.07147e+11 1.07147e+11 0 1.3372e+10 0.183 3.65725e+11 2.00882e+11 1.14483e+11 1.07147e+11 1.94697e+11 2.58578e+11 2.34386e+11 1.41712e+11 7.0898e+10 2.65595e+11 3.3589e+10 1.4473e+10
aapl 2019-09-30 00:00:00 12M 4.6236e+10 2.2926e+10 -5.8579e+10 nan 1.05341e+11 4.61783e+09 11.97 2.5913e+10 -1.0495e+10 4.5174e+10 4.8844e+10 1.00557e+11 -1.4119e+10 3.664e+10 1.2204e+10 -9.0976e+10 -1.923e+09 2.4311e+10 -2.89e+08 -3.488e+09 2.45e+08 5.98e+09 4.5174e+10 9.0488e+10 7.81e+08 1.61782e+11 nan 1.62819e+11 1.624e+10 1.624e+10 5.522e+09 5.522e+09 1.05718e+11 -3.4e+08 1.2547e+10 4.64891e+09 11.89 5.5256e+10 6.9313e+10 5.0224e+10 1.00896e+12 12.3254 3.878 17.2712 5.8896e+10 -5.84e+08 nan nan nan 9.5957e+10 9.8392e+10 3.576e+09 3.576e+09 4.961e+09 4.961e+09 4.106e+09 1.98535e+11 4.5896e+10 1.05341e+11 1.05341e+11 1.7085e+10 9.075e+09 9.1807e+10 9.1807e+10 6.9797e+10 9.95152e+11 5.9203e+10 5.5256e+10 5.5256e+10 5.5256e+10 5.5256e+10 5.5256e+10 5.5256e+10 1.385e+09 1.385e+09 -2.922e+09 -1.078e+09 3.7378e+10 9.0488e+10 nan nan nan 8.186e+10 5.5256e+10 6.9391e+10 3.4462e+10 6.393e+10 2.60174e+11 4.44324e+09 1.2352e+10 1.026e+10 3.772e+10 4.22e+08 nan -6.52e+08 3.2978e+10 2.0958e+10 4.22e+08 2.2878e+10 5.1713e+10 4.6236e+10 4.6236e+10 10.3172 19.0127 2.0355 6.5737e+10 0 4.09034 -6.24e+08 -4.0631e+10 4.5804e+10 1.61782e+11 1.2547e+10 -8.805e+09 -6.6897e+10 1.6217e+10 4.5898e+10 9.8724e+10 1.8245e+10 4.44324e+09 6.068e+09 9.0488e+10 9.0488e+10 0 1.0481e+10 0.159 3.38516e+11 1.82295e+11 1.08047e+11 9.0488e+10 1.96244e+11 2.48028e+11 1.75697e+11 1.4231e+11 6.393e+10 2.60174e+11 2.9545e+10 5.7101e+10

get_financial_data

  • Description: Obtain specific data from either cash flow, income statement, balance sheet, or valuation measures.
  • Return: pandas.DataFrame
  • Arguments
Argument Description Type Default Required Options
types Specific item(s) to retrieve from financials list or str None Required See options below
frequency Display either quarterly or annual data str a optional Annual - a
Quarter - q
trailing Include or exclude trailing twelve month (TTM) data bool True optional True
False

Warning

If you try and use all of the options below AND trailing=True, you will receive an error because the requested URL will be too long

[
    'AccountsPayable', 'AccountsReceivable', 'AccruedInterestReceivable',
    'AccumulatedDepreciation', 'AdditionalPaidInCapital',
    'AllowanceForDoubtfulAccountsReceivable', 'AssetsHeldForSaleCurrent',
    'AvailableForSaleSecurities', 'BuildingsAndImprovements', 'CapitalLeaseObligations',
    'CapitalStock', 'CashAndCashEquivalents', 'CashCashEquivalentsAndShortTermInvestments',
    'CashEquivalents', 'CashFinancial', 'CommercialPaper', 'CommonStock',
    'CommonStockEquity', 'ConstructionInProgress', 'CurrentAccruedExpenses',
    'CurrentAssets', 'CurrentCapitalLeaseObligation', 'CurrentDebt',
    'CurrentDebtAndCapitalLeaseObligation', 'CurrentDeferredAssets',
    'CurrentDeferredLiabilities', 'CurrentDeferredRevenue', 'CurrentDeferredTaxesAssets',
    'CurrentDeferredTaxesLiabilities', 'CurrentLiabilities', 'CurrentNotesPayable',
    'CurrentProvisions', 'DefinedPensionBenefit', 'DerivativeProductLiabilities',
    'DividendsPayable', 'DuefromRelatedPartiesCurrent', 'DuefromRelatedPartiesNonCurrent',
    'DuetoRelatedPartiesCurrent', 'DuetoRelatedPartiesNonCurrent', 'EmployeeBenefits',
    'FinancialAssets', 'FinancialAssetsDesignatedasFairValueThroughProfitorLossTotal',
    'FinishedGoods', 'FixedAssetsRevaluationReserve', 'ForeignCurrencyTranslationAdjustments',
    'GainsLossesNotAffectingRetainedEarnings', 'GeneralPartnershipCapital', 'Goodwill',
    'GoodwillAndOtherIntangibleAssets', 'GrossAccountsReceivable', 'GrossPPE',
    'HedgingAssetsCurrent', 'HeldToMaturitySecurities', 'IncomeTaxPayable',
    'InterestPayable', 'InventoriesAdjustmentsAllowances', 'Inventory',
    'InvestedCapital', 'InvestmentProperties', 'InvestmentinFinancialAssets',
    'InvestmentsAndAdvances', 'InvestmentsInOtherVenturesUnderEquityMethod',
    'InvestmentsinAssociatesatCost', 'InvestmentsinJointVenturesatCost',
    'InvestmentsinSubsidiariesatCost', 'LandAndImprovements', 'Leases',
    'LiabilitiesHeldforSaleNonCurrent', 'LimitedPartnershipCapital',
    'LineOfCredit', 'LoansReceivable', 'LongTermCapitalLeaseObligation',
    'LongTermDebt', 'LongTermDebtAndCapitalLeaseObligation', 'LongTermEquityInvestment',
    'LongTermProvisions', 'MachineryFurnitureEquipment', 'MinimumPensionLiabilities',
    'MinorityInterest', 'NetDebt', 'NetPPE', 'NetTangibleAssets', 'NonCurrentAccountsReceivable',
    'NonCurrentAccruedExpenses', 'NonCurrentDeferredAssets', 'NonCurrentDeferredLiabilities',
    'NonCurrentDeferredRevenue', 'NonCurrentDeferredTaxesAssets', 'NonCurrentDeferredTaxesLiabilities',
    'NonCurrentNoteReceivables', 'NonCurrentPensionAndOtherPostretirementBenefitPlans',
    'NonCurrentPrepaidAssets', 'NotesReceivable', 'OrdinarySharesNumber',
    'OtherCapitalStock', 'OtherCurrentAssets', 'OtherCurrentBorrowings',
    'OtherCurrentLiabilities', 'OtherEquityAdjustments', 'OtherEquityInterest',
    'OtherIntangibleAssets', 'OtherInventories', 'OtherInvestments', 'OtherNonCurrentAssets',
    'OtherNonCurrentLiabilities', 'OtherPayable', 'OtherProperties', 'OtherReceivables',
    'OtherShortTermInvestments', 'Payables', 'PayablesAndAccruedExpenses',
    'PensionandOtherPostRetirementBenefitPlansCurrent', 'PreferredSecuritiesOutsideStockEquity',
    'PreferredSharesNumber', 'PreferredStock', 'PreferredStockEquity',
    'PrepaidAssets', 'Properties', 'RawMaterials', 'Receivables',
    'ReceivablesAdjustmentsAllowances', 'RestrictedCash', 'RestrictedCommonStock',
    'RetainedEarnings', 'ShareIssued', 'StockholdersEquity', 'TangibleBookValue',
    'TaxesReceivable', 'TotalAssets', 'TotalCapitalization', 'TotalDebt',
    'TotalEquityGrossMinorityInterest', 'TotalLiabilitiesNetMinorityInterest',
    'TotalNonCurrentAssets', 'TotalNonCurrentLiabilitiesNetMinorityInterest',
    'TotalPartnershipCapital', 'TotalTaxPayable', 'TradeandOtherPayablesNonCurrent',
    'TradingSecurities', 'TreasurySharesNumber', 'TreasuryStock', 'UnrealizedGainLoss',
    'WorkInProcess', 'WorkingCapital'
]
[
    'RepaymentOfDebt', 'RepurchaseOfCapitalStock', 'CashDividendsPaid',
    'CommonStockIssuance', 'ChangeInWorkingCapital',
    'CapitalExpenditure',
    'CashFlowFromContinuingFinancingActivities', 'NetIncome',
    'FreeCashFlow', 'ChangeInCashSupplementalAsReported',
    'SaleOfInvestment', 'EndCashPosition', 'OperatingCashFlow',
    'DeferredIncomeTax', 'NetOtherInvestingChanges',
    'ChangeInAccountPayable', 'NetOtherFinancingCharges',
    'PurchaseOfInvestment', 'ChangeInInventory',
    'DepreciationAndAmortization', 'PurchaseOfBusiness',
    'InvestingCashFlow', 'ChangesInAccountReceivables',
    'StockBasedCompensation', 'OtherNonCashItems',
    'BeginningCashPosition'
]
[
    'Amortization', 'AmortizationOfIntangiblesIncomeStatement',
    'AverageDilutionEarnings', 'BasicAccountingChange', 'BasicAverageShares',
    'BasicContinuousOperations', 'BasicDiscontinuousOperations', 'BasicEPS',
    'BasicEPSOtherGainsLosses', 'BasicExtraordinary', 'ContinuingAndDiscontinuedBasicEPS',
    'ContinuingAndDiscontinuedDilutedEPS', 'CostOfRevenue', 'DepletionIncomeStatement',
    'DepreciationAmortizationDepletionIncomeStatement', 'DepreciationAndAmortizationInIncomeStatement',
    'DepreciationIncomeStatement', 'DilutedAccountingChange', 'DilutedAverageShares',
    'DilutedContinuousOperations', 'DilutedDiscontinuousOperations', 'DilutedEPS',
    'DilutedEPSOtherGainsLosses', 'DilutedExtraordinary', 'DilutedNIAvailtoComStockholders',
    'DividendPerShare', 'EBIT', 'EBITDA', 'EarningsFromEquityInterest',
    'EarningsFromEquityInterestNetOfTax', 'ExciseTaxes', 'GainOnSaleOfBusiness',
    'GainOnSaleOfPPE', 'GainOnSaleOfSecurity', 'GeneralAndAdministrativeExpense',
    'GrossProfit', 'ImpairmentOfCapitalAssets', 'InsuranceAndClaims',
    'InterestExpense', 'InterestExpenseNonOperating', 'InterestIncome',
    'InterestIncomeNonOperating', 'MinorityInterests', 'NetIncome', 'NetIncomeCommonStockholders',
    'NetIncomeContinuousOperations', 'NetIncomeDiscontinuousOperations',
    'NetIncomeExtraordinary', 'NetIncomeFromContinuingAndDiscontinuedOperation',
    'NetIncomeFromContinuingOperationNetMinorityInterest', 'NetIncomeFromTaxLossCarryforward',
    'NetIncomeIncludingNoncontrollingInterests', 'NetInterestIncome',
    'NetNonOperatingInterestIncomeExpense', 'NormalizedBasicEPS', 'NormalizedDilutedEPS',
    'NormalizedEBITDA', 'NormalizedIncome', 'OperatingExpense', 'OperatingIncome',
    'OperatingRevenue', 'OtherGandA', 'OtherIncomeExpense', 'OtherNonOperatingIncomeExpenses',
    'OtherOperatingExpenses', 'OtherSpecialCharges', 'OtherTaxes',
    'OtherunderPreferredStockDividend', 'PreferredStockDividends',
    'PretaxIncome', 'ProvisionForDoubtfulAccounts', 'ReconciledCostOfRevenue',
    'ReconciledDepreciation', 'RentAndLandingFees', 'RentExpenseSupplemental',
    'ReportedNormalizedBasicEPS', 'ReportedNormalizedDilutedEPS', 'ResearchAndDevelopment',
    'RestructuringAndMergernAcquisition', 'SalariesAndWages', 'SecuritiesAmortization',
    'SellingAndMarketingExpense', 'SellingGeneralAndAdministration', 'SpecialIncomeCharges',
    'TaxEffectOfUnusualItems', 'TaxLossCarryforwardBasicEPS', 'TaxLossCarryforwardDilutedEPS',
    'TaxProvision', 'TaxRateForCalcs', 'TotalExpenses', 'TotalOperatingIncomeAsReported',
    'TotalOtherFinanceCost', 'TotalRevenue', 'TotalUnusualItems',
    'TotalUnusualItemsExcludingGoodwill', 'WriteOff'
]
[
    'ForwardPeRatio', 'PsRatio', 'PbRatio',
    'EnterprisesValueEBITDARatio', 'EnterprisesValueRevenueRatio',
    'PeRatio', 'MarketCap', 'EnterpriseValue', 'PegRatio'
]
aapl = Ticker('aapl')
types = ['TotalDebt', 'TotalAssets', 'EBIT', 'EBITDA', 'PeRatio']
aapl.get_financial_data(types, trailing=False)
symbol asOfDate periodType EBIT PeRatio TotalAssets TotalDebt
aapl 2016-09-30 00:00:00 12M 6.2828e+10 13.1607 3.21686e+11 8.7032e+10
aapl 2017-09-30 00:00:00 12M 6.6412e+10 17.4541 3.75319e+11 1.1568e+11
aapl 2018-09-30 00:00:00 12M 7.6143e+10 20.4105 3.65725e+11 1.14483e+11
aapl 2019-09-30 00:00:00 12M 6.9313e+10 19.0127 3.38516e+11 1.08047e+11