QA: us_semiconductors 2009-2023

Ranks across the years

	name	name_short	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2009-val	2010-val	2011-val	2012-val	2013-val	2014-val	2015-val	2016-val	2017-val	2018-val	2019-val	2020-val	2021-val	2022-val	2023-val	2009->2010	2010->2011	2011->2012	2012->2013	2013->2014	2014->2015	2015->2016	2016->2017	2017->2018	2018->2019	2019->2020	2020->2021	2021->2022	2022->2023
0000724910	NVE Corp NEW	NVE Cor	NaN	NaN	2	1	1	2	4	2	NaN	NaN	NaN	NaN	NaN	2	1	NaN	NaN	583.169500	552.645130	547.492500	532.855140	553.275670	543.184180	NaN	NaN	NaN	NaN	NaN	571.865450	673.253010	NaN	NaN	-1	0	1	2	-2	NaN	NaN	NaN	NaN	NaN	NaN	-1
0000855658	Lattice Semiconductor Corp	Lattice	NaN	NaN	16	47	19	NaN	13	64	61	55	33	NaN	35	20	2	NaN	NaN	450.153260	289.457620	387.562900	NaN	417.622430	66.294766	47.334209	101.244000	208.006820	NaN	222.268610	328.100850	527.324800	NaN	NaN	31	-28	NaN	NaN	51	-3	-6	-22	NaN	NaN	-15	-18
0001280452	Monolithic Power Systems INC	Monolit	NaN	NaN	25	NaN	NaN	NaN	NaN	NaN	NaN	11	9	10	6	8	3	NaN	NaN	406.272460	NaN	NaN	NaN	NaN	NaN	NaN	395.622720	390.969730	406.948330	400.469710	443.547130	455.407430	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	1	-4	2	-5
0000833640	Power Integrations INC	Power I	NaN	15	32	46	9	7	11	9	12	4	1	3	2	3	4	NaN	397.531370	395.099730	290.882610	438.217070	443.109520	420.954340	424.785100	400.165100	462.266600	550.447110	436.162080	493.817630	520.608090	449.858770	NaN	17	14	-37	-2	4	-2	3	-8	-3	2	-1	1	1
0000002488	Advanced Micro Devices INC	Advance	NaN	29	60	83	66	65	65	55	44	38	30	2	11	12	5	NaN	286.307020	277.102560	58.098573	203.136860	149.421930	64.394947	116.969360	199.489850	222.117130	236.607370	437.949030	374.244790	422.417610	412.332610	NaN	31	23	-17	-1	0	-10	-11	-6	-8	-28	9	1	-7
0000827054	Microchip Technology INC	Microch	1	4	11	5	13	NaN	NaN	NaN	NaN	24	11	6	13	7	6	484.56776	476.668080	468.719360	475.717140	415.715180	NaN	NaN	NaN	NaN	303.020220	373.860940	410.548830	362.577160	449.789280	406.821980	3	7	-6	8	NaN	NaN	NaN	NaN	NaN	-13	-5	7	-6	-1
0001438423	Everspin Technologies INC	Everspi	NaN	NaN	NaN	NaN	NaN	NaN	NaN	67	72	64	62	59	21	23	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3.971608	-212.904170	-29.715601	-49.442197	34.181757	311.985600	316.512960	398.696910	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	-8	-2	-3	-38	2	-16
0000810136	Photronics INC	Photron	NaN	NaN	64	53	54	39	31	18	18	21	18	16	20	22	8	NaN	NaN	257.860140	269.710040	250.917370	274.586680	275.424920	368.298750	362.299300	339.404990	336.379010	351.390260	322.915320	316.566150	394.270920	NaN	NaN	-11	1	-15	-8	-13	0	3	-3	-2	4	2	-14
0001039399	Formfactor INC	Formfac	NaN	NaN	63	48	57	31	23	40	27	10	21	18	14	17	9	NaN	NaN	266.255910	289.290560	237.375480	299.717190	349.035770	216.880180	300.967150	398.835670	316.744140	349.637080	359.476530	342.650070	375.232710	NaN	NaN	-15	9	-26	-8	17	-13	-17	11	-3	-4	3	-8
0000772406	Cirrus Logic INC	Cirrus	NaN	NaN	1	8	4	4	35	23	NaN	NaN	NaN	NaN	NaN	NaN	10	NaN	NaN	663.308250	466.501720	478.528390	469.286750	256.685780	331.592660	NaN	NaN	NaN	NaN	NaN	NaN	368.899270	NaN	NaN	7	-4	0	31	-12	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000088941	Semtech Corp	Semtech	NaN	21	23	6	22	47	17	16	10	13	7	9	4	6	11	NaN	352.373620	425.241420	474.789540	380.993960	251.125030	391.093910	381.279650	402.134370	393.612580	409.225670	407.295840	419.154330	452.709400	360.035120	NaN	2	-17	16	25	-30	-1	-6	3	-6	2	-5	2	5
0000050863	Intel Corp	Intel C	3	5	15	12	10	10	14	14	9	2	5	4	5	16	12	406.06608	468.708180	451.828210	433.551460	429.549040	408.074070	414.258900	385.193270	408.480600	471.661590	436.559700	430.012450	413.961780	357.316770	355.544530	2	10	-3	-2	0	4	0	-5	-7	3	-1	1	11	-4
0000912093	Viavi Solutions INC	Viavi S	NaN	NaN	52	65	34	24	NaN	21	13	33	19	NaN	33	30	13	NaN	NaN	325.779090	200.839200	331.811820	325.268340	NaN	343.624610	397.573030	249.816820	331.765520	NaN	253.499850	295.444470	337.481950	NaN	NaN	13	-31	-10	NaN	NaN	-8	20	-14	NaN	NaN	-3	-17
0001807794	Credo Technology Group Holding Ltd	Credo T	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28	19	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	272.621690	333.749280	335.287170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9	-5
0000004127	Skyworks Solutions INC	Skywork	NaN	14	22	11	6	5	5	1	1	3	3	5	22	31	15	NaN	398.195390	426.683160	441.991100	466.390940	449.684180	488.364190	580.346910	526.726520	471.315350	464.844430	425.342590	305.170740	288.004760	334.196330	NaN	8	-11	-5	-1	0	-4	0	2	0	2	17	9	-16
0000056978	Kulicke Soffa Industries INC	Kulicke	NaN	NaN	53	14	23	17	19	19	19	25	26	22	9	10	16	NaN	NaN	321.866540	429.588380	378.288210	378.811500	383.278250	355.922890	361.519680	302.291990	261.998770	296.406400	376.386650	437.974320	329.865170	NaN	NaN	-39	9	-6	2	0	0	6	1	-4	-13	1	6
0001038074	Silicon Laboratories INC	Silicon	NaN	12	39	37	40	NaN	30	25	38	30	28	NaN	39	39	17	NaN	409.792260	378.178030	323.622930	308.753980	NaN	289.627970	325.335690	227.107800	258.269850	240.887910	NaN	205.235640	245.828560	325.870990	NaN	27	-2	3	NaN	NaN	-5	13	-8	-2	NaN	NaN	0	-22
0000091668	Solitron Devices INC	Solitro	NaN	NaN	35	NaN	14	6	8	NaN	NaN	NaN	NaN	32	8	13	18	NaN	NaN	383.541530	NaN	407.739190	448.905040	447.742090	NaN	NaN	NaN	NaN	244.713940	382.341600	414.419480	311.793040	NaN	NaN	NaN	NaN	-8	2	NaN	NaN	NaN	NaN	NaN	-24	5	5
0000006281	Analog Devices INC	Analog	NaN	17	42	30	30	29	26	31	47	40	34	34	24	29	19	NaN	371.026110	361.896030	341.885500	339.190670	302.266370	321.271220	285.620560	165.692650	210.302890	206.746620	210.241940	283.470330	298.760200	309.413150	NaN	25	-12	0	-1	-3	5	16	-7	-6	0	-10	5	-10
0000006951	Applied Materials INC De	Applied	NaN	27	58	64	65	49	49	41	37	42	36	33	31	34	20	NaN	296.006860	295.619700	201.435090	207.724320	242.114070	200.209100	213.043580	238.897280	198.188110	197.353360	223.614160	260.682640	260.540260	285.786380	NaN	31	6	1	-16	0	-8	-4	5	-6	-3	-2	3	-14
0001097864	On Semiconductor Corp	On Semi	NaN	34	84	NaN	NaN	NaN	59	62	46	47	48	52	41	36	21	NaN	196.374570	113.233670	NaN	NaN	NaN	150.813880	84.562932	167.329740	165.051240	126.065740	133.696730	200.799780	246.495190	284.841650	NaN	50	NaN	NaN	NaN	NaN	3	-16	1	1	4	-11	-5	-15
0000097476	Texas Instruments INC	Texas I	4	8	69	59	53	36	28	22	26	22	23	24	17	18	22	399.92904	445.822430	225.712740	224.755820	252.863200	280.208430	308.341650	342.120240	311.336030	333.792640	298.868890	290.541350	342.774540	337.612470	270.549380	4	61	-10	-6	-17	-8	-6	4	-4	1	1	-7	1	4
0001274494	First Solar INC	First S	2	13	71	68	52	26	25	36	33	27	31	19	15	38	23	428.01497	400.630970	211.730370	178.758480	253.710380	322.399800	331.923420	254.095680	261.790180	282.377370	231.236860	332.178470	354.996580	246.036510	269.152840	11	58	-3	-16	-26	-1	11	-3	-6	4	-12	-4	23	-15
0001325702	Magnachip Semiconductor Corp	Magnach	NaN	NaN	NaN	58	NaN	89	73	69	64	62	59	1	16	27	24	NaN	NaN	NaN	231.008090	NaN	-80.984815	-66.295533	-47.609053	8.989818	-0.952449	-8.595559	540.071260	350.972880	307.885010	265.132940	NaN	NaN	NaN	NaN	NaN	-16	-4	-5	-2	-3	-58	15	11	-3
0001831651	Shoals Technologies Group Inc	Shoals	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	66	32	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-0.567180	281.740020	251.740130	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-34	-7
0001051627	AXT INC	AXT INC	NaN	NaN	6	23	26	19	22	12	7	18	16	15	10	26	26	NaN	NaN	497.953370	397.118820	352.867250	368.218500	361.851840	397.206620	420.029170	373.503560	338.696660	374.794470	376.137840	311.942250	245.520130	NaN	NaN	17	3	-7	3	-10	-5	11	-2	-1	-5	16	0
0001835632	Marvell Technology Inc	Marvell	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23	37	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	285.285890	246.399160	244.600560	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	-10
0001124796	Nlight INC	Nlight	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12	20	30	29	42	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	394.713350	321.536300	255.471500	266.052000	214.881600	243.206070	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8	10	-1	13	-14
0001493594	Macom Technology Solutions Holdings Inc	Macom T	NaN	NaN	NaN	51	25	76	55	54	58	56	63	57	53	24	29	NaN	NaN	NaN	274.937300	354.460200	83.037779	179.814710	118.241040	91.849283	89.322738	-76.649660	53.028913	138.710980	314.553100	238.698000	NaN	NaN	NaN	-26	51	-21	-1	4	-2	7	-6	-4	-29	5
0001045810	Nvidia Corp	Nvidia	7	28	50	22	17	14	36	35	29	15	4	17	27	21	30	285.94268	288.090940	341.400210	402.432940	402.583590	400.670170	255.735980	254.648470	286.420040	388.308440	437.806400	350.627220	276.193170	322.228360	226.750150	21	22	-28	-5	-3	22	-1	-6	-14	-11	13	10	-6	9
0001451809	Sitime Corp	Sitime	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	46	27	3	9	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	130.092600	272.877400	443.049420	440.719420	225.613120	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-19	-24	6	22
0000065759	Micropac Industries INC	Micropa	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	35	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	253.263800	225.486900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3
0001047127	Amkor Technology INC	Amkor T	NaN	39	87	81	80	71	61	56	53	51	42	42	38	41	33	NaN	98.365712	82.454627	63.970234	89.395157	98.401520	93.669193	116.351960	136.480630	135.515760	137.878040	177.736720	206.281210	232.865280	224.675550	NaN	48	-6	-1	-9	-10	-5	-3	-2	-9	0	-4	3	-8
0001604778	Qorvo Inc	Qorvo I	NaN	NaN	NaN	NaN	NaN	37	15	32	30	28	24	29	25	33	34	NaN	NaN	NaN	NaN	NaN	279.999790	399.379120	282.579440	279.590720	276.094010	294.822050	257.329730	280.172340	277.474590	200.303750	NaN	NaN	NaN	NaN	NaN	-22	17	-2	-2	-4	5	-4	8	1
0000723125	Micron Technology INC	Micron	NaN	NaN	67	70	69	55	42	52	34	1	13	21	18	15	35	NaN	NaN	242.025040	153.605020	197.709030	232.870230	240.198870	137.647560	255.348390	493.202360	362.677170	297.774460	338.877730	357.858500	193.985520	NaN	NaN	3	-1	-14	-13	10	-18	-33	12	8	-3	-3	20
0001730168	Broadcom Inc	Broadco	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	53	54	49	36	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	105.274190	133.558200	157.368380	182.472620	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	-5	-13
0001288469	Maxlinear INC	Maxline	NaN	NaN	74	66	70	46	39	8	52	50	39	56	48	40	37	NaN	NaN	206.818920	198.127490	193.358920	251.523380	249.484200	458.218080	139.640360	154.431830	178.649230	66.091033	162.339490	243.468260	178.409210	NaN	NaN	-8	4	-24	-7	-31	44	-2	-11	17	-8	-8	-3
0001652535	Ichor Holdings LTD	Ichor H	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	48	45	49	38	45	43	38	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	161.014260	177.511930	122.673950	191.933490	187.304560	209.315510	176.289700	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	4	-11	7	-2	-5
0001126741	GSI Technology INC	GSI Tec	NaN	NaN	14	18	15	20	24	24	22	23	12	23	44	44	39	NaN	NaN	457.476760	415.634100	406.093410	357.029080	340.205450	327.923610	339.375880	330.554050	368.603780	295.430190	189.040870	198.234430	172.921850	NaN	NaN	4	-3	5	4	0	-2	1	-11	11	21	0	-5
0001463101	Enphase Energy Inc	Enphase	NaN	NaN	NaN	92	88	79	69	71	68	63	32	43	61	54	40	NaN	NaN	NaN	-14.815295	-4.646397	60.481121	8.228302	-156.912660	-112.736350	-6.243503	216.211960	172.313150	83.375567	128.010640	138.934320	NaN	NaN	NaN	-4	-9	-10	2	-3	-5	-31	11	18	-7	-14
0001821769	Navitas Semiconductor Corp	Navitas	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	74	4	41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-164.147250	508.156940	113.005760	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-70	37
0001398805	Beam Global	Beam Gl	NaN	NaN	98	103	103	93	75	78	75	71	60	28	40	67	42	NaN	NaN	-454.040180	-778.671170	-836.378640	-503.179030	-396.159600	-484.611690	-364.799590	-414.341320	-32.877923	263.280910	201.076620	-80.675483	107.445150	NaN	NaN	5	0	-10	-18	3	-3	-4	-11	-32	12	27	-25
0001158114	Applied Optoelectronics INC	Applied	NaN	NaN	NaN	NaN	71	57	44	27	15	34	52	51	56	59	43	NaN	NaN	NaN	NaN	180.521560	224.985420	221.261650	310.218700	385.478900	240.445780	117.313940	137.342850	123.797300	39.450840	100.621640	NaN	NaN	NaN	NaN	-14	-13	-17	-12	19	18	-1	5	3	-16
0000882508	Quicklogic Corp	Quicklo	NaN	NaN	45	77	73	66	NaN	70	67	65	65	NaN	70	61	44	NaN	NaN	353.661490	93.143399	166.595100	141.868980	NaN	-113.655980	-112.270800	-45.147659	-101.178450	NaN	-50.624894	-15.553768	97.922225	NaN	NaN	32	-4	-7	NaN	NaN	-3	-2	0	NaN	NaN	-9	-17
0001040161	Pixelworks INC	Pixelwo	NaN	NaN	NaN	84	85	84	63	66	49	41	38	58	55	48	45	NaN	NaN	NaN	56.356554	37.957614	-5.498593	69.278854	9.538732	159.541640	203.094350	186.960810	41.797798	129.632280	167.259750	77.110111	NaN	NaN	NaN	1	-1	-21	3	-17	-8	-3	20	-3	-7	-3
0001819974	Skywater Technology Inc	Skywate	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	68	63	46	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-30.004121	-17.687589	16.038152	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	-17
0001616533	Smart Global Holdings Inc	Smart G	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	62	52	41	55	62	57	47	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.897518	132.917630	146.161760	71.691599	71.986090	82.482295	-8.748595	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-10	-11	14	7	-5	-10
0000771266	Kopin Corp	Kopin C	NaN	NaN	37	41	24	61	NaN	NaN	NaN	NaN	NaN	46	59	66	48	NaN	NaN	379.164200	309.447160	369.246030	216.519740	NaN	NaN	NaN	NaN	NaN	167.063040	94.944297	-59.177275	-18.431458	NaN	NaN	4	-17	37	NaN	NaN	NaN	NaN	NaN	NaN	13	7	-18
0001333822	Semileds Corp	Semiled	NaN	NaN	NaN	78	91	82	67	73	63	61	64	60	67	60	49	NaN	NaN	NaN	86.729546	-19.866294	25.420117	34.828292	-323.105400	27.495113	3.314210	-87.021267	26.471270	-3.094374	-12.124292	-62.776093	NaN	NaN	NaN	13	-9	-15	6	-10	-2	3	-4	7	-7	-11
0001634447	Isun INC	Isun IN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	14	43	55	50	51	72	50	NaN	NaN	NaN	NaN	NaN	NaN	NaN	419.973480	395.554770	183.932140	56.799508	139.281930	157.408450	-278.092920	-72.606558	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	29	12	-5	1	21	-22
0000808326	Emcore Corp	Emcore	NaN	NaN	88	91	64	62	2	15	16	37	54	47	12	52	51	NaN	NaN	82.423621	9.800937	208.576610	208.846560	595.385120	383.065320	375.091770	223.202430	59.020172	164.384720	373.838690	144.379300	-97.423965	NaN	NaN	3	-27	-2	-60	13	1	21	17	-7	-35	40	-1
0001667011	Arteris Inc	Arteris	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	64	62	52	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	36.219574	-16.913182	-111.070900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-10
0001507957	Ideal Power Inc	Ideal P	NaN	NaN	NaN	NaN	92	91	70	77	71	73	NaN	NaN	26	53	53	NaN	NaN	NaN	NaN	-22.205592	-90.801411	-8.951158	-466.729060	-165.475900	-504.724230	NaN	NaN	277.055940	137.585770	-202.047020	NaN	NaN	NaN	NaN	-1	-21	7	-6	2	NaN	NaN	NaN	27	0
0001420520	Atomera Inc	Atomera	NaN	NaN	NaN	NaN	NaN	NaN	NaN	61	69	66	67	49	65	68	54	NaN	NaN	NaN	NaN	NaN	NaN	NaN	87.338015	-113.059500	-75.065528	-223.994730	146.722450	29.628935	-116.245900	-222.684020	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8	-3	1	-18	16	3	-14
0001817760	Smartkem Inc	Smartke	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	79	76	55	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-403.699120	-586.652780	-246.145100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	-21
0001282631	Netlist INC	Netlist	NaN	NaN	83	99	98	92	NaN	72	74	69	68	NaN	73	69	56	NaN	NaN	113.554570	-136.713660	-175.201040	-344.799350	NaN	-218.720330	-297.680700	-284.618170	-255.525050	NaN	-127.782860	-119.308930	-288.459820	NaN	NaN	16	-1	-6	NaN	NaN	2	-5	-1	NaN	NaN	-4	-13
0001832487	Guerrilla Rf Inc	Guerril	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34	71	57	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	230.223230	-261.849730	-343.833650	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37	-14
0000890394	Peraso Inc	Peraso	NaN	NaN	4	73	67	87	72	76	70	70	57	64	37	77	58	NaN	NaN	518.578600	121.581620	202.395130	-33.517196	-59.665150	-445.639550	-121.590470	-329.551700	20.553502	-111.483020	210.474360	-595.515460	-631.543730	NaN	NaN	69	-6	20	-15	4	-6	0	-13	7	-27	40	-19
0001682149	Wisa Technologies INC	Wisa Te	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	78	70	68	72	75	59	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-7122.312500	-1186.889100	-410.537690	-62.025619	-534.369240	-1143.045200	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-8	-2	4	3	-16
0000768251	Altera Corp	Altera	9	25	43	34	60	52	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	200.00729	324.701910	357.500750	332.812300	229.797900	239.206130	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16	18	-9	26	-8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000945436	Sunedison INC	Sunedis	8	37	94	90	93	85	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	212.34099	160.374820	-88.768119	23.277980	-23.853346	-13.007929	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29	57	-4	3	-8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001054374	Broadcom Corp	Broadco	6	11	21	25	20	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	304.69020	428.807290	436.578560	389.600000	387.336770	395.120750	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	10	4	-5	-5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001058057	Marvell Technology Group LTD	Marvell	5	NaN	13	13	NaN	NaN	NaN	44	20	8	27	14	NaN	NaN	NaN	381.00897	NaN	458.008620	432.047700	NaN	NaN	NaN	195.014040	360.891000	442.705270	258.031610	388.229440	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN	-24	-12	19	-13	NaN	NaN	NaN
0000093384	Standard Microsystems Corp	Standar	NaN	26	55	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	308.566430	314.927170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000310568	Microsemi Corp	Microse	NaN	9	27	26	11	11	12	11	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	445.360160	405.108180	386.528520	423.658110	407.644430	420.728660	399.803690	421.624460	NaN	NaN	NaN	NaN	NaN	NaN	NaN	18	-1	-15	0	1	-1	-5	NaN	NaN	NaN	NaN	NaN	NaN
0000316793	International Rectifier Corp De	Interna	NaN	23	34	42	43	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	329.862690	384.604590	303.474920	293.142830	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	8	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000703360	LSI Corp	LSI Cor	NaN	35	70	67	49	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	183.224940	220.109160	185.342260	276.983600	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	35	-3	-18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000703361	Integrated Device Technology INC	Integra	NaN	22	33	20	32	8	10	29	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	345.101010	386.123820	409.758590	337.908140	443.099550	421.469730	305.377350	278.833910	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	-13	12	-24	2	19	2	NaN	NaN	NaN	NaN	NaN	NaN
0000743316	Maxim Integrated Products INC	Maxim I	NaN	31	NaN	NaN	NaN	NaN	50	47	41	44	25	NaN	NaN	NaN	NaN	NaN	259.566510	NaN	NaN	NaN	NaN	200.183990	182.459760	211.698560	180.954180	265.377680	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	-6	3	-19	NaN	NaN	NaN	NaN
0000743988	Xilinx INC	Xilinx	NaN	6	5	4	5	16	16	13	11	16	2	12	NaN	NaN	NaN	NaN	450.925230	500.623100	485.206600	470.440920	393.296360	397.512260	388.444610	401.172090	383.995900	510.475420	397.646620	NaN	NaN	NaN	NaN	-1	-1	1	11	0	-3	-2	5	-14	10	NaN	NaN	NaN
0000767920	PMC Sierra INC	PMC Sie	NaN	24	40	80	47	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	326.285560	373.390300	83.440057	279.770010	347.475330	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16	40	-33	-25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000791915	Cypress Semiconductor Corp De	Cypress	NaN	38	NaN	NaN	86	74	NaN	46	50	35	35	NaN	NaN	NaN	NaN	NaN	149.895780	NaN	NaN	36.191758	84.411443	NaN	184.897270	151.118970	240.031960	199.562190	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-12	NaN	NaN	4	-15	0	NaN	NaN	NaN	NaN
0000817720	Synaptics Inc	Synapti	NaN	20	31	27	18	40	48	42	39	53	44	41	52	46	NaN	NaN	355.414450	398.857580	378.732490	395.948660	272.686280	202.698940	201.434100	213.258760	108.466630	133.619760	184.675730	147.321940	177.208280	NaN	NaN	11	-4	-9	22	8	-6	-3	14	-9	-3	11	-6	NaN
0000867773	Sunpower Corp	Sunpowe	NaN	36	78	89	NaN	69	NaN	65	66	67	58	NaN	42	58	NaN	NaN	166.539370	178.894510	33.020674	NaN	125.348830	NaN	62.561522	-102.110790	-142.593390	5.304538	NaN	192.211640	57.262224	NaN	NaN	42	11	NaN	NaN	NaN	NaN	1	1	-9	NaN	NaN	16	NaN
0000872448	Atmel Corp	Atmel C	NaN	19	36	NaN	NaN	59	33	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	363.549390	379.482620	NaN	NaN	224.171770	260.454200	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17	NaN	NaN	NaN	-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000895419	Wolfspeed INC	Wolfspe	NaN	7	17	16	12	13	27	20	25	36	37	39	57	45	NaN	NaN	449.638780	444.788880	419.290130	417.772750	404.732380	319.833440	345.697570	312.959770	234.494460	187.822860	191.154960	121.208850	179.078710	NaN	NaN	10	-1	-4	1	14	-7	5	11	1	2	18	-12	NaN
0000911160	Rf Micro Devices INC	Rf Micr	NaN	33	57	55	63	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	201.931640	299.720810	250.536070	210.780860	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	24	-2	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000913885	Triquint Semiconductor INC	Triquin	NaN	3	26	33	33	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	478.086980	405.313870	337.541450	332.681550	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23	7	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000917273	Rambus INC	Rambus	NaN	18	79	85	78	43	7	38	40	NaN	NaN	NaN	NaN	NaN	NaN	NaN	370.588000	175.605070	55.820978	122.750860	258.969850	448.159460	249.744380	211.829110	NaN	NaN	NaN	NaN	NaN	NaN	NaN	61	6	-7	-35	-36	31	2	NaN	NaN	NaN	NaN	NaN	NaN
0001036960	Fairchild Semiconductor International INC	Fairchi	NaN	30	59	49	45	51	41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	264.397140	284.827290	289.086410	287.613180	239.459860	241.830670	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29	-10	-4	6	-10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001096325	Intersil Corp De	Intersi	NaN	32	61	43	NaN	28	20	17	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	224.167930	270.935570	300.117770	NaN	315.824020	376.781540	368.440970	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29	-18	NaN	NaN	-8	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001102934	CMC Materials Inc	CMC Mat	NaN	10	19	63	59	48	34	30	23	7	45	45	58	NaN	NaN	NaN	442.802100	441.421530	218.059090	233.333930	248.943260	260.104130	303.409750	317.554360	443.177840	131.966550	168.420500	109.057640	NaN	NaN	NaN	9	44	-4	-11	-14	-4	-7	-16	38	0	13	NaN	NaN
0001130866	Hittite Microwave Corp	Hittite	NaN	1	3	3	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	539.572770	560.500900	521.768180	506.984070	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001175609	Cavium INC	Cavium	NaN	16	44	82	51	45	29	60	54	NaN	NaN	NaN	NaN	NaN	NaN	NaN	396.507660	354.861270	63.549023	256.182840	256.335070	296.754320	91.405589	130.247860	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28	38	-31	-6	-16	31	-6	NaN	NaN	NaN	NaN	NaN	NaN
0001261694	Tessera Technologies INC	Tessera	NaN	2	29	29	77	1	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	480.706260	402.433280	371.928430	127.526360	628.946790	591.793380	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	27	0	48	-76	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000711065	Applied Micro Circuits Corp	Applied	NaN	NaN	49	79	97	54	62	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	342.489770	83.842971	-173.326660	239.108720	85.848773	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30	18	-43	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000730000	Supertex INC	Superte	NaN	NaN	30	24	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	401.550330	393.991420	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000753568	Exar Corp	Exar Co	NaN	NaN	66	54	35	21	46	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	244.249500	259.601630	331.012120	349.227530	205.741230	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-12	-19	-14	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000791907	Linear Technology Corp Ca	Linear	NaN	NaN	65	61	56	3	NaN	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	247.215790	218.806800	239.801410	492.925000	NaN	513.707240	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	-5	-53	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000850579	PLX Technology INC	PLX Tec	NaN	NaN	81	95	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	136.703970	-32.040691	338.966170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	-64	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000854701	Integrated Silicon Solution INC	Integra	NaN	NaN	20	45	29	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	438.982090	292.128170	342.263340	323.471170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25	-16	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000869986	Advanced Photonix INC	Advance	NaN	NaN	73	57	79	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	209.327590	236.147440	113.182580	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-16	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000880446	Vitesse Semiconductor Corp	Vitesse	NaN	NaN	95	98	95	83	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-163.943480	-88.095273	-52.011406	4.390908	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-3	-12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000886328	E Digital Corp	E Digit	NaN	NaN	93	NaN	NaN	NaN	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	48.658051	NaN	NaN	NaN	269.745100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000887969	MRV Communications INC	MRV Com	NaN	NaN	75	69	74	75	56	63	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	206.253690	164.358900	148.522640	83.914495	179.688470	77.284119	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	5	1	-19	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000889971	Lightpath Technologies INC	Lightpa	NaN	NaN	91	76	58	56	53	28	24	26	29	26	43	50	NaN	NaN	NaN	66.863318	98.847201	236.531380	225.242370	183.320260	309.066540	313.403400	297.158850	237.015160	277.071020	189.460450	156.226490	NaN	NaN	NaN	-15	-18	-2	-3	-25	-4	2	3	-3	17	7	NaN
0000907686	Plures Technologies Inc De	Plures	NaN	NaN	86	101	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	94.555679	-211.924990	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000915778	DSP Group INC De	DSP Gro	NaN	NaN	68	52	42	30	NaN	NaN	NaN	NaN	NaN	31	NaN	NaN	NaN	NaN	NaN	234.568690	273.975580	293.744790	300.371290	NaN	NaN	NaN	NaN	NaN	246.148560	NaN	NaN	NaN	NaN	NaN	-16	-10	-12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000932111	Micrel INC	Micrel	NaN	NaN	38	35	27	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	378.519620	331.137700	346.098640	338.323460	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	-8	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000940332	Anadigics INC	Anadigi	NaN	NaN	76	93	94	NaN	74	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	189.006410	-22.135971	-42.433559	NaN	-181.640850	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000944739	Transwitch Corp De	Transwi	NaN	NaN	97	102	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-274.402600	-404.957750	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000945699	Ixys LLC	Ixys LL	NaN	NaN	54	39	44	38	38	34	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	321.384530	317.700770	291.710380	277.384680	253.417580	254.657370	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-15	5	-6	0	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001001426	Pericom Semiconductor Corp	Pericom	NaN	NaN	48	32	46	18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	344.852610	339.625260	287.414890	370.390660	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-16	14	-28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001039065	OSI Systems INC	OSI Sys	NaN	NaN	62	62	72	64	40	45	51	54	40	48	46	47	NaN	NaN	NaN	270.932170	218.762960	179.501660	193.560480	244.847170	185.634490	149.441470	103.161130	154.880420	162.308300	171.054570	168.572370	NaN	NaN	NaN	0	10	-8	-24	5	6	3	-14	8	-2	1	NaN
0001046995	Emagin Corp	Emagin	NaN	NaN	8	15	87	63	43	59	59	60	50	61	63	56	NaN	NaN	NaN	473.448710	423.430250	13.678230	199.973750	238.387610	100.387030	59.909221	33.482031	120.447780	-14.789554	53.855939	84.065072	NaN	NaN	NaN	7	72	-24	-20	16	0	1	-10	11	2	-7	NaN
0001050550	Volterra Semiconductor Corp	Volterr	NaN	NaN	10	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	469.945700	444.795560	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001094739	Finisar Corp	Finisar	NaN	NaN	41	31	38	35	37	33	35	39	NaN	NaN	NaN	NaN	NaN	NaN	NaN	368.472730	340.504400	312.447180	280.254780	255.504180	260.700310	255.132250	213.382060	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-10	7	-3	2	-4	2	4	NaN	NaN	NaN	NaN	NaN
0001106851	Omnivision Technologies INC	Omnivis	NaN	NaN	51	50	50	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	339.371190	282.148470	266.762730	321.468900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	0	-23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001110647	Oclaro INC	Oclaro	NaN	NaN	80	88	90	60	NaN	50	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	137.466660	38.748076	-19.257022	221.486990	NaN	150.937730	415.394320	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8	2	-30	NaN	NaN	-42	NaN	NaN	NaN	NaN	NaN	NaN
0001111928	IPG Photonics Corp	IPG Pho	NaN	NaN	18	9	7	12	9	7	3	9	6	8	NaN	NaN	NaN	NaN	NaN	443.047770	446.710250	464.379400	406.221380	439.013360	460.358730	475.713490	433.780210	416.763300	407.937860	NaN	NaN	NaN	NaN	NaN	-9	-2	5	-3	-2	-4	6	-3	2	NaN	NaN	NaN
0001160958	Inphi Corp	Inphi C	NaN	NaN	28	44	37	33	57	NaN	56	57	53	54	NaN	NaN	NaN	NaN	NaN	404.663680	298.985750	313.699570	297.096670	174.556740	NaN	94.935726	69.445177	66.780699	71.951564	NaN	NaN	NaN	NaN	NaN	16	-7	-4	24	NaN	NaN	1	-4	1	NaN	NaN	NaN
0001210618	SPI Energy Co Ltd	SPI Ene	NaN	NaN	89	94	99	68	NaN	NaN	NaN	NaN	NaN	NaN	71	64	NaN	NaN	NaN	73.670246	-27.436233	-179.326580	126.489430	NaN	NaN	NaN	NaN	NaN	NaN	-56.881444	-41.275460	NaN	NaN	NaN	5	5	-31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-7	NaN
0001224370	Mindspeed Technologies INC	Mindspe	NaN	NaN	72	87	101	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	210.173810	41.929405	-372.761790	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001227025	Neophotonics Corp	Neophot	NaN	NaN	77	NaN	76	67	47	48	57	58	51	40	60	NaN	NaN	NaN	NaN	180.985230	NaN	131.733950	132.284050	204.332050	180.127150	93.040410	68.731367	120.446390	189.420300	89.237035	NaN	NaN	NaN	NaN	NaN	NaN	-9	-20	1	9	1	-7	-11	20	NaN	NaN
0001227930	Entropic Communications INC	Entropi	NaN	NaN	7	21	55	80	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	477.863130	406.804480	244.067560	46.104810	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	34	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001275014	Ultra Clean Holdings Inc	Ultra C	NaN	NaN	56	NaN	62	50	54	43	36	48	47	37	50	51	NaN	NaN	NaN	305.330780	NaN	214.077350	240.114230	182.039800	199.112690	241.695630	160.364420	128.638420	194.887890	159.988850	155.949880	NaN	NaN	NaN	NaN	NaN	-12	4	-11	-7	12	-1	-10	13	1	NaN
0001294924	Invensense Inc	Invense	NaN	NaN	24	2	2	58	45	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	423.040280	529.559340	508.104890	224.218230	206.247120	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-22	0	56	-13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001337675	Tower Us Holdings Inc	Tower U	NaN	NaN	82	75	81	78	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	123.487410	101.468400	86.720416	69.317531	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-7	6	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001356104	Mellanox Technologies Ltd	Mellano	NaN	NaN	46	17	39	32	18	39	32	17	14	NaN	NaN	NaN	NaN	NaN	NaN	347.508920	417.991620	309.305440	298.516400	385.913180	239.130940	275.968180	379.105160	362.198040	NaN	NaN	NaN	NaN	NaN	NaN	-29	22	-7	-14	21	-7	-15	-3	NaN	NaN	NaN	NaN
0001387467	Alpha Omega Semiconductor Ltd	Alpha O	NaN	NaN	47	40	41	34	NaN	NaN	NaN	NaN	NaN	44	36	11	NaN	NaN	NaN	346.901660	310.604840	295.546820	291.667140	NaN	NaN	NaN	NaN	NaN	169.157970	220.966750	427.895450	NaN	NaN	NaN	-7	1	-7	NaN	NaN	NaN	NaN	NaN	NaN	-8	-25	NaN
0001392522	Freescale Semiconductor Ltd	Freesca	NaN	NaN	96	100	100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-213.147660	-202.985930	-213.558200	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001394954	Gt Advanced Technologies Inc	Gt Adva	NaN	NaN	85	71	84	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	111.365140	145.122820	45.288490	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-14	13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001410172	Rubicon Technology Inc	Rubicon	NaN	NaN	12	28	36	41	71	75	60	5	8	11	NaN	NaN	NaN	NaN	NaN	466.156630	375.247380	323.087090	272.467810	-56.923208	-441.781380	52.951609	457.749110	403.796350	405.472050	NaN	NaN	NaN	NaN	NaN	16	8	5	30	4	-15	-55	3	3	NaN	NaN	NaN
0001432150	Gigpeak Inc	Gigpeak	NaN	NaN	92	72	28	44	21	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	66.229813	141.645330	344.775350	256.920530	373.712860	313.202680	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-20	-44	16	-23	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001441634	Avago Technologies LTD	Avago T	NaN	NaN	9	7	8	72	51	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	471.808730	473.025720	450.636410	95.015390	196.318030	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	1	64	-21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001481028	Sunhydrogen INC	Sunhydr	NaN	NaN	99	105	104	95	77	53	65	72	NaN	70	81	1	NaN	NaN	NaN	-4008.660500	-3730.306900	-1273.404900	-1396.207300	-727.069150	119.923150	-58.987350	-497.171030	NaN	-1169.652000	-518.689840	1013.830900	NaN	NaN	NaN	6	-1	-9	-18	-24	12	7	NaN	NaN	11	-80	NaN
0001487990	Aeroflex Holding Corp	Aerofle	NaN	NaN	90	86	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	70.193685	51.893818	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000029002	Diodes INC DEL	Diodes	NaN	NaN	NaN	38	61	42	58	49	42	32	22	36	32	25	NaN	NaN	NaN	NaN	318.952230	227.921730	264.529180	169.919060	167.459120	204.412730	252.034590	306.715010	196.117650	260.053240	312.334850	NaN	NaN	NaN	NaN	23	-19	16	-9	-7	-10	-10	14	-4	-7	NaN
0000093205	Living 3D Holdings INC	Living	NaN	NaN	NaN	104	102	94	1	80	76	74	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1014.074700	-458.484090	-673.999230	18198.040000	-993.237310	-392.574980	-549.644870	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-8	-93	79	-4	-2	NaN	NaN	NaN	NaN	NaN
0000790715	Sigma Designs INC	Sigma D	NaN	NaN	NaN	96	89	53	52	37	43	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-37.092368	-6.282352	239.154410	183.588140	253.262700	203.478090	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-7	-36	-1	-15	6	NaN	NaN	NaN	NaN	NaN	NaN
0000880177	Peregrine Semiconductor Corp	Peregri	NaN	NaN	NaN	60	48	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	223.920790	279.557570	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001081078	API Technologies Corp	API Tec	NaN	NaN	NaN	97	75	77	66	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-58.746244	148.181320	80.456713	40.006590	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-22	2	-11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001201663	Audience INC	Audienc	NaN	NaN	NaN	19	21	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	409.999470	381.901180	-81.999502	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	69	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001280263	Ambarella INC	Ambarel	NaN	NaN	NaN	36	16	9	6	5	5	14	17	25	30	28	NaN	NaN	NaN	NaN	323.777840	403.358830	441.505770	451.933620	470.873640	450.955090	392.635800	336.990930	290.035960	263.315030	305.911580	NaN	NaN	NaN	NaN	-20	-7	-3	-1	0	9	3	8	5	-2	NaN
0001311241	Intermolecular INC	Intermo	NaN	NaN	NaN	56	68	70	60	51	45	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	243.695580	200.810310	115.320460	122.134790	150.428070	169.591170	257.352390	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12	2	-10	-9	-6	-14	NaN	NaN	NaN	NaN	NaN
0001350102	Ascent Solar Technologies Inc	Ascent	NaN	NaN	NaN	74	96	96	78	81	77	75	NaN	65	76	73	NaN	NaN	NaN	NaN	106.308880	-78.807415	-2944.952600	-1075.112700	-1103.698500	-781.830960	-649.551250	NaN	-235.034320	-207.577410	-396.679670	NaN	NaN	NaN	NaN	22	0	-18	3	-4	-2	NaN	NaN	11	-3	NaN
0001021604	On Track Innovations LTD	On Trac	NaN	NaN	NaN	NaN	83	81	68	NaN	NaN	46	61	63	77	NaN	NaN	NaN	NaN	NaN	NaN	85.002656	31.626524	10.248983	NaN	NaN	165.380460	-32.994244	-109.750850	-344.854820	NaN	NaN	NaN	NaN	NaN	NaN	-2	-13	NaN	NaN	NaN	15	2	14	NaN	NaN
0001322705	Spansion Inc	Spansio	NaN	NaN	NaN	NaN	82	73	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	85.248603	87.819025	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001431959	Meta Materials INC	Meta Ma	NaN	NaN	NaN	NaN	NaN	86	NaN	NaN	NaN	NaN	NaN	62	47	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-26.429574	NaN	NaN	NaN	NaN	NaN	-74.281567	163.524810	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-15	NaN	NaN
0001579910	Resonant Inc	Resonan	NaN	NaN	NaN	NaN	NaN	88	76	74	73	68	69	66	80	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-35.672978	-509.423720	-428.897880	-256.372060	-280.463670	-691.340120	-246.849410	-492.952970	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-12	-2	-1	-5	1	-3	14	NaN	NaN
0001395848	Adesto Technologies Corp	Adesto	NaN	NaN	NaN	NaN	NaN	NaN	64	68	55	59	56	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	65.324297	-17.109196	124.205540	61.723428	26.396360	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	-13	4	-3	NaN	NaN	NaN	NaN
0001571636	Nanoflex Power Corp	Nanofle	NaN	NaN	NaN	NaN	NaN	NaN	79	79	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1189.965700	-746.964450	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001649338	Broadcom Pte Ltd	Broadco	NaN	NaN	NaN	NaN	NaN	NaN	NaN	57	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	113.497590	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001649345	Broadcom Cayman L P	Broadco	NaN	NaN	NaN	NaN	NaN	NaN	NaN	57	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	113.497590	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001651235	Acacia Communications Inc	Acacia	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	17	20	15	13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	507.880930	366.748090	340.998000	343.233120	390.731040	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	13	3	-5	-2	NaN	NaN	NaN
0001690666	Xperi Corp	Xperi C	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	21	49	43	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	464.928880	356.910810	156.070090	133.750840	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15	28	-6	NaN	NaN	NaN	NaN
0001316016	Aquantia Corp	Aquanti	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	295.219410	266.338270	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN	NaN	NaN	NaN	NaN
0001370702	On Semiconductor Connectivity Solutions Inc	On Semi	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	452.291550	345.615190	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15	NaN	NaN	NaN	NaN	NaN
0001556898	Techpoint Inc	Techpoi	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	6	10	7	1	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	516.121560	452.799430	376.251430	409.526790	519.586390	507.001340	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	4	-3	-6	4	NaN
0001494162	Kinerjapay Corp	Kinerja	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	77	71	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1425.496600	-1404.139600	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	NaN	NaN	NaN	NaN
0001715768	Transphorm Inc	Transph	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	76	NaN	67	NaN	55	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-919.466950	NaN	-358.180660	NaN	99.759809	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001781405	Odyssey Semiconductor Technologies Inc	Odyssey	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	66	69	75	74	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-150.982300	-474.055720	-206.169180	-513.936630	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	6	-1	NaN
0000866291	Allegro Microsystems INC	Allegro	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20	19	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	321.775010	324.298860	410.117630	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	-5	NaN
0001803696	Adeia Inc	Adeia I	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	35	49	65	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	200.583520	162.043950	-41.959174	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	16	NaN
0001813658	Tempo Automation Holdings Inc	Tempo A	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	79	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	385.174580	-1832.333300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	72	NaN
0001828161	FTC Solar Inc	FTC Sol	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	69	70	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-43.063361	-223.661680	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN
0001852117	Rockley Photonics Holdings Ltd	Rockley	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	78	78	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-361.117980	-818.352850	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN

PDF reports

All reports for 2023 are collected in a single PDF for easier review.

2009

Logs

warning	6 × Missing logo	subcommand.report	0000945436 0000768251 0000827054 0001045810 0001054374 0001058057
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.61946643343821}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	155,645,000	251,357,800	509,315,593	5,189,400,000	7,591,000,000	0000827054	0000945436	0000050863
1	LiabilitiesNonCurrent	0	0	138,427	505,793,600	697,700,000	0000050863	0001054374	0000945436
2	remainder_Liabilities	0	0	2,523,278	686,000,000	810,000,000	0000050863	0001058057	0000097476
3	AssetsCurrent	1,249,600,000	1,290,268,400	2,041,870,950	15,139,800,000	21,157,000,000	0000945436	0000768251	0000050863
4	AssetsNonCurrent	0	7,078,400	51,010,749	5,766,730,800	9,519,000,000	0001045810	0000097476	0000050863
5	IntangibleAssets	0	24,753,200	517,371,444	3,566,265,600	4,421,000,000	0000768251	0001045810	0000050863
6	PropertyPlantAndEquipmentNet	174,516,000	196,436,400	626,088,387	11,598,200,000	17,225,000,000	0000768251	0001045810	0000050863
7	remainder_Assets	40,026,000	40,232,000	433,225,154	1,356,800,000	1,746,000,000	0001045810	0000945436	0000097476
8	ResearchAndDevelopmentExpense	40,400,000	55,504,400	855,942,514	4,005,767,200	5,653,000,000	0000945436	0001045810	0000050863
9	SellingGeneralAndAdministrativeExpense	161,218,000	161,490,800	272,969,459	5,286,600,000	7,931,000,000	0000827054	0001274494	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	97,813,000	153,323,000	0000050863	0000945436	0001058057
11	remainder_Expenses	409,159,000	432,666,600	1,468,846,394	12,775,000,000	17,167,000,000	0000827054	0001058057	0000050863
12	remainder_Revenues	903,297,000	1,007,418,200	2,950,942,437	25,247,000,000	35,127,000,000	0000827054	0001058057	0000050863
13	remainder_NetIncome	-7,000,000	582,800	17,863,634	28,175,400	28,191,000	0000050863	0000768251	0000827054
14	remainder_ComprehensiveNetIncome	0	0	0	136,240,000	169,000,000	0000050863	0001054374	0000097476

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	155,645,000	327,440,200	1,148,397,636	5,513,400,000	7,591,000,000	0000827054	0001054374	0000050863
1	Assets	2,293,231,000	2,338,223,000	3,567,178,160	36,704,600,000	53,095,000,000	0000768251	0000945436	0000050863
2	Expenses	685,901,000	796,424,600	2,827,496,864	22,043,800,000	30,751,000,000	0000827054	0001058057	0000050863
3	Revenues	903,297,000	1,007,418,200	2,950,942,437	25,247,000,000	35,127,000,000	0000827054	0001058057	0000050863
4	StockholdersEquity	1,085,336,000	1,533,921,600	2,653,728,024	31,191,200,000	45,504,000,000	0000768251	0001274494	0000050863
5	NetIncome	-69,800,000	-53,896,400	245,591,380	3,209,400,000	4,369,000,000	0000945436	0000827054	0000050863
6	ComprehensiveNetIncome	-30,041,000	-11,104,600	245,591,380	3,277,000,000	4,369,000,000	0001045810	0000827054	0000050863
7	BaseVar	4,377,977,935	4,993,431,173	13,610,328,316	111,828,295,000	156,512,775,000	0000827054	0001058057	0000050863
8	EconomicCapitalRatio	2.00	2.05	3.81	4.62	4.85	0000768251	0001058057	0000827054

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-0.385	-0.312	0.0457	0.423	0.447	0000768251	0000050863	0001058057
1	LiabilitiesNonCurrent	-0.874	-0.608	0.297	0.486	0.493	0000945436	0000827054	0001045810
2	remainder_Liabilities	-0.890	-0.568	0.237	0.380	0.396	0000768251	0000827054	0001045810
3	AssetsCurrent	-0.295	-0.268	-0.0892	0.542	0.924	0001045810	0000827054	0000768251
4	AssetsNonCurrent	-0.0726	-0.0600	-0.00484	0.0566	0.0909	0001045810	0001274494	0000050863
5	IntangibleAssets	-0.192	-0.146	-0.0109	0.305	0.433	0000768251	0001274494	0001058057
6	PropertyPlantAndEquipmentNet	-0.299	-0.273	-0.0207	0.351	0.551	0001054374	0000097476	0000945436
7	remainder_Assets	-0.147	-0.117	0.00407	0.0989	0.132	0001045810	0000827054	0000945436
8	ResearchAndDevelopmentExpense	-0.900	-0.785	0.0638	0.456	0.504	0001054374	0000050863	0001274494
9	SellingGeneralAndAdministrativeExpense	-0.393	-0.281	0.0312	0.218	0.228	0000050863	0000097476	0001058057
10	AmortizationOfIntangibleAssets	-0.207	-0.118	0.0174	0.0353	0.0379	0001058057	0000827054	0001045810
11	remainder_Expenses	-0.840	-0.693	-0.0226	0.432	0.505	0001045810	0001054374	0000768251
12	remainder_Revenues	-0.609	-0.425	0.194	0.419	0.451	0000945436	0001054374	0000097476
13	remainder_NetIncome	-0.0400	-0.0372	-0.00503	0.0404	0.0584	0000050863	0001058057	0000827054
14	remainder_ComprehensiveNetIncome	-0.0498	-0.0472	-0.0290	0.0885	0.116	0001045810	0001274494	0000945436

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.70	-1.50	0.732	0.849	0.858	0000768251	0000827054	0001058057
1	Assets	-0.620	-0.537	-0.0714	0.432	0.624	0001045810	0001058057	0000945436
2	Expenses	-1.07	-0.932	-0.137	0.426	0.430	0001045810	0000050863	0000827054
3	Revenues	-0.609	-0.425	0.194	0.419	0.451	0000945436	0001054374	0000097476
4	StockholdersEquity	-1.83	-1.56	0.107	1.28	1.93	0001045810	0001058057	0000827054
5	NetIncome	-0.799	-0.706	0.0361	0.625	0.779	0001045810	0000050863	0001274494
6	ComprehensiveNetIncome	-0.848	-0.753	0.00156	0.598	0.750	0001045810	0000050863	0001274494
7	BaseVar	nan	nan	nan	nan	nan	0000050863	0000945436	0000050863
8	EconomicCapitalRatio	-1.45	-1.40	0.363	1.17	1.40	0000768251	0001058057	0000827054

