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 named
in 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 click
for one of them0110 - Statement - Consolidated balance sheet
which is another item, you can copy it toclipboard
and then click ontable
. - Now please go to
Excel
and selectCell A1
and 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