FundamentalAnalysis#

What it is#

fundamentalanalysis is a python package that makes it easy to access current and historical financial data from Financial Modeling Prep.

See the following resources:

After setting up a free account with Financial Modeling Prep, you gain access to a unique API key. From there you can import the fundamentalanalysis package and define an API variable.

import pandas as pd
import fundamentalanalysis as fa

my_api_key = 'YOUR_API_KEY_HERE'

Attention

With a free account, we are able to make no more than 250 requests per day. Similarly, the rate at which we can make requests might be limited. See the Slowing down requests section below.

Available functions#

Below you will find some examples of what you can do with the fundamentalanalysis package.

Available companies#

available_tickers = fa.available_companies(my_api_key)
available_tickers

	name	price	exchange	exchangeShortName	type
symbol
SPY	SPDR S&P 500 ETF Trust	402.33	New York Stock Exchange Arca	AMEX	etf
CMCSA	Comcast Corporation	35.65	NASDAQ Global Select	NASDAQ	stock
KMI	Kinder Morgan, Inc.	18.63	New York Stock Exchange	NYSE	stock
INTC	Intel Corporation	29.34	NASDAQ Global Select	NASDAQ	stock
MU	Micron Technology, Inc.	58.41	NASDAQ Global Select	NASDAQ	stock
...	...	...	...	...	...
TSLL	Direxion Daily TSLA Bull 1.5X Shares	11.78	NASDAQ Global Market	NASDAQ	stock
AAALF	Aareal Bank AG	31.99	Other OTC	OTC	stock
GEN	Gen Digital Inc.	23.11	NASDAQ Global Select	NASDAQ	stock
NAMS	NewAmsterdam Pharma Company N.V. Ordinary Shares	10.04	NASDAQ Global Market	NASDAQ	stock
NAMSW	NewAmsterdam Pharma Company N.V. Warrant	0.95	NASDAQ Global Market	NASDAQ	stock

45692 rows × 5 columns

Company profile#

my_ticker = 'PFE'
company_profile = fa.profile(ticker=my_ticker, api_key=my_api_key)
company_profile

	0
symbol	PFE
price	49.21
beta	0.641639
volAvg	19927634
mktCap	276230982738
lastDiv	1.6
range	41.45-61.71
changes	0.36
companyName	Pfizer Inc.
currency	USD
cik	0000078003
isin	US7170811035
cusip	717081103
exchange	New York Stock Exchange
exchangeShortName	NYSE
industry	Drug Manufacturers—General
website	https://www.pfizer.com
description	Pfizer Inc. discovers, develops, manufactures,...
ceo	Dr. Albert Bourla
sector	Healthcare
country	US
fullTimeEmployees	79000
phone	12125732323
address	235 E 42ND ST
city	New York City
state	NEW YORK
zip	10017
dcfDiff	0.329424
dcf	48.5206
image	https://financialmodelingprep.com/image-stock/...
ipoDate	1944-01-17
defaultImage	False
isEtf	False
isActivelyTrading	True
isAdr	False
isFund	False

Financial statements#

company_bs = fa.balance_sheet_statement(ticker=my_ticker, api_key=my_api_key)
company_bs

	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	...	2003	2002	2001	2000	1999	1998	1997	1996	1995	1994
reportedCurrency	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	...	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD
cik	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	...	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003
fillingDate	2022-02-24	2021-02-25	2020-02-27	2019-02-28	2018-02-22	2017-02-23	2016-02-29	2015-02-27	2014-02-28	2013-02-28	...	2004-03-10	2003-03-27	2002-03-28	2001-03-28	1999-12-31	1998-12-31	1997-12-31	1996-12-31	1996-03-29	1995-03-24
acceptedDate	2022-02-24 14:25:01	2021-02-25 13:59:00	2020-02-27 14:15:12	2019-02-28 14:35:32	2018-02-22 15:42:15	2017-02-23 16:30:32	2016-02-29 17:26:35	2015-02-27 16:38:16	2014-02-28 16:38:15	2013-02-28 16:57:54	...	2004-03-10 11:17:20	2003-03-27 15:04:15	2002-03-28 00:00:00	2001-03-28 00:00:00	1999-12-31	1998-12-31	1997-12-31	1996-12-31	1996-03-29 00:00:00	1995-03-24 00:00:00
calendarYear	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	...	2003	2002	2001	2000	1999	1998	1997	1996	1995	1994
period	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	...	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY
cashAndCashEquivalents	1944000000	1784000000	1305000000	1139000000	1342000000	2595000000	3641000000	3343000000	2183000000	10389000000	...	1520000000	1878000000	1036000000	1099000000	739000000	1552000000	877000000	1150000000	403300000	1458500000
shortTermInvestments	29125000000	10437000000	8525000000	17694000000	18650000000	15255000000	19649000000	32779000000	30225000000	22319000000	...	10432000000	10673000000	7579000000	5764000000	3703000000	0.0	0.0	0.0	0.0	0.0
cashAndShortTermInvestments	31069000000	12221000000	9830000000	18833000000	19992000000	17850000000	23290000000	36122000000	32408000000	32708000000	...	11952000000	12551000000	8615000000	6863000000	4442000000	1552000000	877000000	1150000000	403300000	1458500000
netReceivables	15745000000	11194000000	12068000000	11399000000	11271000000	11266000000	10838000000	8669000000	9357000000	21574000000	...	9166000000	6184000000	5337000000	5489000000	3864000000	2914000000	2527000000	2252000000	2024000000	1665000000
inventory	9059000000	8046000000	8283000000	7508000000	7578000000	6783000000	7513000000	5663000000	6166000000	7063000000	...	5837000000	2678000000	2741000000	2702000000	1654000000	1828000000	1773000000	1589000000	1384100000	1264900000
otherCurrentAssets	3820000000	3606000000	2622000000	12186000000	2300000000	3050000000	2163000000	7248000000	8313000000	70000000	...	2786000000	3368000000	1757000000	2133000000	1231000000	3637000000	1643000000	1477000000	2341000000	1400000000
totalCurrentAssets	59693000000	35067000000	32803000000	49926000000	41141000000	38949000000	43804000000	57702000000	56244000000	61415000000	...	29741000000	24781000000	18450000000	17187000000	11191000000	9931000000	6820000000	6468000000	6152400000	5788400000
propertyPlantEquipmentNet	14882000000	13900000000	13967000000	13385000000	13865000000	13318000000	13766000000	11762000000	12397000000	14461000000	...	18287000000	10712000000	10415000000	9425000000	5343000000	4415000000	4137000000	3850000000	3472600000	3073200000
goodwill	49208000000	49577000000	58653000000	53411000000	55952000000	54449000000	48242000000	42069000000	42519000000	44672000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
intangibleAssets	25146000000	28472000000	35369000000	35211000000	48740000000	52648000000	40358000000	35167000000	39385000000	46013000000	...	58656000000	1200000000	1722000000	1791000000	763000000	813000000	1294000000	1424000000	1243000000	325700000
goodwillAndIntangibleAssets	74354000000	78049000000	94022000000	88622000000	104692000000	107097000000	88600000000	77236000000	81904000000	90685000000	...	58656000000	1200000000	1722000000	1791000000	763000000	813000000	1294000000	1424000000	1243000000	325700000
longTermInvestments	21526000000	20262000000	20147000000	2767000000	7015000000	7116000000	15999000000	17518000000	16406000000	14149000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
taxAssets	3341000000	2383000000	2099000000	1924000000	1855000000	1812000000	1794000000	1544000000	1554000000	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
otherNonCurrentAssets	7679000000	4569000000	4450000000	2798000000	3227000000	3323000000	3497000000	3512000000	3596000000	5088000000	...	10091000000	9663000000	8566000000	5107000000	3277000000	3143000000	3085000000	2925000000	1861300000	1911200000
totalNonCurrentAssets	121782000000	119163000000	134685000000	109496000000	130654000000	132666000000	123656000000	111572000000	115857000000	124383000000	...	87034000000	21575000000	20703000000	16323000000	9383000000	8371000000	8516000000	8199000000	6576900000	5310100000
otherAssets	1000000.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
totalAssets	181476000000	154230000000	167488000000	159422000000	171795000000	171615000000	167460000000	169274000000	172101000000	185798000000	...	116775000000	46356000000	39153000000	33510000000	20574000000	18302000000	15336000000	14667000000	12729300000	11098500000
accountPayables	5578000000	4309000000	4220000000	4674000000	4656000000	4536000000	3620000000	3440000000	3234000000	4264000000	...	2601000000	1620000000	1579000000	1719000000	951000000	971000000	765000000	913000000	715300000	524900000
shortTermDebt	2241000000	2703000000	16190000000	8836000000	9940000000	10688000000	10160000000	5141000000	6027000000	6424000000	...	8818000000	8669000000	6265000000	4289000000	5001000000	2729000000	2255000000	2235000000	2035500000	2220000000
taxPayables	1266000000	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
deferredRevenue	3067000000	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
otherCurrentLiabilities	30519000000	18908000000	16894000000	18348000000	15831000000	15891000000	15619000000	13050000000	14105000000	17931000000	...	12238000000	8266000000	5796000000	5973000000	3233000000	3492000000	2285000000	2492000000	2436400000	2081000000
totalCurrentLiabilities	42671000000	25920000000	37304000000	31858000000	30427000000	31115000000	29399000000	21631000000	23366000000	28619000000	...	23657000000	18555000000	13640000000	11981000000	9185000000	7192000000	5305000000	5640000000	5187200000	4825900000
longTermDebt	34757000000	35571000000	35955000000	32429000000	32666000000	31398000000	28818000000	31541000000	30462000000	31036000000	...	5755000000	3140000000	2609000000	1123000000	525000000	527000000	1123000000	687000000	833000000	604200000
deferredRevenueNonCurrent	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
deferredTaxLiabilitiesNonCurrent	349000000	4063000000	5578000000	3700000000	3900000000	30753000000	26877000000	24981000000	25590000000	21593000000	...	13238000000	364000000	452000000	380000000	301000000	197000000	156000000	253000000	166100000	211700000
otherNonCurrentLiabilities	26237000000	25202000000	25205000000	27677000000	33148000000	18509000000	17368000000	19499000000	16063000000	22872000000	...	8748000000	4347000000	4159000000	3950000000	1676000000	1576000000	819000000	1083000000	989800000	1094000000
totalNonCurrentLiabilities	61343000000	64836000000	66738000000	63806000000	69714000000	80660000000	73063000000	76021000000	72115000000	75501000000	...	27741000000	7851000000	7220000000	5453000000	2502000000	2300000000	2098000000	2023000000	1988900000	1909900000
otherLiabilities	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
capitalLeaseObligations	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0	0	0	0	0	0	0	0
totalLiabilities	104014000000	90756000000	104042000000	95664000000	100141000000	111775000000	102462000000	97652000000	95481000000	104120000000	...	51398000000	26406000000	20860000000	17434000000	11687000000	9492000000	7403000000	7663000000	7176100000	6735800000
preferredStock	0.0	0.0	17000000	19000000	21000000	24000000	26000000	29000000	33000000	39000000	...	219000000	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
commonStock	473000000	470000000	468000000	467000000	464000000	461000000	459000000	455000000	453000000	448000000	...	435000000	341000000	340000000	337000000	213000000	0.0	0.0	0.0	0.0	0.0
retainedEarnings	103394000000	96770000000	97670000000	89554000000	85291000000	71774000000	71993000000	72176000000	69732000000	54240000000	...	29382000000	30243000000	24430000000	19599000000	13396000000	11439000000	9349000000	8017000000	6858900000	5944500000
accumulatedOtherComprehensiveIncomeLoss	-5897000000	-14812000000	-11640000000	-11275000000	-9321000000	-11036000000	-9522000000	-7316000000	-3271000000	-5953000000	...	-7094000000	-5431000000	-5133000000	-4709000000	-2074000000	-2429000000	-1990000000	-2155000000	-1990800000	-1919700000
othertotalStockholdersEquity	-20769000000	-19190000000	-23372000000	-15358000000	-5147000000	-1679000000	1764000000	5957000000	9360000000	32486000000	...	42435000000	-5203000000	-1344000000	849000000	-2648000000	-200000000	574000000	1092000000	638500000	299100000
totalStockholdersEquity	77201000000	63238000000	63143000000	63407000000	71308000000	59544000000	64720000000	71301000000	76307000000	81260000000	...	65377000000	19950000000	18293000000	16076000000	8887000000	8810000000	7933000000	6954000000	5506600000	4323900000
totalLiabilitiesAndStockholdersEquity	181215000000	153994000000	167185000000	159071000000	171449000000	171319000000	167182000000	168953000000	171788000000	185380000000	...	116775000000	46356000000	39153000000	33510000000	20574000000	18302000000	15336000000	14617000000	12682700000	11059700000
minorityInterest	261000000	236000000	303000000	351000000	346000000	296000000	278000000	321000000	313000000	418000000	...	0	0	0	0	0	0	0	50000000	46600000	38800000
totalEquity	77462000000	63474000000	63446000000	63758000000	71654000000	59840000000	64998000000	71622000000	76620000000	81678000000	...	65377000000	19950000000	18293000000	16076000000	8887000000	8810000000	7933000000	7004000000	5553200000	4362700000
totalLiabilitiesAndTotalEquity	181476000000	154230000000	167488000000	159422000000	171795000000	171615000000	167460000000	169274000000	172101000000	185798000000	...	116775000000	46356000000	39153000000	33510000000	20574000000	18302000000	15336000000	14667000000	12729300000	11098500000
totalInvestments	50651000000	30699000000	28672000000	20461000000	25665000000	22371000000	35648000000	50297000000	46631000000	36468000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
totalDebt	36998000000	38274000000	52145000000	41265000000	42606000000	42086000000	38978000000	36682000000	36489000000	37460000000	...	14573000000	11809000000	8874000000	5412000000	5526000000	3256000000	3378000000	2922000000	2868500000	2824200000
netDebt	35054000000	36490000000	50840000000	40126000000	41264000000	39491000000	35337000000	33339000000	34306000000	27071000000	...	13053000000	9931000000	7838000000	4313000000	4787000000	1704000000	2501000000	1772000000	2465200000	1365700000
link	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...					https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...
finalLink	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...					https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...

52 rows × 28 columns

company_is = fa.income_statement(ticker=my_ticker, api_key=my_api_key)
company_is

	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	...	1994	1993	1992	1991	1990	1989	1988	1987	1986	1985
