Barchart Advanced Option Functions - Optional Addon

Discussion in 'Formulae' started by marketxls, Aug 10, 2017.

Barchart Advanced Option Functions - Optional Addon

  1. marketxls

    marketxls Administrator
    Staff Member

    Dec 21, 2015
    Likes Received:
    This function requires an optional addon subscription from Barchart API. MarketXLS integrates with Barchart options API and exposes the following functions for Options Intraday pricing and Option Historical Pricing.

    Following functions are available with an OPTIONAL barchart subscription specifically for Options Data...

    Barchart_Option_Open(symbol As String)
    Barchart_Option_ExpirationType(symbol As String)
    Barchart_Option_Volatility(symbol As String)
    Barchart_Option_Delta(symbol As String)
    Barchart_Option_Gamma(symbol As String)
    Barchart_Option_Theta(symbol As String)
    Barchart_Option_Vega(symbol As String)
    Barchart_Option_Rho(symbol As String)
    Barchart_Option_Bid(symbol As String)
    Barchart_Option_BidSize(symbol As String)
    Barchart_Option_BidDate(symbol As String)
    Barchart_Option_Ask(symbol As String)
    Barchart_Option_AskSize(symbol As String)
    Barchart_Option_AskDate(symbol As String)
    Barchart_Option_High(symbol As String)
    Barchart_Option_Low(symbol As String)
    Barchart_Option_Last(symbol As String)
    Barchart_Option_Change(symbol As String)
    Barchart_Option_PercentChange(symbol As String)
    Barchart_Option_Premium(symbol As String)
    Barchart_Option_Settlement(symbol As String)
    Barchart_Option_LastTradeDate(symbol As String)
    Barchart_Option_Volume(symbol As String)
    Barchart_Option_OpenInterest(symbol As String)
    Barchart_Option_Expirations(symbol As String)
    Barchart_Option_History(symbol As String)

    To use these functions....

    1) Enter your API Key and save


    2) Change the formulae mode to "Group Mode"


    3) Create a new List of Underlying symbols for which you need Option data.


    4) Once you have the symbols loaded, you can use the functions. As shown in the screenshots below...



    Attached Files:

    #1 marketxls, Aug 10, 2017
    Last edited: Aug 15, 2017

Share This Page