Skip to main content
Message Font: Serif | Sans-Serif
 
No. of Recommendations: 2
Hi KitKat and all
The 10K is not excel compatible
I may be off the mark and can't offer a way to pull the data from within Excel, but I find it easy to download the information from the 10K and 10Q in to Excel.

Here is how I do it.
I use Firefox so skip step two if you're using IE
1. Got to the filing on Edgar
2. Right click and select View Page in IE Tab (you need the Firefox extension for this)
3. Right click anywhere on the data you want to download and select Export to Microsoft Excel.
4. Data is exported to Excel, then quick macro to format the negatives and you're done.

I now it's not fancy, but it quickly does the job.

Hope it is of some help.

Cheers
Dean
Print the post  

Announcements

What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.