reportedCurrency	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	...	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD
cik	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	...	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003
fillingDate	2022-02-24	2021-02-25	2020-02-27	2019-02-28	2018-02-22	2017-02-23	2016-02-29	2015-02-27	2014-02-28	2013-02-28	...	1995-03-24	1993-12-31	1992-12-31	1991-12-31	1990-12-31	1989-12-31	1988-12-31	1987-12-31	1986-12-31	1985-12-31
acceptedDate	2022-02-24 14:25:01	2021-02-25 13:59:00	2020-02-27 14:15:12	2019-02-28 14:35:32	2018-02-22 15:42:15	2017-02-23 16:30:32	2016-02-29 17:26:35	2015-02-27 16:38:16	2014-02-28 16:38:15	2013-02-28 16:57:54	...	1995-03-24 00:00:00	1993-12-31	1992-12-31	1991-12-31	1990-12-31	1989-12-31	1988-12-31	1987-12-31	1986-12-31	1985-12-31
calendarYear	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	...	1994	1993	1992	1991	1990	1989	1988	1987	1986	1985
period	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	...	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY
revenue	81288000000	41908000000	51750000000	53647000000	52546000000	52824000000	48851000000	49605000000	51584000000	58986000000	...	8281300000	7477700000	7230200000	6950000000	6406000000	5671500000	5385400000	4919800000	4476000000	4024500000
costOfRevenue	30821000000	8692000000	10219000000	11248000000	11240000000	12329000000	9648000000	9577000000	9586000000	11334000000	...	1626600000	1513800000	1760400000	1956500000	2034600000	1855200000	1825600000	1734900000	1573300000	1416200000
grossProfit	50467000000	33216000000	41531000000	42399000000	41306000000	40495000000	39203000000	40028000000	41998000000	47652000000	...	6654700000	5963900000	5469800000	4993500000	4371400000	3816300000	3559800000	3184900000	2902700000	2608300000
grossProfitRatio	0.620842	0.792593	0.802531	0.790333	0.786092	0.766602	0.802501	0.806935	0.814167	0.807853	...	0.803582	0.797558	0.756521	0.718489	0.682392	0.672891	0.661009	0.647364	0.648503	0.648105
researchAndDevelopmentExpenses	13829000000	9405000000	8650000000	8006000000	7657000000	7872000000	7690000000	8393000000	6678000000	7870000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
generalAndAdministrativeExpenses	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	4390200000	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
sellingAndMarketingExpenses	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
sellingGeneralAndAdministrativeExpenses	12703000000	11615000000	14350000000	14455000000	14784000000	14837000000	14809000000	14097000000	14355000000	16616000000	...	4390200000	4792400000	3762500000	3495900000	3092800000	2641000000	2353400000	2082100000	1795900000	1598800000
otherExpenses	3700000000	3436000000	4610000000	4893000000	4758000000	4056000000	3728000000	4039000000	4599000000	5175000000	...	292000000	258200000	263900000	244100000	224800000	207100000	194500000	162000000	147100000	129500000
operatingExpenses	30232000000	24456000000	27610000000	27354000000	27199000000	26765000000	26227000000	26529000000	25632000000	29661000000	...	4682200000	5050600000	4026400000	3740000000	3317600000	2848100000	2547900000	2244100000	1943000000	1728300000
costAndExpenses	61053000000	33148000000	37829000000	38602000000	38439000000	39094000000	35875000000	36106000000	35218000000	40995000000	...	6308800000	6564400000	5786800000	5696500000	5352200000	4703300000	4373500000	3979000000	3516300000	3144500000
interestIncome	36000000	73000000	226000000	333000000	391000000	470000000	471000000	425000000	403000000	383000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
interestExpense	1291000000	1449000000	1574000000	1316000000	1270000000	1186000000	1199000000	1360000000	1414000000	1524000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
depreciationAndAmortization	5191000000	4777000000	6010000000	6384000000	6269000000	5757000000	5157000000	5537000000	6410000000	7611000000	...	292000000	258200000	263900000	244100000	224800000	207100000	194500000	162000000	147100000	129500000
ebitda	30313000000	16319000000	25241000000	19559000000	19798000000	15281000000	15306000000	19152000000	34133000000	26267000000	...	2148900000	1107000000	1513400000	1184600000	1323900000	1119500000	1295200000	1169500000	1107800000	1005600000
ebitdaratio	0.372909	0.389401	0.487749	0.364587	0.376775	0.289281	0.31332	0.38609	0.661697	0.445309	...	0.259488	0.14804	0.209316	0.170446	0.206666	0.19739	0.240502	0.237713	0.247498	0.24987
operatingIncome	20235000000	8760000000	13921000000	15045000000	14107000000	13730000000	12976000000	13499000000	16366000000	17991000000	...	1972500000	913300000	1443400000	1253500000	1053800000	968200000	1011900000	940800000	959700000	880000000
operatingIncomeRatio	0.24893	0.209029	0.269005	0.280444	0.26847	0.25992	0.265624	0.27213	0.317269	0.305005	...	0.238187	0.122136	0.199635	0.18036	0.164502	0.170713	0.187897	0.191227	0.21441	0.218661
totalOtherIncomeExpensesNet	4076000000	-1263000000	3761000000	-3160000000	-1802000000	-5379000000	-4011000000	-1259000000	-650000000	-5911000000	...	-115600000	-64500000	88700000	-313000000	45300000	-55800000	88800000	66700000	1000000.0	-3900000.0
incomeBeforeTax	24311000000	7497000000	17682000000	11885000000	12305000000	8351000000	8965000000	12240000000	15716000000	12080000000	...	1856900000	848800000	1532100000	940500000	1099100000	912400000	1100700000	1007500000	960700000	876100000
incomeBeforeTaxRatio	0.299072	0.178892	0.341681	0.221541	0.234176	0.158091	0.183517	0.246749	0.304668	0.204794	...	0.224228	0.113511	0.211903	0.135324	0.171574	0.160875	0.204386	0.204785	0.214634	0.217692
incomeTaxExpense	1852000000	477000000	1384000000	706000000	-9049000000	1123000000	1990000000	3120000000	4306000000	2562000000	...	558500000	191300000	438600000	218400000	297900000	231300000	309400000	317300000	300700000	296400000
netIncome	21979000000	9616000000	16273000000	11153000000	21308000000	7215000000	6960000000	9135000000	22003000000	14570000000	...	1298400000	657500000	810900000	722100000	801200000	681100000	791300000	690200000	660000000	579700000
netIncomeRatio	0.270384	0.229455	0.314454	0.207896	0.405511	0.136586	0.142474	0.184155	0.426547	0.247008	...	0.156787	0.087928	0.112155	0.103899	0.12507	0.120092	0.146934	0.14029	0.147453	0.144043
eps	3.92	1.73	2.92	1.9	3.57	1.18	1.13	1.44	3.23	1.96	...	0.349167	0.17	0.21	0.19	0.21	0.16	0.19	0.17	0.16	0.14
epsdiluted	3.85	1.71	2.87	1.87	3.52	1.17	1.11	1.42	3.19	1.94	...	0.349167	0.17	0.2	0.18	0.21	0.16	0.19	0.17	0.16	0.14
weightedAverageShsOut	5601000000	5555000000	5569000000	5872000000	5970000000	6089000000	6176000000	6346000000	6813000000	7442000000	...	3718568019	3867647059	3861428571	3800526316	3815238095	4256875000	4164736842	4060000000	4125000000	4140714286
weightedAverageShsOutDil	5708000000	5632000000	5675000000	5977000000	6058000000	6159000000	6257000000	6424000000	6895000000	7508000000	...	3718568019	3867647059	4054500000	4011666667	3815238095	4256875000	4164736842	4060000000	4125000000	4140714286
link	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	...	https://www.sec.gov/Archives/edgar/data/78003/...
finalLink	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	...	https://www.sec.gov/Archives/edgar/data/78003/...

36 rows × 37 columns

company_cf = fa.cash_flow_statement(ticker=my_ticker, api_key=my_api_key)
company_cf

	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	...	1998	1997	1996	1995	1994	1993	1992	1991	1990	1989
