Finwin Quote (Table)

Requests:

Quote

Types:

·Query

·QueryNoNews

·Array

·Delimited

·StandardXML

·FuturesChain

·FutChainXML

·FuturesStrip

·Table

·CustomXML

·CustomQuery

Chart

Lookup

Sample Code:

Coldfusion

ASP

JSP

PHP

Perl

Quotes (Table)

Quotes Type=Table returns a pre-formatted HTML table with colors you chose when you subscribed to FinWin. The table will include a combination of the below columns depending upon the symbols symboltype.

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 = Table
Symbol = MSFT - only 1 symbol allowed

Optional Parmeters

NewsURL - The url to display a news story, if applicable.
ChartURL - The url to display a chart of the symbol.
Target - Target of ALL urls. - Default is _self
NoJS - Eliminates all pop-ups. Sets urls to target.

Cold Fusion Example

<cf_stockinfo 
      request="QUOTE"
      type="Table"
      username="myUsername"
      password="myPassword"
      id="1183"
      symbol="MSFT"
      newsurl="http://www.somedomain.com/display_news.cfm"
      charturl="http://www.somedomain.com/display_chart.cfm"
      target="_blank">

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=table&newsurl=http://www.somedomain.com/display_news.asp&charturl=" & 
"http://www.somedomain.com/display_chart.asp&target=_blank"

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

Quotes (Type = Table) Example:

Quotes Delayed at least 15 Minutes

GENERAL ELECTRIC CO

DJ INDUSTRIALS	-30.720	10467.16	-0.293%
NASDAQ COMP	-12.870	2251.69	-0.568%
S&P 500	-4.600	1101.53	-0.416%
Closing prices

GE - NYSE

Last

16.1500

CHANGE

0.1000

Open

16.1500

%Change

0.6231%

Bid

16.1200

ASK

16.1300

Day Low

15.9400

Day High

16.2400

52 Week Low

12.1100

52 Week High

19.7000

Previous Close

16.0500

Volume

69909343

Updated 18:47 ET

chart it!