Large scale data analytics in XBRL using python

Posted on Tue 20 November 2012 in XBRL • Tagged with financial ratios, python, python xbrl, sec fillings, xbrl analyticsLeave a comment

Hello all,

Just now i am completing my 8 months old experiment. It was to develop something with use of XBRL which can reduce the dependency on financial information which are processed by 3rd party.

I mean that the current dependency on Yahoo finance/Bloomberg/Google Finance/9W search/i-metrix_edgar-online ...

Continue reading

xbrlMapper- "Facts": my first attempt to Arelle's Fact-List

Posted on Mon 17 September 2012 in XBRL • Tagged with arelle, python xbrl, xbrl instance facts, xbrlMapperLeave a comment

I was just thinking that what i can do with my xbrlMapper module, so i thought lets try to make something  like arelle's fact-list(3rd and last image of this post; 'www.arelle.org").

I have extended my present library; added new method "reportGen"; a methods with returns dicts ...

Continue reading

automating calucation of decimal value from scale for xbrl fact

Posted on Sat 28 July 2012 in XBRLLeave a comment

Today in office or currently in office; (both are right...)

i am making python script that can automate calculation of decimal value from scale for various cases of xbrl instance facts.

Here below, i am giving my current output.

(scale, excel value) (decimal, instance value)

(None, '2345') ('INF', '2345')
('3 ...

Continue reading

Dynamic excel mapping for creating XBRL with help of Python/elementTree/xlrd

Posted on Sat 14 July 2012 in XBRL • Tagged with excel, excel macro, python, python xbrl creation, xbrl creatiion, xlrd, xml/xbrlLeave a comment

Yesterday was a great day for me.. .After 3 months of development i got little bit success, i have created xbrl package from excel with help of python language.

I have developed my own mapping language which needs to be defined in excel which recognizes financial facts and their properties ...

Continue reading

Adding new line and encoding infomation while creating XML/XBRL with ElementTree/Python

Posted on Tue 10 July 2012 in XBRL • Tagged with elementTree, ElementTree/Python, encoding, new line, ProcessingInstruction, python, xbrl, xbrl creationLeave a comment

I am making xbrl files with python ElementTree/python module. But there is a problem while creating an xbrl file. It writes it into a single line, which creates confusion a lot.

So i have tried to modified the native ElementTree class which writes a xml  part. In windows it ...

Continue reading