S&P 500 Component Stocks

	A	B	F	G	H
1	Worksheet ID (copy/paste from URL):	- Look at the text between /d/ and /edit# in the URL to get your worksheet ID. Copy into this cell -	Date	Row	Count of Securities
2	Link to download Backlog Data:	https://docs.google.com/spreadsheets/d/- Look at the text between /d/ and /edit# in the URL to get your worksheet ID. Copy into this cell -/gviz/tq?tqx=out:csv&sheet=Backtest_CSV	2010-01-01	1	497
3	Link to download Live Data:	https://docs.google.com/spreadsheets/d/- Look at the text between /d/ and /edit# in the URL to get your worksheet ID. Copy into this cell -/gviz/tq?tqx=out:csv&sheet=Live_CSV	2010-02-26	2	497
4	Backtest Start Date:	2010-01-01	2010-04-29	3	497
5			2010-06-28	4	497
6	Colour Code:	Note:	2010-06-30	5	497
7	Internet Data (Wikipedia)	Make sure to check the Backlog Start Date above. It needs to match the start date for your backlog test! If you start the backlog "in between" CSV dates, then the universe selection will be empty until the next change happens in the S&P500, and no trades will happen in that time. The furthest back in time you can go is 2010-01-01. Note that there is some discrepancies with the Wikipedia data. For example, on the Changes table, Ticker DLPH is added but is never removed, even though is does not exist on the Current Symbols table	2010-07-14	6	497
8	Formula		2010-08-26	7	497
9	Calculated Data from Array Formula		2010-11-17	8	496
10	Manual Entry (This sheet Only)		2010-12-17	9	496
11			2011-02-25	10	495
12			2011-02-28	11	495
13			2011-03-31	12	496
14			2011-04-01	13	496
15			2011-04-27	14	496
16			2011-06-01	15	496
17			2011-06-30	16	496
18			2011-07-05	17	496
19			2011-09-23	18	496
20			2011-10-14	19	496
21			2011-10-31	20	496
22			2011-11-18	21	496
23			2011-12-12	22	497
24			2011-12-16	23	497
25			2011-12-20	24	497
26			2011-12-31	25	497
27			2012-03-13	26	498
28			2012-04-03	27	498
29			2012-04-23	28	498
30			2012-05-17	29	498
31			2012-05-21	30	498
32			2012-06-05	31	498
33			2012-06-29	32	498
34			2012-07-02	33	498
35			2012-07-31	34	498
36			2012-09-05	35	498
37			2012-10-01	36	498
38			2012-10-02	37	498
39			2012-10-10	38	498
40			2012-12-03	39	498
41			2012-12-11	40	498
42			2012-12-21	41	497
43			2013-01-02	42	497
44			2013-02-15	43	497
45			2013-04-30	44	497
46			2013-05-08	45	497
47			2013-05-23	46	497
48			2013-06-06	47	497
49			2013-06-21	48	497
50			2013-07-01	49	497
51			2013-07-08	50	497
52			2013-09-10	51	497
53			2013-09-20	52	498
54			2013-10-29	53	498
55			2013-11-13	54	497
56			2013-12-02	55	497
57			2013-12-10	56	497
58			2013-12-23	57	497
59			2014-01-24	58	497
60			2014-03-21	59	497
61			2014-04-02	60	497
62			2014-04-03	61	498
63			2014-05-01	62	497
64			2014-05-08	63	497
65			2014-06-20	64	497
66			2014-07-01	65	497
67			2014-07-02	66	497
68			2014-08-06	67	497
69			2014-08-18	68	497
70			2014-09-20	69	497
71			2014-11-05	70	498
72			2014-12-05	71	499
73			2015-01-27	72	499
74			2015-03-12	73	499
75			2015-03-18	74	499
76			2015-03-23	75	500
77			2015-04-07	76	500
78			2015-06-11	77	500
79			2015-07-01	78	500
80			2015-07-02	79	500
81			2015-07-06	80	500
82			2015-07-08	81	500
83			2015-07-20	82	500
84			2015-07-29	83	500
85			2015-08-28	84	500
86			2015-09-02	85	500
87			2015-09-18	86	503
88			2015-10-07	87	503
89			2015-11-02	88	503
90			2015-11-18	89	503
91			2015-11-19	90	503
92			2015-12-01	91	503
93			2015-12-15	92	502
94			2015-12-29	93	502
95			2016-01-05	94	501
96			2016-01-19	95	501
97			2016-02-01	96	501
98			2016-02-22	97	501
99			2016-03-04	98	501
100			2016-03-07	99	501