Procreportdata=Prod2 Comparesumm Nowdmissing

odshtmlfile='h:\_stuff\port_prod2.html'; optionsmissing=' ';

procreportdata=prod2_comparesumm nowdmissing

style(report)=[cellspacing=5 borderwidth=3 bordercolor=CX4D7EBF]

style(header)=[color=white backgroundcolor=CX4D7EBF fontsize=2 vjust=b font_face='Arial Narrow']

style(column)=[color=black backgroundcolor=white fontsize=2]

style(lines)=[color=cx3e3d73 backgroundcolor=CX4D7EBF fontsize=3 textalign=r];

column product2 Mo1count Mo1Balance Mo1margin Mo1avgspread Mo1util Tenure1 closed percbalchgMOM

perccntchgYOY percbalchgYOY percmgnchgYOY image;

define product2 / group'Product' order order=internal /*format=$prod2sort.*/

style(column)=[cellwidth=1.5in cellheight=.15 vjust=t font_weight=bold textalign=l];

define Mo1count / group'Count'style(column)=[cellwidth=.4in cellheight=.15 vjust=t textalign=r];

define Mo1balance / grouporder=data 'Balance/ ($MM)'style(column)=[cellwidth=.45in cellheight=.15 vjust=t textalign=r];

define Mo1util / group'Utilization'style(column)=[cellwidth=.5in cellheight=.15 vjust=t textalign=r];

define Tenure1 / group'Tenure/ (Yrs)'style(column)=[cellwidth=.4in cellheight=.15 vjust=t textalign=r];

define closed / group'Hard Block/ Zero Bal/ Cnt'style(column)=[cellwidth=.5in cellheight=.15 vjust=t textalign=r];

define Mo1margin / group'Margin'style(column)=[cellwidth=.5in cellheight=.15 vjust=t textalign=r];

define Mo1avgspread / group'Avg Spread/ per mo'style(column)=[cellwidth=.5in cellheight=.15 vjust=t textalign=r];

define countchgMOM / group'MoM/ Cnt/ Chg'style(column)=[cellwidth=.4in cellheight=.15 vjust=t textalign=r];

define percbalchgMOM / group'MoM/ % Bal/ Chg'style(column)=[cellwidth=.4in cellheight=.15 vjust=t textalign=r];

define percmgnchgMOM / group'MoM/ % Mgn/ Chg'style(column)=[cellwidth=.4in cellheight=.15 vjust=t textalign=r];

define perccntchgYOY / group'YoY/ % Cnt/ Chg'style(column)=[cellwidth=.4in cellheight=.15 vjust=t textalign=r];

define percbalchgYOY / group'YoY/ % Bal/ Chg'style(column)=[cellwidth=.4in cellheight=.15 vjust=t textalign=r];

define percmgnchgYOY / group'YoY/ Mgn/ Chg'style(column)=[cellwidth=.4in cellheight=.15 vjust=t textalign=r];

define image / 'YOY Change'computedstyle(column)={width=2};

compute percbalchgMOM;

if percbalchgMOM <=0thencalldefine(_col_,"style", "style=[foreground=red]");

endcomp;

compute percmgnchgMOM;

if percmgnchgMOM <=0thencalldefine(_col_,"style", "style=[foreground=red]");

endcomp;

compute perccntchgYOY;

if perccntchgYOY >.04thencalldefine(_col_,"style", "style=[foreground=white background=limegreen font_weight=bold]");

elseif perccntchgYOY <=0thencalldefine(_col_,"style", "style=[foreground=red]");

endcomp;

compute percbalchgYOY;

if percbalchgYOY >.04thencalldefine(_col_,"style", "style=[foreground=white background=limegreen font_weight=bold]");

elseif percbalchgYOY <=0thencalldefine(_col_,"style", "style=[foreground=red]");

endcomp;

compute percmgnchgYOY;

if percmgnchgYOY >.01thencalldefine(_col_,"style", "style=[foreground=white background=limegreen font_weight=bold]");

elseif percmgnchgYOY <=0thencalldefine(_col_,"style", "style=[foreground=red]");

endcomp;

compute image;

length imageloc $90;

image=' ';

if percbalchgYOY <=-.9851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn99%.png"}'); end;

elseif percbalchgYOY <=-.9751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn98%.png"}'); end;

elseif percbalchgYOY <=-.9651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn97%.png"}'); end;

elseif percbalchgYOY <=-.9551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn96%.png"}'); end;

elseif percbalchgYOY <=-.9451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn95%.png"}'); end;

elseif percbalchgYOY <=-.9351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn94%.png"}'); end;

elseif percbalchgYOY <=-.9251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn93%.png"}'); end;

elseif percbalchgYOY <=-.9151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn92%.png"}'); end;

elseif percbalchgYOY <=-.9051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn91%.png"}'); end;

elseif percbalchgYOY <=-.8951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn90%.png"}'); end;

elseif percbalchgYOY <=-.8851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn89%.png"}'); end;

elseif percbalchgYOY <=-.8751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn88%.png"}'); end;

elseif percbalchgYOY <=-.8651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn87%.png"}'); end;

elseif percbalchgYOY <=-.8551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn86%.png"}'); end;

elseif percbalchgYOY <=-.8451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn85%.png"}'); end;

elseif percbalchgYOY <=-.8351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn84%.png"}'); end;

elseif percbalchgYOY <=-.8251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn83%.png"}'); end;

elseif percbalchgYOY <=-.8151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn82%.png"}'); end;

elseif percbalchgYOY <=-.8051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn81%.png"}'); end;

elseif percbalchgYOY <=-.7951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn80%.png"}'); end;

elseif percbalchgYOY <=-.7851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn79%.png"}'); end;

elseif percbalchgYOY <=-.7751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn78%.png"}'); end;

elseif percbalchgYOY <=-.7651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn77%.png"}'); end;

elseif percbalchgYOY <=-.7551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn76%.png"}'); end;

elseif percbalchgYOY <=-.7451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn75%.png"}'); end;

elseif percbalchgYOY <=-.7351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn74%.png"}'); end;

elseif percbalchgYOY <=-.7251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn73%.png"}'); end;

elseif percbalchgYOY <=-.7151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn72%.png"}'); end;

elseif percbalchgYOY <=-.7051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn71%.png"}'); end;

elseif percbalchgYOY <=-.6951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn70%.png"}'); end;

elseif percbalchgYOY <=-.6851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn69%.png"}'); end;

elseif percbalchgYOY <=-.6751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn68%.png"}'); end;

elseif percbalchgYOY <=-.6651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn67%.png"}'); end;

elseif percbalchgYOY <=-.6551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn66%.png"}'); end;

elseif percbalchgYOY <=-.6451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn65%.png"}'); end;

elseif percbalchgYOY <=-.6351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn64%.png"}'); end;

elseif percbalchgYOY <=-.6251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn63%.png"}'); end;

elseif percbalchgYOY <=-.6151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn62%.png"}'); end;

elseif percbalchgYOY <=-.6051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn61%.png"}'); end;

elseif percbalchgYOY <=-.5951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn60%.png"}'); end;

elseif percbalchgYOY <=-.5851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn59%.png"}'); end;

elseif percbalchgYOY <=-.5751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn58%.png"}'); end;

elseif percbalchgYOY <=-.5651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn57%.png"}'); end;

elseif percbalchgYOY <=-.5551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn56%.png"}'); end;

elseif percbalchgYOY <=-.5451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn55%.png"}'); end;

elseif percbalchgYOY <=-.5351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn54%.png"}'); end;

elseif percbalchgYOY <=-.5251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn53%.png"}'); end;

elseif percbalchgYOY <=-.5151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn52%.png"}'); end;

elseif percbalchgYOY <=-.5051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn51%.png"}'); end;

elseif percbalchgYOY <=-.4951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn50%.png"}'); end;

elseif percbalchgYOY <=-.4851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn49%.png"}'); end;

elseif percbalchgYOY <=-.4751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn48%.png"}'); end;

elseif percbalchgYOY <=-.4651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn47%.png"}'); end;

elseif percbalchgYOY <=-.4551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn46%.png"}'); end;

elseif percbalchgYOY <=-.4451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn45%.png"}'); end;

