Spreadsheet: 597544d1541864302-picking-values-from-variable-range-excel
Sheet: Sheet1

 |  |  |  |  |  | Weekly Data |  |  |  |  | Monthly Data
Day | Date | Open | High | Low | Close | Open | High | Low | Close | Week | Open | High | Low | Close
 | 2008-11-03 00:00:00 | 582.3 | 624.7 | 580.05 | 602.2
 | 2008-11-04 00:00:00 | 600 | 648.9 | 582.4 | 640.45
 | 2008-11-05 00:00:00 | 651.9 | 674.8 | 592.35 | 604
 | 2008-11-06 00:00:00 | 590 | 610.9 | 552.5 | 582.7
 | 2008-11-07 00:00:00 | 580 | 599 | 547.15 | 581.6
 | 2008-11-10 00:00:00 | 594.45 | 613 | 578.3 | 608.9
 | 2008-11-11 00:00:00 | 600 | 603 | 560 | 564.05
 | 2008-11-12 00:00:00 | 559 | 569.7 | 523.15 | 525.3
 | 2008-11-14 00:00:00 | 540 | 554.4 | 487 | 492.95
 | 2008-11-17 00:00:00 | 587.2 | 587.2 | 431.3 | 456.65
 | 2008-11-18 00:00:00 | 452 | 452 | 425 | 437.75
 | 2008-11-19 00:00:00 | 425 | 464.3 | 421.1 | 427.55
 | 2008-11-20 00:00:00 | 418 | 418 | 394 | 405.45
 | 2008-11-21 00:00:00 | 419 | 422.5 | 383.6 | 411.5
 | 2008-11-24 00:00:00 | 409 | 420 | 391.85 | 397.55
 | 2008-11-25 00:00:00 | 414.8 | 418.7 | 367 | 376.55
 | 2008-11-26 00:00:00 | 379.9 | 418.2 | 362.4 | 404.45
 | 2008-11-28 00:00:00 | 382 | 416 | 352.5 | 408.5
 | 2008-12-01 00:00:00 | 412.5 | 436.7 | 408.1 | 413.05
 | 2008-12-02 00:00:00 | 408 | 434.7 | 388.25 | 429.1
 | 2008-12-03 00:00:00 | 435 | 439.9 | 422.4 | 433.7
 | 2008-12-04 00:00:00 | 439.5 | 464.8 | 433 | 455.2
 | 2008-12-05 00:00:00 | 457 | 475 | 440 | 443.05
 | 2008-12-08 00:00:00 | 460 | 468 | 448 | 451.95
 | 2008-12-10 00:00:00 | 457.4 | 466 | 438.15 | 462.8
 | 2008-12-11 00:00:00 | 465.5 | 479 | 444.4 | 457
 | 2008-12-12 00:00:00 | 449.7 | 473.4 | 435.6 | 468.8
 | 2008-12-15 00:00:00 | 478.2 | 492.4 | 475 | 486.2
 | 2008-12-16 00:00:00 | 485 | 506.3 | 478.25 | 500.8
 | 2008-12-17 00:00:00 | 504 | 520 | 492.05 | 497.6
 | 2008-12-18 00:00:00 | 495 | 543 | 495 | 537.2
 | 2008-12-19 00:00:00 | 539.7 | 562 | 531.25 | 546
 | 2008-12-22 00:00:00 | 549.7 | 556.8 | 528.55 | 537.5
 | 2008-12-23 00:00:00 | 533.1 | 542.9 | 490.75 | 499.5
 | 2008-12-24 00:00:00 | 495 | 498 | 481 | 490.75
 | 2008-12-26 00:00:00 | 491.45 | 511 | 477.25 | 482.8
 | 2008-12-29 00:00:00 | 480 | 501.8 | 468 | 494.95
 | 2008-12-30 00:00:00 | 496.5 | 519.4 | 494 | 510.25
 | 2008-12-31 00:00:00 | 519.7 | 521 | 499.6 | 504.7
 | 2009-01-01 00:00:00 | 508.5 | 522.7 | 508 | 516.85
 | 2009-01-02 00:00:00 | 522 | 547.5 | 517.3 | 541.9
 | 2009-01-05 00:00:00 | 549.5 | 564.8 | 549.5 | 560.1
 | 2009-01-06 00:00:00 | 561 | 577 | 551.4 | 569.75
 | 2009-01-07 00:00:00 | 574 | 575.4 | 515 | 522.1
 | 2009-01-09 00:00:00 | 508 | 540.3 | 475 | 486.6
 | 2009-01-12 00:00:00 | 490 | 494.8 | 445 | 451.7
 | 2009-01-13 00:00:00 | 442 | 465 | 433 | 440.3
 | 2009-01-14 00:00:00 | 450 | 456.95 | 438 | 449.4
 | 2009-01-15 00:00:00 | 430 | 438.4 | 421 | 434.05
 | 2009-01-16 00:00:00 | 448.7 | 451 | 436 | 443.55
 | 2009-01-19 00:00:00 | 448.9 | 450 | 431.55 | 438.3
 | 2009-01-20 00:00:00 | 429.7 | 429.7 | 416.6 | 422.4
 | 2009-01-21 00:00:00 | 405.55 | 428 | 404 | 407.7
 | 2009-01-22 00:00:00 | 410.5 | 421 | 403.3 | 416.05
 | 2009-01-23 00:00:00 | 410 | 418.9 | 380.1 | 384.3
 | 2009-01-27 00:00:00 | 394.95 | 404.7 | 383.25 | 394.75
 | 2009-01-28 00:00:00 | 399 | 429.5 | 397 | 422.85
 | 2009-01-29 00:00:00 | 430 | 445 | 426.1 | 435.65
 | 2009-01-30 00:00:00 | 434 | 439 | 418.65 | 433.7