fbpx

Two Ways to Export SEC Filings to Excel that People Don’t Know About


Written by

Jae Jun

follow me on

Facebook

Twitter

To get this kind of information and other exclusive articles before regular readers, get on the VIP Mailing List today.

********

Having worked with financial data for several years now, I just cannot appreciate enough the transparency and access to data we have in the US. It is so far ahead of the rest of the world.

To be honest, I still don’t like searching and digging for data on the SEC. It isn’t the most user friendly website. It’s why I now use secfilings.com. Free and easier to use.

I also use my dedicated data feed which make life much easier and saves me countless hours, but for those who cannot afford the cost of the OSV spreadsheets, here are a couple of alternatives.

Exporting SEC Filings to Excel

XBRL is the new technology that is being used by companies to report filings to the SEC. At first it was the giant companies that complied with XBRL standards but all companies now support this which makes for pulling data easier.

But let’s get down to what you really want. Exporting financial statements directly from SEC to Excel.

Calcbench

This site was mentioned in the best investing websites magazine and if you haven’t downloaded it yet, I highly advise you to get a copy. It’s free and is filled with valuable resources.

I view Calcbench as the leader of the group in terms of web applications allowing you to export SEC data to excel.

You have access to each part of the financial statements and if you create a free account, you can export the data for free.

XBRL to XL

I spent some time today fiddling around with XBRL to XL and there is promise.

The process of getting to download the excel data can be confusing at first, but once you get the hang of it, it is quite easy.

Financial statements are not in plain English type format. There are lots of syntax and other “tags” to clean up.

No point in me trying to explain it all. Go play with it and you’ll figure out how to use it.

But before I continue, click on the image below to be a VIP and get all the free hidden content and exclusive resources we don’t publish anywhere else.

get on the VIP list for exclusive content

Important Reminders

XBRL is still being adopted and so things can change in a couple of years. At the moment, I would consider both sites to be in the beta stage. They are not perfect and you’ll encounter some bugs and numbers mismatch, but it more than makes up for the time, effort and hair pulling trying to manually do the same thing.

Since XBRL is still relatively new, the data is not going to go far back. You won’t be able to get data from 10 years ago because companies are not going to update all of their filings. That’s just crazy.

So it will take about 6-7 years before you can start exporting 10 years worth of data.

Nevertheless, having access to 3-4 years is a great start.

Please Share if You Find this Useful

If you find this useful, please help out Old School Value by sharing this article using the social sharing buttons.

The more you share, the more I know what type of content you really like and I will be able to provide more quality content.

To get this kind of information and other exclusive articles before regular readers, get on the VIP Mailing List today.

********

What is Old School Value?

Old School Value is a suite of value investing tools designed to fatten your portfolio by identifying what stocks to buy and sell.

It is a stock grader, value screener, and valuation tools for the busy investor designed to help you pick stocks 4x faster.

Check out the live preview of AMZN, MSFT, BAC, AAPL and FB.

Pick Winning Stocks and Fatten Your Portfolio

LIVE PREVIEW OF AAPL, MSFT