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 (Query)

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

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 = Query
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 Query

Cold Fusion Example

<cf_stockinfo 
      request="QUOTE"
      type="Query"
      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=query"

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

Quotes (Type = Query) Example:

MICROSOFT
SYMBOL	MSFT	MARKET IDENTIFIER	NMS
OPEN	26.13	BID PRICE	26.02
LAST	26.03	BID SIZE	11100
CHANGE	0.08	ASK PRICE	26.09
VOLUME	69444188	ASK SIZE	200
HIGH	26.41	PE RATIO	12.4
LOW	25.6	52 WEEK HIGH	31.58
PREVIOUS CLOSE	25.95	52 WEEK HIGH DATE	4/23/10
SHARES OUTSTANDING	8763839	52 WEEK LOW	22.73
SIC CODE	7372	52 WEEK LOW DATE	7/01/10
ANNUAL EPS	2.1	DIVIDEND YIELD	2
ANNUAL EST EPS	2.39	ANNUAL DIVIDEND	0.13

Microsoft 2010 Analyst Meeting At 11:00 AM ET

Microsoft, Adobe Collaborate To Protect Against Online Threats - Quick Facts

Microsoft, Adobe Collaborate To Protect Against Online Threats

PPD, Microsoft To Deliver Innovative REMS Solution Based On Microsoft Technologies