Yahoo Finance - Getting Balance Sheet data

Getting Balance Sheet Data from Yahoo Finance into Google Sheets

SyncWith's Google Sheets addon will let you pull data from Yahoo Finance's undocumented API, pulling live data into Google Sheets and keeping it up to date.
Here we'll use it to pull Balance Sheet data!

Yahoo Finance Balance Sheet

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 SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards

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.
notion image

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:
assetProfile balanceSheetHistory balanceSheetHistoryQuarterly calendarEvents cashflowStatementHistory cashflowStatementHistoryQuarterly defaultKeyStatistics earnings earningsHistory earningsTrend esgScores financialData fundOwnership incomeStatementHistory incomeStatementHistoryQuarterly indexTrend industryTrend insiderHolders insiderTransactions institutionOwnership majorDirectHolders majorHoldersBreakdown netSharePurchaseActivity price recommendationTrend secFilings sectorTrend summaryDetail summaryProfile upgradeDowngradeHistory pageviews quotetype