vwap

vwap — aggregate function that returns the volume-weighted average price.

SYNOPSIS

vwap (price, quantity)

DESCRIPTION

This function computes a value for the specified fields in each record from the base table and returns the volume-weighted average price. The argument field types must be of type double, or coercible to double. The returned price is type double.

EXAMPLE

This example shows how to use dynamic aggregation to find the volume weighted average price of the values in two columns. In the Hello LiveView sample, create a query that finds the VWAP of the lastSoldPrice field weighted by the quantityRemaining field from the ItemSales table, grouping by Item. Follow these steps:

  1. In LiveView Desktop connected to a server running the Hello LiveView sample, select the ItemsSales table from the Tables pane of the LiveView Tables view.

  2. In the Select field, enter:

    Item, vwap(lastSoldPrice,quantityRemaining) AS VWAP
  3. In the Query field, enter the following:

    group by Item
  4. Click Open Query.

The query results open in a grid view. LiveView Server recalculates the VWAP value whenever the rows returned by the query predicate change.

SEE ALSO

This LiveView aggregate function is based on the vwap aggregate function in the StreamBase expression language.