elseif percbalchgYOY <=-.4351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn44%.png"}'); end;

elseif percbalchgYOY <=-.4251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn43%.png"}'); end;

elseif percbalchgYOY <=-.4151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn42%.png"}'); end;

elseif percbalchgYOY <=-.4051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn41%.png"}'); end;

elseif percbalchgYOY <=-.3951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn40%.png"}'); end;

elseif percbalchgYOY <=-.3851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn39%.png"}'); end;

elseif percbalchgYOY <=-.3751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn38%.png"}'); end;

elseif percbalchgYOY <=-.3651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn37%.png"}'); end;

elseif percbalchgYOY <=-.3551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn36%.png"}'); end;

elseif percbalchgYOY <=-.3451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn35%.png"}'); end;

elseif percbalchgYOY <=-.3351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn34%.png"}'); end;

elseif percbalchgYOY <=-.3251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn33%.png"}'); end;

elseif percbalchgYOY <=-.3151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn32%.png"}'); end;

elseif percbalchgYOY <=-.3051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn31%.png"}'); end;

elseif percbalchgYOY <=-.2951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn30%.png"}'); end;

elseif percbalchgYOY <=-.2851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn29%.png"}'); end;

elseif percbalchgYOY <=-.2751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn28%.png"}'); end;

elseif percbalchgYOY <=-.2651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn27%.png"}'); end;

elseif percbalchgYOY <=-.2551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn26%.png"}'); end;

elseif percbalchgYOY <=-.2451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn25%.png"}'); end;

elseif percbalchgYOY <=-.2351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn24%.png"}'); end;

elseif percbalchgYOY <=-.2251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn23%.png"}'); end;

elseif percbalchgYOY <=-.2151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn22%.png"}'); end;

elseif percbalchgYOY <=-.2051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn21%.png"}'); end;

elseif percbalchgYOY <=-.1951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn20%.png"}'); end;

elseif percbalchgYOY <=-.1851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn19%.png"}'); end;

elseif percbalchgYOY <=-.1751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn18%.png"}'); end;

elseif percbalchgYOY <=-.1651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn17%.png"}'); end;

elseif percbalchgYOY <=-.1551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn16%.png"}'); end;

elseif percbalchgYOY <=-.1451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn15%.png"}'); end;

elseif percbalchgYOY <=-.1351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn14%.png"}'); end;

elseif percbalchgYOY <=-.1251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn13%.png"}'); end;

elseif percbalchgYOY <=-.1151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn12%.png"}'); end;

elseif percbalchgYOY <=-.1051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn11%.png"}'); end;

elseif percbalchgYOY <=-.09951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn10%.png"}'); end;

elseif percbalchgYOY <=-.09849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.9%.png"}'); end;

elseif percbalchgYOY <=-.09749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.8%.png"}'); end;

elseif percbalchgYOY <=-.09649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.7%.png"}'); end;

elseif percbalchgYOY <=-.09549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.6%.png"}'); end;

elseif percbalchgYOY <=-.09449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.5%.png"}'); end;

elseif percbalchgYOY <=-.09349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.4%.png"}'); end;

elseif percbalchgYOY <=-.09249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.3%.png"}'); end;

elseif percbalchgYOY <=-.09149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.2%.png"}'); end;

elseif percbalchgYOY <=-.09049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9.1%.png"}'); end;

elseif percbalchgYOY <=-.08951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn9%.png"}'); end;

elseif percbalchgYOY <=-.08849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.9%.png"}'); end;

elseif percbalchgYOY <=-.08749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.8%.png"}'); end;

elseif percbalchgYOY <=-.08649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.7%.png"}'); end;

elseif percbalchgYOY <=-.08549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.6%.png"}'); end;

elseif percbalchgYOY <=-.08449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.5%.png"}'); end;

elseif percbalchgYOY <=-.08349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.4%.png"}'); end;

elseif percbalchgYOY <=-.08249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.3%.png"}'); end;

elseif percbalchgYOY <=-.08149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.2%.png"}'); end;

elseif percbalchgYOY <=-.08049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8.1%.png"}'); end;

elseif percbalchgYOY <=-.07951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn8%.png"}'); end;