2010

Logs

error	1 × Non-active company, it does not contain Assets	input.sec.sec_edgar_reading	0000029002
warning	23 × No stock price available	subcommand.plot	0000316793 0001036960 0001096325 0000050863 0000093384 0000310568 0000703360 0000703361 0000743316 0000743988 0000767920 0000768251 0000791915 0000872448 0000911160 0000913885 0000945436 0001045810 0001054374 0001102934 0001130866 0001175609 0001261694
warning	19 × Missing logo	subcommand.report	0000316793 0000827054 0001036960 0001096325 0000093384 0000703360 0000703361 0000743988 0000767920 0000768251 0000872448 0000911160 0000913885 0000945436 0001045810 0001054374 0001130866 0001261694 0000088941
warning	3 × Similarly named company. Duplicate?	None	0000743316 0000911160 0001102934
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.783489053690163}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001494162

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	22,623,000	44,847,300	239,225,164	2,071,687,600	9,327,000,000	0001130866	0000791915	0000050863
1	LiabilitiesNonCurrent	0	0	11,707,176	547,630,400	974,390,000	0000002488	0000895419	0001047127
2	remainder_Liabilities	0	0	5,340,840	533,440,000	983,000,000	0000002488	0000316793	0000097476
3	AssetsCurrent	0	213,881,100	843,355,493	6,794,783,500	31,611,000,000	0000827054	0001036960	0000050863
4	AssetsNonCurrent	0	0	27,364,294	221,095,300	8,137,000,000	0000006951	0000768251	0000050863
5	IntangibleAssets	0	0	214,028,743	1,628,632,000	4,531,000,000	0000768251	0000088941	0000050863
6	PropertyPlantAndEquipmentNet	0	17,946,500	260,147,457	1,751,503,400	17,899,000,000	0000945436	0000872448	0000050863
7	remainder_Assets	0	0	43,964,640	1,782,709,800	2,307,000,000	0000002488	0000917273	0000945436
8	ResearchAndDevelopmentExpense	31,467,000	35,461,600	129,266,590	1,589,232,300	6,576,000,000	0001130866	0000913885	0000050863
9	SellingGeneralAndAdministrativeExpense	0	52,871,500	169,270,005	999,563,200	6,309,000,000	0000093384	0000316793	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	30,108,800	61,000,000	0000006281	0000006281	0000002488
11	remainder_Expenses	-58,546,000	89,133,900	655,766,771	6,689,575,800	19,731,000,000	0000917273	0000768251	0000050863
12	remainder_Revenues	206,500,000	282,329,600	978,748,133	10,024,087,300	43,623,000,000	0001175609	0000911160	0000050863
13	remainder_NetIncome	-122,639,000	-23,804,200	2,604,118	146,800,000	457,000,000	0001047127	0001261694	0000050863
14	remainder_ComprehensiveNetIncome	-80,827,000	-29,012,300	0	334,600	8,945,000	0000316793	0000867773	0001096325

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	29,757,000	54,985,800	357,642,699	3,008,323,200	9,327,000,000	0001130866	0000743988	0000050863
1	Assets	291,620,000	413,762,000	1,673,140,198	11,189,110,500	63,186,000,000	0001175609	0001096325	0000050863
2	Expenses	153,635,000	167,899,000	909,891,462	8,875,307,900	32,616,000,000	0000917273	0000911160	0000050863
3	Revenues	206,500,000	282,329,600	978,748,133	10,024,087,300	43,623,000,000	0001175609	0000911160	0000050863
4	StockholdersEquity	234,610,000	349,502,300	1,178,748,431	7,826,201,700	53,859,000,000	0001175609	0001036960	0000050863
5	NetIncome	-151,370,000	-13,978,900	83,321,513	1,296,420,000	11,464,000,000	0000791915	0000767920	0000050863
6	ComprehensiveNetIncome	-151,370,000	-13,978,900	83,321,513	1,288,420,000	11,464,000,000	0000791915	0000767920	0000050863
7	BaseVar	894,117,540	1,285,679,558	4,666,335,890	43,524,099,789	183,129,340,000	0001175609	0000827054	0000050863
8	EconomicCapitalRatio	0.984	1.59	3.55	4.78	5.40	0001047127	0000817720	0001130866

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-0.891	-0.455	0.110	0.462	0.612	0000767920	0000827054	0001130866
1	LiabilitiesNonCurrent	-1.30	-1.13	0.267	0.590	0.630	0000911160	0000767920	0000817720
2	remainder_Liabilities	-0.723	-0.703	0.165	0.273	0.323	0000945436	0000006281	0000817720
3	AssetsCurrent	-0.837	-0.505	-0.0450	0.297	0.840	0001047127	0001054374	0000768251
4	AssetsNonCurrent	-0.0532	-0.0364	-0.00252	0.0562	0.121	0001045810	0001102934	0000791915
5	IntangibleAssets	-0.444	-0.250	-0.0159	0.399	0.660	0001047127	0001274494	0001096325
6	PropertyPlantAndEquipmentNet	-0.284	-0.197	-0.0110	0.304	0.772	0000703360	0000310568	0001047127
7	remainder_Assets	-0.294	-0.292	-0.0200	0.122	1.15	0001047127	0001102934	0000945436
8	ResearchAndDevelopmentExpense	-0.618	-0.590	0.0255	0.463	0.695	0001045810	0000872448	0001047127
9	SellingGeneralAndAdministrativeExpense	-0.631	-0.538	0.0678	0.344	0.696	0000791915	0000768251	0000093384
10	AmortizationOfIntangibleAssets	-0.146	-0.0825	0.0158	0.0236	0.0280	0000310568	0001130866	0000817720
11	remainder_Expenses	-1.18	-0.880	-0.0892	0.801	1.93	0001047127	0000895419	0000917273
12	remainder_Revenues	-0.620	-0.452	0.0765	0.637	0.723	0000791915	0000911160	0000097476
13	remainder_NetIncome	-0.216	-0.140	-0.00797	0.133	0.674	0001047127	0000768251	0000703361
14	remainder_ComprehensiveNetIncome	-0.356	-0.0236	0.00993	0.0165	0.0373	0000316793	0000310568	0001096325

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.54	-1.34	0.436	1.06	1.10	0001047127	0000833640	0001102934
1	Assets	-0.954	-0.728	-0.00916	0.297	0.443	0001047127	0001102934	0000767920
2	Expenses	-1.07	-0.954	-0.0315	0.480	0.961	0000791915	0000833640	0000917273
3	Revenues	-0.620	-0.452	0.0765	0.637	0.723	0000791915	0000911160	0000097476
4	StockholdersEquity	-2.65	-2.19	0.109	1.89	1.96	0000002488	0001175609	0001261694
5	NetIncome	-1.67	-0.758	-0.0768	0.758	0.934	0000791915	0000767920	0000917273
6	ComprehensiveNetIncome	-1.66	-0.747	-0.0699	0.765	0.940	0000791915	0000767920	0000917273
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0000833640	0000002488
8	EconomicCapitalRatio	-2.43	-1.83	0.136	1.36	1.98	0001047127	0000817720	0001130866

