Prices

Overview

Price utility functions.

Function List

qlMidEquivalent ()
qlMidSafe ()

Function Documentation

qlMidEquivalent

double returnValue
 
qlMidEquivalent(
        double Bid
        double Ask
        double Last
        double Close
        any Trigger)

Description:

returns the mid price if available, or a suitable substitute otherwise.

Supported Platforms:

Excel

Parameters

Bid	bid price. Default value = 0.
Ask	ask price. Default value = 0.
Last	last price. Default value = 0.
Close	close price. Default value = 0.
Trigger	dependency tracking trigger

qlMidSafe

double returnValue
 
qlMidSafe(
        double Bid
        double Ask
        any Trigger)

Description:

returns the mid price only if both bid and ask are available.

Supported Platforms:

Excel

Parameters

Bid	bid price. Default value = 0.
Ask	ask price. Default value = 0.
Trigger	dependency tracking trigger