create Email with multiple HTML blocks embedded
kevind0718 at gmail.com
kevind0718 at gmail.com
Wed Jan 6 13:29:19 EST 2016
On Tuesday, January 5, 2016 at 10:27:30 AM UTC-5, kevin... at gmail.com wrote:
> The below script will send an email with one HTML file embedded and the second attached. Not really what I need. I need a Python script to create an email that contains multiple blocks of HTML in the body of the email.
>
> There is a process that will create at least one HTML file but very often two. A summary and an exception web pages. These need to be emailed to a user group.
>
> The code below displays one file in the email, but the other shows up as an attachment. If I reverse the body.attach statements then the files switch. I need both to appear in the body of the email.
>
> I messed around with the boundary attribute, but could not get that to work.
>
> Your kind assistance is requested.
>
> Best Regards
>
> KD
>
>
> import smtplib
> from pprint import pprint
> from email.mime.multipart import MIMEMultipart
> from email.mime.text import MIMEText
>
> msg = MIMEMultipart()
> msg['Subject'] = 'email from Python with HTML content '
> msg['From'] = 'kduf at xxx.com'
> msg['To'] = 'kduf at xxx.com'
>
> text = "\nBelow I hope will be the Summary Table in HTML\n\n"
> body = MIMEMultipart('multipart')
>
> with open("H:\\dev\\testHTML\\Exceptions_SheetDec30d.htm", "r") as fE:
> htmlE = fE.read().replace('\n', '')
>
>
> with open("H:\\dev\\testHTML\\Summary_SheetDec30d.htm", "r") as f:
> html = f.read().replace('\n', '')
>
> body.attach(MIMEText(html, 'html'))
> body.attach(MIMEText(htmlE, 'html'))
>
> msg.attach(body)
>
> s = smtplib.SMTP('smtp.aigfpc.com') # ('localhost')
> s.sendmail('kduf at xxx.com', ['kduf at xxx.com'], msg.as_string())
> s.quit()
Thomas:
Following your suggestions, I now have code that looks like the below.
I get the same result. First HTML is displayed in body of email and
second shows up as an attachment.
A dump of the email message is also below.
Maybe this would help.
Thanks for your kind assistance
KD
'''
'''
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from pprint import pprint
##msg = MIMEText("Hello KBD:\n\n" + "this is the query: select * from TSR.TSR_SRC \n\n" + rslt )
msg = MIMEMultipart()
msg['Subject'] = 'email from Python with HTML content file name: wbOut\Summary_SheetOnly_Out'
msg['From'] = 'kdff at xxx.com'
msg['To'] = 'kduf at xxx.com'
text = "\nBelow I hope will be the Summary Table in HTML\n\n"
## body = MIMEMultipart('multipart' )
## summary_html.tmp.html
## with open ("H:\\dev\\wbOut\\Summary_SheetOnly_Out.htm", "r") as f:
## with open ("H:\\dev\\wbOut\\TSR_DQ_Summary_Dec30.HTML_Out.htm" , "r") as f:
with open ("H:\\dev\\testHTML\\Exceptions_SheetDec30d.htm", "r") as fE:
htmlE = fE.read() ##.replace('\n', '')
with open ("H:\\dev\\testHTML\\Summary_SheetDec30d.htm", "r") as f:
##with open ("H:\\dev\\wbOutwbHTML.htm", "r") as f:
html = f.read() ##.replace('\n', '')
msg.attach( MIMEText(htmlE, 'html') )
msg.attach( MIMEText(html, 'html') )
print(msg)
# Send the message via our own SMTP server, but don't include the
# envelope header.
s = smtplib.SMTP('smtp.xxxfpc.com') ## ('localhost')
##s.sendmail('kduf at xxx.com', ['kduf at xxx.com'], msg.as_string() )
s.sendmail('kduf at xxx.com', ['kduf at xxx.com'], msg.as_string() )
s.quit()
## body.attach( MIMEText(html, 'html') )
## body.attach( MIMEText(htmlE, 'html') )
##body.attach( MIMEText(html, 'html; charset=utf-8 ') )
## msg.attach(body )
##msg.attach(htmlPart)
pydev debugger: starting (pid: 7516)
>From nobody Wed Jan 06 13:16:01 2016
Content-Type: multipart/mixed; boundary="===============0399484825=="
MIME-Version: 1.0
Subject: email from Python with HTML content file name:
wbOut\Summary_SheetOnly_Out
From: kduff at xxx.com
To: kduff at xxx.com
--===============0399484825==
Content-Type: text/html; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
<html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x="urn:schemas-microsoft-com:office:excel"xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><meta name=ProgId content=Excel.Sheet><meta name=Generator content="Microsoft Excel 15"><link rel=File-List href="Exceptions_SheetDec30d_files/filelist.xml"><style id="TSR_DQ_AsAt_30-Dec-2015_16321_Styles"><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}.xl1516321 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6316321 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:14.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6416321 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:Fixed; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6516321 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:14.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}--></style></head><body><!--[if !excel]> <![endif]--><!--The following information was generated by Microsoft Excel's Publish as WebPage wizard.--><!--If the same item is republished from Excel, all information between the DIVtags will be replaced.--><!-----------------------------><!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --><!-----------------------------><div id="TSR_DQ_AsAt_30-Dec-2015_16321" align=center x:publishsource="Excel"><table border=0 cellpadding=0 cellspacing=0 width=651 style='border-collapse: collapse;table-layout:fixed;width:489pt'> <col width=111 style='mso-width-source:userset;mso-width-alt:4059;width:83pt'> <col width=234 style='mso-width-source:userset;mso-width-alt:8557;width:176pt'> <col width=114 style='mso-width-source:userset;mso-width-alt:4169;width:86pt'> <col width=64 span=3 style='width:48pt'> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 width=111 style='height:15.0pt;width:83pt'></td> <td class=xl1516321 width=234 style='width:176pt'></td> <td class=xl1516321 width=114 style='width:86pt'></td> <td class=xl1516321 width=64 style='width:48pt'></td> <td class=xl1516321 width=64 style='width:48pt'></td> <td class=xl1516321 width=64 style='width:48pt'></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=25 style='height:18.75pt'> <td height=25 class=xl6316321 style='height:18.75pt'>Exception</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=25 style='height:18.75pt'> <td height=25 class=xl6516321 style='height:18.75pt'>As At:</td> <td class=xl6316321>30-Dec-2015</td> <td class=xl6316321></td> <td class=xl6316321>As Of:<span style='mso-spacerun:yes'> </span></td> <td class=xl6316321 colspan=2>29-Dec-2015</td> </tr> <tr height=25 style='height:18.75pt'> <td height=25 class=xl6516321 style='height:18.75pt'></td> <td class=xl6316321></td> <td class=xl6316321></td> <td class=xl6316321></td> <td class=xl6316321></td> <td class=xl1516321></td> </tr> <tr height=25 style='height:18.75pt'> <td height=25 class=xl1516321 style='height:18.75pt'></td> <td class=xl6316321><a name="RANGE!B6">There are Exceptions</a></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'><span style='mso-spacerun:yes'> </span></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=25 style='height:18.75pt'> <td height=25 class=xl6316321 style='height:18.75pt'>Sheet</td> <td class=xl6316321>Break Point / Exception</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'>PX_Last</td> <td class=xl1516321>Percent Change Break Point</td> <td class=xl1516321 align=center>FALSE</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'>PX_Last</td> <td class=xl1516321>Dropped - Added</td> <td class=xl1516321 align=center style='background:#FF5050;mso-pattern:black none'>TRUE</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'>PX_LAST Stale</td> <td class=xl1516321>PX_Last Stale Count</td> <td class=xl1516321 align=center style='background:#FF5050;mso-pattern:black none'>TRUE</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'>MarkIt Spread</td> <td class=xl1516321>Percent Change Break Point</td> <td class=xl6416321 align=center>FALSE</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'>MarkIt Spread</td> <td class=xl1516321>Dropped - Added</td> <td class=xl1516321 align=center style='background:#FF5050;mso-pattern:black none'>TRUE</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'>ARM Rate Match</td> <td class=xl1516321>ARM Rate Match Count</td> <td class=xl1516321 align=center style='background:#FF5050;mso-pattern:black none'>TRUE</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'>************</td> <td class=xl1516321>******************************</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516321 style='height:15.0pt'>************</td> <td class=xl1516321>******************************</td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> <td class=xl1516321></td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=111 style='width:83pt'></td> <td width=234 style='width:176pt'></td> <td width=114 style='width:86pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> </tr> <![endif]></table></div><!-----------------------------><!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD--><!-----------------------------></body></html>
--===============0399484825==
Content-Type: text/html; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
<html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x="urn:schemas-microsoft-com:office:excel"xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><meta name=ProgId content=Excel.Sheet><meta name=Generator content="Microsoft Excel 15"><link rel=File-List href="Summary_SheetDec30d_files/filelist.xml"><style id="TSR_DQ_AsAt_30-Dec-2015_16170_Styles"><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}.xl1516170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6316170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:14.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6416170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:0; text-align:general; vertical-align:bottom; border:.5pt solid windowtext; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6516170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6616170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:left; vertical-align:bottom; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6716170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:.5pt solid windowtext; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6816170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:"\@"; text-align:general; vertical-align:bottom; border:.5pt solid windowtext; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl6916170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:"Short Date"; text-align:general; vertical-align:bottom; border:.5pt solid windowtext; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl7016170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:Percent; text-align:general; vertical-align:bottom; border:.5pt solid windowtext; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl7116170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:"\@"; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl7216170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:"m\/d\/yyyy\;\@"; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl7316170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:Percent; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;}.xl7416170 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:normal;}--></style></head><body><!--[if !excel]> <![endif]--><!--The following information was generated by Microsoft Excel's Publish as WebPage wizard.--><!--If the same item is republished from Excel, all information between the DIVtags will be replaced.--><!-----------------------------><!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --><!-----------------------------><div id="TSR_DQ_AsAt_30-Dec-2015_16170" align=center x:publishsource="Excel"><table border=0 cellpadding=0 cellspacing=0 width=986 style='border-collapse: collapse;table-layout:fixed;width:741pt'> <col width=64 style='width:48pt'> <col width=86 style='mso-width-source:userset;mso-width-alt:3145;width:65pt'> <col width=64 style='width:48pt'> <col width=118 style='mso-width-source:userset;mso-width-alt:4315;width:89pt'> <col width=133 style='mso-width-source:userset;mso-width-alt:4864;width:100pt'> <col width=84 style='mso-width-source:userset;mso-width-alt:3072;width:63pt'> <col width=83 style='mso-width-source:userset;mso-width-alt:3035;width:62pt'> <col width=126 style='mso-width-source:userset;mso-width-alt:4608;width:95pt'> <col width=100 style='mso-width-source:userset;mso-width-alt:3657;width:75pt'> <col width=64 span=2 style='width:48pt'> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 width=64 style='height:15.0pt;width:48pt'></td> <td class=xl1516170 width=86 style='width:65pt'></td> <td class=xl1516170 width=64 style='width:48pt'></td> <td class=xl1516170 width=118 style='width:89pt'></td> <td class=xl1516170 width=133 style='width:100pt'></td> <td class=xl1516170 width=84 style='width:63pt'></td> <td class=xl1516170 width=83 style='width:62pt'></td> <td class=xl1516170 width=126 style='width:95pt'></td> <td class=xl1516170 width=100 style='width:75pt'></td> <td class=xl1516170 width=64 style='width:48pt'></td> <td class=xl1516170 width=64 style='width:48pt'></td> </tr> <tr height=25 style='height:18.75pt'> <td height=25 class=xl1516170 style='height:18.75pt'></td> <td class=xl6516170>Summary</td> <td class=xl1516170></td> <td class=xl6516170>As At:</td> <td class=xl1516170>30-Dec-2015</td> <td class=xl1516170></td> <td class=xl1516170>As Of:<span style='mso-spacerun:yes'> </span></td> <td class=xl1516170>29-Dec-2015</td> <td class=xl6316170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td colspan=6 class=xl6616170>PX_LAST<span style='mso-spacerun:yes'> </span>Day - Over - Day Count Compare</td> <td class=xl6616170> </td> <td rowspan=2 class=xl7416170 width=100 style='width:75pt'>Percent Change Break Point</td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='mso-height-source:userset;height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6716170 style='border-top:none'>SOURCE_CD</td> <td class=xl6716170 style='border-top:none;border-left:none'>FIELD</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PCT_CHANGE</td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6816170 style='border-top:none'>BBG</td> <td class=xl6816170 style='border-top:none;border-left:none'>PX_LAST</td> <td class=xl6916170 align=right style='border-top:none;border-left:none'>12/29/2015</td> <td class=xl6416170 align=right style='border-top:none;border-left:none'>8349</td> <td class=xl6916170 align=right style='border-top:none;border-left:none'>12/28/2015</td> <td class=xl6416170 align=right style='border-top:none;border-left:none'>8358</td> <td class=xl7016170 align=right style='border-top:none;border-left:none'>-11.00%</td> <td class=xl6416170 align=right style='border-left:none'>10</td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td colspan=6 class=xl6616170>PX_LAST<span style='mso-spacerun:yes'> </span>Week - Over - Week Count Compare</td> <td class=xl6616170> </td> <td rowspan=2 class=xl7416170 width=100 style='width:75pt'>Percent Change Break Point</td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6716170 style='border-top:none'>SOURCE_CD</td> <td class=xl6716170 style='border-top:none;border-left:none'>FIELD</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PCT_CHANGE</td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6816170 style='border-top:none'>BBG</td> <td class=xl6816170 style='border-top:none;border-left:none'>PX_LAST</td> <td class=xl6916170 align=right style='border-top:none;border-left:none'>12/29/2015</td> <td class=xl6416170 align=right style='border-top:none;border-left:none'>8349</td> <td class=xl6916170 align=right style='border-top:none;border-left:none'>12/22/2015</td> <td class=xl6416170 align=right style='border-top:none;border-left:none'>8376</td> <td class=xl7016170 align=right style='border-top:none;border-left:none'>-32.00%</td> <td class=xl6416170 align=right style='border-left:none'>10</td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td colspan=6 class=xl6616170>MarkIt Spread<span style='mso-spacerun:yes'> </span>Day - Over - Day Count Compare</td> <td class=xl6616170> </td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6716170 style='border-top:none'>SOURCE_CD</td> <td class=xl6716170 style='border-top:none;border-left:none'>FIELD</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PCT_CHANGE</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6816170 style='border-top:none'>MARKIT</td> <td class=xl6816170 style='border-top:none;border-left:none'>SPREAD</td> <td class=xl6916170 align=right style='border-top:none;border-left:none'>12/29/2015</td> <td class=xl6416170 align=right style='border-top:none;border-left:none'>2204</td> <td class=xl6916170 align=right style='border-top:none;border-left:none'>12/28/2015</td> <td class=xl6416170 align=right style='border-top:none;border-left:none'>2197</td> <td class=xl7016170 align=right style='border-top:none;border-left:none'>32.00%</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td colspan=6 class=xl6616170>MarkIt Spread<span style='mso-spacerun:yes'> </span>Week - Over - Week Count Compare</td> <td class=xl6616170> </td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6716170 style='border-top:none'>SOURCE_CD</td> <td class=xl6716170 style='border-top:none;border-left:none'>FIELD</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PCT_CHANGE</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6816170 style='border-top:none'>MARKIT</td> <td class=xl6816170 style='border-top:none;border-left:none'>SPREAD</td> <td class=xl6916170 align=right style='border-top:none;border-left:none'>12/29/2015</td> <td class=xl6416170 align=right style='border-top:none;border-left:none'>2204</td> <td class=xl6916170 align=right style='border-top:none;border-left:none'>12/22/2015</td> <td class=xl6416170 align=right style='border-top:none;border-left:none'>2217</td> <td class=xl7016170 align=right style='border-top:none;border-left:none'>-59.00%</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td colspan=6 class=xl6616170>PX_YEILD<span style='mso-spacerun:yes'> </span>Day - Over - Day Count Compare</td> <td class=xl6616170> </td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6716170 style='border-top:none'>SOURCE_CD</td> <td class=xl6716170 style='border-top:none;border-left:none'>FIELD</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PCT_CHANGE</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl7116170>RM</td> <td class=xl7116170>PX_YIELD</td> <td class=xl7216170 align=right>12/29/2015</td> <td class=xl7116170>4030</td> <td class=xl7216170 align=right>12/28/2015</td> <td class=xl7116170>4030</td> <td class=xl7316170 align=right>0.00%</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td colspan=6 class=xl6616170>PX_YIELD<span style='mso-spacerun:yes'> </span>Week - Over - Week Count Compare</td> <td class=xl6616170> </td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl6716170 style='border-top:none'>SOURCE_CD</td> <td class=xl6716170 style='border-top:none;border-left:none'>FIELD</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>CURRENT_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_DATE</td> <td class=xl6716170 style='border-top:none;border-left:none'>PREV_COUNT</td> <td class=xl6716170 style='border-top:none;border-left:none'>PCT_CHANGE</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl7116170>RM</td> <td class=xl7116170>PX_YIELD</td> <td class=xl7216170 align=right>12/29/2015</td> <td class=xl7116170>4030</td> <td class=xl7216170 align=right>12/22/2015</td> <td class=xl7116170>4030</td> <td class=xl7316170 align=right>0.00%</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170 colspan=2>ARM Rate Matches</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170 align=right>47</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170 colspan=3>PX_Stale Greater then 40 Days</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170 align=right>337</td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <tr height=20 style='height:15.0pt'> <td height=20 class=xl1516170 style='height:15.0pt'></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> <td class=xl1516170></td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=64 style='width:48pt'></td> <td width=86 style='width:65pt'></td> <td width=64 style='width:48pt'></td> <td width=118 style='width:89pt'></td> <td width=133 style='width:100pt'></td> <td width=84 style='width:63pt'></td> <td width=83 style='width:62pt'></td> <td width=126 style='width:95pt'></td> <td width=100 style='width:75pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> </tr> <![endif]></table></div><!-----------------------------><!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD--><!-----------------------------></body></html>
--===============0399484825==--
More information about the Python-list
mailing list