2011

Logs

error	12 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000093205 0000093205 0001355242 0001355242 0000065759 0000065759 0001431959 0001431959 0001324344 0001324344 0001494562 0001417451
error	1 × Non-active company, it does not contain Assets	input.sec.sec_edgar_reading	0000029002
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001135711
warning	55 × No stock price available	subcommand.plot	0000743988 0000753568 0000907686 0000940332 0001036960 0001096325 0001227025 0001261694 0001487990 0000093384 0000310568 0000316793 0000703360 0000703361 0000711065 0000730000 0000767920 0000768251 0000791907 0000850579 0000854701 0000869986 0000872448 0000880446 0000886328 0000887969 0000911160 0000913885 0000915778 0000932111 0000944739 0000945436 0000945699 0001001426 0001046995 0001050550 0001054374 0001058057 0001094739 0001102934 0001106851 0001110647 0001130866 0001160958 0001175609 0001224370 0001227930 0001294924 0001337675 0001356104 0001392522 0001394954 0001432150 0001441634 0001210618
warning	49 × Missing logo	subcommand.report	0000743988 0000753568 0000907686 0000940332 0001036960 0001096325 0001261694 0001487990 0000093384 0000316793 0000703360 0000703361 0000711065 0000730000 0000767920 0000768251 0000791907 0000850579 0000854701 0000869986 0000872448 0000880446 0000886328 0000887969 0000911160 0000913885 0000915778 0000932111 0000944739 0000945436 0001001426 0001050550 0001054374 0001058057 0001106851 0001130866 0001224370 0001227930 0001294924 0001337675 0001392522 0001394954 0001432150 0001441634 0000088941 0000724910 0000772406 0000827054 0001045810
warning	7 × Similarly named company. Duplicate?	None	0000711065 0000869986 0000911160 0001102934 0001227930 0001394954 0001280452
warning	7 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000093205 0001355242 0000065759 0001431959 0001324344 0001494562 0001417451
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.982203462423524}
warning	1 × Non-active company, it does not contain more than 2 integer variables	input.sec.sec_edgar_reading	0001322705
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054
warning	1 × IncomeStatement or BalanceSheet table not found.	input.sec.get_statements	0000899297
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001494162
warning	1 × Ignoring company because Assets is zero	pre-agg	0001097864

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	69,214	2,135,068	70,867,661	1,470,610,000	12,028,000,000	0001481028	0001210618	0000050863
1	LiabilitiesNonCurrent	0	0	3,085,439	1,077,689,600	7,095,000,000	0000002488	0001387467	0001392522
2	remainder_Liabilities	-1,681,689	0	735,020	388,268,700	1,835,000,000	0001398805	0000913885	0000097476
3	AssetsCurrent	62,269	10,373,840	318,634,271	4,522,913,200	25,872,000,000	0001481028	0001356104	0000050863
4	AssetsNonCurrent	0	0	7,946,390	214,409,400	5,537,000,000	0000724910	0000771266	0000050863
5	IntangibleAssets	0	0	26,108,431	850,091,200	15,521,000,000	0000091668	0000913885	0000050863
6	PropertyPlantAndEquipmentNet	0	1,291,800	54,726,871	1,164,171,400	23,627,000,000	0000886328	0000940332	0000050863
7	remainder_Assets	0	0	18,223,343	839,300,000	2,529,900,000	0000056978	0001261694	0000945436
8	ResearchAndDevelopmentExpense	0	0	53,130,127	853,704,800	1,983,000,000	0000050863	0000880446	0001054374
9	SellingGeneralAndAdministrativeExpense	0	583,925	59,202,028	518,200,000	1,638,000,000	0000050863	0001111928	0000097476
10	AmortizationOfIntangibleAssets	0	0	0	33,398,200	232,000,000	0000002488	0000723125	0001392522
11	remainder_Expenses	-32,028,000	6,301,335	202,530,272	3,786,100,000	41,361,000,000	0000890394	0000088941	0000050863
12	remainder_Revenues	0	9,893,842	363,334,720	6,650,100,000	53,999,000,000	0001481028	0000945699	0000050863
13	remainder_NetIncome	-656,000,000	-37,198,800	602,451	31,791,400	304,000,000	0001392522	0001130866	0000050863
14	remainder_ComprehensiveNetIncome	-75,000,000	-608,000	0	37,914	21,039,000	0000097476	0001288469	0001487990

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	69,214	3,159,521	93,845,923	4,177,030,000	12,028,000,000	0001481028	0000088941	0000050863
1	Assets	83,500	11,330,141	488,643,949	6,608,341,300	71,119,000,000	0001481028	0001130866	0000050863
2	Expenses	807,917	7,587,455	327,780,359	6,384,900,000	41,361,000,000	0001481028	0000945699	0000050863
3	Revenues	0	9,893,842	363,334,720	6,650,100,000	53,999,000,000	0001481028	0000945699	0000050863
4	StockholdersEquity	-4,480,000,000	3,834,297	366,092,519	5,763,782,100	59,091,000,000	0001392522	0000833640	0000050863
5	NetIncome	-1,520,000,000	-43,390,200	25,845,765	871,067,500	12,942,000,000	0000945436	0001051627	0000050863
6	ComprehensiveNetIncome	-1,520,000,000	-43,414,500	25,845,765	877,750,900	12,942,000,000	0000945436	0001051627	0000050863
7	BaseVar	1,623,518	45,765,185	1,541,868,631	29,012,476,000	224,770,060,000	0001481028	0001387467	0000050863
8	EconomicCapitalRatio	-40.1	-0.963	3.41	4.98	6.63	0001481028	0001045810	0000772406

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-1.89	-0.534	0.125	0.644	1.33	0001481028	0000917273	0001275014
1	LiabilitiesNonCurrent	-5.91	-0.945	0.306	0.515	0.681	0001481028	0000767920	0001294924
2	remainder_Liabilities	-3.57	-1.15	0.167	0.318	0.502	0001481028	0001261694	0001275014
3	AssetsCurrent	-27.4	-1.14	-0.0493	0.569	1.58	0001481028	0001094739	0000886328
4	AssetsNonCurrent	-0.110	-0.0586	-0.00430	0.0628	2.92	0001282631	0001387467	0001481028
5	IntangibleAssets	-12.6	-0.497	-0.0280	0.487	0.754	0001481028	0001160958	0000850579
6	PropertyPlantAndEquipmentNet	-13.7	-0.546	-0.0241	0.473	1.14	0001481028	0001160958	0001047127
7	remainder_Assets	-9.71	-0.463	-0.0406	0.234	1.66	0001481028	0001227930	0000945436
8	ResearchAndDevelopmentExpense	-4.65	-1.47	0.146	0.844	2.13	0001481028	0001441634	0001275014
9	SellingGeneralAndAdministrativeExpense	-29.2	-0.777	0.138	0.854	1.42	0001481028	0000768251	0001275014
10	AmortizationOfIntangibleAssets	-0.638	-0.184	0.0280	0.0483	0.115	0000850579	0001097864	0001481028
11	remainder_Expenses	-5.45	-1.55	-0.197	1.17	9.97	0001275014	0001432150	0001481028
12	remainder_Revenues	-17.4	-0.939	0.156	0.915	2.13	0001481028	0001046995	0001275014
13	remainder_NetIncome	-0.457	-0.208	-0.0103	0.286	0.585	0001392522	0000088941	0000703360
14	remainder_ComprehensiveNetIncome	-0.103	-0.0186	0.000794	0.00329	0.0902	0000882508	0000091668	0001039065

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-9.54	-1.92	0.417	1.26	1.92	0001481028	0001410172	0001275014
1	Assets	-32.4	-1.71	-0.0611	0.417	0.623	0001481028	0001051627	0000917273
2	Expenses	-23.8	-1.77	0.0848	0.729	1.42	0001481028	0000932111	0000772406
3	Revenues	-17.4	-0.939	0.156	0.915	2.13	0001481028	0001046995	0001275014
4	StockholdersEquity	-10.6	-4.05	0.0355	1.88	3.38	0001481028	0000711065	0000890394
5	NetIncome	-41.2	-2.04	0.168	1.11	2.69	0001481028	0001045810	0000772406
6	ComprehensiveNetIncome	-41.2	-2.05	0.181	1.11	2.69	0001481028	0001039065	0000772406
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0000932111	0000002488
8	EconomicCapitalRatio	-42.6	-3.46	0.921	2.49	4.14	0001481028	0001045810	0000772406

2012

Logs

error	4 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001322705 0001494162 0001494162 0000065759
warning	60 × No stock price available	subcommand.plot	0000316793 0000703360 0000703361 0000711065 0000723125 0000730000 0000743988 0000753568 0000767920 0000790715 0000791907 0000850579 0000880177 0000887969 0000911160 0000915778 0000932111 0000940332 0000944739 0000945699 0001001426 0001036960 0001054374 0001058057 0001094739 0001096325 0001106851 0001110647 0001130866 0001160958 0001201663 0001210618 0001224370 0001227930 0001261694 0001294924 0001311241 0001337675 0001350102 0001356104 0001392522 0001394954 0001432150 0001487990 0000093205 0000310568 0000768251 0000854701 0000869986 0000880446 0000907686 0000913885 0000945436 0001046995 0001050550 0001081078 0001102934 0001175609 0001441634 0001481028
warning	51 × Missing logo	subcommand.report	0000088941 0000316793 0000703360 0000703361 0000711065 0000724910 0000730000 0000743988 0000753568 0000767920 0000790715 0000791907 0000827054 0000850579 0000880177 0000887969 0000911160 0000915778 0000932111 0000940332 0000944739 0001001426 0001036960 0001045810 0001054374 0001058057 0001096325 0001106851 0001130866 0001201663 0001224370 0001227930 0001261694 0001294924 0001337675 0001392522 0001394954 0001432150 0001487990 0000768251 0000854701 0000869986 0000880446 0000907686 0000913885 0000945436 0001050550 0001081078 0001441634 0000772406 0001280263
warning	8 × Similarly named company. Duplicate?	None	0000711065 0000911160 0001227930 0001350102 0001394954 0001463101 0000869986 0001102934
warning	6 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000880177 0000093205 0001280263 0001494162 0000065759 0001431959
warning	5 × Ignoring company because Assets is zero	pre-agg	0001097864 0001097864 0001097864 0001097864 0001097864
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.7443677526720975}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -1.8973147488520836}
warning	1 × Non-active company, it is bankrupted	input.sec.sec_edgar_reading	0000091668
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001494162

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	132,408	2,869,946	63,932,926	1,344,760,000	12,898,000,000	0001481028	0001387467	0000050863
1	LiabilitiesNonCurrent	0	0	3,030,215	954,150,600	6,830,000,000	0000002488	0001039399	0001392522
2	remainder_Liabilities	0	0	1,054,083	520,277,400	1,920,800,000	0000002488	0000932111	0000945436
3	AssetsCurrent	24,890	9,239,800	229,355,168	3,880,486,400	31,358,000,000	0000093205	0000753568	0000050863
4	AssetsNonCurrent	0	15,940	7,463,246	271,650,400	4,641,000,000	0000093205	0001111928	0000050863
5	IntangibleAssets	0	0	25,806,314	1,150,665,600	15,945,000,000	0000093205	0000890394	0000050863
6	PropertyPlantAndEquipmentNet	0	1,136,400	56,071,322	882,981,800	27,983,000,000	0000093205	0000945699	0000050863
7	remainder_Assets	0	0	11,537,710	1,155,800,000	4,424,000,000	0000056978	0000833640	0000050863
8	ResearchAndDevelopmentExpense	0	0	49,205,775	985,684,000	2,318,000,000	0000050863	0001130866	0001054374
9	SellingGeneralAndAdministrativeExpense	0	2,399,958	50,894,259	435,800,000	1,804,000,000	0000050863	0001463101	0000097476
10	AmortizationOfIntangibleAssets	0	0	0	32,032,200	113,000,000	0000002488	0000768251	0001054374
11	remainder_Expenses	-2,847,000	7,256,409	188,456,995	3,924,628,400	42,571,000,000	0000890394	0000772406	0000050863
12	remainder_Revenues	0	11,346,958	302,235,937	5,137,186,000	53,341,000,000	0001481028	0001493594	0000050863
13	remainder_NetIncome	-563,000,000	-66,951,600	221,113	18,037,800	235,000,000	0001392522	0001432150	0000050863
14	remainder_ComprehensiveNetIncome	-67,000,000	-16,302,800	0	8,791,400	382,000,000	0000006951	0001325702	0000050863

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	132,408	3,779,200	89,890,807	3,767,993,200	12,898,000,000	0001481028	0000945699	0000050863
1	Assets	24,890	18,557,000	396,328,442	6,232,477,400	84,351,000,000	0000093205	0001081078	0000050863
2	Expenses	734,032	21,074,853	329,581,211	5,992,000,000	42,571,000,000	0000093205	0001387467	0000050863
3	Revenues	0	11,346,958	302,235,937	5,137,186,000	53,341,000,000	0001481028	0001493594	0000050863
4	StockholdersEquity	-4,531,000,000	1,471,698	279,436,659	4,935,808,400	71,453,000,000	0001392522	0001387467	0000050863
5	NetIncome	-1,183,000,000	-148,702,400	-833,010	577,472,000	11,005,000,000	0000002488	0001481028	0000050863
6	ComprehensiveNetIncome	-1,181,000,000	-148,702,400	-833,750	577,745,600	11,387,000,000	0000002488	0001481028	0000050863
7	BaseVar	1,687,590	99,312,540	1,465,217,097	24,782,573,000	233,477,535,000	0001481028	0000833640	0000050863
8	EconomicCapitalRatio	-37.3	-1.90	2.70	4.74	5.53	0001481028	0000810136	0000724910

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-1.81	-0.415	0.217	0.692	25.3	0001210618	0001487990	0000093205
1	LiabilitiesNonCurrent	-5.27	-1.22	0.287	0.521	0.624	0001481028	0000316793	0001227930
2	remainder_Liabilities	-3.52	-0.963	0.163	0.344	0.403	0001481028	0001311241	0001227930
3	AssetsCurrent	-25.2	-1.74	-0.106	0.755	1.67	0001481028	0000945699	0000882508
4	AssetsNonCurrent	-0.254	-0.113	-0.00476	0.106	2.80	0000093205	0000895419	0001481028
5	IntangibleAssets	-11.1	-0.759	-0.0487	0.900	1.52	0001481028	0001394954	0001081078
6	PropertyPlantAndEquipmentNet	-12.9	-0.754	-0.0405	0.624	3.34	0001481028	0001094739	0001350102
7	remainder_Assets	-7.96	-0.628	-0.0516	0.317	1.70	0001481028	0000911160	0000945436
8	ResearchAndDevelopmentExpense	-3.28	-1.53	0.174	0.783	1.11	0001481028	0000880177	0000907686
9	SellingGeneralAndAdministrativeExpense	-24.2	-0.652	0.153	0.575	0.871	0001481028	0001051627	0001398805
10	AmortizationOfIntangibleAssets	-0.366	-0.124	0.0199	0.0360	0.0770	0000850579	0000050863	0001481028
11	remainder_Expenses	-3.63	-1.45	-0.0530	1.44	7.70	0001398805	0000912093	0001481028
12	remainder_Revenues	-14.1	-1.40	0.206	1.00	1.33	0001481028	0000097476	0001040161
13	remainder_NetIncome	-2.02	-0.458	0.0567	0.237	0.720	0000850579	0000316793	0000887969
14	remainder_ComprehensiveNetIncome	-0.631	-0.0920	0.00614	0.0486	0.120	0000887969	0000004127	0000771266

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-3.15	-1.82	0.467	1.23	14.8	0001392522	0001111928	0000093205
1	Assets	-29.9	-2.34	-0.0876	0.698	3.19	0001481028	0000913885	0000890394
2	Expenses	-19.7	-2.00	0.167	0.775	0.959	0001481028	0000833640	0000724910
3	Revenues	-14.1	-1.40	0.206	1.00	1.33	0001481028	0000097476	0001040161
4	StockholdersEquity	-11.3	-3.82	-0.110	2.26	2.88	0001481028	0000854701	0000724910
5	NetIncome	-33.7	-2.88	0.408	1.42	1.81	0001481028	0000912093	0001294924
6	ComprehensiveNetIncome	-33.7	-2.84	0.358	1.48	1.82	0001481028	0000915778	0001294924
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0000945436	0000002488
8	EconomicCapitalRatio	-39.1	-3.65	0.946	2.99	3.77	0001481028	0000810136	0000724910

