FundFlow Viz 3 asks: WHICH WAY? HOW MUCH? HOW MANY? HOW FAST (ACCELERATING; DECELERATING)?

Description of "FF Moving Rate of Change"

The trends of Buy Sell Rate of Change (Parameters), Buy Sell Range Measures and Rate of $Chg XmR for Date. Color shows details about Buy Sell Range Measures and Rate of $Chg XmR. The data is filtered on Action (Date), which keeps 769 members. The view is filtered on Date, which ranges from 1/8/92 to 10/4/06 and keeps Null values.

Wkly Flows Properties

Marks

The mark type is Line (Automatic).

The marks are labeled automatically.

Stacked marks is off.

Shelves

Rows:

Buy Sell Rate of Change, Wkly Flows, Rate $Chg

Columns:

Date

Filters:

Action (Date), Date

Color:

Measure Names

Rate $Chg Properties

Marks

The mark type is Line (Automatic).

The marks are labeled automatically.

Stacked marks is off.

Shelves

Rows:

Buy Sell Rate of Change, Wkly Flows, Rate $Chg

Columns:

Date

Filters:

Action (Date), Date

Color:

Measure Names

Dimensions

Measure Names has 2 members on this sheet

Members: Buy Sell Range Measures; Rate of $Chg XmR

Measure Names is sorted manually.

Date ranges from 1/8/92 to 10/4/06 on this sheet.

The filter associated with this field ranges from 1/8/92 to 10/4/06 and keeps Null values.

Measures

Wkly Flows ranges from -20,599,497 to 15,326,335 on this sheet.

Rate $Chg ranges from -4,243,492 to 8,162,630 on this sheet.

 

The formula is CASE [Buy Sell Rate of Change]

WHEN "4-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -3, 0)

WHEN "5-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -4, 0)

WHEN "6-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -5, 0)

WHEN "7-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -6, 0)

WHEN "8-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -7, 0)

WHEN "9-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -8, 0)

WHEN "10-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -9, 0)

WHEN "11-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -10, 0)

WHEN "12-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -11, 0)

WHEN "13-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -12, 0)

END

Results are computed along Date.

Buy Sell Rate of Change (Parameters) has the value 11-WK SMA.

Sets

Action (Date) has 769 members on this sheet

Members: 1/15/1992; 1/22/1992; 1/29/1992; 1/8/1992; 2/5/1992; ...

Parameters

Buy Sell Rate of Change (Parameters) has the value 11-WK SMA.

Data Source Details

Data Source:

AMGDEMO EQxETF

Type:

Tableau Data Engine Database

Database:

C:/Users/bob/AppData/Local/Temp/TableauTemp/30082704/Data/Datasources/AMGDEMO EQxETF.tde

Table:

Extract (Extract.Extract)

©Robert Adler 2014-2019, All Rights Reserved