Transcript
Page 1: Benchmarking xbrl tag usage

Steps to analyze how XBRL tags are usedby @XBRLAnalyst

FinDynamics, Inc.http://findynamics.com/try-xbrlanalyst/

[email protected]

Page 2: Benchmarking xbrl tag usage

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

Step 1: List companies and tags

Remove from the list Text XBRL tags – the name ends with TextBlock

Page 4: Benchmarking xbrl tag usage

Step 2a: get Unpivoted data in Excel

Page 5: Benchmarking xbrl tag usage

Result:

Page 6: Benchmarking xbrl tag usage

Pivot Table Report:

Page 7: Benchmarking xbrl tag usage

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