Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
endDate
cash.raw
shortTermInvestments.raw
netReceivables.raw
totalCurrentAssets.raw
propertyPlantEquipment.raw
otherAssets.raw
totalAssets.raw
accountsPayable.raw
otherCurrentLiab.raw
otherLiab.raw
totalCurrentLiabilities.raw
totalLiab.raw
commonStock.raw
retainedEarnings.raw
treasuryStock.raw
capitalSurplus.raw
otherStockholderEquity.raw
totalStockholderEquity.raw
netTangibleAssets.raw
intangibleAssets.raw
Get a live Google Sheet
Export your data to a google sheet, with the Crypto Coin Tracker Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets
End result
Here's a screenshot of the live data Google Sheet you can get when you click Get Google Sheet (above) and install the free SyncWith addon.
Reference
In the above example we used the module balanceSheet to specify the data we wanted, and we used the SyncWith addon's data transformation capabilities to extract the data into columns.
Here is a list of other modules you can use when querying the Yahoo API: