Getting full control over your files at any moment is crucial to alleviate your daily duties and increase your efficiency. Accomplish any objective with DocHub features for document management and convenient PDF editing. Access, modify and save and integrate your workflows with other safe cloud storage.
DocHub gives you lossless editing, the opportunity to work with any formatting, and securely eSign documents without the need of looking for a third-party eSignature alternative. Make the most of your file managing solutions in one place. Consider all DocHub functions right now with the free profile.
in a previous video i showed you how to pull the stock prices from yahoo finance into microsoft excel this time around im going to show you how to pull a companys financial statements into your spreadsheet so in front of me ive got a the wall street journals website for walmart inc and and their financials for the last five years and the reason i like using the wall street journal website for for this purpose is the data is organized in a table which is going to download nicely into power query and also the the url is really easy to manipulate for instance i got walmarts ticker symbol in here um annual telling me its annual its the income statement so for instance if i want to select a balance sheet or a cash flow the url is going to change so it makes it easy to manipulate based on what you want to what you want to see if i click on quarterly its going to update the url to show quarter instead of annual and ive got the quarterly data in here so im going to start with this as