Finwin Quote (Array)

Requests:

Quote

Types:

·Query

·QueryNoNews

·Array

·Delimited

·StandardXML

·FuturesChain

·FutChainXML

·FuturesStrip

·Table

·CustomXML

·CustomQuery

Chart

Lookup

Sample Code:

Coldfusion

ASP

JSP

PHP

Perl

Quotes (Array)

Quotes Type=Array returns a query recordset that is constructed as a 2 dimensional array. The first position is an index of rows that represents the number of records in the recordset and the second position represents the columns (i.e. myarray [row] [column] ). The first row (0 or 1 depending on the platform) contains the column headers. For example, if the query had 20 columns, looping through MyArray[0][1-20] would output the column headers. This also means that the size of the array will be one more than the actual number of records in the array.

NOTE: - Items that are faded are no longer supported by Finwin. Items that are colored Red are new fields.

Ask - Current ask (where applicable).	Assets - For money markets and mutual funds this represents the market value of the holdings. For an equity this represents the firms productive resources.
AskExchange - Exchange that the Ask value comes from.	AskSize - Size of the lot being offered.
AvgDaysToMaturity - Applies to Money Markets.	Bid - Current bid (where applicable - some delayed data does not include the bid or ask, notably the NYSE).
BidExchange - Exchange that the Bid value comes from.	BidSize - Size of the lot for which the bid is offered.
BidTick - (Required by Nasdaq) This value represents the direction of the last bid. I contains one of 3 letters: E - Equal/Even or Unchanged Bid Tick D - Down Bid Tick U - Up Bid Tick	BondNumber - Applies to Bonds.
BondMat - Maturity for this bond.	Change - Change from previous close - equivalent to prev - last.
Close - This value represents the latest closing price at session end. This price will stay the same until a new end-of-day value is sent.	CloseRange1 - Applies to Futures only
CloseRange2 - Applies to Futures only	Coupon - Applies to Bonds.
Desc - Company or issuer name.	Div - Amount of dividend
DivDay - Dividend day (int 1-12)	DivFreq - blank
DivMon - Dividend month (int 1-12)	DivYld - Dividend Yield
EEPS - Estimated Earnings per share.	EPS - Earnings per share.
Exchange - The short version of the exchange where issue is traded.	ExchangeLong - This is the descriptive name (long name) for the exchange. For example, instead of OTCBB, this field would contain "Nasdaq OTC Bulletin Board".
ExchangeSfx - (exchange suffix) this is the 5 letter identifier for the specific exchange. For example a Nasdaq OTCBB stock would have an ExchangeSfx value of USNB. The first two letters are international (US meaning US stock market), and the next 2 are the exchange NB being Nasdaq otcbb.	Expiration - Applies only to futures. Expiration of the future contract.
High - Todays high price.	Last - Last Price.
Low - Today's low price.	Ltdate - Last trade date (note: use this item to determine if the lttime is for todays activity. some stocks trade at a very low volume.).
LtTime - Last Trade time.	Maturity - Applies to Money Markets.
News - Flag - set to "yes" or "no" depending on whether there is news on this company.	Open - Today's open price.
OpenRange1 - Applies to Futures only.	OpenRange2 - Applies to Futures only.
PE - Price to Earnings Ratio	PercChange - Change as a percentage.
Prev - This value is the closing price for the previous day. For futures, it contains the latest settlement. This price will stay the same until a new end-of-day value is sent.	SevenDYld - Applies to Money Markets. Yeild for the last 7 days.
SharesOut - Outstanding shares for this company. Note: The value often exceeds the allowable field length for certain data types. Be very careful when re-formatting this number.	SIC - SIC classification number for this instrument.
Status - Contains information about this particular instrument. It may contain the following values: O = "Open" - Commodities only C = "Closed" - Commodities only D = "Delayed Quote" R = "Realtime Quote"	StoryNumbers - If there IS news on this company, the storynumbers column will be populated with the same number of items as the "headlines" column. The format of storynumbers is a list separated by the piping symbol ( \| ). For example, if a quote for GE had the 2 headlines listed above, storynumbers would contain exactly 2 numbers corresponding to the headlines - as in "394300 \| 349033". 394300 would match "GE Announces quarterly Earnings", and 349033 would match "Product liability lawsuit against GE quashed by appellate court". You can create a link to a newshandler that passes these numbers to the FinWin News application (or CF Tag) and retrieve the full text of the story - as well as related keywords, symbols and meta data about the company, story and source.
Success - This column allows you to check the validity of a symbol. If Success is 'Y', the quote has been successful. If Success is 'N', the quote has failed, usually because the symbol is not valid.	SymbolType - This value represents the type of instrument being quoted. It can contain the following possible values: STOCK - This is an equity trading instrument. INDEX - An index (dow, composite etc.) FUTURE - A commodity instrument. MUTUAL FUND - Mutual Fund MONEY MARKET FUND - Money Market Fund BOND - A corporate or municipal bond FUTURE SPREAD - A spread on a commodity covering a range of contracts. For example a spread might cover May to August Corn. SPOT (CASH) PRICE - An instrument that represents a cash value. INDEX/EQUITY OPTION - Index/Equity option FUTURE OPTION - Future Option
Sym - The symbol.	TickHistory - A string of symbols that represent the last 8 ticks. A plus sign (+) means an up tick a minus sign (-) means a down tick and an asterisk () means an even tick. (example: +--+-)
Time - Time of the Quote (note: not time of the trade.	Titles - If there IS news on this company, the titles column will be populated with one or more headlines in a list separated by the piping symbol ( \| ). For example, if the symbol was GE, Titles might contain this data: "GE Announces quarterly Earnings \| Product liability lawsuit against GE quashed by appellate court". The number of titles corresponds exactly to the number of items in the "storynumber" list.
TmonthLow - 52 week low price.	TmonthLowDay - 52 week low day of month (int 1-31).
TmonthLowDate - This is the date of the 52 week Low value. It's created from the TmonLowDay and TmonLowMon value.	TmonthLowMon - 52 week low day of month (int 1-12).
TmonthHigh - 52 week high price	TmonthHighDate - This is the date of the 52 week high value. It's created from the TmonHighDay and TmonHighMon value.
TmonthHighDay - 52 week high day of month (int 1-31).	TmonthHighMon - 52 week high month(int 1-12).
TradesToday - Total number of trades today.	TradeVolume - Size (number of shares) of the most recent trade.
Volume - Accumulated trade volume for today.	YearEndNAV - Applies to Mutual Funds. The Net Asset Value of the fund at the end of the year.
Yield - Applies to Bond. Actual current Yield.

Required Parameters

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

Optional Parmeters

*Queryname = GetQuotes
* Will work only when using Cold Fusion with Finwin's custom tags

Example WDDX Packet

Quotes Array

Cold Fusion Example

<cf_stockinfo 
      request="QUOTE"
      type="Array"
      username="myUsername"
      password="myPassword"
      id="1183"
      queryname="GetQuotes"
      symbol="MSFT">

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=array"

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

Quotes (Type = Array) Example:

MICROSOFT CORP
SYMBOL	MSFT	MARKET IDENTIFIER	NMS
OPEN	23.76	BID PRICE	0
LAST	23.37	BID SIZE	0
CHANGE	-0.67	ASK PRICE	0
VOLUME	65427699	ASK SIZE	0
HIGH	24.04	PE RATIO	13.8
LOW	23.21	52 WEEK HIGH	28.5
PREVIOUS CLOSE	24.04	52 WEEK HIGH DATE	8/13/08
SHARES OUTSTANDING	8899720	52 WEEK LOW	14.87
SIC CODE	7372	52 WEEK LOW DATE	3/06/09
ANNUAL EPS	1.74	DIVIDEND YIELD	2.2
ANNUAL EST EPS	1.7	ANNUAL DIVIDEND	0.13

Wipro Appoints Martha Bejar As President, Global Sales And Operations - Quick Facts

CSC Announces Global Agreement To Resell Microsoft Business Productivity Online Suite

Bing Increases Microsoft's Share Of Search Market By 1%

ICAP Ocean Tomo To Offer For Sale Significant Portfolio Of Intellectual Property Assets Held By Delphi Technologies

Recruiting Patterns to Hold Steady in Q3, According to Quarterly Job Forecast