Finwin Quote (Delimited)

Requests:

Quote

Types:

·Query

·QueryNoNews

·Array

·Delimited

·StandardXML

·FuturesChain

·FutChainXML

·FuturesStrip

·Table

·CustomXML

·CustomQuery

Chart

Lookup

Sample Code:

Coldfusion

ASP

JSP

PHP

Perl

Quotes (Delimited)

Type=Delimited returns a plain text delimited list of fields that are determined 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 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
Delimiter = | - we strongly recommend NOT using a comma (,) or a space if you wish to have a tab delimiter please enter the word "tab".

Optional Parmeters

Fields = Comma delimeted list of fields you want returned. You can find a list of available fields by security type here.
*QueryName = GetQuotes
Notes:
1. The field names may be different than our other services.
2. FinWin reserves the right to add columns of data with minimal notice to our "Custom" and delimited datasets. Please code accordingly.
* Will work only when using Cold Fusion with Finwin's custom tags

Example File

Stock

Commodity

Index
(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=delimited&delimiter=|" content = HttpObj.Retrieve(FinwinURL, Request_POST,PostData, "", "") Response.write(content)

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