benchmarking xbrl tag usage
Post on 18-Nov-2014
187 Views
Preview:
DESCRIPTION
TRANSCRIPT
Steps to analyze how XBRL tags are usedby @XBRLAnalyst
FinDynamics, Inc.http://findynamics.com/try-xbrlanalyst/
sales@findynamics.com
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
Step 1: List companies and tags
Remove from the list Text XBRL tags – the name ends with TextBlock
Step 2a: get Unpivoted data in Excel
Result:
Pivot Table Report:
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
top related