Arelle automate small procedure to trasfer data to Excel by using Python -
If we take these simple steps, then we will use the SEC Edgar database to bring data into ARL program.
These steps are:
- Open the ORLL and open the icon-button at the top of the ORLLL click on Open Web File.
- Enter a box URL Pop up above Please provide a URL in which the XBRL example (you can) and click OK.
- When the download is finished (it takes ~ 10 seconds), click on the Scale button, which has the icon-buttons of a scale, from the top left side of the Arial screen to the second sketching. Here is a simple process that I want to do in Python automatically:
-
There is a tab in the Arl, which is called
The fact table is namedin which there are some items that can expand in a tree by clicking on the plus sign beside them. -
Without if you open any of these
right clickfor one of them0110 - Statement - Consolidated balance sheetwhich is another item, you can copy it toclipboardand then click ontable. - Now please go to
Exceland selectCell A1and Ctrl + V
Summary: What I have to do is to do it automatically in Python
Thank you for your attention.
-
Provide a Python API that you can find with documentation.
This API will allow you to automate your process by scripting the activities, so that the need to work with the GUI yourself can be removed which would be cumbersome.
Comments
Post a Comment