2013

Logs

error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000065759 0001431959
warning	56 × No stock price available	subcommand.plot	0000093205 0000316793 0000703360 0000703361 0000711065 0000723125 0000743988 0000753568 0000767920 0000790715 0000791907 0000791915 0000850579 0000854701 0000880177 0000887969 0000911160 0000915778 0000932111 0000940332 0000945699 0001001426 0001021604 0001036960 0001054374 0001094739 0001102934 0001106851 0001110647 0001130866 0001160958 0001201663 0001210618 0001224370 0001227025 0001227930 0001261694 0001294924 0001322705 0001337675 0001350102 0001356104 0001392522 0001394954 0001432150 0001441634 0000310568 0000768251 0000869986 0000880446 0000913885 0000945436 0001046995 0001081078 0001175609 0001311241
warning	45 × Missing logo	subcommand.report	0000088941 0000316793 0000703360 0000703361 0000711065 0000724910 0000743988 0000753568 0000767920 0000790715 0000791907 0000827054 0000850579 0000854701 0000880177 0000887969 0000911160 0000915778 0000932111 0000940332 0001001426 0001036960 0001045810 0001054374 0001106851 0001130866 0001201663 0001224370 0001227930 0001261694 0001294924 0001322705 0001337675 0001392522 0001394954 0001432150 0001441634 0000768251 0000869986 0000880446 0000913885 0000945436 0001081078 0000772406 0001280263
warning	9 × Similarly named company. Duplicate?	None	0000711065 0000911160 0001102934 0001227930 0001350102 0001394954 0001463101 0000869986 0001507957
warning	7 × Ignoring company because Assets is zero	pre-agg	0001392522 0001097864 0001097864 0001097864 0001097864 0001097864 0001097864
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000065759 0001431959
warning	2 × Ignoring company because Expenses is zero	pre-agg	0000065759 0001494162
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.660892087772076}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -1.7870774879859272}
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	966,172	1,867,005	61,914,947	1,613,509,150	13,568,000,000	0001481028	0000808326	0000050863
1	LiabilitiesNonCurrent	0	0	3,467,534	1,470,786,650	6,779,000,000	0000002488	0000855658	0001392522
2	remainder_Liabilities	0	0	1,581,964	251,767,300	3,322,400,000	0000002488	0000940332	0000945436
3	AssetsCurrent	27,792	10,523,750	244,961,261	4,646,219,300	32,084,000,000	0001481028	0001294924	0000050863
4	AssetsNonCurrent	0	0	4,586,863	257,407,200	6,962,000,000	0000093205	0001224370	0000050863
5	IntangibleAssets	0	0	20,580,410	970,793,800	15,663,000,000	0000091668	0000817720	0000050863
6	PropertyPlantAndEquipmentNet	0	496,861	48,665,191	828,685,000	31,428,000,000	0000790715	0000808326	0000050863
7	remainder_Assets	0	0	9,878,673	1,617,520,450	6,221,000,000	0000056978	0001102934	0000050863
8	ResearchAndDevelopmentExpense	0	0	49,048,059	904,600,000	2,486,000,000	0000050863	0001130866	0001054374
9	SellingGeneralAndAdministrativeExpense	0	1,427,484	50,977,853	459,023,300	1,858,000,000	0000050863	0000711065	0000097476
10	AmortizationOfIntangibleAssets	0	0	0	17,625,000	84,819,000	0000006281	0000890394	0000310568
11	remainder_Expenses	-18,665,548	6,154,200	170,761,187	3,390,894,300	43,408,000,000	0001350102	0000767920	0000050863
12	remainder_Revenues	0	8,927,931	290,776,768	5,146,173,850	52,708,000,000	0001481028	0001394954	0000050863
13	remainder_NetIncome	-699,000,000	-32,286,850	145,185	17,344,296	1,205,000,000	0001392522	0001111928	0000723125
14	remainder_ComprehensiveNetIncome	-47,330,000	-13,732,950	0	21,024,500	1,642,000,000	0000827054	0001507957	0000050863

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	966,172	2,627,527	90,417,556	4,586,417,000	13,568,000,000	0001481028	0001175609	0000050863
1	Assets	49,199	16,111,243	359,152,144	6,853,051,700	92,358,000,000	0001481028	0000854701	0000050863
2	Expenses	744,233	12,557,271	316,228,236	5,175,707,550	43,408,000,000	0000093205	0001227025	0000050863
3	Revenues	0	8,927,931	290,776,768	5,146,173,850	52,708,000,000	0001481028	0001394954	0000050863
4	StockholdersEquity	-4,594,000,000	4,008,745	263,638,457	5,331,555,100	78,790,000,000	0001392522	0001227930	0000050863
5	NetIncome	-613,900,000	-99,875,000	-1,263,995	542,330,400	9,620,000,000	0000945436	0001481028	0000050863
6	ComprehensiveNetIncome	-613,900,000	-99,794,200	-1,092,143	546,789,800	11,262,000,000	0000945436	0001158114	0000050863
7	BaseVar	2,667,273	58,233,126	1,392,586,817	23,351,023,250	240,782,370,000	0001481028	0001175609	0000050863
8	EconomicCapitalRatio	-12.7	-1.79	2.53	4.66	5.47	0001481028	0001274494	0000724910

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-1.87	-0.641	0.350	0.947	30.2	0000791907	0000029002	0001481028
1	LiabilitiesNonCurrent	-3.69	-1.07	0.262	0.552	0.769	0001392522	0000771266	0000772406
2	remainder_Liabilities	-1.80	-0.854	0.180	0.406	0.472	0001337675	0001130866	0000880177
3	AssetsCurrent	-5.49	-1.49	-0.0914	0.784	5.41	0001481028	0000088941	0001507957
4	AssetsNonCurrent	-0.172	-0.0819	-0.00741	0.0902	0.302	0000940332	0000097476	0001394954
5	IntangibleAssets	-1.54	-0.763	-0.0716	0.505	1.06	0001481028	0001280263	0001081078
6	PropertyPlantAndEquipmentNet	-2.03	-0.594	-0.0432	0.749	4.66	0001481028	0000771266	0001350102
7	remainder_Assets	-1.95	-0.655	-0.0696	0.279	1.70	0000724910	0001356104	0000945436
8	ResearchAndDevelopmentExpense	-3.26	-1.37	0.108	0.722	1.36	0000711065	0001094739	0001275014
9	SellingGeneralAndAdministrativeExpense	-9.74	-0.611	0.190	0.703	1.03	0001350102	0001102934	0001106851
10	AmortizationOfIntangibleAssets	-0.342	-0.0341	0.0152	0.0301	0.0391	0000767920	0000050863	0000940332
11	remainder_Expenses	-3.19	-1.57	-0.0633	1.15	7.03	0001398805	0000915778	0001350102
12	remainder_Revenues	-3.90	-1.51	0.280	1.22	1.89	0001481028	0001038074	0000772406
13	remainder_NetIncome	-0.691	-0.234	0.00337	0.182	0.847	0001398805	0000882508	0000771266
14	remainder_ComprehensiveNetIncome	-0.201	-0.0673	-0.0104	0.0834	0.423	0001350102	0001481028	0000703360

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-2.71	-1.43	0.687	1.56	18.4	0001392522	0000002488	0001481028
1	Assets	-7.49	-2.35	-0.125	1.18	3.49	0001481028	0000817720	0000890394
2	Expenses	-4.14	-1.79	0.0965	0.763	1.00	0001481028	0001311241	0000724910
3	Revenues	-3.90	-1.51	0.280	1.22	1.89	0001481028	0001038074	0000772406
4	StockholdersEquity	-6.79	-3.55	-0.123	2.15	3.11	0001481028	0000723125	0000724910
5	NetIncome	-8.03	-2.84	0.486	1.41	2.16	0001481028	0000006951	0000772406
6	ComprehensiveNetIncome	-8.04	-2.77	0.512	1.39	2.14	0001481028	0000810136	0000772406
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0000945436	0000002488
8	EconomicCapitalRatio	-14.7	-3.79	0.529	2.66	3.47	0001481028	0001274494	0000724910

2014

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001494162
warning	47 × No stock price available	subcommand.plot	0000093205 0000703361 0000711065 0000743988 0000753568 0000767920 0000790715 0000791907 0000791915 0000854701 0000872448 0000887969 0000915778 0000932111 0000945699 0001001426 0001036960 0001054374 0001081078 0001094739 0001096325 0001102934 0001106851 0001110647 0001160958 0001201663 0001210618 0001227025 0001227930 0001261694 0001294924 0001322705 0001356104 0001432150 0001441634 0001604778 0000310568 0000768251 0000880446 0000945436 0001021604 0001046995 0001175609 0001311241 0001337675 0001579910 0001350102
warning	35 × Missing logo	subcommand.report	0000088941 0000703361 0000711065 0000724910 0000743988 0000753568 0000767920 0000772406 0000790715 0000791907 0000854701 0000872448 0000887969 0000915778 0000932111 0001001426 0001036960 0001045810 0001054374 0001081078 0001096325 0001106851 0001201663 0001227930 0001261694 0001280263 0001294924 0001322705 0001432150 0001441634 0001604778 0000768251 0000880446 0000945436 0001337675
warning	7 × Similarly named company. Duplicate?	None	0000711065 0001102934 0001227930 0001463101 0001350102 0001507957 0001431959
warning	5 × Ignoring company because Assets is zero	pre-agg	0001392522 0001097864 0001097864 0001097864 0001097864
warning	2 × Ignoring company because Expenses is zero	pre-agg	0000065759 0001494162
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.490998212126057}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -1.5430089648120207}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001494162
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000002488
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054
warning	1 × IncomeStatement or BalanceSheet table not found.	input.sec.get_statements	0001419612

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	0	1,462,007	67,787,191	1,467,500,000	16,019,000,000	0000945436	0000945699	0000050863
1	LiabilitiesNonCurrent	0	0	3,702,551	1,635,427,500	6,057,000,000	0000002488	0001282631	0000723125
2	remainder_Liabilities	0	0	1,611,694	326,675,750	10,015,200,000	0000002488	0001051627	0000945436
3	AssetsCurrent	10,524	8,527,886	260,562,116	5,210,177,750	27,730,000,000	0000093205	0000833640	0000050863
4	AssetsNonCurrent	0	0	4,096,831	291,707,250	8,584,000,000	0000093205	0000833640	0000050863
5	IntangibleAssets	0	0	30,041,883	2,799,130,000	15,307,000,000	0000091668	0000810136	0000050863
6	PropertyPlantAndEquipmentNet	0	106,461	58,105,360	1,219,076,000	33,238,000,000	0000093205	0001001426	0000050863
7	remainder_Assets	0	0	10,523,403	1,890,024,750	7,998,100,000	0000002488	0001387467	0000945436
8	ResearchAndDevelopmentExpense	0	0	51,388,968	1,137,958,500	2,373,000,000	0000050863	0000029002	0001054374
9	SellingGeneralAndAdministrativeExpense	0	1,310,387	51,364,890	575,500,000	1,843,000,000	0000050863	0001039399	0000097476
10	AmortizationOfIntangibleAssets	0	0	0	25,930,000	197,000,000	0000006951	0000808326	0001441634
11	remainder_Expenses	-118,950	2,658,672	203,641,505	4,285,000,000	44,620,000,000	0000093205	0000703361	0000050863
12	remainder_Revenues	0	1,603,930	332,723,353	6,236,500,000	55,870,000,000	0001431959	0000945699	0000050863
13	remainder_NetIncome	-776,300,000	-38,787,500	0	26,618,000	454,000,000	0000945436	0000817720	0000050863
14	remainder_ComprehensiveNetIncome	-577,000,000	-38,750,000	-84,472	4,200,250	75,916,000	0000050863	0001288469	0001274494

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	773,436	2,679,056	109,271,350	5,791,500,000	16,019,000,000	0001579910	0000088941	0000050863
1	Assets	10,524	12,203,440	404,681,921	11,742,600,000	91,956,000,000	0000093205	0001175609	0000050863
2	Expenses	493,597	8,527,771	324,750,112	6,324,750,000	44,620,000,000	0000093205	0001227025	0000050863
3	Revenues	0	1,603,930	332,723,353	6,236,500,000	55,870,000,000	0001431959	0000945699	0000050863
4	StockholdersEquity	-18,502,000	6,651,518	266,450,978	6,696,048,500	75,937,000,000	0001325702	0000945699	0000050863
5	NetIncome	-1,272,400,000	-102,901,000	1,894,110	635,791,000	11,704,000,000	0000945436	0001096325	0000050863
6	ComprehensiveNetIncome	-1,272,400,000	-99,362,250	1,633,737	623,215,000	11,127,000,000	0000945436	0001096325	0000050863
7	BaseVar	1,939,996	35,960,014	1,492,087,686	28,163,241,250	248,400,215,000	0000093205	0000833640	0000050863
8	EconomicCapitalRatio	-29.4	-1.54	2.46	4.49	6.29	0001350102	0001102934	0001261694

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-7.75	-0.518	0.324	0.867	38.7	0001350102	0001094739	0001481028
1	LiabilitiesNonCurrent	-4.24	-1.45	0.261	0.520	0.632	0001350102	0000004127	0000772406
2	remainder_Liabilities	-3.69	-0.589	0.204	0.437	0.529	0000945436	0001227025	0001275014
3	AssetsCurrent	-18.9	-1.43	-0.0858	0.615	6.34	0001350102	0000310568	0001579910
4	AssetsNonCurrent	-1.73	-0.0770	-0.00745	0.113	0.230	0001350102	0001274494	0000791915
5	IntangibleAssets	-9.59	-0.739	-0.0796	0.617	2.66	0001350102	0000768251	0000890394
6	PropertyPlantAndEquipmentNet	-6.25	-0.595	-0.0368	0.419	1.81	0001350102	0001126741	0001333822
7	remainder_Assets	-7.16	-0.779	-0.100	0.288	10.0	0001350102	0000817720	0001431959
8	ResearchAndDevelopmentExpense	-3.39	-1.46	0.136	0.767	3.06	0000890394	0001441634	0001350102
9	SellingGeneralAndAdministrativeExpense	-3.82	-1.16	0.128	0.658	0.976	0001350102	0001158114	0001106851
10	AmortizationOfIntangibleAssets	-0.315	-0.0863	0.0158	0.0310	0.0656	0000767920	0001045810	0001350102
11	remainder_Expenses	-17.1	-1.67	0.0261	1.48	2.72	0001350102	0000097476	0001481028
12	remainder_Revenues	-12.0	-2.00	0.371	1.28	2.00	0001350102	0001047127	0001275014
13	remainder_NetIncome	-8.77	-0.270	0.153	0.372	1.86	0001481028	0001160958	0001110647
14	remainder_ComprehensiveNetIncome	-1.10	-0.107	0.0170	0.0458	0.151	0001350102	0001311241	0000945699

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-11.2	-1.36	0.654	1.52	21.5	0001350102	0000915778	0001481028
1	Assets	-23.4	-2.24	-0.0884	1.36	3.98	0001350102	0000912093	0001579910
2	Expenses	-17.7	-2.04	0.0597	0.794	4.17	0001350102	0001356104	0001481028
3	Revenues	-12.0	-2.00	0.371	1.28	2.00	0001350102	0001047127	0001275014
4	StockholdersEquity	-7.35	-3.41	-0.119	2.07	3.29	0001481028	0000932111	0000724910
5	NetIncome	-29.2	-4.00	0.617	1.64	2.52	0001350102	0000310568	0001261694
6	ComprehensiveNetIncome	-30.3	-3.99	0.608	1.50	2.53	0001350102	0000912093	0001261694
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0001036960	0000002488
8	EconomicCapitalRatio	-31.1	-3.19	0.808	2.84	4.64	0001350102	0001102934	0001261694

2015

Logs

