Spreadsheet: 61921d1262819851-sumif-with-multiple-criteria-example
Sheet: Analyst Changes Database

 |  |  |  |  |  |  |  | Top Rated Analyst Changes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Closing Price on Announcement Day
 |  |  |  |  |  |  |  | BEST_ANALYST_RECS_BULK | [NAME] | Rating |  |  | Price Target |  | Last Report Date |  |  |  | Yesterdays Rating | Yesterdays Last Report Date | Yesterdays Price Target | Institutional Investor | [NAME] | WSJ | Rating Change | New Report Released | Price Target Change | Any Analyst Activity | Day of Announcment | Outperform/Underperform ETF % | Rating Change | Price Target Change | Analyst Rating
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 1 | RTN | [NAME] | [NAME] | neutral | 3 | D | 56 | 12 month | 2009-12-09 00:00:00 |  |  | [NAME] | outperform | 2009-10-23 00:00:00 | 58 | #N/A | #N/A | #N/A | 1 | 1 | 1 | 1 | 2009-12-09 00:00:00 | -0.05944105162855143 | Downgraded | Lowered | ii1-2x
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 2
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 3
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RTN US Equity
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | PX_LAST
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2009-12-09 00:00:00 | 2009-12-10 00:00:00 | 2009-12-11 00:00:00 | 2009-12-14 00:00:00 | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-17 00:00:00 | 2009-12-18 00:00:00 | 2009-12-21 00:00:00 | 2009-12-22 00:00:00 | 2009-12-23 00:00:00 | 2009-12-24 00:00:00 | 2009-12-28 00:00:00 | 2009-12-29 00:00:00 | 2009-12-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.36 | 51.8 | 52.23 | 52.74 | 53.44 | 53.34 | 53.02 | 52.52 | 52.45 | 52.96 | 52.55 | 52 | 52.25 | 52.79 | 52.72 | 52.18 | 51.52 | 52.21 | 51.45
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Return from closing price of ann. day |  |  |  |  |  | -0.01069518716577544 | 0.008301158301158296 | 0.01814671814671824 | 0.03166023166023167 | 0.02972972972972985 | 0.02355212355212367 | 0.01389961389961402 | 0.01254826254826266 | 0.02239382239382246 | 0.01447876447876448 | 0.003861003861003916 | 0.008687258687258743 | 0.01911196911196915 | 0.01776061776061779 | 0.007335907335907385 | -0.00540540540540529 | 0.007915057915057987 | -0.006756756756756647
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean [NAME] % |  |  |  |  |  |  | -0.002394028864617148 | 0.007451530980942797 | 0.02096504449445623 | 0.01903454256395441 | 0.01285693638634822 | 0.003204426733838571 | 0.001853075382487215 | 0.01169863522804702 | 0.003783577312989036 | -0.006834183304771528 | -0.002007928478516701 | 0.008416781946193708 | 0.00706543059484235 | -0.003359279829868059 | -0.01610059257118074 | -0.002780129250717456 | -0.01745194392253209
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean Revert $ |  |  |  |  |  | -0.5600000000000023 | -0.1300000000000026 | 0.3800000000000026 | 1.079999999999998 | 0.980000000000004 | 0.6600000000000037 | 0.1600000000000037 | 0.09000000000000341 | 0.6000000000000014 | 0.1899999999999977 | -0.3599999999999994 | -0.1099999999999994 | 0.4299999999999997 | 0.3599999999999994 | -0.1799999999999997 | -0.8399999999999963 | -0.1499999999999986 | -0.9099999999999966
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outperform/Underperform ETF |  |  |  |  |  |  | 0.008902119839619856 | 0.002321397633897746 | 0.001411834224334278 | 0.001284216909216998 | -0.006896594396594201 | -0.00473019379269367 | -0.004879622067121905 | -0.008054895554895403 | -0.02207972911097902 | -0.02798995767745754 | -0.02536722849222835 | -0.01514283858033856 | -0.01789643352143351 | -0.02852146445896439 | -0.02623873873873861 | -0.03875962157212147 | -0.05944105162855143
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 12
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ITA US Equity
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | PX_LAST
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2009-12-09 00:00:00 | 2009-12-10 00:00:00 | 2009-12-11 00:00:00 | 2009-12-14 00:00:00 | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-17 00:00:00 | 2009-12-18 00:00:00 | 2009-12-21 00:00:00 | 2009-12-22 00:00:00 | 2009-12-23 00:00:00 | 2009-12-24 00:00:00 | 2009-12-28 00:00:00 | 2009-12-29 00:00:00 | 2009-12-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50.25 | 49.92 | 49.89 | 50.71 | 51.43 | 51.34 | 51.44 | 50.85 | 50.79 | 51.44 | 51.745 | 51.51 | 51.62 | 51.63 | 51.7 | 51.71 | 50.96 | 52.25 | 52.55
-0.05944105162855143 | RTN | 2009-12-09 00:00:00 | Downgraded | Lowered | ii1-2x | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Return from closing price of ann. day |  |  |  |  |  | -0.006567164179104443 | -0.0006009615384615613 | 0.01582532051282049 | 0.03024839743589739 | 0.02844551282051285 | 0.03044871794871787 | 0.01862980769230769 | 0.01742788461538456 | 0.03044871794871787 | 0.0365584935897435 | 0.03185096153846146 | 0.03405448717948709 | 0.03425480769230771 | 0.0356570512820513 | 0.03585737179487178 | 0.02083333333333331 | 0.04667467948717945 | 0.05268429487179478
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 1 | TWC | Goldman Sachs | JASON ARMSTRONG | neutral/neutral | 3 | M | 45 | 12 month | 2009-12-14 00:00:00 |  |  | TWCGoldman SachsJASON ARMSTRONG | neutral/cautious | 2009-11-05 00:00:00 | 41 | - | - | 3 | 1 | 1 | 1 | 1 | 2009-12-15 00:00:00 | -0.06085295948930182 | Upgraded | Increased | ii1-3x
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 2
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 3
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TWC US Equity
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | PX_LAST
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-17 00:00:00 | 2009-12-18 00:00:00 | 2009-12-21 00:00:00 | 2009-12-22 00:00:00 | 2009-12-23 00:00:00 | 2009-12-24 00:00:00 | 2009-12-28 00:00:00 | 2009-12-29 00:00:00 | 2009-12-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.93 | 43.06 | 43.5 | 42.66 | 42.14 | 42.41 | 41.92 | 41.42 | 41.84 | 41.69 | 42.43 | 41.83 | 41.39 | 42.29 | 42.04
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Return from closing price of ann. day |  |  |  |  |  | 0.003028185418122585 | 0.01021830004644676 | -0.009289363678588148 | -0.02136553646075248 | -0.01509521597770566 | -0.02647468648397586 | -0.03808639108221088 | -0.02833255921969342 | -0.03181607059916406 | -0.01463074779377618 | -0.02856479331165824 | -0.03878309335810501 | -0.017882025081282 | -0.02368787738039951
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean [NAME] % |  |  |  |  |  |  | 0.01324648546456935 | -0.006261178260465563 | -0.01833735104262989 | -0.01206703055958307 | -0.02344650106585328 | -0.03505820566408829 | -0.02530437380157084 | -0.02878788518104148 | -0.0116025623756536 | -0.02553660789353566 | -0.03575490793998242 | -0.01485383966315942 | -0.02065969196227693
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean Revert $ |  |  |  |  |  | 0.1300000000000026 | 0.5700000000000003 | -0.2700000000000031 | -0.7899999999999991 | -0.5200000000000031 | -1.009999999999998 | -1.509999999999998 | -1.089999999999996 | -1.240000000000002 | -0.5 | -1.100000000000001 | -1.539999999999999 | -0.6400000000000006 | -0.8900000000000006
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outperform/Underperform ETF |  |  |  |  |  |  | 0.002439561930630009 | -0.002374929797862126 | -0.01099388563966337 | -0.01595952021279639 | -0.02561038224888513 | -0.04586512919802763 | -0.040432818510964 | -0.04305202565534375 | -0.02759531132013749 | -0.03980074836783793 | -0.0448332230037403 | -0.04121823942873227 | -0.06085295948930182
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 12
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PBS US Equity
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | PX_LAST
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-17 00:00:00 | 2009-12-18 00:00:00 | 2009-12-21 00:00:00 | 2009-12-22 00:00:00 | 2009-12-23 00:00:00 | 2009-12-24 00:00:00 | 2009-12-28 00:00:00 | 2009-12-29 00:00:00 | 2009-12-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.56 | 11.57 | 11.66 | 11.49 | 11.45 | 11.58 | 11.56 | 11.66 | 11.71 | 11.7 | 11.72 | 11.7 | 11.64 | 11.84 | 12
-0.06085295948930182 | TWC | 2009-12-15 00:00:00 | Upgraded | Increased | ii1-3x | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Return from closing price of ann. day |  |  |  |  |  | 0.0008650519031141683 | 0.007778738115816755 | -0.006914433880726022 | -0.01037165082108911 | 0.0008643042350907335 | -0.0008643042350907335 | 0.007778738115816755 | 0.01210025929127058 | 0.01123595505617969 | 0.01296456352636131 | 0.01123595505617969 | 0.006050129645635288 | 0.02333621434745026 | 0.03716508210890231
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 1 | WYNN | UBS | [NAME] | Buy | 5 | U | 76 | 12 month | 2010-01-04 00:00:00 |  |  | [NAME] PANJABI | neutral | 2009-12-04 00:00:00 | 76 | ii1-8x |  | - |  | 1 | 1 | 1 | 2010-01-04 00:00:00 | 0.05 | Upgraded | Unchanged | ii1-8x
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 2
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 3
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WYNN US Equity
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | PX_LAST
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2010-01-04 00:00:00
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.85 | 37.09
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Return from closing price of ann. day |  |  |  |  |  | 0.006512890094979701
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean [NAME] %
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean Revert $ |  |  |  |  |  | 0.240000000000002
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outperform/Underperform ETF
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 12
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BJK US Equity
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | PX_LAST
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2010-01-05 00:00:00
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56.15 | 56.48
0.05 | WYNN | 2010-01-04 00:00:00 | Upgraded | Unchanged | ii1-8x | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Return from closing price of ann. day |  |  |  |  |  | 0.005877114870881537