Finwin Quote (Query)

Requests:

Quote

Types:

·Query

·QueryNoNews

·Array

·Delimited

·StandardXML

·FuturesChain

·FutChainXML

·FuturesStrip

·Table

·CustomXML

·CustomQuery

Chart

Lookup

Sample Code:

Coldfusion

ASP

JSP

PHP

Perl

Quotes (CustomXML)

Type=CustomXML returns an XML packet. The fields returned will vary depending upon 2 factors:

The security type of the instrument you are requesting (stock, bond, mutual fund, etc.)
The custom field list you request (optional)

The option parameter Fields is a comma delimeted list of all fields you wish to be returned. Utlizing this option will give you complete control over the data returned. If you leave this field blank or omit it altogether, you will be returned all applicable fields for the particular security type your are requesting.

You also have the ability to rename the field names. Among other benefits, this feature will allow you to more easily migrate existing applications to FinWin. To utilize this feature, simply use the format: Fields="NEWNAME=OLDNAME,...". For example, to rename SYMBOL to SYM, use: Fields="SYM=SYMBOL".

Required Parameters

URL = http://www.finwin.com/processct/processquotetag.cfm Username = myUsername
Password = myPassword
Id = 1183
Request = Quote
Type = CustomXML
Symbol = MSFT - can be a comma delimited list

Optional Parmeters

Fields = Comma delimeted list of fields you want returned. You can find a list of available fields by security type here.

Notes:
1. The field names for CustomXML and CustomQuery are different than our other services.
2. FinWin reserves the right to add columns of data with minimal notice to our "Custom" datasets. Please code accordingly.

Example WDDX Packet

Custom XML - Stock

Custom XML - Bond

Custom XML - Mutual Fund

Custom XML - Commodity

Custom XML - Stock
(with Fields="SYMBOL,OPEN_PRICE,HIGH_PRICE,LOW_PRICE,CLOSE_PRICE")

ASP Example

Dim strSymbol strSymbol = Request.Form("Symbol") Request_POST = 1 Set HttpObj = Server.CreateObject("SOFTWING.AspTear") FinwinURL = "Http://www.finwin.com/processCT/ProcessQuoteTag.cfm" PostData = "username=MyUsername&password=MyPassword&id=1183&request=Quote&Symbol=" & strSymbol & "&type=CustomXML" content = HttpObj.Retrieve(FinwinURL, Request_POST,PostData, "", "") Response.write(content)

DTN Market Access
9110 West Dodge Road, Suite 200 Omaha, Nebraska 68114
Copyright 2012, All rights reserved