I need help understanding why there are many different values for a specific metric reported by a company's 10-K or 10-Q in the EDGAR database.
I've downloaded the entire US equity universe in JSON from the SEC website here (Bulk Data).
Here is my code for getting the Diluted Earnings Per Share of a company in 2016
import json import pandas as pd f = open('CIK0001511198.json') data = json.load(f) df = pd.DataFrame(data['facts']['us-gaap']['EarningsPerShareDiluted']['units']['USD']) df = df[(df['form'] == '10-K') | (df['form'] == '10-Q')] df[df['fy'] == 2016]
I was expecting 4 rows with three 10-Q and one 10-K... some values are different even within the same form id (
Can someone explain why there are many different values and what the differences are?