error	3 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001494162 0001631547 0001631547
warning	33 × No stock price available	subcommand.plot	0000093205 0000703361 0000711065 0000743988 0000753568 0000790715 0000872448 0000887969 0000940332 0000945699 0001036960 0001081078 0001094739 0001096325 0001102934 0001160958 0001227025 0001261694 0001294924 0001311241 0001356104 0001395848 0001432150 0001441634 0000310568 0000743316 0000886328 0001021604 0001046995 0001175609 0001571636 0001579910 0001350102
warning	22 × Missing logo	subcommand.report	0000088941 0000703361 0000711065 0000724910 0000743988 0000753568 0000772406 0000790715 0000872448 0000887969 0000940332 0001036960 0001045810 0001081078 0001096325 0001261694 0001280263 0001294924 0001432150 0001441634 0001604778 0000886328
warning	6 × Similarly named company. Duplicate?	None	0000711065 0001102934 0000743316 0001571636 0001350102 0001507957
warning	4 × Ignoring company because Assets is zero	pre-agg	0001392522 0001097864 0001097864 0001097864
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001494162 0001631547
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001494162 0000065759
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.948553410614342}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -4.0748601504816575}
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	72,204	1,445,259	64,731,233	1,518,200,000	15,667,000,000	0000093205	0001275014	0000050863
1	LiabilitiesNonCurrent	0	0	8,697,694	1,703,207,400	6,950,000,000	0000002488	0001160958	0000723125
2	remainder_Liabilities	0	0	1,502,137	476,321,700	1,398,000,000	0000002488	0001021604	0001045810
3	AssetsCurrent	100	1,942,072	275,684,708	5,849,100,000	40,356,000,000	0000093205	0001280263	0000050863
4	AssetsNonCurrent	0	0	7,847,212	233,023,400	9,626,000,000	0000093205	0000753568	0000050863
5	IntangibleAssets	0	0	56,370,763	2,404,438,700	15,265,000,000	0000091668	0001039399	0000050863
6	PropertyPlantAndEquipmentNet	0	12,445	56,623,433	1,571,901,700	31,858,000,000	0000093205	0000917273	0000050863
7	remainder_Assets	0	0	8,217,188	2,153,531,200	5,960,000,000	0000002488	0000743316	0000050863
8	ResearchAndDevelopmentExpense	0	73,172	59,805,737	1,288,000,000	12,128,000,000	0000091668	0001102934	0000050863
9	SellingGeneralAndAdministrativeExpense	0	1,541,913	70,577,189	509,300,000	7,930,000,000	0001398805	0000917273	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	38,981,800	249,000,000	0000006951	0000029002	0001441634
11	remainder_Expenses	-107,963,000	1,778,718	197,746,076	3,903,100,000	24,087,000,000	0000917273	0001081078	0000050863
12	remainder_Revenues	0	2,071,539	357,318,248	7,108,300,000	55,355,000,000	0001481028	0001463101	0000050863
13	remainder_NetIncome	-77,197,000	-21,224,300	0	33,000,000	474,000,000	0001047127	0000886328	0000723125
14	remainder_ComprehensiveNetIncome	-606,000,000	-29,605,300	-130,727	1,399,700	34,835,000	0000050863	0001463101	0001325702

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	72,204	1,447,259	125,442,573	5,918,600,000	15,667,000,000	0000093205	0000703361	0000050863
1	Assets	100	2,003,172	487,673,570	11,063,600,000	103,065,000,000	0000093205	0000833640	0000050863
2	Expenses	350,220	8,405,582	343,552,544	5,742,100,000	44,145,000,000	0000093205	0001288469	0000050863
3	Revenues	0	2,071,539	357,318,248	7,108,300,000	55,355,000,000	0001481028	0001463101	0000050863
4	StockholdersEquity	-62,330,000	-205,754	353,943,688	6,317,144,000	87,398,000,000	0001325702	0001175609	0000050863
5	NetIncome	-660,000,000	-53,321,400	10,801,533	1,365,300,000	11,420,000,000	0000002488	0001158114	0000050863
6	ComprehensiveNetIncome	-663,000,000	-50,368,900	1,299,633	1,343,000,000	10,814,000,000	0000002488	0001432150	0000050863
7	BaseVar	4,751,334	22,383,160	1,562,954,976	33,214,594,000	251,471,140,000	0000093205	0000945699	0000050863
8	EconomicCapitalRatio	-11.9	-4.07	2.45	4.95	182	0001571636	0001039065	0000093205

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-0.585	-0.284	0.370	0.929	142	0001021604	0001410172	0000093205
1	LiabilitiesNonCurrent	-1.90	-1.27	0.243	0.584	112	0001493594	0000790715	0000093205
2	remainder_Liabilities	-1.78	-0.718	0.115	0.300	81.7	0001160958	0001507957	0000093205
3	AssetsCurrent	-5.10	-1.92	-0.0451	0.590	163	0001350102	0001227025	0000093205
4	AssetsNonCurrent	-0.370	-0.0808	-0.00872	0.0978	52.5	0001350102	0000056978	0000093205
5	IntangibleAssets	-2.73	-0.919	-0.0633	0.710	135	0001350102	0001175609	0000093205
6	PropertyPlantAndEquipmentNet	-1.65	-0.553	-0.0222	1.47	134	0001571636	0000310568	0000093205
7	remainder_Assets	-1.29	-0.612	-0.0527	0.198	108	0000724910	0000895419	0000093205
8	ResearchAndDevelopmentExpense	-3.30	-1.63	0.166	0.981	21.9	0000890394	0000310568	0000093205
9	SellingGeneralAndAdministrativeExpense	-14.3	-1.24	0.112	0.574	1.05	0000093205	0001096325	0001398805
10	AmortizationOfIntangibleAssets	-0.263	-0.147	0.0231	0.0440	0.643	0001261694	0001158114	0000093205
11	remainder_Expenses	-3.59	-1.90	0.0423	1.16	58.9	0001398805	0001441634	0000093205
12	remainder_Revenues	-95.6	-2.37	0.367	1.01	1.58	0000093205	0000723125	0001463101
13	remainder_NetIncome	-4.74	-0.225	0.0301	0.162	224	0001350102	0001038074	0000093205
14	remainder_ComprehensiveNetIncome	-0.414	-0.124	0.0202	0.0558	0.697	0000945699	0001274494	0000093205

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.47	-1.18	0.475	1.63	158	0001081078	0000753568	0000093205
1	Assets	-6.82	-3.07	0.0103	0.818	169	0001571636	0000004127	0000093205
2	Expenses	-4.39	-2.11	0.0666	0.996	67.1	0001579910	0000945699	0000093205
3	Revenues	-95.6	-2.37	0.367	1.01	1.58	0000093205	0000723125	0001463101
4	StockholdersEquity	-67.2	-4.25	-0.0836	1.88	3.24	0000093205	0001294924	0000724910
5	NetIncome	-11.6	-4.34	0.445	1.83	195	0001350102	0001432150	0000093205
6	ComprehensiveNetIncome	-11.5	-4.32	0.413	1.86	196	0001350102	0001227025	0000093205
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0001039399	0000002488
8	EconomicCapitalRatio	-16.0	-8.20	-1.68	0.822	178	0001571636	0001039065	0000093205

2016

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001631547
warning	29 × No stock price available	subcommand.plot	0000703361 0000743988 0000790715 0000791907 0000791915 0000887969 0000945699 0001058057 0001094739 0001096325 0001102934 0001110647 0001175609 0001227025 0001311241 0001356104 0001395848 0001432150 0001579910 0001649338 0001649345 0001651235 0001690666 0000093205 0000310568 0000743316 0001046995 0001571636 0001350102
warning	16 × Missing logo	subcommand.report	0000088941 0000703361 0000724910 0000743988 0000772406 0000790715 0000791907 0000887969 0001045810 0001058057 0001096325 0001280263 0001432150 0001604778 0001649338 0001649345
warning	7 × Similarly named company. Duplicate?	None	0001102934 0001649345 0001651235 0000743316 0001571636 0001350102 0001507957
warning	5 × Ignoring company because Expenses is zero	pre-agg	0001419612 0001494162 0001494162 0001494162 0000065759
warning	4 × Ignoring company because Assets is zero	pre-agg	0001392522 0001097864 0001097864 0001097864
warning	2 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000912093 0001350102
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.708736386490141}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -4.667290577825598}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000065759
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054
warning	1 × IncomeStatement or BalanceSheet table not found.	input.sec.get_statements	0001494162

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	0	1,589,469	101,083,608	3,078,000,000	20,302,000,000	0001634447	0001275014	0000050863
1	LiabilitiesNonCurrent	0	0	10,732,976	3,143,000,000	24,481,000,000	0000002488	0001096325	0001649338
2	remainder_Liabilities	0	0	3,161,736	531,000,000	1,237,143,000	0000002488	0001311241	0000867773
3	AssetsCurrent	100	1,535,601	341,448,392	7,125,000,000	35,508,000,000	0000093205	0000088941	0000050863
4	AssetsNonCurrent	0	0	7,224,328	460,000,000	11,875,000,000	0000093205	0001493594	0000050863
5	IntangibleAssets	0	0	102,466,432	3,891,000,000	39,800,000,000	0000093205	0001274494	0001649338
6	PropertyPlantAndEquipmentNet	0	6,942	74,048,352	2,509,000,000	36,171,000,000	0000093205	0000703361	0000050863
7	remainder_Assets	0	0	9,399,104	1,838,565,000	6,180,000,000	0000056978	0000791907	0000050863
8	ResearchAndDevelopmentExpense	0	668,840	72,208,128	1,540,000,000	12,740,000,000	0000093205	0001325702	0000050863
9	SellingGeneralAndAdministrativeExpense	0	1,752,962	81,071,696	806,000,000	8,397,000,000	0001398805	0000833640	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	104,800,000	1,873,000,000	0000002488	0000029002	0001649338
11	remainder_Expenses	0	672,000	260,039,208	6,849,000,000	27,996,000,000	0000093205	0001493594	0000050863
12	remainder_Revenues	0	115,400	478,452,352	12,399,000,000	59,387,000,000	0000093205	0001651235	0000050863
13	remainder_NetIncome	-225,000,000	-71,191,000	-106,144	62,000,000	223,383,000	0001649338	0000882508	0001274494
14	remainder_ComprehensiveNetIncome	-49,000,000	-13,881,000	0	15,646,000	65,800,000	0000723125	0001438423	0000912093

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	230,328	1,814,896	181,887,088	7,371,000,000	28,090,000,000	0000093205	0001096325	0001649338
1	Assets	100	9,001,276	767,015,904	16,431,000,000	113,327,000,000	0000093205	0000855658	0000050863
2	Expenses	848	6,597,957	439,383,664	9,986,000,000	49,133,000,000	0001634447	0000810136	0000050863
3	Revenues	0	115,400	478,452,352	12,399,000,000	59,387,000,000	0000093205	0001651235	0000050863
4	StockholdersEquity	-72,114,000	-1,385,104	488,181,344	10,473,000,000	93,025,000,000	0001325702	0000833640	0000050863
5	NetIncome	-1,861,000,000	-381,138,000	1,440,392	861,664,000	10,316,000,000	0001649338	0001493594	0000050863
6	ComprehensiveNetIncome	-1,800,000,000	-379,048,000	-144,939	861,664,000	10,362,000,000	0001649338	0000093205	0000050863
7	BaseVar	418,021	23,622,044	2,364,262,348	56,336,795,000	274,837,120,000	0000093205	0000088941	0000050863
8	EconomicCapitalRatio	-11.0	-4.67	2.13	4.71	5.80	0001350102	0000006951	0000004127

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-28.1	-0.160	0.317	1.05	35.2	0001481028	0001634447	0000093205
1	LiabilitiesNonCurrent	-2.20	-1.51	0.318	0.835	0.930	0001649338	0001039065	0001288469
2	remainder_Liabilities	-1.43	-0.784	0.113	0.428	0.525	0000703361	0000006281	0001288469
3	AssetsCurrent	-4.48	-1.86	-0.0824	0.708	10.4	0001350102	0000029002	0001420520
4	AssetsNonCurrent	-0.260	-0.118	-0.00427	0.0686	0.202	0001350102	0001604778	0001398805
5	IntangibleAssets	-3.09	-1.75	-0.0918	1.45	2.56	0001350102	0001126741	0001649338
6	PropertyPlantAndEquipmentNet	-1.03	-0.610	-0.0287	0.545	1.34	0000093205	0001126741	0001333822
7	remainder_Assets	-1.36	-1.05	-0.173	0.327	6.86	0001410172	0001649345	0001634447
8	ResearchAndDevelopmentExpense	-2.68	-1.79	0.143	0.774	1.37	0001507957	0001690666	0001275014
9	SellingGeneralAndAdministrativeExpense	-4.57	-1.14	0.205	0.820	1.30	0000093205	0000790715	0001398805
10	AmortizationOfIntangibleAssets	-0.238	-0.161	0.0272	0.0526	0.0702	0000310568	0000006951	0001040161
11	remainder_Expenses	-6.25	-2.15	0.0265	1.34	1.92	0001410172	0001102934	0001481028
12	remainder_Revenues	-3.99	-2.92	0.380	1.59	1.84	0001350102	0001356104	0001275014
13	remainder_NetIncome	-3.70	-0.194	-0.0299	0.180	6.13	0001350102	0001227025	0001481028
14	remainder_ComprehensiveNetIncome	-0.156	-0.0896	0.00156	0.0464	0.266	0001051627	0001126741	0000912093

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-14.9	-1.48	0.445	1.93	18.4	0001481028	0001438423	0000093205
1	Assets	-6.40	-3.22	-0.0302	0.764	3.92	0001350102	0000791907	0001420520
2	Expenses	-4.87	-2.39	0.189	0.770	3.04	0001410172	0001047127	0001481028
3	Revenues	-3.99	-2.92	0.380	1.59	1.84	0001350102	0001356104	0001275014
4	StockholdersEquity	-6.63	-4.61	-0.143	2.21	3.76	0001481028	0001175609	0001634447
5	NetIncome	-9.24	-5.66	0.565	1.91	6.21	0001350102	0001325702	0001481028
6	ComprehensiveNetIncome	-9.24	-5.65	0.550	1.91	6.21	0001350102	0000895419	0001481028
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0001047127	0000002488
8	EconomicCapitalRatio	-12.5	-6.13	0.672	3.25	4.34	0001350102	0000006951	0000004127

2017

Logs

warning	25 × No stock price available	subcommand.plot	0000703361 0000743988 0000790715 0000791915 0001058057 0001094739 0001102934 0001110647 0001160958 0001175609 0001227025 0001311241 0001356104 0001370702 0001395848 0001579910 0001651235 0001690666 0000093205 0000310568 0000743316 0001046995 0001316016 0001350102 0001556898
warning	8 × Missing logo	subcommand.report	0000088941 0000703361 0000743988 0000790715 0001045810 0001058057 0001280263 0001604778
warning	8 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000855658 0000912093 0000912093 0000912093 0000912093 0000912093 0001046995 0001350102
warning	6 × Ignoring company because Expenses is zero	pre-agg	0001419612 0001494162 0001494162 0001494162 0001730168 0000065759
warning	4 × Similarly named company. Duplicate?	None	0001102934 0000743316 0001350102 0001507957
warning	4 × Ignoring company because Assets is zero	pre-agg	0001392522 0001097864 0001097864 0001097864
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.512223836982274}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.646337875772299}
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001350102
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	630,394	1,678,126	96,976,257	1,882,000,000	17,421,000,000	0000093205	0001690666	0000050863
1	LiabilitiesNonCurrent	0	0	17,599,054	3,320,080,000	10,511,000,000	0000002488	0001094739	0000723125
2	remainder_Liabilities	0	0	1,962,661	662,356,400	1,707,255,000	0000002488	0000790715	0000006281
3	AssetsCurrent	39,889	2,553,387	407,683,448	8,575,600,000	29,500,000,000	0001634447	0001275014	0000050863
4	AssetsNonCurrent	0	0	7,547,414	282,352,000	11,314,000,000	0000093205	0001690666	0000050863
5	IntangibleAssets	0	0	106,738,417	3,615,581,600	37,134,000,000	0000093205	0001094739	0000050863
6	PropertyPlantAndEquipmentNet	0	54,019	67,862,312	2,356,080,000	41,109,000,000	0000790715	0000056978	0000050863
7	remainder_Assets	0	0	7,476,381	1,194,200,000	4,192,000,000	0000743316	0001395848	0000050863
8	ResearchAndDevelopmentExpense	0	708,857	73,837,932	1,472,000,000	13,098,000,000	0000093205	0001039399	0000050863
9	SellingGeneralAndAdministrativeExpense	0	3,058,677	86,490,927	701,436,800	7,474,000,000	0001398805	0001102934	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	114,280,000	297,351,000	0000002488	0000006951	0000006281
11	remainder_Expenses	-14,000	51,297	280,226,939	4,551,200,000	35,004,000,000	0001579910	0001102934	0000050863
12	remainder_Revenues	0	535,743	507,460,907	8,435,400,000	62,761,000,000	0001481028	0001102934	0000050863
13	remainder_NetIncome	-226,649,000	-82,195,800	-333,427	55,636,000	2,416,000,000	0000006281	0001652535	0000050863
14	remainder_ComprehensiveNetIncome	-102,400,000	-13,210,000	0	53,400,000	756,000,000	0000912093	0001040161	0000050863

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	630,394	1,932,491	239,208,221	7,858,000,000	17,421,000,000	0000093205	0001102934	0000050863
1	Assets	165,833	12,409,858	666,362,819	17,997,400,000	123,249,000,000	0001481028	0001110647	0000050863
2	Expenses	54,371	10,154,612	453,265,249	6,490,400,000	55,576,000,000	0001634447	0000855658	0000050863
3	Revenues	0	535,743	507,460,907	8,435,400,000	62,761,000,000	0001481028	0001102934	0000050863
4	StockholdersEquity	-39,637,000	-4,465,118	458,966,939	9,511,508,000	105,828,000,000	0001325702	0001039399	0000050863
5	NetIncome	-1,092,910,000	-84,250,000	3,786,990	2,019,600,000	9,601,000,000	0000867773	0001556898	0000050863
6	ComprehensiveNetIncome	-1,092,910,000	-80,118,600	7,874,712	2,020,200,000	10,357,000,000	0000867773	0000889971	0000050863
7	BaseVar	794,811	30,598,728	2,331,565,052	40,059,184,664	303,024,735,000	0000093205	0001102934	0000050863
8	EconomicCapitalRatio	-7.82	-2.65	2.13	4.51	5.27	0001350102	0000817720	0000004127

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-5.42	-0.495	0.350	0.872	3.06	0001481028	0000889971	0001350102
1	LiabilitiesNonCurrent	-2.18	-1.48	0.222	0.882	1.33	0000743316	0000890394	0001556898
2	remainder_Liabilities	-2.05	-1.14	0.174	0.484	0.756	0001160958	0001288469	0001556898
3	AssetsCurrent	-3.02	-1.03	-0.0712	1.58	9.17	0001350102	0000310568	0001420520
4	AssetsNonCurrent	-0.144	-0.0621	-0.00464	0.0538	0.182	0001438423	0001690666	0001398805
5	IntangibleAssets	-1.78	-1.07	-0.0654	1.34	2.73	0001282631	0000029002	0000006281
6	PropertyPlantAndEquipmentNet	-1.21	-0.436	-0.0496	0.678	1.58	0001282631	0001058057	0001350102
7	remainder_Assets	-1.18	-0.591	-0.127	0.296	7.46	0001282631	0001395848	0001634447
8	ResearchAndDevelopmentExpense	-2.41	-1.47	0.157	0.720	1.46	0001438423	0000817720	0001275014
9	SellingGeneralAndAdministrativeExpense	-2.38	-1.28	0.166	0.774	1.00	0001420520	0001051627	0001275014
10	AmortizationOfIntangibleAssets	-0.687	-0.0749	0.0275	0.0537	0.0591	0001690666	0001398805	0001275014
11	remainder_Expenses	-3.04	-1.95	-0.0812	1.24	1.90	0001275014	0000855658	0001579910
12	remainder_Revenues	-2.90	-2.39	0.392	1.48	2.17	0001350102	0000050863	0001556898
13	remainder_NetIncome	-1.55	-0.273	-0.0349	0.148	4.74	0001350102	0000743316	0001481028
14	remainder_ComprehensiveNetIncome	-0.340	-0.0322	-0.00440	0.0947	0.280	0000912093	0001420520	0001111928

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-10.7	-1.15	0.286	1.77	3.27	0001481028	0001604778	0001556898
1	Assets	-3.96	-2.12	-0.0299	1.38	2.74	0001282631	0000833640	0001420520
2	Expenses	-2.44	-1.99	0.149	0.688	2.08	0001420520	0001126741	0001481028
3	Revenues	-2.90	-2.39	0.392	1.48	2.17	0001350102	0000050863	0001556898
4	StockholdersEquity	-6.24	-3.38	-0.164	2.08	3.54	0001481028	0001160958	0001634447
5	NetIncome	-6.05	-3.66	0.477	1.63	4.09	0001350102	0000810136	0001481028
6	ComprehensiveNetIncome	-6.05	-3.66	0.503	1.68	4.08	0001350102	0001039065	0001481028
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0001094739	0000002488
8	EconomicCapitalRatio	-9.61	-4.43	0.346	2.72	3.48	0001350102	0000817720	0000004127

