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
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:
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