No credit card required.
Getting started is easy. Copy the Google sheets below to get started with 5 years of history for AAPL (no sign-up required).
Getting started is simple. Use the queries below to get 5 years of history for AAPL (no sign-up required).
https://api.findl.com/v1.0/data/fundamentals?apiKey=test-api-key&from=2020-05-03&ticker=AAPL&limit=1500&format=csv
https://api.findl.com/v1.0/data/stocks?apiKey=test-api-key&from=2020-05-03&ticker=AAPL&limit=1500&format=csv
Comprehensive reference grade data for US public companies and funds.
Dive right in and start exploring the data.
Table:
Reference grade financial data.
Free access to all 13 findl tables for current sp500 companies for the last 5 years
Flagship Bundle
Unlimited access to all 13 findl tables for all active and delisted companies and funds for up to 25+ years
Table:
Example API call
https://api.findl.com/v1.0/data/fundamentals?format=json&apiKey=test-api-key&ticker=AAPL&from=2020-05-03&to=2025-05-03
Sample Output
{
"count": 4,
"data": [
{
"ticker": "AAPL",
"dimension": "ARQ",
"calendardate": "2023-06-30",
"date": "2023-08-04",
"reportperiod": "2023-07-01",
"lastupdated": "2023-08-14",
"accoci": "-11801000000",
"assets": "335038000000",
"assetsavg": null,
"assetsc": "122659000000",
"assetsnc": "212379000000",
"assetturnover": null,
"bvps": 3.84,
"capitalexpenditure": "-2093000000",
"cashneq": "28408000000",
"cashnequsd": "28408000000",
"cor": "45384000000",
"consolinc": "19881000000",
"currentratio": 0.982,
"de": 4.559,
"debt": "109280000000",
"debtc": "11209000000",
"debtnc": "98071000000",
"debtusd": "109280000000",
"deferredrev": "8158000000",
"depamor": "3052000000",
"deposits": "0",
"divyield": 0.005,
"dps": 0.24,
"ebit": "23731000000",
"ebitda": "26783000000",
"ebitdamargin": 0.327,
"ebitdausd": "26783000000",
"ebitusd": "23731000000",
"ebt": "22733000000",
"eps": 1.27,
"epsdil": 1.26,
"epsusd": 1.27,
"equity": "60274000000",
"equityavg": null,
"equityusd": "60274000000",
"ev": "2926145881680",
"evebit": "25",
"evebitda": 23.062,
"fcf": "24287000000",
"fcfps": 1.547,
"fxusd": 1,
"gp": "36413000000",
"grossmargin": 0.445,
"intangibles": "0",
"intexp": "998000000",
"invcap": "290947000000",
"invcapavg": null,
"inventory": "7351000000",
"investments": "138135000000",
"investmentsc": "34074000000",
"investmentsnc": "104061000000",
"liabilities": "274764000000",
"liabilitiesc": "124963000000",
"liabilitiesnc": "149801000000",
"marketcap": "2845273881680",
"ncf": "2769000000",
"ncfbus": "0",
"ncfcommon": "-17478000000",
"ncfdebt": "-283000000",
"ncfdiv": "-3849000000",
"ncff": "-24048000000",
"ncfi": "437000000",
"ncfinv": "3036000000",
"ncfo": "26380000000",
"ncfx": "0",
"netinc": "19881000000",
"netinccmn": "19881000000",
"netinccmnusd": "19881000000",
"netincdis": "0",
"netincnci": "0",
"netmargin": 0.243,
"opex": "13415000000",
"opinc": "22998000000",
"payables": "46699000000",
"payoutratio": 0.189,
"pb": 47.206,
"pe": 30.026,
"pe1": 30.433,
"ppnenet": "43550000000",
"prefdivis": "0",
"price": 181.99,
"ps": 7.411,
"ps1": 7.441,
"receivables": "39186000000",
"retearn": "1408000000",
"revenue": "81797000000",
"revenueusd": "81797000000",
"rnd": "7442000000",
"roa": null,
"roe": null,
"roic": null,
"ros": null,
"sbcomp": "2617000000",
"sgna": "5973000000",
"sharefactor": 1,
"sharesbas": "15634232000",
"shareswa": "15697614000",
"shareswadil": "15775021000",
"sps": 5.211,
"tangibles": "335038000000",
"taxassets": "0",
"taxexp": "2852000000",
"taxliabilities": "0",
"tbvps": 21.343,
"workingcapital": "-2304000000"
},
{
"ticker": "AAPL",
"dimension": "ART",
"calendardate": "2023-06-30",
"date": "2023-08-04",
"reportperiod": "2023-07-01",
"lastupdated": "2023-08-14",
"accoci": "-11801000000",
"assets": "335038000000",
"assetsavg": "341675000000",
"assetsc": "122659000000",
"assetsnc": "212379000000",
"assetturnover": 1.124,
"bvps": 3.84,
"capitalexpenditure": "-12085000000",
"cashneq": "28408000000",
"cashnequsd": "28408000000",
"cor": "217117000000",
"consolinc": "94760000000",
"currentratio": 0.982,
"de": 4.559,
"debt": "109280000000",
"debtc": "11209000000",
"debtnc": "98071000000",
"debtusd": "109280000000",
"deferredrev": "8158000000",
"depamor": "11731000000",
"deposits": "0",
"divyield": 0.005,
"dps": 0.93,
"ebit": "115153000000",
"ebitda": "126884000000",
"ebitdamargin": 0.33,
"ebitdausd": "126884000000",
"ebitusd": "115153000000",
"ebt": "111395000000",
"eps": 5.98,
"epsdil": 5.95,
"epsusd": 5.98,
"equity": "60274000000",
"equityavg": "57457750000",
"equityusd": "60274000000",
"ev": "2926145881680",
"evebit": "25",
"evebitda": 23.062,
"fcf": "100987000000",
"fcfps": 6.433,
"fxusd": 1,
"gp": "166816000000",
"grossmargin": 0.434,
"intangibles": "0",
"intexp": "3758000000",
"invcap": "290947000000",
"invcapavg": "295798000000",
"inventory": "7351000000",
"investments": "138135000000",
"investmentsc": "34074000000",
"investmentsnc": "104061000000",
"liabilities": "274764000000",
"liabilitiesc": "124963000000",
"liabilitiesnc": "149801000000",
"marketcap": "2845273881680",
"ncf": "1037000000",
"ncfbus": "-137000000",
"ncfcommon": "-80975000000",
"ncfdebt": "-10237000000",
"ncfdiv": "-14970000000",
"ncff": "-112129000000",
"ncfi": "94000000",
"ncfinv": "13666000000",
"ncfo": "113072000000",
"ncfx": "0",
"netinc": "94760000000",
"netinccmn": "94760000000",
"netinccmnusd": "94760000000",
"netincdis": "0",
"netincnci": "0",
"netmargin": 0.247,
"opex": "54590000000",
"opinc": "112226000000",
"payables": "46699000000",
"payoutratio": 0.156,
"pb": 47.206,
"pe": 30.026,
"pe1": 30.433,
"ppnenet": "43550000000",
"prefdivis": "0",
"price": 181.99,
"ps": 7.411,
"ps1": 7.441,
"receivables": "39186000000",
"retearn": "1408000000",
"revenue": "383933000000",
"revenueusd": "383933000000",
"rnd": "29369000000",
"roa": 0.277,
"roe": 1.649,
"roic": 0.389,
"ros": 0.3,
"sbcomp": "10486000000",
"sgna": "25221000000",
"sharefactor": 1,
"sharesbas": "15634232000",
"shareswa": "15697614000",
"shareswadil": "15775021000",
"sps": 24.458,
"tangibles": "335038000000",
"taxassets": "0",
"taxexp": "16635000000",
"taxliabilities": "0",
"tbvps": 21.343,
"workingcapital": "-2304000000"
},
{
"ticker": "AAPL",
"dimension": "MRQ",
"calendardate": "2023-06-30",
"date": "2023-07-01",
"reportperiod": "2023-07-01",
"lastupdated": "2023-08-14",
"accoci": "-11801000000",
"assets": "335038000000",
"assetsavg": null,
"assetsc": "122659000000",
"assetsnc": "212379000000",
"assetturnover": null,
"bvps": 3.84,
"capitalexpenditure": "-2093000000",
"cashneq": "28408000000",
"cashnequsd": "28408000000",
"cor": "45384000000",
"consolinc": "19881000000",
"currentratio": 0.982,
"de": 4.559,
"debt": "109280000000",
"debtc": "11209000000",
"debtnc": "98071000000",
"debtusd": "109280000000",
"deferredrev": "8158000000",
"depamor": "3052000000",
"deposits": "0",
"divyield": 0.005,
"dps": 0.24,
"ebit": "23731000000",
"ebitda": "26783000000",
"ebitdamargin": 0.327,
"ebitdausd": "26783000000",
"ebitusd": "23731000000",
"ebt": "22733000000",
"eps": 1.27,
"epsdil": 1.26,
"epsusd": 1.27,
"equity": "60274000000",
"equityavg": null,
"equityusd": "60274000000",
"ev": "3135824326940",
"evebit": "27",
"evebitda": 24.714,
"fcf": "24287000000",
"fcfps": 1.547,
"fxusd": 1,
"gp": "36413000000",
"grossmargin": 0.445,
"intangibles": "0",
"intexp": "998000000",
"invcap": "290947000000",
"invcapavg": null,
"inventory": "7351000000",
"investments": "138135000000",
"investmentsc": "34074000000",
"investmentsnc": "104061000000",
"liabilities": "274764000000",
"liabilitiesc": "124963000000",
"liabilitiesnc": "149801000000",
"marketcap": "3050896326940",
"ncf": "2769000000",
"ncfbus": "0",
"ncfcommon": "-17478000000",
"ncfdebt": "-283000000",
"ncfdiv": "-3849000000",
"ncff": "-24048000000",
"ncfi": "437000000",
"ncfinv": "3036000000",
"ncfo": "26380000000",
"ncfx": "0",
"netinc": "19881000000",
"netinccmn": "19881000000",
"netinccmnusd": "19881000000",
"netincdis": "0",
"netincnci": "0",
"netmargin": 0.243,
"opex": "13415000000",
"opinc": "22998000000",
"payables": "46699000000",
"payoutratio": 0.189,
"pb": 50.617,
"pe": 32.196,
"pe1": 32.436,
"ppnenet": "43550000000",
"prefdivis": "0",
"price": 193.97,
"ps": 7.946,
"ps1": 7.931,
"receivables": "39186000000",
"retearn": "1408000000",
"revenue": "81797000000",
"revenueusd": "81797000000",
"rnd": "7442000000",
"roa": null,
"roe": null,
"roic": null,
"ros": null,
"sbcomp": "2617000000",
"sgna": "5973000000",
"sharefactor": 1,
"sharesbas": "15728702000",
"shareswa": "15697614000",
"shareswadil": "15775021000",
"sps": 5.211,
"tangibles": "335038000000",
"taxassets": "0",
"taxexp": "2852000000",
"taxliabilities": "0",
"tbvps": 21.343,
"workingcapital": "-2304000000"
},
{
"ticker": "AAPL",
"dimension": "MRT",
"calendardate": "2023-06-30",
"date": "2023-07-01",
"reportperiod": "2023-07-01",
"lastupdated": "2023-08-14",
"accoci": "-11801000000",
"assets": "335038000000",
"assetsavg": "341675000000",
"assetsc": "122659000000",
"assetsnc": "212379000000",
"assetturnover": 1.124,
"bvps": 3.84,
"capitalexpenditure": "-12085000000",
"cashneq": "28408000000",
"cashnequsd": "28408000000",
"cor": "217117000000",
"consolinc": "94760000000",
"currentratio": 0.982,
"de": 4.559,
"debt": "109280000000",
"debtc": "11209000000",
"debtnc": "98071000000",
"debtusd": "109280000000",
"deferredrev": "8158000000",
"depamor": "11731000000",
"deposits": "0",
"divyield": 0.005,
"dps": 0.93,
"ebit": "115153000000",
"ebitda": "126884000000",
"ebitdamargin": 0.33,
"ebitdausd": "126884000000",
"ebitusd": "115153000000",
"ebt": "111395000000",
"eps": 5.98,
"epsdil": 5.95,
"epsusd": 5.98,
"equity": "60274000000",
"equityavg": "57457750000",
"equityusd": "60274000000",
"ev": "3135824326940",
"evebit": "27",
"evebitda": 24.714,
"fcf": "100987000000",
"fcfps": 6.433,
"fxusd": 1,
"gp": "166816000000",
"grossmargin": 0.434,
"intangibles": "0",
"intexp": "3758000000",
"invcap": "290947000000",
"invcapavg": "295798000000",
"inventory": "7351000000",
"investments": "138135000000",
"investmentsc": "34074000000",
"investmentsnc": "104061000000",
"liabilities": "274764000000",
"liabilitiesc": "124963000000",
"liabilitiesnc": "149801000000",
"marketcap": "3050896326940",
"ncf": "1037000000",
"ncfbus": "-137000000",
"ncfcommon": "-80975000000",
"ncfdebt": "-10237000000",
"ncfdiv": "-14970000000",
"ncff": "-112129000000",
"ncfi": "94000000",
"ncfinv": "13666000000",
"ncfo": "113072000000",
"ncfx": "0",
"netinc": "94760000000",
"netinccmn": "94760000000",
"netinccmnusd": "94760000000",
"netincdis": "0",
"netincnci": "0",
"netmargin": 0.247,
"opex": "54590000000",
"opinc": "112226000000",
"payables": "46699000000",
"payoutratio": 0.156,
"pb": 50.617,
"pe": 32.196,
"pe1": 32.436,
"ppnenet": "43550000000",
"prefdivis": "0",
"price": 193.97,
"ps": 7.946,
"ps1": 7.931,
"receivables": "39186000000",
"retearn": "1408000000",
"revenue": "383933000000",
"revenueusd": "383933000000",
"rnd": "29369000000",
"roa": 0.277,
"roe": 1.649,
"roic": 0.389,
"ros": 0.3,
"sbcomp": "10486000000",
"sgna": "25221000000",
"sharefactor": 1,
"sharesbas": "15728702000",
"shareswa": "15697614000",
"shareswadil": "15775021000",
"sps": 24.458,
"tangibles": "335038000000",
"taxassets": "0",
"taxexp": "16635000000",
"taxliabilities": "0",
"tbvps": 21.343,
"workingcapital": "-2304000000"
}
]
}
Copyright © findl 2025. All rights reserved.