elseif percbalchgYOY <=-.07849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.9%.png"}'); end;

elseif percbalchgYOY <=-.07749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.8%.png"}'); end;

elseif percbalchgYOY <=-.07649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.7%.png"}'); end;

elseif percbalchgYOY <=-.07549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.6%.png"}'); end;

elseif percbalchgYOY <=-.07449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.5%.png"}'); end;

elseif percbalchgYOY <=-.07349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.4%.png"}'); end;

elseif percbalchgYOY <=-.07249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.3%.png"}'); end;

elseif percbalchgYOY <=-.07149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.2%.png"}'); end;

elseif percbalchgYOY <=-.07049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7.1%.png"}'); end;

elseif percbalchgYOY <=-.06949thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn7%.png"}'); end;

elseif percbalchgYOY <=-.06849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.9%.png"}'); end;

elseif percbalchgYOY <=-.06749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.8%.png"}'); end;

elseif percbalchgYOY <=-.06649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.7%.png"}'); end;

elseif percbalchgYOY <=-.06549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.6%.png"}'); end;

elseif percbalchgYOY <=-.06449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.5%.png"}'); end;

elseif percbalchgYOY <=-.06349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.4%.png"}'); end;

elseif percbalchgYOY <=-.06249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.3%.png"}'); end;

elseif percbalchgYOY <=-.06149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.2%.png"}'); end;

elseif percbalchgYOY <=-.06049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6.1%.png"}'); end;

elseif percbalchgYOY <=-.05949thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn6%.png"}'); end;

elseif percbalchgYOY <=-.05849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.9%.png"}'); end;

elseif percbalchgYOY <=-.05749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.8%.png"}'); end;

elseif percbalchgYOY <=-.05649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.7%.png"}'); end;

elseif percbalchgYOY <=-.05549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.6%.png"}'); end;

elseif percbalchgYOY <=-.05449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.5%.png"}'); end;

elseif percbalchgYOY <=-.05349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.4%.png"}'); end;

elseif percbalchgYOY <=-.05249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.3%.png"}'); end;

elseif percbalchgYOY <=-.05149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.2%.png"}'); end;

elseif percbalchgYOY <=-.05049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5.1%.png"}'); end;

elseif percbalchgYOY <=-.04949thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn5%.png"}'); end;

elseif percbalchgYOY <=-.04849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.9%.png"}'); end;

elseif percbalchgYOY <=-.04749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.8%.png"}'); end;

elseif percbalchgYOY <=-.04649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.7%.png"}'); end;

elseif percbalchgYOY <=-.04549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.6%.png"}'); end;

elseif percbalchgYOY <=-.04449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.5%.png"}'); end;

elseif percbalchgYOY <=-.04349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.4%.png"}'); end;

elseif percbalchgYOY <=-.04249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.3%.png"}'); end;

elseif percbalchgYOY <=-.04149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.2%.png"}'); end;

elseif percbalchgYOY <=-.04049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4.1%.png"}'); end;

elseif percbalchgYOY <=-.03949thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn4%.png"}'); end;

elseif percbalchgYOY <=-.03849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.9%.png"}'); end;

elseif percbalchgYOY <=-.03749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.8%.png"}'); end;

elseif percbalchgYOY <=-.03649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.7%.png"}'); end;

elseif percbalchgYOY <=-.03549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.6%.png"}'); end;

elseif percbalchgYOY <=-.03449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.5%.png"}'); end;

elseif percbalchgYOY <=-.03349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.4%.png"}'); end;

elseif percbalchgYOY <=-.03249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.3%.png"}'); end;

elseif percbalchgYOY <=-.03149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.2%.png"}'); end;

elseif percbalchgYOY <=-.03049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3.1%.png"}'); end;

elseif percbalchgYOY <=-.02949thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn3%.png"}'); end;

elseif percbalchgYOY <=-.02849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.9%.png"}'); end;

elseif percbalchgYOY <=-.02749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.8%.png"}'); end;

elseif percbalchgYOY <=-.02649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.7%.png"}'); end;

elseif percbalchgYOY <=-.02549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.6%.png"}'); end;

elseif percbalchgYOY <=-.02449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.5%.png"}'); end;