2018

Logs

error	1 × Non-active company, it does not contain Assets	input.sec.sec_edgar_reading	0001419612
error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001481028
warning	23 × No stock price available	subcommand.plot	0000743988 0000791915 0001021604 0001046995 0001058057 0001094739 0001102934 0001160958 0001227025 0001311241 0001350102 0001356104 0001370702 0001395848 0001651235 0001690666 0000093205 0000743316 0001316016 0001494162 0001579910 0001556898 0001715768
warning	15 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000833640 0000855658 0000912093 0000912093 0000912093 0000912093 0000912093 0000912093 0001046995 0001046995 0001046995 0001046995 0001046995 0001275014 0001350102
warning	11 × Ignoring company because Expenses is zero	pre-agg	0001730168 0001730168 0001730168 0001730168 0001730168 0001494162 0001494162 0001419612 0001419612 0001419612 0000065759
warning	7 × Missing logo	subcommand.report	0000088941 0000743988 0000827054 0001045810 0001058057 0001280263 0001604778
warning	4 × Similarly named company. Duplicate?	None	0001102934 0001280452 0001350102 0001507957
warning	4 × Ignoring company because Assets is zero	pre-agg	0001392522 0001097864 0001097864 0001097864
warning	2 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001275014 0001350102
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.5842673168164465}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -5.6463082600699925}
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	61,565	1,350,397	85,708,494	2,085,890,000	16,626,000,000	0001715768	0001652535	0000050863
1	LiabilitiesNonCurrent	0	0	11,805,793	3,092,690,000	7,088,190,000	0000002488	0001094739	0000006281
2	remainder_Liabilities	0	0	621,831	546,680,700	1,557,000,000	0000002488	0000810136	0000006951
3	AssetsCurrent	4,496	356,707	375,481,329	8,270,700,000	28,787,000,000	0001715768	0001690666	0000050863
4	AssetsNonCurrent	0	0	6,418,238	323,460,300	7,809,000,000	0001021604	0001158114	0000050863
5	IntangibleAssets	0	0	50,700,347	3,638,000,000	36,349,000,000	0000093205	0001463101	0000050863
6	PropertyPlantAndEquipmentNet	0	47,851	73,444,518	2,564,727,200	48,976,000,000	0001634447	0000056978	0000050863
7	remainder_Assets	0	0	6,381,208	1,326,365,200	6,042,000,000	0000093205	0000833640	0000050863
8	ResearchAndDevelopmentExpense	0	0	65,956,811	1,594,700,000	13,543,000,000	0000093205	0000833640	0000050863
9	SellingGeneralAndAdministrativeExpense	0	157,234	72,020,179	813,300,000	6,750,000,000	0000743316	0001325702	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	22,030,050	428,902,000	0000002488	0001058057	0000006281
11	remainder_Expenses	0	43,184	252,045,256	4,577,850,000	29,503,000,000	0001507957	0001039399	0000050863
12	remainder_Revenues	0	3,481	402,522,472	10,624,500,000	70,848,000,000	0000743316	0001690666	0000050863
13	remainder_NetIncome	-289,000,000	-75,309,650	240,015	99,679,700	1,617,558,000	0000723125	0001652535	0000743316
14	remainder_ComprehensiveNetIncome	-85,694,000	-34,767,250	-1,549	2,923,950	105,263,000	0001111928	0001438423	0000867773

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	61,565	1,584,902	193,081,301	8,340,735,850	16,626,000,000	0001715768	0000810136	0000050863
1	Assets	4,496	3,129,698	648,602,378	17,232,400,000	127,963,000,000	0001715768	0001616533	0000050863
2	Expenses	44,429	3,777,504	420,746,034	7,200,350,000	49,796,000,000	0001715768	0000855658	0000050863
3	Revenues	0	3,481	402,522,472	10,624,500,000	70,848,000,000	0000743316	0001690666	0000050863
4	StockholdersEquity	-149,886,000	-6,773,515	383,570,963	7,699,450,000	111,337,000,000	0000867773	0001288469	0000050863
5	NetIncome	-917,496,000	-100,003,350	-37,797	3,086,900,000	21,053,000,000	0000867773	0001634447	0000050863
6	ComprehensiveNetIncome	-812,233,000	-100,156,350	473,981	3,075,600,000	21,007,000,000	0000867773	0001410172	0000050863
7	BaseVar	118,112	17,440,223	2,176,628,270	42,481,405,000	303,417,765,000	0001715768	0001039399	0000050863
8	EconomicCapitalRatio	-71.2	-5.65	2.12	4.58	4.93	0001682149	0001094739	0000723125

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-42.3	-0.278	0.698	2.09	14.0	0001682149	0001325702	0001715768
1	LiabilitiesNonCurrent	-27.2	-1.65	0.209	0.808	1.11	0001682149	0001160958	0001556898
2	remainder_Liabilities	-14.9	-1.11	0.159	0.420	0.566	0001682149	0001288469	0001556898
3	AssetsCurrent	-55.3	-2.08	-0.100	1.10	8.64	0001682149	0000895419	0001420520
4	AssetsNonCurrent	-8.84	-0.181	-0.0143	0.0650	1.29	0001682149	0000810136	0000093205
5	IntangibleAssets	-39.6	-1.30	-0.0764	0.872	2.60	0001682149	0000889971	0000006281
6	PropertyPlantAndEquipmentNet	-36.0	-1.09	-0.0441	0.665	1.24	0001682149	0000912093	0001333822
7	remainder_Assets	-25.9	-0.647	-0.0639	0.203	5.91	0001682149	0000827054	0001634447
8	ResearchAndDevelopmentExpense	-3.01	-1.56	0.134	0.963	1.60	0001579910	0001039399	0001494162
9	SellingGeneralAndAdministrativeExpense	-6.42	-1.57	0.260	0.840	1.44	0001494162	0001463101	0001398805
10	AmortizationOfIntangibleAssets	-0.436	-0.112	0.0212	0.0417	0.187	0001690666	0001158114	0001682149
11	remainder_Expenses	-29.6	-2.59	0.0581	1.34	2.21	0001682149	0000723125	0001507957
12	remainder_Revenues	-25.2	-2.50	0.437	1.50	2.26	0001682149	0001438423	0001616533
13	remainder_NetIncome	-14.9	-0.920	0.0960	0.334	1.82	0001682149	0001356104	0000743316
14	remainder_ComprehensiveNetIncome	-0.211	-0.113	0.00952	0.0470	0.179	0001111928	0001420520	0000867773

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-48.7	-1.00	0.832	2.32	8.92	0001682149	0000029002	0001715768
1	Assets	-63.9	-3.91	-0.0313	1.04	3.29	0001682149	0000808326	0001420520
2	Expenses	-28.2	-2.41	0.148	0.757	1.19	0001682149	0001158114	0000723125
3	Revenues	-25.2	-2.50	0.437	1.50	2.26	0001682149	0001438423	0001616533
4	StockholdersEquity	-12.1	-4.37	0.474	2.08	3.46	0001682149	0001690666	0001410172
5	NetIncome	-68.3	-4.82	0.667	2.07	2.63	0001682149	0000006281	0000723125
6	ComprehensiveNetIncome	-68.2	-4.81	0.672	1.92	2.64	0001682149	0001051627	0000723125
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0001097864	0000002488
8	EconomicCapitalRatio	-71.6	-6.03	1.73	4.20	4.54	0001682149	0001094739	0000723125

2019

Logs

error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001481028
warning	18 × No stock price available	subcommand.plot	0000743988 0000791915 0001021604 0001046995 0001058057 0001102934 0001160958 0001227025 0001356104 0001395848 0001651235 0001690666 0000743316 0001398805 0001494162 0001579910 0001556898 0001781405
warning	18 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000833640 0000855658 0000912093 0000912093 0000912093 0000912093 0001046995 0001046995 0001046995 0001046995 0001046995 0001046995 0001275014 0001275014 0001275014 0001275014 0001275014 0001350102
warning	12 × Ignoring company because Expenses is zero	pre-agg	0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001730168 0001730168 0001730168 0001494162 0001494162 0000065759
warning	7 × Missing logo	subcommand.report	0000088941 0000743988 0000827054 0001045810 0001058057 0001280263 0001604778
warning	6 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001275014 0001275014 0001275014 0001275014 0001275014 0001350102
warning	5 × Ignoring company because Assets is zero	pre-agg	0001191334 0001392522 0001097864 0001097864 0001097864
warning	2 × Similarly named company. Duplicate?	None	0001102934 0001280452
warning	2 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810 0001431959
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.371830534056199}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.3975988908775117}
warning	1 × Non-active company, it does not contain more than 2 integer variables	input.sec.sec_edgar_reading	0001191334
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	530,383	1,630,500	133,852,089	2,366,750,000	22,310,000,000	0001781405	0001325702	0000050863
1	LiabilitiesNonCurrent	0	0	30,949,476	4,107,900,000	6,817,000,000	0000002488	0000004127	0000097476
2	remainder_Liabilities	0	0	1,188,593	552,150,000	2,135,366,000	0000002488	0001634447	0000006281
3	AssetsCurrent	1,501,178	5,616,778	467,036,820	9,483,500,000	31,239,000,000	0001781405	0001275014	0000050863
4	AssetsNonCurrent	0	0	9,811,134	461,783,500	8,829,000,000	0001021604	0001051627	0000050863
5	IntangibleAssets	0	0	98,414,604	6,208,593,500	37,103,000,000	0000867773	0000056978	0000050863
6	PropertyPlantAndEquipmentNet	0	241,500	81,246,890	2,386,374,500	55,386,000,000	0001047127	0001227025	0000050863
7	remainder_Assets	0	0	20,784,208	1,668,453,000	3,967,000,000	0000743316	0000810136	0000050863
8	ResearchAndDevelopmentExpense	0	0	73,483,202	1,800,500,000	13,362,000,000	0000743316	0000833640	0000050863
9	SellingGeneralAndAdministrativeExpense	0	2,588,950	88,783,819	909,000,000	6,150,000,000	0000743316	0001288469	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	32,374,500	429,041,000	0000002488	0000097476	0000006281
11	remainder_Expenses	1,000	1,140,444	310,596,582	5,326,000,000	33,428,000,000	0001579910	0000056978	0000050863
12	remainder_Revenues	0	727,426	540,126,256	13,049,500,000	71,965,000,000	0000743316	0000056978	0000050863
13	remainder_NetIncome	-379,200,000	-130,550,000	54,322	136,512,500	2,023,000,000	0000895419	0001556898	0000050863
14	remainder_ComprehensiveNetIncome	-306,000,000	-34,850,000	0	12,425,000	126,000,000	0000050863	0001282631	0000097476

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	530,383	2,333,500	291,008,774	9,397,226,500	22,310,000,000	0001781405	0001288469	0000050863
1	Assets	2,076,147	8,343,000	840,697,451	18,687,000,000	136,524,000,000	0001781405	0001039399	0000050863
2	Expenses	2,179,256	9,427,282	529,736,369	8,604,000,000	52,940,000,000	0001781405	0001280452	0000050863
3	Revenues	0	727,426	540,126,256	13,049,500,000	71,965,000,000	0000743316	0000056978	0000050863
4	StockholdersEquity	-14,981,000	1,328,382	419,720,077	10,525,594,000	114,214,000,000	0001325702	0001280263	0000050863
5	NetIncome	-383,798,000	-93,922,000	-422,112	3,423,500,000	21,048,000,000	0001493594	0001634447	0000050863
6	ComprehensiveNetIncome	-381,628,000	-93,366,500	-421,377	3,407,500,000	20,742,000,000	0001493594	0001634447	0000050863
7	BaseVar	6,857,422	36,839,900	2,723,434,051	52,941,245,000	323,070,110,000	0001781405	0000810136	0000050863
8	EconomicCapitalRatio	-14.0	-2.40	1.97	4.37	5.50	0001494162	0000006951	0000833640

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-1.12	-0.573	0.137	0.680	8.05	0000882508	0001410172	0001494162
1	LiabilitiesNonCurrent	-2.01	-1.41	0.276	0.885	0.958	0000743316	0000889971	0000002488
2	remainder_Liabilities	-1.36	-0.963	0.128	0.334	0.376	0001038074	0000006951	0001616533
3	AssetsCurrent	-6.13	-0.912	-0.146	0.791	6.90	0001494162	0000006951	0001420520
4	AssetsNonCurrent	-0.561	-0.160	-0.0193	0.0817	0.283	0001494162	0001280263	0000867773
5	IntangibleAssets	-3.88	-1.08	-0.0922	1.37	2.44	0001682149	0000723125	0001058057
6	PropertyPlantAndEquipmentNet	-2.98	-0.733	-0.0844	0.579	1.39	0001682149	0001038074	0001158114
7	remainder_Assets	-1.40	-0.261	-0.0175	0.290	1.37	0001682149	0001493594	0001047127
8	ResearchAndDevelopmentExpense	-4.53	-1.17	0.141	1.04	1.47	0001579910	0001046995	0001634447
9	SellingGeneralAndAdministrativeExpense	-4.23	-2.21	0.157	0.729	1.34	0001682149	0001356104	0001398805
10	AmortizationOfIntangibleAssets	-0.479	-0.118	0.0256	0.0461	0.0523	0001690666	0000097476	0001682149
11	remainder_Expenses	-4.13	-1.70	0.0138	1.50	2.90	0001398805	0000827054	0001494162
12	remainder_Revenues	-4.95	-2.32	0.289	1.15	1.83	0001494162	0000791915	0001616533
13	remainder_NetIncome	-6.76	-0.408	0.0419	0.204	2.06	0001494162	0000743988	0000743316
14	remainder_ComprehensiveNetIncome	-0.114	-0.0431	0.00451	0.0461	0.117	0001051627	0001420520	0001325702

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.72	-1.33	0.230	1.47	3.39	0000743316	0001227025	0001494162
1	Assets	-8.96	-2.08	-0.0971	1.06	1.55	0001494162	0000097476	0001420520
2	Expenses	-5.96	-1.89	0.145	0.813	1.08	0001682149	0001651235	0000833640
3	Revenues	-4.95	-2.32	0.289	1.15	1.83	0001494162	0000791915	0001616533
4	StockholdersEquity	-5.54	-3.43	-0.0858	1.73	3.29	0001494162	0000889971	0001410172
5	NetIncome	-11.6	-4.69	0.471	1.69	2.39	0001682149	0001126741	0001045810
6	ComprehensiveNetIncome	-11.6	-4.69	0.478	1.70	2.40	0001682149	0001038074	0001045810
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0001097864	0000002488
8	EconomicCapitalRatio	-15.5	-3.81	0.560	2.96	4.09	0001494162	0000006951	0000833640

2020

Logs

