Note:  the prices of the stocks – and – the weights in the Index will change every day.
Therefore, your answers may not exactly match the answers in the videos (or on another student’s project).
If you wish to be extra cautious, you can include the Date you downloaded the data as part of your answer to Question 1 (in the “H” column of the Comparison sheet).  If you do that, I can check your work against historical data if needed.
1. Use these URLs for the data for the S&P 500 and the Nasdaq 100:
https://www.slickcharts.com/nasdaq100
https://www.slickcharts.com/sp500
2. Use the videos in the related Project 5 page to help explain & Walk-through this Projett.
3. Use the Instructions (from the Instructions page) in this workbook and the rest of the workbook as a template for your work.  These are also found on the introduction page to this Project. 
(40 points = 20 points per connection) 1. Create web connections and queries to the two stock index tables as per the Instructions in the workbook.  Please ensure you do NOT have either of the “auto refresh” or “refresh on open” enabled.
(10 points total) 2.     Rename the queries as per the Instructions.
(10 points total) 3. Determine the Percent Weight of each stock in each index – and – determine the dollar value of each stock in each index (assuming a $1000 portfolio per index).
(15 points total ) 4.Properly complete the table in the “A” through “E” columns on the Comparison sheet.
(15 points total) 5.  Complete the “F” column information on the Comparison sheet as per the Instructions.
(10 points total) 6.  Answer questions #1 through #4 on the Comparison sheet as per the Instructions.