What would be the best way to tackle this type of project: I would like to create an Excel workbook that has the quarterly financial statement data on a company, HNZ, going back at least ten years. Rather than entering the data in myself, I was wondering if there was a way to import this data all at once? I have found databases to download Excel sheets with the past two or three years, but I would like to go back much further, and on a quarterly basis.
instead of wasting your time trying to get around it, just take the day or two to enter the data like the rest of us.
instead of wasting your time trying to get around it, just take the day or two to enter the data like the rest of us. Or - ask someone on the sell side for it (assuming you are a paying client)
Find a bloomberg machine and make use of the BDH function.
Halberstram Wrote: ------------------------------------------------------- > instead of wasting your time trying to get around > it, just take the day or two to enter the data > like the rest of us. Hmm… Marcus from WSO? Welcome aboard. And to the address the original post, I have yet to find a reasonable service to provide this type of service. Petrobras allows you to export their financial information right from their website… why more companies are not like this is beyond me. The SEC have been working on XBRL for ever and only a handful of companies file through it… one day hopefully… until then grab a cup of coffee and ready your 10 key.
are there any xbrl readers that do this? Of course, older financial statements won’t be marked up with xbrl. Edgar probably has xbrl marked documents.
Yes, an XBRL reader could do this if the XBRL documents with the information existed, but they don’t. Only a handful of companies have been participating in the SEC trial and only since 2002 or so. EdgarOnline has gone back and encoded all the information for the last ten years for the companies they follow, but you have to subscribe to their service to get the information.
Thanks Pigaletto (great name, he he) for filling me in on XBRL. I’ve heard about it some time, and know that EdgarOnline was highly invested in it, but I wasn’t sure of the actual progress in using the standard.
Anyone use this: http://finance.groups.yahoo.com/group/smf_addin/ An Excel plug-in that pulls the data from Yahoo.
ChadD Wrote: ------------------------------------------------------- > Anyone use this: > http://finance.groups.yahoo.com/group/smf_addin/ > > An Excel plug-in that pulls the data from Yahoo. I’ve used it. Works well and the data from ADVFN (sp?) comes from morningstar. Still, it is not entirely accurate, and like other services line items are compressed to fit a format, so depending on what you are doing you may still want to get it directly from filings. Great for a reference point though.