mxls_db_query function

Last Updated On April 22, 2019
You are here:
< Back

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, min, variance, standarddeviation, “How far you want to go in days” 1, 100, 200 etc)

The only database which is supported right now is called “historical”.

So, to get the minimum low a symbol has moved to in last 100 days, type =MXLS_DB_Query(“historical”, “MSFT” , “low”, “min”, “100”)

To get the average of daily returns of a stock in last 100 days, type =mxls_db_query(“Historical”,”msft”,”returns”,”average”,100)

Shopping Cart