Formula Guide

QuickCalc supports a large set of mathematical, logical, and GlobalView data functions, which can be used to create user-defined formulas against live quotes.

Live Data Functions

ASK

The ASK data function returns the latest asking price for the symbol provided.  For applicable symbols, this price updates in real time.

Syntax:

ASK(“symbol”)

Examples:

=ASK(“/NGF4”)  returns the current ask price for the /NGF4 contract

=ASK(“/NGF4”)*2   returns 10.64 if the current ask price is 5.32 for the /NGF4 contract

ASKSIZE

The ASKSIZE data function returns the quantity offered at the latest ask price.  For applicable symbols, this value updates in real time.

Syntax:

ASKSIZE(“symbol”)

Examples:

=ASKSIZE(“/NGF4”)  returns the quantity offered at the latest ask price for the /NGF4 contract

=(ASKSIZE(“/NGF4”)+ASKSIZE(“/NGG4”)+ASKSIZE(“/NGH4”))/3     averages the quantity offered at the latest ask price for the symbols shown.

BID

The BID data function returns the latest bid price for the symbol provided.  For applicable symbols, this price updates in real time.

Syntax:

BID(“symbol”)

Examples:

=BID(“/NGF4”)  returns the latest bid price for the /NGF4 contract

=BID(“/NGF4”)*2   returns 10.38 if the latest bid price is 5.19 for the /NGF4 contract

BIDSIZE

The BIDSIZE data function returns the quantity offered at the latest bid price.  For applicable symbols, this value updates in real time.

Syntax:

BIDSIZE(“symbol”)

Examples:

=BIDSIZE(“/NGF4”)  returns the quantity offered at the latest bid price for the /NGF4 contract

=(BIDSIZE(“/NGF4”)+BIDSIZE(“/NGG4”)+BIDSIZE(“/NGH4”))/3     averages the quantity offered at the latest bid price for the symbols shown.

CONTRACT

The CONTRACT data function returns the formatted name of the contract specified.  The formatted name consists of the contract’s expiration month and year.

Syntax:

CONTRACT(“symbol”)

Examples:

=CONTRACT(“/NGF4”)  returns “Jan 04”

DESC

The DESC data function returns the symbol’s description.

Syntax:

DESC(“symbol”)

Examples:

=DESC(“/NGF4”)  returns “JAN 04 Natural Gas”

HIGH

The HIGH data function returns the session's highest transaction value.  For applicable symbols, this value updates in real time.

Syntax:

HIGH(“symbol”)

Examples:

=HIGH(“/NGF4”)  returns the session’s highest transaction value for /NGF4.

=HIGH(“/NGF4”)/7  returns 0.774285 if the session’s high value is 5.42

HISTORICAL CLOSE

The HISTORICAL CLOSE data function returns the previous session's close or settle value.  For applicable symbols, this value updates in real time.

Syntax:

HISTCLOSE(“symbol”)

Examples:

=HISTCLOSE(“/NGF4”)  returns the previous session’s settle value for /NGF4.

=HISTCLOSE(“/NGF4”)/7  returns 0.774285 if the previous session’s settle value is 5.42

LAST

The LAST data function returns the last trade price or value  (most recent).  For applicable symbols, this value updates in real time.

Syntax:

LAST(“symbol”)

Examples:

=LAST(“/NGF4”)  returns the last trade price for /NGF4.

=LAST(“/NGF4”)*5  returns 26.65 if the last price is 5.33

LOW

The LOW data function returns the session's lowest transaction value.  For applicable symbols, this value updates in real time.

Syntax:

LOW(“symbol”)

Examples:

=LOW(“/NGF4”)  returns the session’s lowest transaction value for /NGF4.

=LOW(“/NGF4”)*5  returns 25.2 if the lowest price is 5.04.

NETCHG

The NETCHG data function returns the net change from previous close.  For applicable symbols, this value updates in real time.

Syntax:

NETCHG(“symbol”)

Examples:

=NETCHG(“/NGF4”)  returns the net change from previous close.

=OPEN(“/NGF4”)/NETCHG(“/NGF4”) returns 15.849057 if open and net change are 5.04 and 0.318, respectively

OPEN

The OPEN data function returns the session's opening price.  For applicable symbols, this value updates in real time.

Syntax:

OPEN(“symbol”)

Examples:

=OPEN(“/NGF4”)  returns the session’s opening price for /NGF4.

=OPEN(“/NGF4”)*5  returns 25.2 if the session’s opening price is 5.04

SETTLE

The SETTLE data function returns the settlement price, e.g. the official closing price of a commodity.  For applicable symbols, this value updates in real time.

Syntax:

SETTLE(“symbol”)

Examples:

=SETTLE(“/NGF4”)  returns the session’s settle value for /NGF4.

=SETTLE(“/NGF4”)*5  returns 26.65 if the session’s settle value is 5.33

TICKCT

The TICKCT data function returns the number of trades this session for a particular symbol.  For applicable symbols, this value updates in real time.

Syntax:

TICKCT(“symbol”)

Examples:

=TICKCT(“/NGF4”)  returns the number of trades in the current session for /NGF4.

TRDDATE

The TRDDATE data function returns the date of the last reported trade.  For applicable symbols, this value updates in real time.

Syntax:

TRDDATE(“symbol”)

Examples:

=TRDDATE(“/NGF4”)  returns the date of the last reported trade.

=MONTH(TRDDATE(“/NGF4”))  returns 11 if the last reported trade is 2003-11-14.

TRDTIME

The TRDTIME data function returns the time of the last reported trade.  For applicable symbols, this value updates in real time.

Syntax:

TRDTIME(“symbol”)

Examples:

=TRDTIME(“/NGF4”)  returns the time of the last reported trade for /NGF4.