reportedCurrency	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	...	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD
cik	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	...	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003	0000078003
fillingDate	2022-02-24	2021-02-25	2020-02-27	2019-02-28	2018-02-22	2017-02-23	2016-02-29	2015-02-27	2014-02-28	2013-02-28	...	1998-12-31	1997-12-31	1996-12-31	1996-03-29	1995-03-24	1993-12-31	1992-12-31	1991-12-31	1990-12-31	1989-12-31
acceptedDate	2022-02-24 14:25:01	2021-02-25 13:59:00	2020-02-27 14:15:12	2019-02-28 14:35:32	2018-02-22 15:42:15	2017-02-23 16:30:32	2016-02-29 17:26:35	2015-02-27 16:38:16	2014-02-28 16:38:15	2013-02-28 16:57:54	...	1998-12-31	1997-12-31	1996-12-31	1996-03-29 00:00:00	1995-03-24 00:00:00	1993-12-31	1992-12-31	1991-12-31	1990-12-31	1989-12-31
calendarYear	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	...	1998	1997	1996	1995	1994	1993	1992	1991	1990	1989
period	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	...	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY
netIncome	21979000000	9616000000	16273000000	11153000000	21308000000	7215000000	6960000000	9135000000	22003000000	14570000000	...	3351000000	2213000000	1929000000	1572900000	1298400000	657500000	810900000	722100000	801200000	681100000
depreciationAndAmortization	5191000000	4777000000	6010000000	6384000000	6269000000	5757000000	5157000000	5537000000	6410000000	7611000000	...	489000000	502000000	430000000	374000000	292000000	258200000	263900000	244100000	224800000	207100000
deferredIncomeTax	-4293000000	-1468000000	614000000	-2205000000	-2410000000	-700000000	-18000000	317000000	1703000000	2198000000	...	-61000000	24000000	75000000	-12900000	32600000	-336100000	0.0	0.0	0.0	0.0
stockBasedCompensation	1182000000	756000000	718000000	949000000	840000000	691000000	669000000	586000000	523000000	481000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
changeInWorkingCapital	12804000000	-275000000	-4031000000	-926000000	1296000000	85000000	564000000	1423000000	-3392000000	-1942000000	...	224000000	-1110000000	-381000000	-77600000	-128600000	-79600000	-370600000	-342700000	-59400000	-223100000
accountsReceivables	-3811000000	-1249000000	-742000000	-644000000	259000000	-134000000	21000000	148000000	940000000	275000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
inventory	-1125000000	-736000000	-1050000000	-717000000	-357000000	365000000	-199000000	175000000	-538000000	-631000000	...	-439000000	-375000000	-149000000	-24600000	-110800000	-142300000	-116100000	-118000000	-38800000	-77100000
accountsPayables	1242000000	353000000	-564000000	431000000	46000000	871000000	254000000	297000000	382000000	579000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
otherWorkingCapital	-1166000000	-1238000000	-2737000000	-78000000	1446000000	-734000000	-235000000	491000000	-170000000	1190000000	...	2739000000	1515000000	828000000	965200000	962500000	0.0	0.0	0.0	0.0	0.0
otherNonCashItems	-4283000000	997000000	-6996000000	472000000	-10833000000	2853000000	1180000000	-115000000	-9482000000	-5864000000	...	-1074000000	0.0	14000000	-35000000	-5900000.0	763000000	102800000	224100000	-106100000	-9300000.0
netCashProvidedByOperatingActivities	32580000000	14403000000	12588000000	15827000000	16470000000	15901000000	14512000000	16883000000	17765000000	17054000000	...	2929000000	1629000000	2067000000	1821400000	1488500000	1263000000	807000000	847600000	860500000	655800000
investmentsInPropertyPlantAndEquipment	-2711000000	-2252000000	-2176000000	-2042000000	-1956000000	-1823000000	-1397000000	-1199000000	-1206000000	-1327000000	...	-1198000000	-943000000	-774000000	-696300000	-671500000	-634200000	-674200000	-593800000	-547500000	-456500000
acquisitionsNet	0.0	0.0	-10861000000	0.0	-1000000000	-18368000000	-16466000000	-195000000	-15000000	10800000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
purchasesOfInvestments	-47613000000	-14402000000	-7036000000	-13474000000	-18133000000	-28186000000	-38123000000	-61672000000	-58058000000	-35163000000	...	-5845000000	-317000000	-2862000000	-2610400000	-1355900000	-760900000	-535700000	-210600000	-89600000	-526900000
salesMaturitiesOfInvestments	28096000000	12730000000	16340000000	19908000000	15959000000	40690000000	52761000000	57449000000	48682000000	31751000000	...	4209000000	217000000	3490000000	2184600000	1288200000	846800000	510800000	242400000	197200000	449800000
otherInvestingActivites	-318000000	-347000000	-212000000	133000000	389000000	-124000000	245000000	-37000000	-28000000	93000000	...	2499000000	21000000	-791000000	-1220700000	-101100000	351400000	1089000000	436800000	110900000	-93200000
netCashUsedForInvestingActivites	-22546000000	-4271000000	-3945000000	4525000000	-4741000000	-7811000000	-2980000000	-5654000000	-10625000000	6154000000	...	-335000000	-1022000000	-937000000	-2342800000	-840300000	-196900000	389900000	-125200000	-329000000	-626800000
debtRepayment	-2100000000	-30329000000	-12633000000	-9620000000	-14743000000	-15875000000	-6968000000	-3955000000	-8380000000	-9720000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
commonStockIssued	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	...	643000000	411000000	280000000	205000000	64200000	0.0	0.0	0.0	0.0	0.0
commonStockRepurchased	0.0	0.0	-8865000000	-12198000000	-5000000000	-5000000000	-6160000000	-5000000000	-16290000000	-8228000000	...	-1912000000	-586000000	-27000000	-108500000	-511200000	-1019600000	-665100000	-463900000	-132200000	-154700000
dividendsPaid	-8729000000	-8440000000	-8043000000	-7978000000	-7659000000	-7317000000	-6940000000	-6609000000	-6580000000	-6534000000	...	-976000000	-881000000	-771000000	-658500000	-594600000	-536100000	-486500000	-437100000	-396700000	-364000000
otherFinancingActivites	1013000000	29120000000	21056000000	9355000000	14367000000	19271000000	9835000000	5578000000	16275000000	8483000000	...	325000000	208000000	136000000	42900000	1103500000	-11300000	-76400000	638400000	29000000	657500000
netCashUsedProvidedByFinancingActivities	-9816000000	-9649000000	-8485000000	-20441000000	-13035000000	-8921000000	-10233000000	-9986000000	-14975000000	-15999000000	...	-1920000000	-848000000	-382000000	-519100000	61900000	-1567000000	-1228000000	-262600000	-499900000	138800000
effectOfForexChangesOnCash	-59000000	-8000000.0	-32000000	-116000000	53000000	-215000000	-1000000000	-83000000	-63000000	-2000000.0	...	1000000.0	-32000000	-1000000.0	-14700000	19000000	-26800000	-29400000	-12500000	13300000	-9000000.0
netChangeInCash	158000000	475000000	125000000	-206000000	-1253000000	-1046000000	298000000	1160000000	-7898000000	7207000000	...	-1920000000	-848000000	-382000000	-519100000	61900000	-1567000000	-1228000000	-262600000	-499900000	138800000
cashAtEndOfPeriod	1983000000	1825000000	1350000000	1225000000	1342000000	2595000000	3641000000	3343000000	2183000000	10389000000	...	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
cashAtBeginningOfPeriod	1825000000	1350000000	1225000000	1431000000	2595000000	3641000000	3343000000	2183000000	10081000000	3182000000	...	877000000	1150000000	403000000	1458500000	729400000	1257100000	1317600000	870300000	825400000	666600000
operatingCashFlow	32580000000	14403000000	12588000000	15827000000	16470000000	15901000000	14512000000	16883000000	17765000000	17054000000	...	2929000000	1629000000	2067000000	1821400000	1488500000	1263000000	807000000	847600000	860500000	655800000
capitalExpenditure	-2711000000	-2791000000	-2594000000	-2196000000	-2217000000	-1999000000	-1496000000	-1583000000	-1465000000	-1327000000	...	-1198000000	-943000000	-774000000	-696300000	-671500000	-634200000	-674200000	-593800000	-547500000	-456500000
freeCashFlow	29869000000	11612000000	9994000000	13631000000	14253000000	13902000000	13016000000	15300000000	16300000000	15727000000	...	1731000000	686000000	1293000000	1125100000	817000000	628800000	132800000	253800000	313000000	199300000
link	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	...				https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...
finalLink	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...	...				https://www.sec.gov/Archives/edgar/data/78003/...	https://www.sec.gov/Archives/edgar/data/78003/...

38 rows × 33 columns

Financial ratios#

company_ratios = fa.financial_ratios(ticker=my_ticker, api_key=my_api_key)
company_ratios

	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	...	2003	2002	2001	2000	1999	1998	1997	1996	1995	1994
period	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	...	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY
currentRatio	1.398913	1.352894	0.879343	1.567142	1.352121	1.251776	1.489983	2.66756	2.407087	2.145952	...	1.257175	1.335543	1.352639	1.434521	1.2184	1.38084	1.28558	1.146809	1.186073	1.199445
quickRatio	1.097092	0.903356	0.587015	0.948961	1.027476	0.935754	1.160856	2.070686	1.787426	1.896712	...	0.892674	1.009701	1.022874	1.030966	0.9043	0.620968	0.641659	0.603191	0.46794	0.647237
cashRatio	0.045558	0.068827	0.034983	0.035752	0.044106	0.0834	0.123848	0.154547	0.093426	0.363011	...	0.064252	0.101213	0.075953	0.091729	0.080457	0.215795	0.165316	0.203901	0.077749	0.302223
daysOfSalesOutstanding	70.69832	97.49475	85.117295	77.555781	78.291687	77.845108	80.978281	63.787622	66.208611	133.497949	...	74.037134	69.723535	60.386404	67.74481	87.037768	78.529976	73.764795	72.70299	73.718243	73.385217
daysOfInventoryOutstanding	107.281886	337.872757	295.850377	243.636202	246.08274	200.81069	284.229374	215.82907	234.778844	227.456767	...	216.690907	241.648949	198.741557	242.973639	303.98288	415.713396	365.205982	332.179267	282.216915	283.83653
operatingCycle	177.980205	435.367507	380.967671	321.191983	324.374427	278.655799	365.207655	279.616692	300.987455	360.954716	...	290.728041	311.372484	259.127961	310.718448	391.020649	494.243372	438.970777	404.882256	355.935158	357.221747
daysOfPayablesOutstanding	66.057883	180.946272	150.729034	151.672297	151.19573	134.288263	136.950663	131.105774	123.138953	137.317805	...	96.558686	146.18047	114.488478	154.578714	174.780967	220.819315	157.576185	190.86197	145.849115	117.784643
cashConversionCycle	111.922323	254.421235	230.238637	169.519686	173.178698	144.367535	228.256992	148.510918	177.848503	223.636911	...	194.169355	165.192015	144.639483	156.139734	216.239682	273.424057	281.394592	214.020286	210.086044	239.437105
grossProfitMargin	0.620842	0.792593	0.802531	0.790333	0.786092	0.766602	0.802501	0.806935	0.814167	0.807853	...	0.78242	0.87505	0.843951	0.862751	0.877438	0.881497	0.858285	0.845569	0.821372	0.803582
operatingProfitMargin	0.24893	0.209029	0.269005	0.280444	0.26847	0.25992	0.265624	0.27213	0.317269	0.305005	...	0.239002	0.379267	0.340246	0.293163	0.280733	0.266022	0.267594	0.272422	0.255473	0.238187
pretaxProfitMargin	0.299072	0.178892	0.341681	0.221541	0.234176	0.158091	0.183517	0.246749	0.304668	0.204794	...	0.072209	0.364378	0.32019	0.195002	0.274192	0.191376	0.246161	0.247479	0.228731	0.224228
netProfitMargin	0.270384	0.229455	0.314454	0.207896	0.405511	0.136586	0.142474	0.184155	0.426547	0.247008	...	0.086527	0.281902	0.241421	0.125989	0.196186	0.247416	0.176983	0.170617	0.156954	0.156787
effectiveTaxRate	0.07618	0.063625	0.078272	0.059403	-0.735392	0.134475	0.221974	0.254902	0.273988	0.212086	...	0.496782	0.221177	0.247943	0.355297	0.279991	0.247685	0.281027	0.310579	0.321961	0.30077
returnOnAssets	0.121112	0.062348	0.097159	0.069959	0.124032	0.042042	0.041562	0.053966	0.127849	0.078418	...	0.033483	0.196868	0.198912	0.111191	0.154515	0.183095	0.144301	0.13152	0.123565	0.116989
returnOnEquity	0.284698	0.15206	0.257717	0.175895	0.298816	0.121171	0.10754	0.128119	0.288348	0.179301	...	0.059807	0.457444	0.425737	0.231774	0.357714	0.380363	0.278961	0.277394	0.285639	0.300284
returnOnCapitalEmployed	0.14578	0.068272	0.106933	0.117941	0.099789	0.097722	0.093987	0.09143	0.110035	0.114462	...	0.115982	0.441639	0.430212	0.402713	0.39942	0.324302	0.333566	0.341199	0.339455	0.314463
netIncomePerEBT	0.904076	1.282646	0.920314	0.93841	1.731654	0.863968	0.776352	0.746324	1.400038	1.206126	...	1.198284	0.773652	0.753994	0.64609	0.715508	1.292824	0.718973	0.689421	0.686197	0.69923
ebtPerEbit	1.201433	0.855822	1.270167	0.789963	0.872262	0.60823	0.690891	0.906734	0.960284	0.671447	...	0.30213	0.960743	0.941053	0.665167	0.976698	0.7194	0.919904	0.908442	0.895321	0.941394
ebitPerRevenue	0.24893	0.209029	0.269005	0.280444	0.26847	0.25992	0.265624	0.27213	0.317269	0.305005	...	0.239002	0.379267	0.340246	0.293163	0.280733	0.266022	0.267594	0.272422	0.255473	0.238187
debtRatio	0.573156	0.588446	0.621191	0.600068	0.58291	0.651313	0.61186	0.576887	0.554796	0.560394	...	0.440146	0.569635	0.532782	0.520263	0.568047	0.518632	0.48272	0.522465	0.563747	0.606911
debtEquityRatio	1.347314	1.43515	1.64772	1.508729	1.404345	1.877183	1.583158	1.369574	1.251274	1.281319	...	0.786179	1.323609	1.140327	1.084474	1.315067	1.077412	0.93319	1.101956	1.303182	1.557807
longTermDebtToCapitalization	0.310447	0.359998	0.362823	0.33838	0.314175	0.345253	0.308089	0.306694	0.285308	0.276377	...	0.080906	0.13599	0.124821	0.065294	0.05578	0.056442	0.124006	0.08991	0.131396	0.122603
totalDebtToCapitalization	0.323978	0.377039	0.452302	0.394232	0.374019	0.41411	0.37588	0.339702	0.323496	0.315532	...	0.182276	0.371832	0.326646	0.251862	0.383404	0.269849	0.298647	0.295869	0.342503	0.395098
interestCoverage	15.673896	6.045549	8.844346	11.432371	11.107874	11.576728	10.822352	9.925735	11.574257	11.805118	...	None	None	None	None	None	None	None	None	None	None
cashFlowToDebtRatio	0.880588	0.376313	0.241404	0.383545	0.386565	0.377822	0.372313	0.460253	0.486859	0.455259	...	0.805531	0.862308	1.043836	1.144678	0.553022	0.89957	0.482238	0.707392	0.634966	0.527052
companyEquityMultiplier	2.350695	2.438882	2.652519	2.514265	2.409197	2.882154	2.587454	2.374076	2.255376	2.286463	...	1.786179	2.323609	2.140327	2.084474	2.315067	2.077412	1.93319	2.109146	2.311644	2.56678
receivablesTurnover	5.162782	3.743791	4.2882	4.70629	4.662053	4.688798	4.507381	5.722113	5.512878	2.734124	...	4.929959	5.234961	6.044407	5.387867	4.193582	4.647907	4.94816	5.020426	4.951285	4.973754
payablesTurnover	5.525457	2.017173	2.421564	2.406504	2.414089	2.718034	2.665193	2.784012	2.964131	2.658068	...	3.780085	2.496914	3.188094	2.361257	2.088328	1.652935	2.31634	1.912377	2.502586	3.098876
inventoryTurnover	3.402252	1.080288	1.233732	1.498135	1.483241	1.817632	1.284174	1.691153	1.554655	1.604701	...	1.684427	1.510456	1.836556	1.502221	1.200726	0.878009	0.999436	1.098804	1.293331	1.285951
fixedAssetTurnover	5.462169	3.014964	3.705162	4.007994	3.789831	3.966361	3.548671	4.217395	4.161007	4.078971	...	2.471045	3.022125	3.09736	3.137825	3.032753	3.067724	3.02248	2.936623	2.885849	2.694683
assetTurnover	0.447927	0.271724	0.308977	0.336509	0.305865	0.307805	0.291717	0.293046	0.299731	0.317474	...	0.386966	0.698356	0.823922	0.882543	0.787596	0.740028	0.815336	0.770846	0.78727	0.746164
operatingCashFlowPerShare	5.816818	2.592799	2.26037	2.695334	2.758794	2.61143	2.349741	2.660416	2.607515	2.291588	...	1.627478	1.654159	1.484693	0.997585	0.809536	0.773027	0.431981	0.534938	0.482495	0.400288
freeCashFlowPerShare	5.332798	2.090369	1.794577	2.321356	2.387437	2.283134	2.107513	2.410968	2.392485	2.113276	...	1.261334	1.368583	1.131592	0.644767	0.396026	0.456849	0.181915	0.334627	0.298043	0.219708
cashPerShare	5.547045	2.2	1.765128	3.207255	3.348744	2.931516	3.771049	5.69209	4.756788	4.395055	...	1.657008	2.038824	1.38083	1.105153	1.176689	0.409607	0.232564	0.297619	0.106836	0.392221
payoutRatio	0.397152	0.877704	0.494254	0.715323	0.359442	1.014137	0.997126	0.723481	0.29905	0.448456	...	1.113299	0.34714	0.348613	0.58964	0.36112	0.291256	0.398102	0.399689	0.418653	0.457948
operatingCashFlowSalesRatio	0.400797	0.343681	0.243246	0.295021	0.31344	0.301018	0.297067	0.340349	0.34439	0.289119	...	0.259781	0.314552	0.287145	0.209475	0.188595	0.216258	0.130278	0.182823	0.181751	0.179742
freeCashFlowOperatingCashFlowRatio	0.916789	0.806221	0.793931	0.86125	0.865392	0.874285	0.896913	0.906237	0.917534	0.922188	...	0.775023	0.827359	0.762172	0.646328	0.489202	0.590987	0.421117	0.625544	0.617712	0.548875
cashFlowCoverageRatios	0.880588	0.376313	0.241404	0.383545	0.386565	0.377822	0.372313	0.460253	0.486859	0.455259	...	0.805531	0.862308	1.043836	1.144678	0.553022	0.89957	0.482238	0.707392	0.634966	0.527052
shortTermCoverageRatios	14.538153	5.328524	0.777517	1.791195	1.656942	1.487743	1.428346	3.283991	2.947569	2.654732	...	1.331254	1.174645	1.478532	1.444393	0.611078	1.073287	0.722395	0.924832	0.894817	0.670495
capitalExpenditureCoverageRatio	-12.017706	-5.160516	-4.852737	-7.207195	-7.428958	-7.954477	-9.700535	-10.665193	-12.12628	-12.851545	...	-4.444907	-5.792378	-4.204721	-2.827476	-1.957719	-2.444908	-1.727466	-2.670543	-2.615827	-2.216679
dividendPaidAndCapexCoverageRatio	5.413759	2.549655	2.310149	2.737288	3.026461	2.990034	2.665687	3.359133	3.473118	3.275206	...	6.856893	7.221986	18.091797	1032.5	-7.399516	-13.193694	-26.274194	-689.0	-48.185185	-19.356307
dividendPayoutRatio	0.397152	0.877704	0.494254	0.715323	0.359442	1.014137	0.997126	0.723481	0.29905	0.448456	...	1.113299	0.34714	0.348613	0.58964	0.36112	0.291256	0.398102	0.399689	0.418653	0.457948
priceBookValueRatio	3.941689	3.153555	3.101944	3.653362	3.002529	3.037739	2.760486	2.638845	2.610755	2.390357	...	3.83431	8.697967	13.347914	16.228584	14.181088	17.49493	12.289804	7.973651	7.303579	5.439616
priceToBookRatio	3.941689	3.153555	3.101944	3.653362	3.002529	3.037739	2.760486	2.638845	2.610755	2.390357	...	3.83431	8.697967	13.347914	16.228584	14.181088	17.49493	12.289804	7.973651	7.303579	5.439616
priceToSalesRatio	3.743509	4.758626	3.784851	4.318018	4.074608	3.424184	3.657216	3.79301	3.862028	3.292992	...	5.547396	5.36016	7.569156	8.821624	7.777545	11.379972	7.797106	4.904366	4.013201	2.840177
priceEarningsRatio	13.84514	20.738822	12.03626	20.770082	10.048074	25.06987	25.66935	20.596856	9.054168	13.331533	...	64.111436	19.014294	31.352516	70.018978	39.643703	45.995325	44.055588	28.744824	25.56926	18.114876
priceToFreeCashFlowsRatio	10.187898	17.174002	19.598364	16.994258	15.021705	13.011014	13.726082	12.297534	12.222015	12.350762	...	27.552838	20.596373	34.585466	65.157521	84.299219	89.04121	142.121016	42.88381	35.746057	28.788684
priceToOperatingCashFlowsRatio	9.340158	13.84604	15.559744	14.6363	12.999657	11.375329	12.3111	11.144481	11.21412	11.389729	...	21.354095	17.040602	26.360077	42.113109	41.23931	52.62217	59.849612	26.825721	22.080756	15.801381
priceCashFlowRatio	9.340158	13.84604	15.559744	14.6363	12.999657	11.375329	12.3111	11.144481	11.21412	11.389729	...	21.354095	17.040602	26.360077	42.113109	41.23931	52.62217	59.849612	26.825721	22.080756	15.801381
priceEarningsToGrowthRatio	0.10937	-0.508885	0.224205	-0.444007	0.04961	5.665791	-1.192383	-0.371664	0.139734	0.250946	...	-1.009414	1.033386	0.289408	-2.450664	-8.081276	0.909573	2.48538	1.466586	1.322658	0.17188
priceSalesRatio	3.743509	4.758626	3.784851	4.318018	4.074608	3.424184	3.657216	3.79301	3.862028	3.292992	...	5.547396	5.36016	7.569156	8.821624	7.777545	11.379972	7.797106	4.904366	4.013201	2.840177
dividendYield	0.028685	0.042322	0.041064	0.03444	0.035772	0.040452	0.038845	0.035126	0.033029	0.033639	...	0.017365	0.018257	0.011119	0.008421	0.009109	0.006332	0.009036	0.013905	0.016373	0.02528
enterpriseValueMultiple	11.195076	14.456432	9.774021	13.895124	12.898695	14.421184	13.981163	11.564916	6.841615	8.425455	...	27.446011	14.365002	22.073346	39.330226	26.347297	34.768928	27.931848	17.726384	15.897459	11.580834
priceFairValue	3.941689	3.153555	3.101944	3.653362	3.002529	3.037739	2.760486	2.638845	2.610755	2.390357	...	3.83431	8.697967	13.347914	16.228584	14.181088	17.49493	12.289804	7.973651	7.303579	5.439616

