I need a script written which will look at data within the SEC and pull out XBRL data and input this into a spreadsheet. The data is mainly financial data.
An example of the data is here
There is a mozilla plugin that does this very nicely however I want this in Google Spreadsheet / SQL
I should have the ability to choose a period and a company in google spreadsheets. This will then look into the SEC data base (FTP or http ) pick out the relevant data for that company and extract it into a human readable format into a spreadsheet or data structure within Google SQL.
A few more links to this type of work is here
I dont want to hold all information forever so there is no need to have a permanent data store.
I am expecting this to be done using google scripts / java.
I expect there will be a company name available that will search the SEC archives for the company data. The data is held in the 10q and 10k forms and is easily identifable.
Additional Project Description:
03/02/2013 at 22:52 EET
I have also attached a spreadsheet which may make it easier for individuals of a non-financial nature to understand the type of output I require. I will also be available from 8am - 10pm UK times to go over any questions that you have throughout the project as it is in my interest this is executed correctly.
I also expect documentaiton to be provided at a high level summarising elements of the solution so that any future modifications can be understood.
I am not concerned about colour schemes etc. At this stage I need an 'engine' that works operationally. We can look to improve the view once the data, process and methods have been established.
03/04/2013 at 6:42 EET
Additional more detailed requirements file updated. Please ensure you read through this as all items are relevant.
There is sample output from another site that does the same thing.
We are not able to assist with the retrival of data from the SEC website as we have very little knowledge in this area. Please ensure you know how to do this or are comptent enough to be able to figure this out. I have added links to the SEC help files. The database is open so there are no access restrictions. The code to retrive the data has to be efficient enough not to have to trawl through the entire SEC database to find the information.
03/04/2013 at 14:11 EET
Full Requirements Spreadsheet.xls contains all the format of the final product.