Finwin Quote (Query No News)

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 No News)

Quotes Type=QueryNoNews returns the same data as Type=Query except without the columns related to news. If you are using FinWin quotes to get snap quotes or a list of multiple quotes, but are NOT using the news data that is returned in the "news", "titles" and "storynumber" columns, you should use vthe querynonews type. It will cut the execution time for building the return packet by roughly 60%. It returns the following in a WDDX packet.

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.
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"
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.	Sym - The symbol.
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
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.
TmonthLow - 52 week low price.	TmonLowDay - 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 = QueryNoNews
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 No News

Cold Fusion Example

<cf_stockinfo 
      request="QUOTE"
      type="QueryNoNews"
      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=querynonews"

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

Quotes (Type = QueryNoNews) Example:

MICROSOFT CORP
SYMBOL	MSFT	MARKET IDENTIFIER	NMS
OPEN	0	BID PRICE	28.8
LAST	28.8	BID SIZE	1300
CHANGE	0	ASK PRICE	28.87
VOLUME	0	ASK SIZE	400
HIGH	0	PE RATIO	15.8
LOW	0	52 WEEK HIGH	31.5
PREVIOUS CLOSE	28.8	52 WEEK HIGH DATE	12/29/09
SHARES OUTSTANDING	8770461	52 WEEK LOW	15.25
SIC CODE	7372	52 WEEK LOW DATE	3/10/09
ANNUAL EPS	1.81	DIVIDEND YIELD	1.8
ANNUAL EST EPS	2	ANNUAL DIVIDEND	0.13

Bedfordreport.com: Complimentary Analyst Research on Tata Motors Ltd. (NYSE: TTM), Microsoft Corp. (NASDAQ: MSFT), Applied Materials, Inc. (NASDAQ: AMAT), BCE, Inc. (NYSE: BCE) and Many More

Note to Editors: The Following Is an Investment Opinion Being Issued by the BedfordReport.com

Microsoft To Present At Jefferies Annual Global Technology Conference; Webcast At 11:15 AM ET

Google Acquires DocVerse