Finwin Quote (Futures Chain)

Requests:

Quote

Types:

·Query

·QueryNoNews

·Array

·Delimited

·StandardXML

·FuturesChain

·FutChainXML

·FuturesStrip

·Table

·CustomXML

·CustomQuery

Chart

Lookup

Sample Code:

Coldfusion

ASP

JSP

PHP

Perl

Quotes (Futures Chain)

Quotes Type=FuturesChain returns a WDDX packet of futures when you pass in the root symbol of the future. The recordset returns the same columns as Type=Query. Below is a list of these 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 = FuturesChain
Symbol = NG - the root of the future. This can also be a comma delimited list.

(NOTE: To see a list of futures and how to format them to Finwin's standards click here)

Optional Parmeters

*Queryname = GetQuotes
MonthsForward = 5 - default is 1

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

Example WDDX Packet

Quotes Futures Chain

Cold Fusion Example

<cf_stockinfo 
      request="Quote"
      type="futureschain"
      username="myUsername"
      password="myPassword"
      id="1183"
      queryname="GetQuotes"
      symbol="NG"
      monthsforward="5">

ASP Example

Dim strSymbol
strSymbol   = "NG"
  
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=futureschain&monthsforward=5"

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

Quotes (Type = FuturesChain) Example:

Symbol	Open	High	Low	Last	Change	Previous Close
NATURAL GAS SEP 2010	4.820	4.820	4.820	4.820	+0.102	4.718
NATURAL GAS OCT 2010	4.810	4.855	4.775	4.855	+0.112	4.743
NATURAL GAS NOV 2010	5.000	5.000	5.000	5.000	+0.083	4.917
NATURAL GAS DEC 2010	5.200	5.200	5.200	5.200	+0.066	5.134
NATURAL GAS JAN 2011	0.000	0.000	0.000	5.335	+0.045	5.282
Update Time 2:28:27 PM
Powered by: Finwin.com