Download - Benchmarking xbrl tag usage
![Page 1: Benchmarking xbrl tag usage](https://reader034.vdocuments.us/reader034/viewer/2022051108/546eb245af795967298b5858/html5/thumbnails/1.jpg)
Steps to analyze how XBRL tags are usedby @XBRLAnalyst
FinDynamics, Inc.http://findynamics.com/try-xbrlanalyst/
![Page 2: Benchmarking xbrl tag usage](https://reader034.vdocuments.us/reader034/viewer/2022051108/546eb245af795967298b5858/html5/thumbnails/2.jpg)
Objective:
1. What you need:a) List of companies (by ticker or name or CIK)
b) List of XBRL tags
2. Steps:a) Load companies and tags in Historical Data report,
check the box “Unpivot data” and output results in Excel
b) Using Excel, build Pivot Table on that result
c) Slice and dice the data by industry sectors, periods, counts or values
Analyze how some XBRL tags are used in an industry sector in Excel
Approach using XBRLAnalyst:
Video: https://www.youtube.com/watch?v=u4woyKtVnYE
![Page 3: Benchmarking xbrl tag usage](https://reader034.vdocuments.us/reader034/viewer/2022051108/546eb245af795967298b5858/html5/thumbnails/3.jpg)
Step 1: List companies and tags
Remove from the list Text XBRL tags – the name ends with TextBlock
![Page 4: Benchmarking xbrl tag usage](https://reader034.vdocuments.us/reader034/viewer/2022051108/546eb245af795967298b5858/html5/thumbnails/4.jpg)
Step 2a: get Unpivoted data in Excel
![Page 5: Benchmarking xbrl tag usage](https://reader034.vdocuments.us/reader034/viewer/2022051108/546eb245af795967298b5858/html5/thumbnails/5.jpg)
Result:
![Page 6: Benchmarking xbrl tag usage](https://reader034.vdocuments.us/reader034/viewer/2022051108/546eb245af795967298b5858/html5/thumbnails/6.jpg)
Pivot Table Report:
![Page 7: Benchmarking xbrl tag usage](https://reader034.vdocuments.us/reader034/viewer/2022051108/546eb245af795967298b5858/html5/thumbnails/7.jpg)
Summary:• In the whole Television Broadcasting Stations
Industry Sector, CBS Corporation is the only one to ever use XBRL tag:{DisposalGroupIncludingDiscontinuedOperationGoodwill}
• In every annual report, it also used XBRL tag:{GoodwillWrittenOffRelatedToSaleOfBusinessUnit}
• Only one other company NXST used it once in 2012.
You can view interactive Excel file: http://1drv.ms/R7YxHG