Barchart Advanced Option Functions – Optional Addon

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 … Read more Barchart Advanced Option Functions – Optional Addon

How to use Forex functions in MarketXLS

All currency functions in MarketXLS need Source currency Symbol and the target currency symbol. Always, 1st symbol is the source and the second is symbol. In the FX_Convert function provide the value to convert first and then provide the source and the target currency symbols. =Fx_Ask(“USD”,”GBP”) – This will get the current Ask Price of … Read more How to use Forex functions in MarketXLS

Using MarketXLS functions

MarketXLS functions are custom functions which work exactly like any other Excel functions. Start type the function and Excel will suggest similar sounding functions for you to use. Along with inbuilt Excel functions the new MarketXLS functions will also show up. For example, if you want to use Mutual Funds related functions start typing “=” … Read more Using MarketXLS functions

Historical Fundamental Functions

We have added new Historical fundamental functions that are available in Pro Version.  Full list of data points is shown below. The repective functions can be accesed by typing =hf_   Projected fiscal year-end date Number of months since last reporting period. If this field is other than 12 months, the company has likely changed … Read more Historical Fundamental Functions

mxls_db_query function

This function allows you to query MarketXLS databases with formulas database on our servers to get useful insights about the price & volume. Function Structure: =Mxls_db_query(“What Database”, “What Symbol”, “What do you want to query” i.e. Volume, Open, High, Low, Close, Dividend, Split, returns “, “How do you want to aggregate” i.e. sum, average, max, … Read more mxls_db_query function