55 rows × 28 columns

Key metrics#

key_metrics = fa.key_metrics(ticker=my_ticker, api_key=my_api_key)
key_metrics

	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	...	2003	2002	2001	2000	1999	1998	1997	1996	1995	1994
period	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	...	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY
revenuePerShare	14.513123	7.544194	9.292512	9.136069	8.801675	8.675316	7.909812	7.816735	7.571408	7.926095	...	6.2648	5.258772	5.17054	4.762319	4.29245	3.574558	3.315831	2.925983	2.654704	2.227013
netIncomePerShare	3.924121	1.731053	2.922069	1.899353	3.569179	1.184924	1.126943	1.439489	3.229561	1.957807	...	0.542077	1.482456	1.248277	0.6	0.842119	0.884402	0.586847	0.499224	0.416667	0.349167
operatingCashFlowPerShare	5.816818	2.592799	2.26037	2.695334	2.758794	2.61143	2.349741	2.660416	2.607515	2.291588	...	1.627478	1.654159	1.484693	0.997585	0.809536	0.773027	0.431981	0.534938	0.482495	0.400288
freeCashFlowPerShare	5.332798	2.090369	1.794577	2.321356	2.387437	2.283134	2.107513	2.410968	2.392485	2.113276	...	1.261334	1.368583	1.131592	0.644767	0.396026	0.456849	0.181915	0.334627	0.298043	0.219708
cashPerShare	5.547045	2.2	1.765128	3.207255	3.348744	2.931516	3.771049	5.69209	4.756788	4.395055	...	1.657008	2.038824	1.38083	1.105153	1.176689	0.409607	0.232564	0.297619	0.106836	0.392221
bookValuePerShare	13.783432	11.383978	11.338301	10.798195	11.944389	9.778946	10.479275	11.235581	11.200205	10.919108	...	9.063774	3.240741	2.93204	2.588728	2.354172	2.325152	2.103686	1.799689	1.458717	1.162786
tangibleBookValuePerShare	0.554901	-2.623762	-5.490393	-4.234332	-5.534003	-7.761045	-3.821567	-0.884652	-0.775576	-1.210293	...	0.93179	3.045809	2.656035	2.300322	2.152053	2.110583	1.760541	1.444099	1.141787	1.085633
shareholdersEquityPerShare	13.783432	11.383978	11.338301	10.798195	11.944389	9.778946	10.479275	11.235581	11.200205	10.919108	...	9.063774	3.240741	2.93204	2.588728	2.354172	2.325152	2.103686	1.799689	1.458717	1.162786
interestDebtPerShare	6.836101	7.150855	9.646076	7.251533	7.349414	7.106586	6.505343	5.994642	5.563335	5.238377	...	2.02038	1.918291	1.422343	0.871498	1.463841	0.85933	0.895784	0.756211	0.759876	0.759486
marketCap	304302340081.799988	199424508332.5	195866053771.600006	231648724718.399994	214104358302	180879110017.899994	178658677049.599976	188152276679.799988	199218849881.399994	194240433009.600006	...	250675715913.799988	173524445845.200012	244173393392.599976	260890712649	126027331967.500015	154130334836.399994	97495017304.5	55448766307.200005	40217888550.671997	23520355109.368309
enterpriseValue	339356340081.799988	235914508332.5	246706053771.600006	271774724718.399994	255368358302	220370110017.899994	213995677049.599976	221491276679.799988	233524849881.399994	221311433009.600006	...	263728715913.799988	183455445845.200012	252011393392.599976	265203712649	130814331967.500015	155834334836.399994	99996017304.5	57220766307.200005	42683088550.671997	24886055109.368309
peRatio	13.84514	20.738822	12.03626	20.770082	10.048074	25.06987	25.66935	20.596856	9.054168	13.331533	...	64.111436	19.014294	31.352516	70.018978	39.643703	45.995325	44.055588	28.744824	25.56926	18.114876
priceToSalesRatio	3.743509	4.758626	3.784851	4.318018	4.074608	3.424184	3.657216	3.79301	3.862028	3.292992	...	5.547396	5.36016	7.569156	8.821624	7.777545	11.379972	7.797106	4.904366	4.013201	2.840177
pocfratio	9.340158	13.84604	15.559744	14.6363	12.999657	11.375329	12.3111	11.144481	11.21412	11.389729	...	21.354095	17.040602	26.360077	42.113109	41.23931	52.62217	59.849612	26.825721	22.080756	15.801381
pfcfRatio	10.187898	17.174002	19.598364	16.994258	15.021705	13.011014	13.726082	12.297534	12.222015	12.350762	...	27.552838	20.596373	34.585466	65.157521	84.299219	89.04121	142.121016	42.88381	35.746057	28.788684
pbRatio	3.941689	3.153555	3.101944	3.653362	3.002529	3.037739	2.760486	2.638845	2.610755	2.390357	...	3.83431	8.697967	13.347914	16.228584	14.181088	17.49493	12.289804	7.973651	7.303579	5.439616
ptbRatio	3.941689	3.153555	3.101944	3.653362	3.002529	3.037739	2.760486	2.638845	2.610755	2.390357	...	3.83431	8.697967	13.347914	16.228584	14.181088	17.49493	12.289804	7.973651	7.303579	5.439616
evToSales	4.174741	5.629343	4.767267	5.065982	4.859901	4.17178	4.380579	4.4651	4.527079	3.751932	...	5.836256	5.666928	7.812127	8.967462	8.072965	11.505784	7.997122	5.061097	4.259194	3.00509
enterpriseValueOverEBITDA	11.195076	14.456432	9.774021	13.895124	12.898695	14.421184	13.981163	11.564916	6.841615	8.425455	...	27.446011	14.365002	22.073346	39.330226	26.347297	34.768928	27.931848	17.726384	15.897459	11.580834
evToOperatingCashFlow	10.416094	16.37954	19.598511	17.171588	15.505061	13.858884	14.746119	13.11919	13.145221	12.977098	...	22.466029	18.015854	27.206239	42.809316	42.805737	53.203938	61.384909	27.683003	23.43422	16.718881
evToFreeCashFlow	11.36149	20.316441	24.685417	19.937989	17.916815	15.851684	16.440971	14.476554	14.326678	14.072069	...	28.987548	21.775127	35.695665	66.234693	87.501225	90.025612	145.766789	44.254266	37.937151	30.460288
earningsYield	0.072228	0.048219	0.083082	0.048146	0.099522	0.039889	0.038957	0.048551	0.110446	0.07501	...	0.015598	0.052592	0.031895	0.014282	0.025225	0.021741	0.022699	0.034789	0.039109	0.055203
freeCashFlowYield	0.098156	0.058228	0.051025	0.058843	0.06657	0.076858	0.072854	0.081317	0.08182	0.080967	...	0.036294	0.048552	0.028914	0.015347	0.011863	0.011231	0.007036	0.023319	0.027975	0.034736
debtToEquity	0.450214	0.562494	0.569422	0.511442	0.458097	0.527308	0.445272	0.442364	0.399203	0.381935	...	0.088028	0.157393	0.142623	0.069856	0.059075	0.059818	0.141561	0.098792	0.151273	0.139735
debtToAssets	0.573156	0.588446	0.621191	0.600068	0.58291	0.651313	0.61186	0.576887	0.554796	0.560394	...	0.440146	0.569635	0.532782	0.520263	0.568047	0.518632	0.48272	0.522465	0.563747	0.606911
netDebtToEBITDA	1.156402	2.236044	2.014183	2.051536	2.084251	2.58432	2.308702	1.740758	1.005068	1.030609	...	1.358414	0.777621	0.68652	0.639626	0.964149	0.380187	0.698603	0.548947	0.918172	0.635534
currentRatio	1.398913	1.352894	0.879343	1.567142	1.352121	1.251776	1.489983	2.66756	2.407087	2.145952	...	1.257175	1.335543	1.352639	1.434521	1.2184	1.38084	1.28558	1.146809	1.186073	1.199445
interestCoverage	15.673896	6.045549	8.844346	11.432371	11.107874	11.576728	10.822352	9.925735	11.574257	11.805118	...	None	None	None	None	None	None	None	None	None	None
incomeQuality	1.482324	1.497816	0.773551	1.41908	0.772949	2.203881	2.085057	1.848166	0.80739	1.170487	...	3.002302	1.115823	1.189394	1.662641	0.961309	0.874067	0.736105	1.07154	1.157988	1.146411
dividendYield	0.028685	0.042322	0.041064	0.03444	0.035772	0.040452	0.038845	0.035126	0.033029	0.033639	...	0.017365	0.018257	0.011119	0.008421	0.009109	0.006332	0.009036	0.013905	0.016373	0.02528
payoutRatio	0.397152	0.877704	0.494254	0.715323	0.359442	1.014137	0.997126	0.723481	0.29905	0.448456	...	1.113299	0.34714	0.348613	0.58964	0.36112	0.291256	0.398102	0.399689	0.418653	0.457948
salesGeneralAndAdministrativeToRevenue	0	0	0	0	0	0	0	0	0	0	...	0	0	0.350259	0.386894	0.39194	0.411105	0.396353	0.535114	0.528579	0.530134
researchAndDdevelopementToRevenue	0.170124	0.22442	0.16715	0.149235	0.14572	0.149023	0.157417	0.169197	0.129459	0.133421	...	0.157807	0.159886	0.150253	0.149963	0.171316	0.168266	0.154191	0	0	0
intangiblesToTotalAssets	0.409718	0.506056	0.561366	0.555896	0.609401	0.624054	0.529082	0.456278	0.475907	0.488084	...	0.502299	0.025887	0.043981	0.053447	0.037086	0.044421	0.084377	0.097089	0.097649	0.029346
capexToOperatingCashFlow	-0.083211	-0.193779	-0.206069	-0.13875	-0.134608	-0.125715	-0.103087	-0.093763	-0.082466	-0.077812	...	-0.224977	-0.172641	-0.237828	-0.353672	-0.510798	-0.409013	-0.578883	-0.374456	-0.382288	-0.451125
capexToRevenue	-0.033351	-0.066598	-0.050126	-0.040934	-0.042192	-0.037843	-0.030624	-0.031912	-0.0284	-0.022497	...	-0.058445	-0.054305	-0.068291	-0.074085	-0.096334	-0.088452	-0.075416	-0.068459	-0.069481	-0.081086
capexToDepreciation	-0.52225	-0.584258	-0.431614	-0.343985	-0.353645	-0.347229	-0.290091	-0.285895	-0.228549	-0.174353	...	-0.647621	-1.696911	-2.062734	-2.26343	-2.880074	-2.449898	-1.878486	-1.8	-1.861765	-2.299658
stockBasedCompensationToRevenue	0.014541	0.01804	0.013874	0.01769	0.015986	0.013081	0.013695	0.011813	0.010139	0.008154	...	0	0	0	0	0	0	0	0	0	0
grahamNumber	34.885192	21.056854	27.303006	21.48175	30.971155	16.146651	16.30076	19.076262	28.528308	21.931573	...	10.514199	10.396911	9.074688	5.911669	6.67878	6.802081	5.270407	4.496117	3.698037	3.022439
roic	0.14578	0.068272	0.106933	0.117941	0.099789	0.097722	0.093987	0.09143	0.110035	0.114462	...	0.115982	0.441639	0.430212	0.402713	0.39942	0.324302	0.333566	0.341199	0.339455	0.314463
returnOnTangibleAssets	0.205177	0.126226	0.221504	0.157528	0.317542	0.111829	0.088258	0.099252	0.243944	0.153186	...	0.067276	0.202099	0.208063	0.117469	0.160466	0.191606	0.157599	0.145662	0.136937	0.120526
grahamNetNet	-10.106543	-11.90216	-14.548303	-10.989058	-11.374665	-13.480703	-10.894916	-8.225142	-7.775172	-6.947057	...	-4.111049	-1.279727	-1.101418	-0.821779	-0.93245	-1.277514	-0.992906	-1.042831	-1.208688	-0.913282
workingCapital	17022000000	9147000000	-4501000000	18068000000	10714000000	7834000000	14405000000	36071000000	32878000000	32796000000	...	6084000000	6226000000	4810000000	5206000000	2006000000	2739000000	1515000000	828000000	965200000	962500000
tangibleAssetValue	3108000000	-14575000000	-30576000000	-24864000000	-33038000000	-47257000000	-23602000000	-5614000000	-5284000000	-9007000000	...	6721000000	18750000000	16571000000	14285000000	8124000000	7997000000	6639000000	5580000000	4310200000	4037000000
netCurrentAssetValue	-44321000000	-55689000000	-71239000000	-45738000000	-59000000000	-72826000000	-58658000000	-39950000000	-39237000000	-42705000000	...	-21657000000	-1625000000	-2410000000	-247000000	-496000000	439000000	-583000000	-1195000000	-1023700000	-947400000
investedCapital	0.479242	0.605237	0.825824	0.650796	0.597493	0.706805	0.602256	0.514467	0.478187	0.460989	...	0.222907	0.59193	0.485104	0.336651	0.621807	0.36958	0.425816	0.42019	0.52092	0.65316
averageReceivables	13469500000	11194000000	11631000000	11296500000	11232500000	11230000000	11016000000	9931500000	10275500000	16384000000	...	10180000000	8689000000	8265500000	8341500000	7529000000	7054000000	6860500000	6723000000	6609000000	6429500000
averagePayables	4943500000	4309000000	4264500000	4491500000	4482500000	4422500000	3964500000	3874500000	3771500000	4286500000	...	3455000000	2964500000	2944000000	3014000000	2630000000	2640000000	2537000000	2611000000	2512150000	2416950000
averageInventory	8552500000	8046000000	8164500000	7777000000	7812000000	7414500000	7779500000	6854500000	7106000000	7554500000	...	6941500000	5362000000	5393500000	5374000000	4850000000	4937000000	4909500000	4817500000	4715050000	4655450000
daysSalesOutstanding	70.69832	97.49475	85.117295	77.555781	78.291687	77.845108	80.978281	63.787622	66.208611	133.497949	...	74.037134	69.723535	60.386404	67.74481	87.037768	78.529976	73.764795	72.70299	73.718243	73.385217
daysPayablesOutstanding	66.057883	180.946272	150.729034	151.672297	151.19573	134.288263	136.950663	131.105774	123.138953	137.317805	...	96.558686	146.18047	114.488478	154.578714	174.780967	220.819315	157.576185	190.86197	145.849115	117.784643
daysOfInventoryOnHand	107.281886	337.872757	295.850377	243.636202	246.08274	200.81069	284.229374	215.82907	234.778844	227.456767	...	216.690907	241.648949	198.741557	242.973639	303.98288	415.713396	365.205982	332.179267	282.216915	283.83653
receivablesTurnover	5.162782	3.743791	4.2882	4.70629	4.662053	4.688798	4.507381	5.722113	5.512878	2.734124	...	4.929959	5.234961	6.044407	5.387867	4.193582	4.647907	4.94816	5.020426	4.951285	4.973754
payablesTurnover	5.525457	2.017173	2.421564	2.406504	2.414089	2.718034	2.665193	2.784012	2.964131	2.658068	...	3.780085	2.496914	3.188094	2.361257	2.088328	1.652935	2.31634	1.912377	2.502586	3.098876
inventoryTurnover	3.402252	1.080288	1.233732	1.498135	1.483241	1.817632	1.284174	1.691153	1.554655	1.604701	...	1.684427	1.510456	1.836556	1.502221	1.200726	0.878009	0.999436	1.098804	1.293331	1.285951
roe	0.284698	0.15206	0.257717	0.175895	0.298816	0.121171	0.10754	0.128119	0.288348	0.179301	...	0.059807	0.457444	0.425737	0.231774	0.357714	0.380363	0.278961	0.277394	0.285639	0.300284
capexPerShare	-0.484021	-0.50243	-0.465793	-0.373978	-0.371357	-0.328297	-0.242228	-0.249448	-0.21503	-0.178312	...	-0.366144	-0.285575	-0.353101	-0.352818	-0.41351	-0.316178	-0.250066	-0.200311	-0.184452	-0.18058

