Finwin Quote (Standard XML)

Requests:

Quote

Types:

·Query

·QueryNoNews

·Array

·Delimited

·StandardXML

·FuturesChain

·FutChainXML

·FuturesStrip

·Table

·CustomXML

·CustomQuery

Chart

Lookup

Sample Code:

Coldfusion

ASP

JSP

PHP

Perl

Quotes (StandardXML)

Quotes Type=StandardXML returns a standard XML document with quote data. The root node is Recordset and there is 1 or more result nodes underneath the root that coresponds to the symbols you submitted. Each result node has at least 2 child nodes: Symbol and Success. If the symbol is not found, the Success node will contain "N" as an element value, the Symbol node will contain your symbol and no other nodes will be present. If the request is successful and the symbol is found, Success will contain "Y" and there will be a node corresponding to the column values found above. Unlike the query method, which returns all the columns regardless of type, enabling a congruity of rows and columns, StandardXML will only return columns that are applicable to symbol type. Below is a list of all possible returned columns. However, only columns that pertain to the type of symbol will be returned in the standardXML packet.

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.
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.
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.
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.

Required Parameters

URL = http://www.finwin.com/processct/processquotetag.cfm Username = myUsername
Password = myPassword
Id = 1183
Request = Quote
Type = StandardXML
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 XML Packet

Quotes StandardXML

Cold Fusion Example

<cf_stockinfo 
      request="Quote"
      type="standardxml"
      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=standardxml"

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

Quotes (Type = StandardXML) 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	2500
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