Spreadsheet: 70422d1271176302-if-statement-to-calculate-an-average-example
Sheet: Sheet1

MAR | MAR Equity | Long | Buy | Neutral |  |  |  | 2010-03-25 00:00:00 |  | 1 |  | 0.033078 | 0.088408 |  |  | 0.01158374133243423 | 0.01262697066065498 | 0.01379329875601724 | 0.02359223825636549 | 0.0181766531221045 | 0.01866854303208614 | -0.002438435349191206 | -0.007049740770165583 | -0.009509620325306112
SHO | SHO Equity | Long | Buy | Neutral |  |  |  | 2010-03-25 00:00:00 |  | 1 |  | 0.024833 | 0.188261 |  |  | 0.03971694163768966 | 0.001053622205234222 | -0.004371673823235746 | -0.005327546663659977 | -0.008896593311179151 | -0.01238687403660102 | -0.002777142264259153 | -0.00322271027722279 | -0.03370943019143312
IGT | IGT Equity | Long | Buy | Neutral |  |  |  | 2009-08-18 00:00:00 | The firm cites valuation and expects an uptick in domestic replacement orders and potential expansion opportunities. Target remains $23 |  |  | -0.060247 | 0.03224 |  |  | 0.02112047056577013 | 0.005442626750031104 | 0.01582537114863514 | 0.03159104315676559 | 0.01775877470465515 | 0.01468119667022835 | 0.05393643227429771 | 0.05268765575417215 | 0.04835359917431033 | 0.06935667105575995 | 0.0481058817184723 | 0.07260196965293572 | 0.07933869474924304 | 0.07556731893972296 | 0.08321535012133989 | 0.08148981923493678 | 0.08824760337832574 | 0.07930659171055526 | 0.07790190519408408 | 0.02037866576856093 | 0.01885089362607933 | -0.008612584216791841 | -0.03289307450963755 | -0.03388004324849614 | -0.05551483439847166 | -0.05631227846166774 | -0.03582622897509161
[NAME] | ASCA Equity | Long | Buy | Neutral |  |  |  | 2009-06-22 00:00:00 | Target increased to $24 from $20. The firm expects a potential positive catalyst 2-Jul with 24-hour gaming in Colorado and also notes valuation, among the rationale. |  |  | -0.006037 | -0.105237 |  |  | 0.08166379421509634 | -0.04084619229541125 | 0.006665056724133641 | -0.02115640848950798 | -0.03114644227324024 | -0.03283798770886608 | -0.04265928144266962 | -0.03292203679372728 | -0.007693491399711008 | -0.02023505176580657 | -0.01341550085177092 | -0.003069054094785334 | -0.01034052292611133 | -0.01946431297743216 | -0.001824483020922556 | -0.003389558207888041 | -0.03128701663529293 | -0.01281446929497822 | 0.02799239716920396 | -0.07563263040987755 | -0.08472721020507337 | -0.109294950526572 | -0.1208598702139416 | -0.1404748923083235 | -0.1883077599188843 | -0.1713509653054488 | -0.1639524660035564
MGM | MGM Equity | Long | Buy | Neutral |  |  |  | 2009-05-18 00:00:00 |  |  |  | -0.390302 | 0.200313 |  |  | 0.06688508011691127 | -0.04149947568777963 | -0.05068678094103213 | -0.06523865161468666 | -0.07358070902442843 | -0.1831889869990116 | -0.1586499452875121 | -0.178236248307055 | -0.1643609231578396 | -0.1101838989192195 | -0.1582026398643039 | -0.1772250783516652 | -0.1794219516992536 | -0.1806738787491709 | -0.1895608607161342 | -0.2153910562648107 | -0.2215902077589557 | -0.2072668034653919 | -0.1731838642537741 | -0.1938964937782034 | -0.1767058204145522 | -0.204196503928896 | -0.2161523080070586 | -0.2332375232955544 | -0.2571665273151371 | -0.26386562980908 | -0.1848634137304004
HOT | HOT Equity | Long | Buy | Neutral |  |  |  | 2009-05-11 00:00:00 |  |  |  | 0.126531 | 0.535466 |  |  | -0.01971209988340377 | 0.003153503575772335 | 0.04457383690317851 | 0.04028551447570433 | 0.04777048990574187 | 0.05604546995069054 | 0.06521877374127161 | 0.07681444810416937 | 0.100556033937546 | 0.1247711244455839 | 0.1640926076743358 | 0.1261842373689564 | 0.1730843768573944 | 0.1922463600008607 | 0.2146323307210121 | 0.1792704950418595 | 0.170385811453528 | 0.174744701943377 | 0.1754888428210011 | 0.2103440967631642 | 0.2161394597531606 | 0.211842930216889 | 0.2092729828492013 | 0.1982343152467617 | 0.1960819202863806 | 0.1675917721505774 | 0.1928573272698228
LVS | LVS Equity | Long | Buy | Neutral |  |  |  | 2009-04-20 00:00:00 | Target for the shares is $8. The firm sees near term expectations as reasonable for LV Strip properties and says LVS is outperforming peers. Stabilization of Macau and the potential for improved investor sentiment is also noted. |  |  | 0.132883 | 1.215859 |  |  | 0.002952611285461981 | 0.05599524119549382 | 0.1503585096920492 | 0.2102570068156112 | 0.404625997668841 | 0.3738032509295375 | 0.3929214854198461 | 0.4506139564903642 | 0.4088198318778292 | 0.4623217442237513 | 0.6784430753059436 | 0.9840816372193858 | 0.7518212258242756 | 0.6578726503242946 | 0.8173112305529322 | 0.9008615792425597 | 0.8281133371992921 | 0.6414035605441103 | 0.7966441208451732 | 0.7547874194561394 | 0.8885469470670011 | 0.8340600399548458 | 0.7987386229231535 | 0.7524902564455672 | 0.6840735697120779 | 0.6912895793486454 | 0.7810710061640463
[NAME] | ASCA Equity | Long | Buy | Neutral |  |  |  | 2009-03-02 00:00:00 |  |  |  | 0.118182 | 0.119454 |  |  | 0.08315570367880001 | -0.010306410602047 | 0.01698868778299822 | 0.03648827253944333 | 0.006938605694511199 | -0.0346355271416193 | -0.02380042408586627 | 0.04454201269156306 | 0.07584302264566874 | 0.0713362198075384 | 0.07262293301609947 | 0.09577610947600629 | 0.05836945026553003 | 0.06920468304113597 | 0.05504000027259889 | 0.08611252583579015 | 0.04250574459257328 | 0.009465495886836262 | 0.01807551714985006 | 0.02747493409688595 | 0.07301736148349106 | 0.07724812476577564 | -0.02344172072769543 | 0.03359544558528033 | -0.09904112278000943 | -0.1696111391171449 | -0.05953971132938068
PENN | PENN Equity | Long | Buy | Neutral |  |  |  | 2008-08-12 00:00:00 | Price target is $39. Firm cites an attractive and fully funded developement pipeline and an advantaged balance sheet. | 1 |  | 0.08238899999999999 | 0.288517 |  |  | 0.04168046859421434 | 0.037290918344745 | 0.02396670425419001 | 0.03044550018349223 | 0.03588375100790188 | 0.04817210637402188 | 0.08712615906512028 | 0.09329147125277404 | 0.08862308759692365 | 0.07624778583439144 | 0.04755454063843552 | 0.05604599969844041 | 0.06633204987829114 | 0.07655870347208063 | 0.06532510302212687 | 0.03673595127291726 | 0.03718839182136899 | 0.04881877880031836 | 0.02018498408303077 | 0.01633085095954965 | 0.03969607033123436 | 0.04494151279955609 | 0.05093637073534308 | 0.04771375876101781 | 0.05596817333765156 | 0.09124144720926103 | 0.02457669156045882
WYNN | WYNN Equity | Long | Buy | Neutral |  |  |  | 2008-03-17 00:00:00 | Price target is $120.00. Valuation and contributions from Macau cited as rationale. |  |  | 0.041478 | -0.09990700000000001 |  |  | 0.0413620097860013 | -0.0081717930435108 | -0.005761956179102898 | -0.005966262859071494 | 0.00731466987413816 | 0.01936346242833634 | 0.03742413494841482 | 0.0232922054906107 | 0.01003441152843174 | 0.006037489466354955 | 0.06541187064343822 | 0.07062865189749984 | 0.1139626125115551 | 0.08419764815915604 | 0.09016049159589924 | 0.07730324012217422 | 0.0882300207777439 | 0.07441587325020133 | 0.04810282809295333 | 0.04470511084224146 | 0.04937104130181314 | 0.04771337337403154 | -0.000234547069275462 | 0.00168592491706978 | -0.007879856781147665 | 0.06813645567006514 | 0.1004747454771799
MGM | MGM Equity | Long | Buy | Neutral |  |  |  | 2007-05-22 00:00:00 |  |  |  | 0.012383 | -0.115374 |  |  | 0.2435587889693731 | -0.02208073024816113 | -0.02709261342062272 | -0.02787041671791164 | 0.00170387482055136 | -0.009887707849229344 | -0.01810209317111451 | -0.0373413419779185 | -0.02985059484358557 | 0.02447251550421004 | 0.01810258712543259 | 0.0265553171422873 | 0.03680314414000921 | 0.04091540954730957 | 0.04549910368048572 | 0.03740137383798049 | 0.03963725272825087 | 0.0662091054652966 | 0.07999793618964522 | 0.0791197533392422 | 0.01935620891434598 | 0.0298841020853606 | 0.035502953471798 | 0.05717798114211951 | 0.08057863448653778 | 0.07001082005200987 | 0.05223555195160319
MGM | MGM Equity | Long | Buy | Neutral |  |  |  | 2006-03-21 00:00:00 |  | 1 |  | 0.016334 | -0.012843 |  |  | 0.03624190216884883 | 0.02313952574071177 | 0.0189764355346124 | 0.008193381668686956 | 0.0206434917375969 | 0.03049597757566557 | 0.02464405721493079 | 0.01464639724481397 | 0.02261144735570259 | 0.02166068606627361 | 0.02253221434142838 | 0.03189930213013297 | 0.03639401402682579 | 0.05564048516381367 | 0.06649870984175804 | 0.06054195670090873 | 0.05882089391309288 | 0.05288240211310544 | 0.03009615579520215 | 0.03748986092216354 | 0.03963884394936119 | 0.03466999550576981 | 0.02636816662482926 | 0.01011382476514956 | 0.02774279121557363 | 0.03587885593404785 | 0.04118989636594526
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Neg | 1 | 5 | 4 | 5 | 3 | 5 | 6 | 5 | 5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 3 | 5 | 3 | 5 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pos | 11 | 7 | 8 | 7 | 9 | 7 | 6 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 9 | 8 | 8 | 7 | 5 | 7 | 5 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Average