error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001481028
warning	21 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000833640 0001046995 0001046995 0001046995 0001046995 0001046995 0001046995 0001046995 0001275014 0001275014 0001275014 0001275014 0001275014 0001275014 0001350102 0000855658 0000912093 0000912093 0000912093 0000912093 0000912093
warning	12 × No stock price available	subcommand.plot	0000743988 0000915778 0001046995 0001058057 0001102934 0001160958 0001227025 0001651235 0001021604 0001579910 0001350102 0001556898
warning	12 × Ignoring company because Expenses is zero	pre-agg	0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001730168 0001730168 0001494162 0001494162 0000065759
warning	9 × Missing logo	subcommand.report	0000088941 0000743988 0000827054 0000866291 0000915778 0001045810 0001058057 0001280263 0001604778
warning	7 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001275014 0001275014 0001275014 0001275014 0001275014 0001275014 0001350102
warning	5 × Ignoring company because Assets is zero	pre-agg	0001191334 0001392522 0001097864 0001097864 0001097864
warning	4 × Similarly named company. Duplicate?	None	0001102934 0001280452 0001431959 0001350102
warning	2 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810 0001431959
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.279110128135993}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.0808159727467084}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	501,351	1,622,600	144,981,807	3,540,100,000	24,754,000,000	0001781405	0001280452	0000050863
1	LiabilitiesNonCurrent	0	0	24,082,350	6,443,434,650	45,661,000,000	0000002488	0001280263	0001730168
2	remainder_Liabilities	0	0	842,348	450,190,050	1,919,595,000	0000002488	0001040161	0000006281
3	AssetsCurrent	204,388	3,066,949	456,028,867	12,705,700,000	47,249,000,000	0001481028	0000088941	0000050863
4	AssetsNonCurrent	0	0	5,607,928	981,435,550	8,109,000,000	0000006281	0001280263	0000050863
5	IntangibleAssets	0	0	23,668,534	10,447,807,250	60,229,000,000	0000091668	0001280263	0001730168
6	PropertyPlantAndEquipmentNet	1,058	130,450	75,653,492	2,541,836,100	56,584,000,000	0001481028	0000817720	0000050863
7	remainder_Assets	0	0	22,295,570	1,528,100,000	5,152,000,000	0000743988	0001604778	0000050863
8	ResearchAndDevelopmentExpense	0	0	54,140,909	2,435,300,000	13,556,000,000	0000091668	0001463101	0000050863
9	SellingGeneralAndAdministrativeExpense	0	1,691,538	78,287,374	1,093,000,000	6,180,000,000	0001398805	0000833640	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	73,610,700	6,220,000,000	0000002488	0000006951	0001730168
11	remainder_Expenses	1,000	833,288	285,409,384	7,117,200,000	38,632,000,000	0001579910	0001651235	0000050863
12	remainder_Revenues	0	123,658	497,817,813	15,968,550,000	77,867,000,000	0001481028	0001325702	0000050863
13	remainder_NetIncome	-186,627,000	-61,997,510	27,179	250,793,750	1,400,000,000	0000006281	0000810136	0000050863
14	remainder_ComprehensiveNetIncome	-119,000,000	-10,960,150	507	22,398,000	529,000,000	0000006951	0001410172	0000050863

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	1,122,951	2,651,200	222,571,303	11,050,050,000	52,032,000,000	0001781405	0000810136	0001730168
1	Assets	291,802	7,788,445	840,095,707	21,955,021,350	153,091,000,000	0001481028	0001651235	0000050863
2	Expenses	1,681,427	6,988,450	504,140,090	11,623,750,000	58,368,000,000	0001481028	0000088941	0000050863
3	Revenues	0	123,658	497,817,813	15,968,550,000	77,867,000,000	0001481028	0001325702	0000050863
4	StockholdersEquity	-61,832,448	1,447,712	421,927,873	14,175,585,000	128,337,000,000	0001481028	0001387467	0000050863
5	NetIncome	-190,600,000	-58,036,802	4,203,223	2,886,200,000	20,899,000,000	0000895419	0001051627	0000050863
6	ComprehensiveNetIncome	-185,200,000	-54,824,236	8,316,376	2,905,250,000	21,428,000,000	0000895419	0001051627	0000050863
7	BaseVar	10,565,088	40,477,996	2,675,591,077	69,314,780,000	353,506,560,000	0001781405	0001325702	0000050863
8	EconomicCapitalRatio	-11.7	-3.08	1.98	4.28	5.40	0001481028	0001803696	0001325702

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-1.45	-0.538	0.221	0.747	31.6	0001333822	0000808326	0001481028
1	LiabilitiesNonCurrent	-2.39	-1.36	0.401	1.09	1.45	0001730168	0000029002	0001325702
2	remainder_Liabilities	-1.70	-0.866	0.210	0.501	0.681	0001431959	0001410172	0000091668
3	AssetsCurrent	-4.92	-0.877	-0.0995	1.65	7.14	0001481028	0001058057	0001420520
4	AssetsNonCurrent	-0.311	-0.141	-0.0156	0.0622	0.523	0001481028	0001651235	0001634447
5	IntangibleAssets	-2.11	-0.934	-0.118	1.06	2.36	0001481028	0001045810	0001730168
6	PropertyPlantAndEquipmentNet	-1.84	-0.656	-0.0728	0.887	1.57	0001481028	0000006281	0001781405
7	remainder_Assets	-1.17	-0.420	-0.0550	0.246	7.40	0001481028	0000743988	0001431959
8	ResearchAndDevelopmentExpense	-3.02	-1.21	0.0835	0.964	1.49	0001579910	0000006281	0000091668
9	SellingGeneralAndAdministrativeExpense	-2.78	-1.12	0.132	0.627	0.813	0001682149	0001039399	0001652535
10	AmortizationOfIntangibleAssets	-0.358	-0.0885	0.0253	0.0444	0.0567	0001730168	0001126741	0000091668
11	remainder_Expenses	-2.87	-2.08	-0.0391	0.928	1.93	0000091668	0000056978	0001481028
12	remainder_Revenues	-3.06	-1.49	0.311	1.38	2.01	0001481028	0001097864	0000002488
13	remainder_NetIncome	-6.84	-0.386	0.0231	0.533	2.63	0001481028	0001451809	0001325702
14	remainder_ComprehensiveNetIncome	-0.319	-0.0380	-0.00692	0.0895	0.139	0001616533	0001556898	0001227025

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-4.62	-1.30	0.671	1.87	14.3	0001350102	0001398805	0001481028
1	Assets	-7.28	-1.75	-0.0944	1.28	3.55	0001481028	0000002488	0001420520
2	Expenses	-3.66	-1.67	0.0266	0.744	3.22	0001781405	0000088941	0001481028
3	Revenues	-3.06	-1.49	0.311	1.38	2.01	0001481028	0001097864	0000002488
4	StockholdersEquity	-6.88	-2.87	-0.132	2.13	3.17	0001481028	0001124796	0001410172
5	NetIncome	-6.68	-3.89	0.499	1.44	3.89	0001481028	0001350102	0001325702
6	ComprehensiveNetIncome	-6.69	-3.91	0.497	1.43	3.93	0001481028	0001803696	0001325702
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0001102934	0000002488
8	EconomicCapitalRatio	-13.4	-4.80	0.263	2.56	3.68	0001481028	0001803696	0001325702

2021

Logs

error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001481028
warning	26 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000833640 0000855658 0000912093 0000912093 0000912093 0000912093 0000912093 0000912093 0000912093 0000912093 0001046995 0001046995 0001046995 0001046995 0001046995 0001046995 0001046995 0001046995 0001275014 0001275014 0001275014 0001275014 0001275014 0001275014 0001275014 0001350102
warning	13 × Ignoring company because Expenses is zero	pre-agg	0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001730168 0001730168 0000065759 0001494162 0001494162
warning	11 × No stock price available	subcommand.plot	0001021604 0001046995 0001102934 0001227025 0001807794 0001852117 0001579910 0001350102 0001813658 0001817760 0001832487
warning	9 × Missing logo	subcommand.report	0000088941 0000827054 0000866291 0001045810 0001280263 0001604778 0001807794 0001835632 0001819974
warning	8 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001275014 0001275014 0001275014 0001275014 0001275014 0001275014 0001275014 0001350102
warning	7 × Similarly named company. Duplicate?	None	0001102934 0001280452 0001463101 0001350102 0001431959 0001828161 0001507957
warning	5 × Ignoring company because Assets is zero	pre-agg	0001392522 0001097864 0001097864 0001097864 0001191334
warning	2 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810 0001431959
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.1396178038270675}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.4485482050124183}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	232,081	1,510,000	93,349,816	4,240,000,000	27,462,000,000	0001781405	0001828161	0000050863
1	LiabilitiesNonCurrent	0	0	13,523,240	7,620,387,000	44,300,000,000	0000002488	0000808326	0001730168
2	remainder_Liabilities	0	0	1,240,025	429,396,000	3,938,830,000	0000002488	0001431959	0000006281
3	AssetsCurrent	0	8,432,000	334,405,088	16,055,000,000	57,718,000,000	0001387467	0000855658	0000050863
4	AssetsNonCurrent	0	0	5,762,240	1,812,000,000	6,912,000,000	0000006281	0001831651	0000050863
5	IntangibleAssets	0	0	18,302,568	7,607,661,000	54,824,000,000	0000091668	0000890394	0001730168
6	PropertyPlantAndEquipmentNet	0	182,000	60,924,400	2,649,587,000	63,245,000,000	0001813658	0001288469	0000050863
7	remainder_Assets	0	0	21,919,088	1,513,000,000	6,298,000,000	0001039065	0001280452	0000050863
8	ResearchAndDevelopmentExpense	0	0	49,289,504	2,663,000,000	15,190,000,000	0000091668	0001616533	0000050863
9	SellingGeneralAndAdministrativeExpense	0	2,921,232	55,992,360	1,347,000,000	6,543,000,000	0001398805	0001280263	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	36,000,000	5,403,000,000	0000002488	0001158114	0001730168
11	remainder_Expenses	-1,853,000	21,973	228,347,712	9,052,000,000	39,670,000,000	0000890394	0001227025	0000050863
12	remainder_Revenues	0	576,399	291,231,648	18,344,000,000	79,024,000,000	0001481028	0001227025	0000050863
13	remainder_NetIncome	-363,487,000	-123,000,000	-10,912	131,000,000	2,247,000,000	0000006281	0001682149	0000050863
14	remainder_ComprehensiveNetIncome	-129,000,000	-14,700,000	0	39,000,000	203,000,000	0000050863	0001451809	0000097476

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	577,540	2,160,000	199,906,928	13,578,000,000	50,581,000,000	0001781405	0001158114	0001730168
1	Assets	3,794,004	12,848,068	584,410,440	28,791,000,000	168,406,000,000	0001781405	0001325702	0000050863
2	Expenses	3,874,441	8,653,000	360,816,360	13,345,000,000	61,403,000,000	0001781405	0000855658	0000050863
3	Revenues	0	576,399	291,231,648	18,344,000,000	79,024,000,000	0001481028	0001227025	0000050863
4	StockholdersEquity	-80,567,323	-1,584,000	384,603,472	16,893,000,000	140,944,000,000	0001481028	0000855658	0000050863
5	NetIncome	-522,500,000	-115,485,000	4,355,028	5,861,000,000	19,868,000,000	0000895419	0001438423	0000050863
6	ComprehensiveNetIncome	-537,200,000	-106,579,000	5,909,323	5,792,000,000	19,739,000,000	0000895419	0001813658	0000050863
7	BaseVar	11,070,700	43,783,505	1,493,935,546	75,948,440,000	371,401,745,000	0001781405	0001828161	0000050863
8	EconomicCapitalRatio	-5.19	-3.45	2.01	4.14	5.20	0001481028	0001097864	0001556898

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-1.38	-0.847	0.210	0.803	1.27	0001210618	0001280263	0001832487
1	LiabilitiesNonCurrent	-2.51	-1.37	0.171	1.12	1.30	0001730168	0001021604	0001556898
2	remainder_Liabilities	-3.55	-0.877	0.236	0.535	0.776	0001831651	0001616533	0001556898
3	AssetsCurrent	-2.32	-0.795	-0.0975	2.52	4.13	0001021604	0000810136	0001817760
4	AssetsNonCurrent	-0.262	-0.158	-0.0191	0.0841	0.865	0001021604	0001387467	0001852117
5	IntangibleAssets	-1.58	-1.19	-0.158	1.70	2.46	0001021604	0000006951	0000006281
6	PropertyPlantAndEquipmentNet	-1.08	-0.673	-0.0773	0.728	1.72	0001021604	0001045810	0001819974
7	remainder_Assets	-0.943	-0.571	-0.106	0.793	5.21	0001282631	0000771266	0001813658
8	ResearchAndDevelopmentExpense	-3.42	-1.25	0.171	0.971	1.36	0001579910	0001280452	0000091668
9	SellingGeneralAndAdministrativeExpense	-2.75	-1.51	0.194	0.683	0.852	0001817760	0001102934	0001047127
10	AmortizationOfIntangibleAssets	-0.418	-0.0530	0.0194	0.0389	0.0457	0001803696	0001280263	0001832487
11	remainder_Expenses	-3.26	-1.81	-0.155	1.28	1.91	0001828161	0001463101	0001579910
12	remainder_Revenues	-3.33	-1.68	0.373	1.75	2.50	0001817760	0001051627	0000002488
13	remainder_NetIncome	-2.94	-0.734	0.0926	0.521	1.53	0001481028	0001038074	0000867773
14	remainder_ComprehensiveNetIncome	-0.113	-0.0478	-0.0112	0.0490	0.347	0000810136	0001398805	0001038074

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-2.01	-1.41	0.206	2.11	2.57	0001831651	0001282631	0001556898
1	Assets	-3.78	-1.68	-0.228	1.52	2.91	0001021604	0001831651	0001431959
2	Expenses	-4.12	-2.19	0.0342	0.718	1.78	0001817760	0001333822	0001481028
3	Revenues	-3.33	-1.68	0.373	1.75	2.50	0001817760	0001051627	0000002488
4	StockholdersEquity	-4.87	-2.62	-0.397	1.98	3.07	0001282631	0000855658	0001507957
5	NetIncome	-7.13	-3.26	0.465	2.11	2.88	0001817760	0001831651	0001556898
6	ComprehensiveNetIncome	-7.09	-3.27	0.565	2.08	2.85	0001817760	0000889971	0001556898
7	BaseVar	nan	nan	nan	nan	nan	0000002488	0001227025	0000002488
8	EconomicCapitalRatio	-6.80	-5.06	0.399	2.53	3.59	0001481028	0001097864	0001556898

2022

Logs

error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001481028
warning	23 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000833640 0000855658 0000912093 0000912093 0000912093 0000912093 0000912093 0000912093 0000912093 0000912093 0000912093 0001046995 0001046995 0001046995 0001046995 0001046995 0001046995 0001275014 0001275014 0001275014 0001275014 0001275014 0001350102
warning	14 × Ignoring company because Expenses is zero	pre-agg	0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001419612 0001730168 0001730168 0000065759 0001494162 0001494162
warning	11 × Missing logo	subcommand.report	0000088941 0000724910 0000827054 0000866291 0001045810 0001280263 0001604778 0001807794 0001835632 0000065759 0001819974
warning	6 × No stock price available	subcommand.plot	0001046995 0001807794 0000065759 0001852117 0001813658 0001817760
warning	6 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001275014 0001275014 0001275014 0001275014 0001275014 0001350102
warning	5 × Similarly named company. Duplicate?	None	0001280452 0001350102 0001463101 0001828161 0001507957
warning	5 × Ignoring company because Assets is zero	pre-agg	0001392522 0001097864 0001097864 0001097864 0001191334
warning	2 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001045810 0001431959
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 5.071168965913839}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -5.395975908792801}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000827054
warning	1 × IncomeStatement or BalanceSheet table not found.	input.sec.get_statements	0001431959

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	449,318	2,351,011	97,268,670	6,437,300,000	32,155,000,000	0001507957	0001493594	0000050863
1	LiabilitiesNonCurrent	0	0	18,147,271	7,819,450,600	43,488,000,000	0000002488	0001325702	0001730168
2	remainder_Liabilities	0	0	1,566,033	531,135,700	3,622,538,000	0000002488	0001813658	0000006281
3	AssetsCurrent	0	8,715,270	267,258,346	16,182,900,000	50,407,000,000	0001387467	0001280263	0000050863
4	AssetsNonCurrent	0	0	6,328,112	2,184,300,000	11,315,000,000	0000065759	0001831651	0000050863
5	IntangibleAssets	0	0	18,431,258	19,258,950,000	50,725,000,000	0000065759	0001040161	0001730168
6	PropertyPlantAndEquipmentNet	0	197,493	60,710,215	3,459,320,200	80,860,000,000	0000724910	0001124796	0000050863
7	remainder_Assets	0	70,361	23,264,226	1,815,390,000	5,912,000,000	0001039065	0000808326	0000050863
8	ResearchAndDevelopmentExpense	0	0	47,967,478	3,296,300,000	17,528,000,000	0000091668	0001807794	0000050863
9	SellingGeneralAndAdministrativeExpense	0	2,667,458	70,485,533	1,464,600,000	7,002,000,000	0000724910	0001280263	0000050863
10	AmortizationOfIntangibleAssets	0	0	0	24,234,500	4,359,000,000	0000002488	0001124796	0001730168
11	remainder_Expenses	42,894	339,671	189,240,992	11,191,000,000	35,941,000,000	0001481028	0001158114	0000050863
12	remainder_Revenues	0	375,905	331,901,256	25,897,900,000	63,054,000,000	0001481028	0001280263	0000050863
13	remainder_NetIncome	-434,931,000	-101,010,000	564,069	128,971,200	5,434,000,000	0001803696	0001652535	0000050863
14	remainder_ComprehensiveNetIncome	-562,000,000	-86,664,700	-120,587	7,080,800	315,000,000	0000723125	0001556898	0000050863

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	1,490,763	5,563,995	183,072,623	14,716,400,000	50,540,000,000	0001507957	0001852117	0001730168
1	Assets	4,172,682	15,884,400	658,270,954	51,900,415,000	182,103,000,000	0001781405	0001280263	0000050863
2	Expenses	4,475,225	10,225,100	302,923,969	19,399,600,000	60,471,000,000	0001481028	0001803696	0000050863
3	Revenues	0	375,905	331,901,256	25,897,900,000	63,054,000,000	0001481028	0001280263	0000050863
4	StockholdersEquity	-99,354,000	1,961,973	384,801,059	27,597,332,300	149,948,000,000	0001852117	0001821769	0000050863
5	NetIncome	-421,000,000	-150,455,900	14,515,242	8,084,000,000	11,495,000,000	0001835632	0000724910	0001730168
6	ComprehensiveNetIncome	-421,000,000	-152,769,900	3,528,444	8,145,700,000	11,557,000,000	0001835632	0000091668	0001730168
7	BaseVar	17,092,723	51,444,760	1,712,772,879	115,946,063,000	354,688,710,000	0001781405	0001280263	0000050863
8	EconomicCapitalRatio	-18.3	-5.40	2.43	5.07	10.1	0001813658	0001288469	0001481028

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	LiabilitiesCurrent	-2.94	-0.925	0.170	0.755	6.89	0001481028	0000004127	0001813658
1	LiabilitiesNonCurrent	-2.61	-1.47	0.227	0.913	1.59	0001730168	0001387467	0001481028
2	remainder_Liabilities	-2.46	-0.857	0.235	0.557	0.981	0001046995	0000004127	0001481028
3	AssetsCurrent	-9.80	-1.71	-0.0668	1.44	4.80	0001813658	0000810136	0001507957
4	AssetsNonCurrent	-0.961	-0.244	-0.00706	0.0829	0.194	0001813658	0000056978	0001350102
5	IntangibleAssets	-5.79	-1.51	-0.129	0.907	2.69	0001813658	0000006951	0001835632
6	PropertyPlantAndEquipmentNet	-3.63	-1.04	-0.0385	0.735	1.86	0001813658	0000006281	0001819974
7	remainder_Assets	-3.16	-0.678	-0.0308	0.751	1.42	0001813658	0000091668	0001634447
8	ResearchAndDevelopmentExpense	-3.79	-1.46	0.234	1.02	1.58	0001817760	0001604778	0001282631
9	SellingGeneralAndAdministrativeExpense	-3.06	-1.40	0.144	0.845	1.58	0001817760	0000895419	0001282631
10	AmortizationOfIntangibleAssets	-0.337	-0.0973	0.0181	0.0343	0.0585	0001803696	0000867773	0001282631
11	remainder_Expenses	-6.40	-2.36	-0.0767	1.57	3.18	0001282631	0000827054	0001813658
12	remainder_Revenues	-5.72	-2.24	0.306	1.66	2.37	0001813658	0000808326	0001282631
13	remainder_NetIncome	-11.2	-0.685	-0.0519	0.386	9.03	0001813658	0001039399	0001481028
14	remainder_ComprehensiveNetIncome	-0.846	-0.147	0.0194	0.0566	0.771	0000810136	0001288469	0001817760

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.93	-1.19	0.257	1.71	2.44	0001730168	0001781405	0001852117
1	Assets	-13.7	-3.26	-0.0780	1.30	3.58	0001813658	0001325702	0001507957
2	Expenses	-5.11	-2.53	0.251	1.12	4.08

QA: us_semiconductors 2009-2023

Table of Contents

Ranks across the years

PDF reports

2009

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2010

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2011

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2012

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2013

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2014

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2015

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2016

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2017

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2018

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2019

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2020

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2021

Logs

Diagrams

Calculation Linkbase Overview