Newman Information Systems (NIS)

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

netSBA
netSBA is the easiest way to incorporate SBA data into your web site. Simply pass the cusip number or pool number to the netSBA 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 netSBA engine.

- <root> <rundate>9/18/2007 12:29:01 PM</rundate> - <input> <cusip>83164J6S0</cusip> </input> - <output> <cusip>83164J6S0</cusip> <coupon>9.075</coupon> <maturity>09/25/2018</maturity> <issue>05/01/2007</issue> <pool_number>508081</pool_number> <factor>0.97969376</factor> <factor_date>9/1/2007</factor_date> <face_original>16674047.2</face_original> <wam>12/25/2016</wam> <warm>111</warm> <adj_index>PRIME</adj_index> <adj_margin>0.825</adj_margin> <adj_resetfreq>3</adj_resetfreq> <adj_nextreset>10/01/2007</adj_nextreset> <cpr_1mth>3.57</cpr_1mth> <cpr_3mth>1.2</cpr_3mth> <cpr_6mth></cpr_6mth> <cpr_1yr></cpr_1yr> <cpr_2yr></cpr_2yr> <cpr_life>0.91</cpr_life> </output> </root>

Use the following code to send a cusip to the netSBA engine and return the entire xmlDocument.

<HTML> <FORM ACTION= "http://netsba.nisanalytics.com" METHOD="POST"> UserID <INPUT NAME = "userid"> <BR> Cusip <INPUT NAME = "cusip" VALUE="83164J6S0"> </FORM> </HTML>

The following code shows you one method that can be used to pass a bond to the netSBA 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> sData = sData & "&cusip=83164J6S0" 'Pass Bond To nisanalytics.com xmlDoc.load("http://netsba.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