58 rows × 28 columns

Analyst recommendations#

analyst_data = fa.rating(ticker=my_ticker, api_key=my_api_key)
analyst_data

	rating	ratingScore	ratingRecommendation	ratingDetailsDCFScore	ratingDetailsDCFRecommendation	ratingDetailsROEScore	ratingDetailsROERecommendation	ratingDetailsROAScore	ratingDetailsROARecommendation	ratingDetailsDEScore	ratingDetailsDERecommendation	ratingDetailsPEScore	ratingDetailsPERecommendation	ratingDetailsPBScore	ratingDetailsPBRecommendation
date
2022-11-23	A+	4	Buy	5	Strong Buy	3	Neutral	3	Neutral	4	Buy	4	Buy	5	Strong Buy
2022-11-22	A+	4	Buy	5	Strong Buy	3	Neutral	3	Neutral	4	Buy	4	Buy	5	Strong Buy
2022-11-21	A+	4	Buy	5	Strong Buy	3	Neutral	3	Neutral	4	Buy	4	Buy	5	Strong Buy
2022-11-18	A+	4	Buy	5	Strong Buy	3	Neutral	3	Neutral	4	Buy	4	Buy	5	Strong Buy
2022-11-17	A+	4	Buy	5	Strong Buy	3	Neutral	3	Neutral	4	Buy	4	Buy	5	Strong Buy

