Edgar URL construction

Aug 13, 2013 at 4:52 PM
Hi,

I want to use Gepsio to download Edgar 10-Q statements. Does anyone know how to construct the URL to properly get a specific XBRL 10-Q by specifying the ticker and the date?

Thanks,

Robby
Coordinator
Aug 14, 2013 at 1:16 PM
Hi there, Robby!

Any URL that points to an XBRL document can be used. The blog post at http://gepsio.blogspot.com/2012/03/using-gepsio-from-c.html illustrates a console application, written in C#, that shows that URLs can be used as input to Gepsio's XbrlDocument.Load() method as easily as file paths can be used. The blog post, for example, shows running the app with a command line of

GepsioConsole http://www.sec.gov/Archives/edgar/data/21344/000104746911006790/ko-20110701.xml

This command line takes the app's argument, which, in this case, is http://www.sec.gov/Archives/edgar/data/21344/000104746911006790/ko-20110701.xml, and uses that as the XBRL document to load. This URL points directly to an XBRL document stored on the Web.

Does this help? I'm not quite sure that I am answering your question, so please let me know if you need some more clarification.

Thanks for trying Gepsio,
Jeff Ferguson
Coordinator
Aug 14, 2013 at 1:21 PM
Oh ... I see now ... I think you're asking about how the URL to be given to Gepsio can be constructed. Good question. That may be up to Edgar. I can find Microsoft's (MSFT) filings by using a URL of http://www.sec.gov/cgi-bin/browse-edgar?CIK=MSFT&Find=Search&owner=exclude&action=getcompany, so I am assuming that search results can be found by using the ticker symbol as the value for the CIK parameter. I may need to do some more digging to find out what URL EDGAR actually needs.

Thanks for trying Gepsio,
Jeff Ferguson
Aug 14, 2013 at 1:22 PM
Actually, what I'm looking for is a better way to construct URLs on Edgar. I think I'm going to have to parse out edgar search responses to get the URL of the XBRL document. I had hoped that it would be something like edgar10Q.html?ticker=AAPL&quarter=201306, but it's more like edgar.html?id=-047301924730192734097. That means I can't just go down a list of tickers and construct the URLs that I want. I will have to use their search form, and parse out a couple of web pages to finally get to the official URL of the edgar posting.

Thanks!

Robby


Coordinator
Aug 16, 2013 at 4:07 PM
I haven't found any good answers yet, so I have posted to your question to a larger XBRL audience. I will let you know what I hear back.

Thanks for trying Gepsio,
Jeff Ferguson
Aug 23, 2013 at 12:54 AM
Thanks!

Sent from my iPad

Coordinator
Aug 23, 2013 at 5:53 PM
I have a bit more information about your question. I will be turning your question and the response into a blog post that I can share with everyone. I will post a link to the blog post when I post it sometime tonight or over the weekend.
Aug 23, 2013 at 7:41 PM
Great. Thanks for going the extra mile.

Sent from my iPad

Coordinator
Aug 24, 2013 at 4:39 PM
I have written a blog post about this issue. Read all about it at http://gepsio.wordpress.com/2013/08/24/edgar-filing-urls-using-ticker-and-date/.
Aug 25, 2013 at 1:34 AM
Thanks. Great sleuthing work!

Sent from my iPhone

Coordinator
Aug 25, 2013 at 1:47 AM
My pleasure. I'm sorry it's not the answer for which you were hoping, but at least we know some of the aspects of the issue.