Finwin Options Quote (Query)

Requests:

OptionChain

Quote

Types:

·Query

·Delimited

Sample Code:

Coldfusion

ASP

JSP

PHP

Perl

Options Quote (Query)

Required Parameters

Username = myUsername
Password = myPassword
Id = 1183
Request = Quote

Optional Parmeters

Type = Query (Default is Query)
Symbol = any valid ticker symbol with the below format.
Fields = List of fields you want returned

If you passed symbol=MSQ IL, you would retrieve an option quote for a Microsoft CALL option for the month of September and a strike price of $60.00. If you passed the symbol "DLQ 0F" it would be a Dell PUT option at a strike price of $30. Here is post data for some sample scenarios (note: postdata is a string representing the form elements. If you are using CF, each of these name/value pairs is a "formfield" for cfhttpparam):

Example WDDX Packet

Option Quote

Options Quote Type=Query returns a WDDX recordset with the following columns :

Symbol - the option symbol. The first 3 characters are the "option root". An option root for a NYSE or AMEX stock is usually the same as the ticker symbol. However, the option root for a Nasdaq stock is a 3-letter derivative of the ticker symbol (for example - DELL uses DLQ for many options). The option root is followed by a space, then 2 more letters (ie. DLQ IU). The trailing letters represent the month of the options expiration, and the strike price (price at issue) for the option. A cross-reference table is provided below.
Expire - This is a string with six characters representing the expiration date. All of the characters are numeric values. The first 2 characters are the month, the next 2 are the day and the next 2 are the year. To convert to a readable date format, use date functions provided by your scripting language, or insert dashes or slashes after the first 2 and first 4 characters (ie. 090101 becomes 09-01-01).
Strike - This is the Strike price for the option. It is the price of the option when first issued.
Last - Price of option at last trade.
Change - Current change is Last minus close.
Pchange - "Percent change" is the (change / close) * 100.
Open - Price of option at market open.
High - Today's High price.
Low - Today's Low price.
Close - Closing price at market's last close. During the market trading hours, this value represents the close of the previous trading day. After market hours it represents this days close.
Bid - Best Bid for this option.
Bid_size - Bid size for this option.
Ask - Best Ask for this option.
Ask_size - Ask size for this option.
Volume - Today's Cumulative trade volume.
Inc_Volume - Last Trade size.
OpenInt - Open Interest. This number represents the number of contracts currently held for that option. Open interest is an indication of the level or scale of interest in the option.

To get an option quote, you may pass a symbol or a list of symbols. You must pass (as a POST request) the required parameters (username, password, id and request=quote) plus the "symbol" parameter to the finwin Option URL (www.finwin.com/processct/processoptiontag.cfm). Each symbol must consist of an "option root" plus a space plus a 2-letter code indicating the expiration month and the strike price (i.e. symbol=DLQ IU). These symbols may need to be URL encoded depending on your request mechanism (i.e. symbol=DLQ%20IU,DLQ%20IP). The first letter of the 2-letter code must be a Month corresponding to the month codes in the matrix below. The second letter of the 2 letter code must correspond to the strike price codes in the strike price matrix below. The easiest way to help your users out is to provide an option chain and allow them to pick from the options they are interested in.

Month	Call letter	Put Letter
JAN	A	M
FEB	B	N
MAR	C	O
APR	D	P
MAY	E	Q
JUN	F	R
JUL	G	S
AUG	H	T
SEP	I	U
OCT	J	V
NOV	K	W
DEC	L	X

Strike Price Letter Codes (evens)
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
5	10	15	20	25	30	35	40	45	50	55	60	65	70	75	80	85	90	95	100
105	110	115	120	125	130	135	140	145	150	155	160	165	170	175	180	185	190	195	200
205	210	215	220	225	230	235	240	245	250	255	260	265	270	275	280	285	290	295	300
305	310	315	320	325	330	335	340	345	350	355	360	365	370	375	380	385	390	395	400
405	410	415	420	425	430	435	440	445	450	455	460	465	470	475	480	485	490	495	500
505	510	515	520	525	530	535	540	545	550	555	560	565	570	575	580	585	590	595	600
605	610	615	620	625	630	635	640	645	650	655	660	665	670	675	680	685	690	695	700
705	710	715	720	725	730	735	740	745	750	755	760	765	770	775	780	785	790	795	800

Strike Price Letter Codes (halves)
U	V	W	X	Y	Z
7.5	12.5	17.5	22.5	27.5	32.5
37.5	42.5	47.5	52.5	57.5	62.5
67.5	72.5	77.5	82.5	87.5	92.5
97.5	102.5	107.5	112.5	117.5	122.5
127.5	132.5	137.5	142.5	147.5	152.5
157.5	162.5	167.5	172.5	177.5	182.5
187.5	192.5	197.5	202.5	207.5	212.5
217.5	222.5	227.5	232.5	237.5	242.5

Cold Fusion Example

<cfhttp url="http://www.finwin.com/processCT/ProcessOptionTag.cfm" method="POST">
  <cfhttpparam name="username" value="myUsername" type="formfield">
  <cfhttpparam name="password" value="myPassword" type="formfield">
  <cfhttpparam name="id" value="1183" type="formfield">
  <cfhttpparam name="request" value="quote" type="formfield">
  <cfhttpparam name="symbol" value="MQF AV" type="formfield">
  <cfhttpparam name="type" value="delimited" type="formfield">
</cfhttp>
<cfoutput>#cfhttp.filecontent#</cfoutput>

ASP Example

	
Dim strSymbol
Dim strMonth
strMonth 	 = Request.Form("Month")
strSymbol   = Request.Form("Symbol")

Request_POST = 	1
Set HttpObj  = Server.CreateObject("SOFTWING.AspTear")
FinwinURL 	 = "http://www.finwin.com/processCT/ProcessOptionTag.cfm"

PostData = "username=myUsername&password=myPassword&id=1183&request=quote
&Symbol=" & strSymbol & _"&type=query"

content = HttpObj.Retrieve(FinwinURL, Request_POST,PostData, "", "")
Response.write(content)