Newman Information Systems (NIS)

nisanalytics.com
"Analytical Tools for Developing Fixed Income Applications"

netMBS
netMBS is the easiest way to incorporate MBS data into your web site. Simply pass the cusip number or pool type and pool number to the netMBS engine and an xml data stream is immediately returned to your web site.

IMPORTANT : A disclaimer must be included on your web site that nisanalytics.com has been used to perform the calclations (ex. Powered by nisanalytics.com).

Below is a partial xml document that is returned from the netMBS engine.

- <root> <rundate>3/27/2008 10:34:21 AM</rundate> - <input> <cusip>31409VJ46</cusip> </input> - <output> <cusip>31409VJ46</cusip> <description>FNMA Pool Number #879683</description> <coupon>5.759</coupon> <maturity>09/01/2036</maturity> <issue>08/01/2006</issue> <pool_number>879683</pool_number> <factor_date>3/1/2008</factor_date> <factor>0.80412496</factor> <factor_previous>0.8351723</factor_previous> <face_original>33474661</face_original> <face_current>26917810</face_current> <prefix>WS</prefix> <wac>6.364</wac> <original_term>360</original_term> <balloon_term></balloon_term> <wala>20</wala> <wam>07/01/2036</wam> <warm>340</warm> <wamtam>100</wamtam> <adj_index>1YRCMTWK</adj_index> <adj_margin>2.145</adj_margin> <adj_percap>2</adj_percap> <adj_lifecap>10.759</adj_lifecap> <adj_lifefloor>0</adj_lifefloor> <adj_resetfreq>12</adj_resetfreq> <adj_nextreset>03/01/2011</adj_nextreset> <cpr_1mth>36.53</cpr_1mth> <cpr_3mth>22.61</cpr_3mth> <cpr_6mth>19.56</cpr_6mth> <cpr_1yr>16.15</cpr_1yr> <cpr_2yr></cpr_2yr> <cpr_life>12.86</cpr_life> <psa_1mth>913</psa_1mth> <psa_3mth>595</psa_3mth> <psa_6mth>558</psa_6mth> <psa_1yr>554</psa_1yr> <psa_2yr></psa_2yr> <psa_life>574</psa_life> <type>FNMA</type> <status>Active</status> <delay>54</delay> <adjustable>Y</adjustable> <balloon>N</balloon> <fha_va>N</fha_va> <relocation>N</relocation> <hybrid>Y</hybrid> <hybrid_type>5/1</hybrid_type> <ltv>72</ltv> <fico>731</fico> <loans_curr>124</loans_curr> <loans_min>71900</loans_min> <loans_max>417000</loans_max> <loans_avg>222730</loans_avg> <property_singleunit>100</property_singleunit> <property_multiunit>0</property_multiunit> <occupancy_owner>80.42</occupancy_owner> <occupancy_second>19.58</occupancy_second> <occupancy_investor>0</occupancy_investor> <purpose_purchase>64.83</purpose_purchase> <purpose_refinance>35.17</purpose_refinance> <delinquent>0</delinquent> <delinquent30>0</delinquent30> <delinquent60>0</delinquent60> <delinquent90>0</delinquent90> <state1>FL</state1> <state1_pct>20.49</state1_pct> <state2>GA</state2> <state2_pct>19.48</state2_pct> <state3>CA</state3> <state3_pct>9.6</state3_pct> <state4>WA</state4> <state4_pct>7.67</state4_pct> </output> </root>

Use the following code to pass bond information to the netMBS engine and to view the entire xmlDocument.

<HTML> <FORM ACTION= "http://netmbs.nisanalytics.com" METHOD="POST"> UserID <INPUT NAME = "userid"> <BR> Cusip <INPUT NAME = "cusip" VALUE="31409VJ46"> </FORM> </HTML>

The following code shows you one method that can be used to pass a bond to the netMBS engine and how to parse the xmlDocument that is returned.

<% 'Define XML Document and Set Properties set xmlDoc = createObject("MSXML2.DOMDocument") xmlDoc.async = False xmlDoc.setProperty "ServerHTTPRequest", True 'Concatenate UserID and cusip Into String sData = "?UserID=" & <Your UserID> & "&cusip=31409VJ46" 'Pass Bond To nisanalytics.com xmlDoc.load("http://netmbs.nisanalytics.com/" & sData) 'Read XML elements If xmlDoc.parseError.errorcode = 0 Then MyCoupon = xmlDoc.selectSingleNode("//root/output/coupon").Text MyWAM = xmlDoc.selectSingleNode("//root/output/wam").Text End If Set xmlDoc = Nothing %>

Š2008 Newman Information Systems Bloomfield, CT (860) 286-0540