How To Import Company Financials Into Excel

This step by step tutorial shows you how to import public company financials into Excel. Copy and paste leads to messy data and typing values manually takes too long. This video shows you a better way to import public company financials into Excel that will increase accuracy and save you time. We start importing public company financials into Excel using the investor relations page and finish on the market data section of the Wall Street Journal. Please make sure to like, subscribe, and leave a comment letting me know - what else can I help you with in Excel.

👍 Like

Purchasing through this affiliate link gives me a small commission to support my channel -- the price to you is the same.

📚 Credit & Inspiration:

[benfithian]

Really slick! This saves me so much time. Thanks a lot man!

[tanishqverma]

You made my work easy man...thanks a lot

[richardgordon]

Brilliant! Many thanks, and much appreciated!!

[benfithian]

I want your top 5 growth stock picks!!

[richardgordon]

I’m building a bunch of models using two different techniques of analysis to cross reference each other. Unfortunately data sources are often incorrect or inconsistent so I have to cross check the data sources as well.

Up until this point I have been copying and pasting, but this technique is much more efficient. Thanks!

[stanley]

I noticed that on the last excel the parenthesis are not converted to minus sign. Do you know how we can fix it cause I am having the same problem

[justinkredible]

It keeps telling me couldnt authenticate with the credentials provided.

[machismocc]

how can I do for multiple companies in a single sheet, so as to compare their data ?

[heyitsgabriel]

It works. Problem is that it creatas a new file, I want it on my original spreadsheet

[HowToAnalyst]

Why are you importing financials into Excel?

[jao]

It seems like it is not working anymore on the WSJ website, anyone has the same problem ?