elseif percbalchgYOY <=-.02349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.4%.png"}'); end;

elseif percbalchgYOY <=-.02249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.3%.png"}'); end;

elseif percbalchgYOY <=-.02149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.2%.png"}'); end;

elseif percbalchgYOY <=-.02049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2.1%.png"}'); end;

elseif percbalchgYOY <=-.01949thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn2%.png"}'); end;

elseif percbalchgYOY <=-.01849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1.9%.png"}'); end;

elseif percbalchgYOY <=-.01749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1.8%.png"}'); end;

elseif percbalchgYOY <=-.01649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1.7%.png"}'); end;

elseif percbalchgYOY <=-.01549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1.6%.png"}'); end;

elseif percbalchgYOY <=-.01449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1.5%.png"}'); end;

elseif percbalchgYOY <=-.01349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1.4%.png"}'); end;

elseif percbalchgYOY <=-.01249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1.3%.png"}'); end;

elseif percbalchgYOY <=-.01149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1.2%.png"}'); end;

elseif percbalchgYOY <=-.00949thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn1%.png"}'); end;

elseif percbalchgYOY <=-.00849thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.9%.png"}'); end;

elseif percbalchgYOY <=-.00749thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.8%.png"}'); end;

elseif percbalchgYOY <=-.00649thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.7%.png"}'); end;

elseif percbalchgYOY <=-.00549thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.6%.png"}'); end;

elseif percbalchgYOY <=-.00449thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.5%.png"}'); end;

elseif percbalchgYOY <=-.00349thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.4%.png"}'); end;

elseif percbalchgYOY <=-.00249thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.3%.png"}'); end;

elseif percbalchgYOY <=-.00149thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.2%.png"}'); end;

elseif percbalchgYOY <=-.00049thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\rdn0.1%.png"}'); end;

elseif percbalchgYOY >=.9851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup99%.png"}'); end;

elseif percbalchgYOY >=.9751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup98%.png"}'); end;

elseif percbalchgYOY >=.9651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup97%.png"}'); end;

elseif percbalchgYOY >=.9551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup96%.png"}'); end;

elseif percbalchgYOY >=.9451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup95%.png"}'); end;

elseif percbalchgYOY >=.9351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup94%.png"}'); end;

elseif percbalchgYOY >=.9251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup93%.png"}'); end;

elseif percbalchgYOY >=.9151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup92%.png"}'); end;

elseif percbalchgYOY >=.9051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup91%.png"}'); end;

elseif percbalchgYOY >=.8951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup90%.png"}'); end;

elseif percbalchgYOY >=.8851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup89%.png"}'); end;

elseif percbalchgYOY >=.8751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup88%.png"}'); end;

elseif percbalchgYOY >=.8651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup87%.png"}'); end;

elseif percbalchgYOY >=.8551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup86%.png"}'); end;

elseif percbalchgYOY >=.8451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup85%.png"}'); end;

elseif percbalchgYOY >=.8351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup84%.png"}'); end;

elseif percbalchgYOY >=.8251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup83%.png"}'); end;

elseif percbalchgYOY >=.8151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup82%.png"}'); end;

elseif percbalchgYOY >=.8051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup81%.png"}'); end;

elseif percbalchgYOY >=.7951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup80%.png"}'); end;

elseif percbalchgYOY >=.7851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup79%.png"}'); end;

elseif percbalchgYOY >=.7751thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup78%.png"}'); end;

elseif percbalchgYOY >=.7651thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup77%.png"}'); end;

elseif percbalchgYOY >=.7551thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup76%.png"}'); end;

elseif percbalchgYOY >=.7451thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup75%.png"}'); end;

elseif percbalchgYOY >=.7351thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup74%.png"}'); end;

elseif percbalchgYOY >=.7251thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup73%.png"}'); end;

elseif percbalchgYOY >=.7151thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup72%.png"}'); end;

elseif percbalchgYOY >=.7051thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup71%.png"}'); end;

elseif percbalchgYOY >=.6951thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup70%.png"}'); end;

elseif percbalchgYOY >=.6851thendo; imageloc= catt('style={preimage="h:\_STUFF\icons\gup69%.png"}'); end;