Documentation for smfGetOptionStrikes() function


Description

    Returns all available strike prices for a given expiration date of a given equity, with the returned range of data centered on the in-the-money and out-of-the-money strike prices.

Syntax

    =smfGetOptionStrikes( Ticker, Expiry, [Put/Call], [Source], [Symbols], [Rows], [Columns], [Type])

Parameters



     Ticker= Ticker symbol of underlying equity (e.g "MMM" or "SPY").

     Expiration Date= The expiration date for which strike prices are to be returned. This can either be a string literal (e.g. "12/17/2001") or an EXCEL serial date (e.g. DATE(2011,12,17)).
    Put/Call= An optional parameter indicating whether strike prices for Puts or Calls should be returned. This parameter would be a literal value of "Put" or "Call", which can be abbreviated to "P" or "C". The default value is "P".
     Source = An optional parameter to indicate which data source the expiration dates should be retrieved from. Possible values:

Y= Yahoo (default value)
8= obsolete
G= obsolete
OX= obsolete

    Symbols= An optional parameter that can allow you to create option ticker symbols for the smfGetOptionQuotes() function. A value of 1 should be passed to create the option ticker symbols. Otherwise, the default value is 0.

    Rows and Columns= These are advanced optional parameters to override the size of the returned array of data. Normally, the returned array size is set by the range the formula is entered over. However, if other functions or VBA are involved, these allow the size of the returned range to be specifically set.

    Type=An optional integer value to determine the type of Internet request to make. Defaults to 0. For now, other values are experimental:

0 = XMLHTTP "Get" Request
1 = IE Object Request
2 = HTMLDocument Request
3 = XMLHTTP "Post" Request
4 = WinHttpRequest.5.1 "Get" Request (for Yahoo urls that require a "crumb" value)

Examples


Usage notes