Dividend history#

dividends = fa.stock_dividend(ticker=my_ticker, api_key=my_api_key)
dividends

	label	adjDividend	dividend	recordDate	paymentDate	declarationDate
2022-11-03	November 03, 22	0.4	0.4	2022-11-04	2022-12-05	2022-09-22
2022-07-28	July 28, 22	0.4	0.4	2022-07-29	2022-09-06	2022-06-23
2022-05-12	May 12, 22	0.4	0.4	2022-05-13	2022-06-10	2022-04-28
2022-01-27	January 27, 22	0.4	0.4	2022-01-28	2022-03-04	2021-12-10
2021-11-04	November 04, 21	0.39	0.39	2021-11-05	2021-12-06	2021-09-23
...	...	...	...	...	...	...
1973-08-28	August 28, 73	0.00316	0.00316
1973-05-30	May 30, 73	0.00316	0.00316
1973-02-28	February 28, 73	0.00316	0.00316
1972-11-28	November 28, 72	0.00416	0.00416
1972-08-29	August 29, 72	0.00316	0.00316

203 rows × 6 columns

Slowing down requests#

If you are making many quick requests, you may run into an error with fundamentalanalysis. Fortunately, the solution is an easy one. Simply add a one second delay between requests.

# this is the package we need to add a delay
import time

# this is how we add a one second delay to our code
time.sleep(1)

For example, if you are looping over a list of companies and collecting the latest stock price for each company, you could do the following:

list_of_companies = ['CSCO', 'TXN', 'QCOM']

list_of_prices = []

# loop over the list of companies
for company in list_of_companies:

	# get the profile data using fundamentalanalysis
	stock_profile = fa.profile(ticker=company, api_key=my_api_key)

	# get the latest stock price from the table
	stock_price = stock_profile.at['price', 0]

	# append the stock price to the list
	list_of_prices.append(stock_price)

	# add a one second delay before the next request
	time.sleep(1)

list_of_prices

[48.4, 177.07, 123.45]

Example#

In this example, we

loop over a list of companies
get the name, market cap, dividend, number of employees, current assets, current liabilities, operating cycle, and free cash flow per share
put this information into a list of dictionaries
put everything into a table

peer_list = ["MSFT", "NVDA", "INTC", "CSCO", "TXN", "QCOM", "AAPL"]

# empty list to store the results
results = []

for peer in peer_list:
    # create an empty dictionary to hold the data for the company
    obs_dict = {}
    
    # add ticker to the dictionary
    obs_dict['ticker'] = peer

    # get the profile data
    profile_data = fa.profile(peer, my_api_key)

    # add pieces of profile data to dictionary
    obs_dict['name'] = profile_data.loc['companyName', 0]
    obs_dict['mcap'] = profile_data.loc['mktCap', 0]
    obs_dict['div'] = profile_data.loc['lastDiv', 0]
    obs_dict['employs'] = profile_data.loc['fullTimeEmployees', 0]

    # get the balance sheet data
    bs_data = fa.balance_sheet_statement(peer, my_api_key)

    # add pieces of balance sheet data to dictionary
    obs_dict['assets_c'] = bs_data.loc['totalCurrentAssets', '2021']
    obs_dict['liab_c'] = bs_data.loc['totalCurrentLiabilities', '2021']

    # get the ratios data
    ratios_data = fa.financial_ratios(peer, my_api_key)

    # add pieces of ratios data to dictionary
    obs_dict['oper_cycle'] = ratios_data.loc['operatingCycle', '2021']
    obs_dict['fcf_per_share'] = ratios_data.loc['freeCashFlowPerShare', '2021']

    # append the dictionary to our list of results
    results.append(obs_dict)
    
final_data = pd.DataFrame(results)
final_data.set_index('ticker', inplace=True)
final_data

	name	mcap	div	employs	assets_c	liab_c	oper_cycle	fcf_per_share
ticker
MSFT	Microsoft Corporation	1844906815939	2.54	221000	184406000000	88657000000	101.030183	7.435802
NVDA	NVIDIA Corporation	405448400000	0.16	22473	16055000000	3925000000	159.314399	1.901945
INTC	Intel Corporation	121086181878	1.46	121100	57718000000	27462000000	155.391674	2.380389
CSCO	Cisco Systems, Inc.	198728944128	1.51	83300	39112000000	26257000000	106.083483	3.496447
TXN	Texas Instruments Incorporated	160703768374	4.69	31000	13685000000	2569000000	150.660350	6.833876
QCOM	QUALCOMM Incorporated	138387442099	2.93	51000	20075000000	11951000000	121.530936	7.646331
AAPL	Apple Inc.	2356148705219	0.91	164000	134836000000	125481000000	62.667561	5.565624

Tyson's Python Tutorial

FundamentalAnalysis

Contents

FundamentalAnalysis#

What it is#

Available functions#

Available companies#

Company profile#

Financial statements#

Financial ratios#

Key metrics#

Analyst recommendations#

Dividend history#

Slowing down requests#

Example#