Spreadsheet: 54050d1254064813-excel-2007-charting-for-stocks-combined-portfolio-back-up-2-for-charting-2
Sheet: RIO

10-day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. of SDs in each return |  |  |  | Sorted in ascending order
SMA | SD | 2XSD | Date | Open | High | Low | Close | Upper | Middle | Lower |  |  |  |  |  |  |  |  |  |  |  |  | O2O SD | C2C SD | O2C SD | Date | O2O SD | C2C SD | O2C SD |  | Using TRANSPOSE * FREQUENCY (Alternative method)
#N/A |  |  | 2009-07-01 00:00:00 | 51.09 | 51.84 | 50.66 | 51.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01883424529108634 | 0.008802226946473998 | 0 |  | O2O | -3 | -2 | -1 | 0 | +1 | +2 | +3 |  | Total
#N/A |  |  | 2009-07-02 00:00:00 | 52.69 | 52.7 | 51.75 | 51.75 |  |  |  | Required chart>>>>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04031252368704349 | 0.02411937664659253 | 0.06444300707683763 |  | O2O
#N/A |  |  | 2009-07-03 00:00:00 | 49.4 | 50.01 | 49.05 | 49.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0419753004340612 | 0.0303793262418133 | 0.09325541921270417 |  | O2O |  | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
#N/A |  |  | 2009-07-06 00:00:00 | 49 | 49.23 | 48.37 | 48.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.08904016030168507 | 0.0304737480491793 | 0.09622550955487678
#N/A |  |  | 2009-07-07 00:00:00 | 46.99 | 47.53 | 46.81 | 47.35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.08965549624689739 | 0.05337219265567727 | 0.1030437474398916 |  | C2C | -3 | -2 | -1 | 0 | +1 | +2 | +3
#N/A |  |  | 2009-07-08 00:00:00 | 46.64 | 48.2 | 46.44 | 48.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1352277818551473 | 0.06788564439797237 | 0.1228088834938153 |  | C2C
#N/A |  |  | 2009-07-09 00:00:00 | 47.47 | 47.81 | 46.93 | 47.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1522956810648927 | 0.08203858976716236 | 0.1303779898231953 |  | C2C |  | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
#N/A |  |  | 2009-07-10 00:00:00 | 48.11 | 48.5 | 47.85 | 48.36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.172637727628821 | 0.1169109058835877 | 0.134608622867428
#N/A |  |  | 2009-07-13 00:00:00 | 47.64 | 47.64 | 46.4 | 46.63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2283160585866718 | 0.1353547578400859 | 0.1872052013878966 |  | O2C | -3 | -2 | -1 | 0 | +1 | +2 | +3
 |  |  | 2009-07-14 00:00:00 | 47.91 | 49.1 | 47.53 | 49.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2409533501094564 | 0.2047557254470837 | 0.1886040096593803 |  | O2C
 |  |  | 2009-07-15 00:00:00 | 49.95 | 50.26 | 49.52 | 50.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2442661540479891 | 0.2689062732154361 | 0.2033034751420174 |  | O2C |  | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 |  |  | 2009-07-16 00:00:00 | 52.58 | 52.69 | 51.84 | 52.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2561704861398346 | 0.3361095537123575 | 0.212643097535579
 |  |  | 2009-07-17 00:00:00 | 52.55 | 52.59 | 51.72 | 52.48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2763751014260536 | 0.3763092670424315 | 0.2152995381554348
 |  |  | 2009-07-20 00:00:00 | 53.2 | 54.05 | 53.17 | 53.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3063551490388773 | 0.3887590766558489 | 0.2371923228852048
 |  |  | 2009-07-21 00:00:00 | 55 | 55.68 | 54.7 | 54.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3143024924897153 | 0.4130709114961967 | 0.2672013416164569
 |  |  | 2009-07-22 00:00:00 | 55.2 | 55.89 | 54.61 | 55.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3284494162711322 | 0.4190053983515127 | 0.3112679458282762
 |  |  | 2009-07-23 00:00:00 | 55.8 | 57.49 | 55.55 | 57.49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3610044910858957 | 0.4819829616620527 | 0.3399948337501081
 |  |  | 2009-07-24 00:00:00 | 58.91 | 58.98 | 57.5 | 57.55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3956672984267452 | 0.4895614468487816 | 0.3966258559580723
 |  |  | 2009-07-27 00:00:00 | 58.5 | 59.87 | 58.4 | 59.74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4109137427101537 | 0.5315786280100793 | 0.4020575495092402
 |  |  | 2009-07-28 00:00:00 | 59.4 | 60.2 | 58.84 | 59.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0.4329190845182288 | 0.544926030024034 | 0.4044102778476841
 |  |  | 2009-07-29 00:00:00 | 57.91 | 58.42 | 57.49 | 58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4510675937090068 | 0.5653234888686123 | 0.43468932990113
 |  |  | 2009-07-30 00:00:00 | 57.15 | 58.53 | 56.97 | 58.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4549139104381129 | 0.6085921287515645 | 0.4714367794791389
 |  |  | 2009-07-31 00:00:00 | 60.12 | 60.4 | 59.41 | 60.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4549139104381129 | 0.6174334247102777 | 0.5336253060661034
 |  |  | 2009-08-03 00:00:00 | 60.5 | 60.55 | 59.85 | 60.29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4960674639244324 | 0.6828142912542057 | 0.5901114455964162
 |  |  | 2009-08-04 00:00:00 | 62.75 | 64.4 | 62.75 | 62.88 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5000730750218781 | 0.7001616613681827 | 0.5930975101831815
 |  |  | 2009-08-05 00:00:00 | 62.88 | 63 | 60.75 | 60.77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5300076074702695 | 0.7055932054740408 | 0.6749548140621996
 |  |  | 2009-08-06 00:00:00 | 61.5 | 62.54 | 61.42 | 61.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5812326177260322 | 0.7275087325741897 | 0.7578622225034901
 |  |  | 2009-08-07 00:00:00 | 60.4 | 60.85 | 60.2 | 60.57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6401273997116642 | 0.7716347367468153 | 0.7999047331236212
 |  |  | 2009-08-10 00:00:00 | 59.65 | 60.15 | 58.45 | 58.55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7076845097461799 | 0.7761474167611704 | 0.844330636843394
 |  |  | 2009-08-11 00:00:00 | 57.1 | 58 | 56.5 | 57.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7792325016948303 | 0.87827972995418 | 0.9032896567513085
 |  |  | 2009-08-12 00:00:00 | 56.98 | 58.23 | 56.8 | 58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8053985555851947 | 0.9302095238480432 | 0.9592412234378423
 |  |  | 2009-08-13 00:00:00 | 58.45 | 58.94 | 57.84 | 58.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8922290969376935 | 0.9641326703660675 | 0.974438475412751
 |  |  | 2009-08-14 00:00:00 | 60.17 | 61.24 | 59.28 | 59.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9511021993514743 | 0.9819010427812173 | 1.015197443830819
 |  |  | 2009-08-17 00:00:00 | 58.98 | 59.49 | 57.01 | 57.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.029498134045672 | 1.081772117431145 | 1.048637549467462
 |  |  | 2009-08-18 00:00:00 | 56.4 | 57.8 | 56.02 | 56.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.133997764858003 | 1.088308443921566 | 1.157895334819246
 |  |  | 2009-08-19 00:00:00 | 58.6 | 58.87 | 57.7 | 58.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.190584575711594 | 1.158618965460752 | 1.202267759349661
 |  |  | 2009-08-20 00:00:00 | 58.9 | 58.9 | 57.39 | 58.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.301697876083038 | 1.182348920032881 | 1.307223429775836
 |  |  | 2009-08-21 00:00:00 | 58 | 58 | 56.22 | 56.31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.301849948469737 | 1.230960082637362 | 1.360618489247981
 |  |  | 2009-08-24 00:00:00 | 58.5 | 59.38 | 58.14 | 58.98 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.355542673779873 | 1.337885483847082 | 1.46209089311292
 |  |  | 2009-08-25 00:00:00 | 59.4 | 59.4 | 58.2 | 58.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.386507068606812 | 1.341658482865525 | 1.644117767493359
 |  |  | 2009-08-26 00:00:00 | 58.5 | 59.37 | 58.45 | 58.94 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.594239555313648 | 1.444643938658408 | 1.663924663812248
 |  |  | 2009-08-27 00:00:00 | 57.97 | 57.97 | 56.95 | 57.16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.615545879148699 | 1.479213143526908 | 1.796496257151735
 |  |  | 2009-08-28 00:00:00 | 57.98 | 58.1 | 57.02 | 57.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.71153162817393 | 1.551849386645602 | 1.839887672624913
 |  |  | 2009-08-31 00:00:00 | 57.6 | 57.96 | 56.11 | 56.11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.968785994158866 | 1.655326651431055 | 1.890060949241834
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Difference