<%@ Language=VBScript %> <% 'on error resume next option explicit dim cn, rs dim sql set cn = server.createobject("ADODB.Connection") set rs = server.createobject("ADODB.Recordset") sql = "select * from ebs order by EBSID" cn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\inetpub\msrb\website\msrb1\TRSweb\ebs.mdb;" rs.open sql, cn Dim oFSO,oFile,dMod Set oFSO = Server.CreateObject("Scripting.FileSystemObject") Set oFile = oFSO.GetFile(Server.MapPath("ebs.mdb")) dMod = FormatDateTime(oFile.DateLastModified,0) & " Eastern" Set oFSO = Nothing Set oFile = Nothing %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <!--<span style="mso-spacerun: yes"></span>#BeginTemplate "/Templates/trs.dwt" --> <HEAD> <!--#include virtual="/msrb1/includes/new/head.inc" --> <META name="keywords" content="MSRB, Municipal, Securities, Rulemaking, Board, bonds"> <META name="description" content="The MSRB makes rules regulating dealers who deal in municipal bonds, municipal notes, and other municipal securities. MSRB.org contains useful information for municipal securities investors, dealers and the general public."> <!--<span style="mso-spacerun: yes"></span>#BeginEditable "doctitle" --> <TITLE>MSRB Dealer Identifiers to be Used when Reporting Transactions to the MSRB Transaction Reporting System</TITLE> <!--#include virtual="/msrb1/includes/new/script.inc" --> <!--<span style="mso-spacerun: yes"></span>#EndEditable --> <!--<LINK rel="stylesheet" href="../msrb.css" type="text/css">--> <!--#include virtual="/msrb1/includes/new/link.inc" --> <style id="EBS_Styles"> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} .xl1515000 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"MS Sans Serif"; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;} --> </style> </HEAD> <!--<BODY align="center" bgcolor="#ffffff" text="#000000" link="#006699" vlink="#996699" alink="#006699" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">--> <BODY> <!--#include virtual="/msrb1/includes/new/body.inc" --> <TABLE width="760" border="0" cellspacing="0" cellpadding="0" align="left"> <TR> <!--<span style="mso-spacerun: yes"></span>main table row 2 --> <TD colspan="8" bgcolor="#ffffff" align="left" valign="top"> <TABLE width="634"> <TR> <TD colspan="7" bgcolor="#ffffff" align="left" valign="top"><!--<span style="mso-spacerun: yes"></span>#BeginEditable "content-1col-cell" --> <p>The list below includes all MSRB registrants that have reported to the MSRB that they are effecting municipal securities transactions; <strong>this is not a complete list of all dealers registered with the MSRB. </strong>This list is provided to facilitate transaction reporting of municipal securities under <a href="/Rules-and-Interpretations/MSRB-Rules/General/Rule-G-14.aspx">MSRB Rule G-14</a>, which requires dealers to report both customer and inter-dealer transactions to the MSRB using the four character (alpha) symbol assigned by NASDAQ.(Click <a href="/Rules-and-Interpretations/MSRB-Rules/General/Rule-G-14.aspx">here</a> to see Rule G-14)</p> <p><strong><u>Inter-dealer Transactions:</u></strong> MSRB Rule G-14 requires dealers to report inter-dealer transactions to the MSRB through the Real Time Trade Matching (RTTM) system operated by the Depository Trust Clearing Corporation (DTCC). The procedures for reporting inter-dealer transactions require that dealers identify themselves and the contra-parties with which they are effecting transactions. Like the Real-Time Trade Reporting System (RTRS), the dealer identifiers used in the RTTM system must include the identifying (alpha) symbols assigned to each firm by NASDAQ. This is included in the field labeled "executing broker symbol.” The list below is designed to help research the broker symbols of other dealers who effect municipal securities transactions and to confirm that the effecting firm is known by the MSRB under the correct company name and executing broker symbol.</p> <table width="539" align="center" border="1"> <TR VALIGN="bottom"> <TD ALIGN="center" bgcolor="#C0C0C0" nowrap> <FONT FACE="MS Sans Serif" size="2"><b>MSRB Number</b></FONT></TD> <TD ALIGN="center" bgcolor="#C0C0C0"> <FONT FACE="MS Sans Serif" size="2"><b>Company Name</b></FONT></TD> <TD ALIGN="center" bgcolor="#C0C0C0" nowrap> <FONT FACE="MS Sans Serif" size="2"><b>EBS ID</b></FONT></TD> </TR> <% if not rs.BOF and not rs.EOF then while not rs.EOF %> <tr height=17 style='height:12.75pt'> <td height=17 class=xl1515000 style='height:12.75pt'> <% = rs(0).Value %> </td> <td class=xl1515000> <% = rs(1).Value %> </td> <td class=xl1515000> <% = rs(2).Value %> </td> </tr> <% rs.MoveNext wend end if %> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=96 style='width:72pt'></td> <td width=389 style='width:292pt'></td> <td width=54 style='width:41pt'></td> </tr> <![endif]> </table><br> <p align="center"><a href="/msrb1/TRSweb/DID_0413.xls">Click here to download this list in Excel (XLS) format</a><br><a href="/msrb1/TRSweb/DID_0413.txt">Click here to download this list in ASCII comma delimited format</a></p> <p align="center"><a href="/msrb1/default.asp">Home</a></p> <p align="center"> <br> <FONT style="height:12.75pt" FACE="arial" color="#C0C0C0"><B>Last updated on</B> <BR> <% =dMod %> </FONT> <BR> </p> <DIV> <DIV id="ftn1"></DIV> </DIV> </TD> </TR> <!--<TR> <TD colspan="7" bgcolor="#ffffff" align="middle" valign="top"> <P align="left"><A href="../Templates/copyright.asp"> 2011 </A> Municipal Securities Rulemaking Board. All Rights Reserved. <A href="../Templates/copyright.asp"> Terms and Conditions of Use</A>.</P> </TD> </TR>--> </TABLE> </TD> </TR> </TABLE> <!--#include virtual="/msrb1/includes/new/footer.inc" --> </BODY> </HTML> <% rs.Close cn.Close set rs = nothing set cn = nothing %>