Page 1
Page 1
Started By
Message

Charting of 10k and 10q Data

Posted on 12/26/14 at 8:22 pm
Posted by Bayou Tiger
Member since Nov 2003
3657 posts
Posted on 12/26/14 at 8:22 pm
Is anyone familiar with a website or tool that allows you to plot a company's trends of Revenue, EBITDA, Capital Investment, etc. I find myself reading various 10k and 10q reports and writing the trends down by hand. Surely there is an easier way.
Posted by boosiebadazz
Member since Feb 2008
80182 posts
Posted on 12/26/14 at 8:26 pm to
excel?
Posted by GeauxColonels
Tottenham Fan | LSU Fan
Member since Oct 2009
25604 posts
Posted on 12/26/14 at 8:34 pm to
Was thinking the same thing.
Posted by Bayou Tiger
Member since Nov 2003
3657 posts
Posted on 12/26/14 at 8:37 pm to
I guess I should have been more specific.

Whether capturing trends by hand or in Excel, I have to read each individual 10k or 10q to extract the numbers. It seems like a website or something would already have all of this data extracted, grouped into data series, and with a simple interface for plotting.
Posted by boosiebadazz
Member since Feb 2008
80182 posts
Posted on 12/26/14 at 8:40 pm to
SEC is the only thing I can think of
Posted by lynxcat
Member since Jan 2008
24125 posts
Posted on 12/26/14 at 11:14 pm to
You could extract into Excel pretty easily
Posted by CalcuttaTigah
Member since Jul 2009
769 posts
Posted on 12/27/14 at 8:07 am to
You can download most of the data and chart it yourself. If you really want to be a baller, the answer is CapIQ.
Posted by igoringa
South Mississippi
Member since Jun 2007
11875 posts
Posted on 12/27/14 at 10:23 am to
XBRL was mandated to allow just this - not sure if anyone uses it though or knows how to use it
This post was edited on 12/27/14 at 10:24 am
Posted by Bayou Tiger
Member since Nov 2003
3657 posts
Posted on 12/27/14 at 9:23 pm to
I have been looking online for ways to get the XBRL data for free into Excel.

So far,
- XBRLAnalyst looks pretty sweet but costs $999 per year.
- FreeXBRLonline is only FREE for a subset of companies that I am not really interested in
- SEC.gov is generous enough to provide a tool to extract the data, but it of course involves "rendering" the data through use of command line prompts and batch files. Geez. Thanks but no thanks.
- XBRLxl.com is a free tool to extract to Excel and seemed promising. But when I downloaded some data from the web interface, a lot of the key data in the Excel sheet was nulled out. Then I tried to use their Excel template but couldn't get the queries to Refresh with my new ticker symbols.

That's about all I have the patience to scout out tonight. Maybe I will look around tomorrow to see if I can find anything better.
Posted by Bayou Tiger
Member since Nov 2003
3657 posts
Posted on 1/10/15 at 4:18 pm to
Bump for posters back from winter break...

I never did have much luck figuring out a free way to get this data in Excel.
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram