Question: Find the percentage of returns of BSE 30 which are because of the movement in Oil prices.
Data available is Value of the BSE 30 at the closing time on different dates and Oil prices in US$ as follows:
Date SENSEX(BSE30) Oil Prices ($)
14-Aug-07 15000.91 ------ 71.47000
13-Aug-07 15017.21 ------ 71.47
10-Aug-07 14868.25 ------ 71.47000
09-Aug-07 15100.15 ------ 71.47000
08-Aug-07 15307.98 ------ 71.47
07-Aug-07 14932.77 ------ 71.47
06-Aug-07 14903.03 ------ 71.47
03-Aug-07 15138.4 ------ 75.49
02-Aug-07 14985.7 ------ 75.49
01-Aug-07 14935.77 ------ 75.49
31-Jul-07 15550.99 ------ 75.49
30-Jul-07 15260.91 ------ 75.49
27-Jul-07 15234.57 ------ 77.03
26-Jul-07 15776.31 ------ 77.03
25-Jul-07 15699.33 ------ 77.03
24-Jul-07 15794.92 ------ 77.03
23-Jul-07 15732.2 ------ 77.03
20-Jul-07 15565.55 ------ 75.58
19-Jul-07 15550.13 ------ 75.58
18-Jul-07 15301.17 ------ 75.58
Please provide the solution with methodology to solve if possible asap. Thanks a lot.
Data available is Value of the BSE 30 at the closing time on different dates and Oil prices in US$ as follows:
Date SENSEX(BSE30) Oil Prices ($)
14-Aug-07 15000.91 ------ 71.47000
13-Aug-07 15017.21 ------ 71.47
10-Aug-07 14868.25 ------ 71.47000
09-Aug-07 15100.15 ------ 71.47000
08-Aug-07 15307.98 ------ 71.47
07-Aug-07 14932.77 ------ 71.47
06-Aug-07 14903.03 ------ 71.47
03-Aug-07 15138.4 ------ 75.49
02-Aug-07 14985.7 ------ 75.49
01-Aug-07 14935.77 ------ 75.49
31-Jul-07 15550.99 ------ 75.49
30-Jul-07 15260.91 ------ 75.49
27-Jul-07 15234.57 ------ 77.03
26-Jul-07 15776.31 ------ 77.03
25-Jul-07 15699.33 ------ 77.03
24-Jul-07 15794.92 ------ 77.03
23-Jul-07 15732.2 ------ 77.03
20-Jul-07 15565.55 ------ 75.58
19-Jul-07 15550.13 ------ 75.58
18-Jul-07 15301.17 ------ 75.58
Please provide the solution with methodology to solve if possible asap. Thanks a lot.