The Value Investor's video: How To Get Stock Data In Excel Balance Sheet UPDATED 2020

Want to know how to get stock data into excel? This video will show you how to automatically pull over 10 years of a stock's balance into excel with just one click of a button. Two of my biggest struggles when analyzing stocks is getting enough information to get a reasonable look at the company, and secondly getting data into Excel to be able to build models on that data. This video will solve both issues by showing you how to get stock data in Excel. I have seen several other videos that claim to automatically get stocks information into Excel, but all you really get is price and market cap. But if you are anything like me, you realize the price isn’t a driver of a company’s value, so getting the financial information to automatically update in Excel is crucial to your analysis. So I hope this video helps you out too. If you want to see more of my videos in the future, then you should subscribe. This channel was created to find undervalued stocks with the hopes of teaching people the best investing practices. If you have any questions or comments, please let me know by leaving a comment down below. Otherwise, thank you for watching and please enjoy my video on how to get stocks financial info in Excel. Music: https://www.bensound.com CREDIT: Subscribe Button by MrNumber112 https://youtu.be/Fps5vWgKdl0 Ae Project files: https://www.patreon.com/posts/20870148 /////////////////PREVIOUS VIDEO///////////////// How to pull a stock's income statement in excel: https://youtu.be/lqpKI9jfH0E /////////////////ANNUAL BALANCE SHEET///////////////// let API= Excel.CurrentWorkbook(){[Name="Table1"]}[Content]{0}[API], Ticker = Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Ticker], Source = Json.Document(Web.Contents("https://financialmodelingprep.com/api/v3/balance-sheet-statement/"&Ticker&"?apikey="&API)), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Renamed Columns" = Table.RenameColumns( #"Converted to Table",{{"Column1", "B.Sheet"}}), #"Expanded B.Sheet" = Table.ExpandRecordColumn( #"Renamed Columns", "B.Sheet", {"date", "symbol", "fillingDate", "acceptedDate", "period", "cashAndCashEquivalents", "shortTermInvestments", "cashAndShortTermInvestments", "netReceivables", "inventory", "otherCurrentAssets", "totalCurrentAssets", "propertyPlantEquipmentNet", "goodwill", "intangibleAssets", "goodwillAndIntangibleAssets", "longTermInvestments", "taxAssets", "otherNonCurrentAssets", "totalNonCurrentAssets", "otherAssets", "totalAssets", "accountPayables", "shortTermDebt", "taxPayables", "deferredRevenue", "otherCurrentLiabilities", "totalCurrentLiabilities", "longTermDebt", "deferredRevenueNonCurrent", "deferredTaxLiabilitiesNonCurrent", "otherNonCurrentLiabilities", "totalNonCurrentLiabilities", "otherLiabilities", "totalLiabilities", "commonStock", "retainedEarnings", "accumulatedOtherComprehensiveIncomeLoss", "othertotalStockholdersEquity", "totalStockholdersEquity", "totalLiabilitiesAndStockholdersEquity", "totalInvestments", "totalDebt", "netDebt", "link", "finalLink"}, {"B.Sheet.date", "B.Sheet.symbol", "B.Sheet.fillingDate", "B.Sheet.acceptedDate", "B.Sheet.period", "B.Sheet.cashAndCashEquivalents", "B.Sheet.shortTermInvestments", "B.Sheet.cashAndShortTermInvestments", "B.Sheet.netReceivables", "B.Sheet.inventory", "B.Sheet.otherCurrentAssets", "B.Sheet.totalCurrentAssets", "B.Sheet.propertyPlantEquipmentNet", "B.Sheet.goodwill", "B.Sheet.intangibleAssets", "B.Sheet.goodwillAndIntangibleAssets", "B.Sheet.longTermInvestments", "B.Sheet.taxAssets", "B.Sheet.otherNonCurrentAssets", "B.Sheet.totalNonCurrentAssets", "B.Sheet.otherAssets", "B.Sheet.totalAssets", "B.Sheet.accountPayables", "B.Sheet.shortTermDebt", "B.Sheet.taxPayables", "B.Sheet.deferredRevenue", "B.Sheet.otherCurrentLiabilities", "B.Sheet.totalCurrentLiabilities", "B.Sheet.longTermDebt", "B.Sheet.deferredRevenueNonCurrent", "B.Sheet.deferredTaxLiabilitiesNonCurrent", "B.Sheet.otherNonCurrentLiabilities", "B.Sheet.totalNonCurrentLiabilities", "B.Sheet.otherLiabilities", "B.Sheet.totalLiabilities", "B.Sheet.commonStock", "B.Sheet.retainedEarnings", "B.Sheet.accumulatedOtherComprehensiveIncomeLoss", "B.Sheet.othertotalStockholdersEquity", "B.Sheet.totalStockholdersEquity", "B.Sheet.totalLiabilitiesAndStockholdersEquity", "B.Sheet.totalInvestments", "B.Sheet.totalDebt", "B.Sheet.netDebt", "B.Sheet.link", "B.Sheet.finalLink"}) in #"Expanded B.Sheet" /////////////////QUARTERLY BALANCE SHEET///////////////// let API= Excel.CurrentWorkbook(){[Name="Table1"]}[Content]{0}[API], Ticker = Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Ticker], Source = Json.Document(Web.Contents("https://financialmodelingprep.com/api/v3/balance-sheet-statement/"&Ticker&"?period=quarter&apikey="&API)),