Importing Financial Statements Dynamically Into Excel

Financial statements are valuable to any investor looking to evaluate a company. The bad news is that web scraping these documents from various websites can be a real pain especially with an unsophisticated language such as Visual Basic. We can actually use a command within Excel VBA to circumvent this and pull the data we need out of the HTML of NASDAQ’s website.

Instructions: Enter a ticker and select a frequency of the sheet from a drop-down list highlighted in orange (annual, quarterly). Next, select the statement type from another drop-down list highlighted in orange. Fill out everything highlighted in orange!

The normalization is taken care of, and you are left with a clean financial statement that you can analyze!