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

Description of "$Prices - Flows"

Rate $Chg broken down by Measure Names vs. Date, sum of %Chg Mkt and sum of Wkly Flows. Color shows details about Trend (Rate of Chg).

Marks

The mark type is Text.

Stacked marks is on.

Shelves

Rows:

Date, %Chg Mkt, Wkly Flows

Columns:

Measure Names

Filters:

Measure Names

Text:

Rate $Chg

Color:

Trend (Rate of Chg)

Dimensions

Measure Names has 1 members on this sheet

Members: Rate $Chg

Date has 769 members on this sheet

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

Date is sorted in descending natural order.

Measures

Sum of %Chg Mkt has 456 members on this sheet

Members: -1.08; -1.14; 0.93; 1.1; 1.79; ...

Sum of Wkly Flows has 769 members on this sheet

Members: 1,989,688.14249994; 2,625,338.85613247; 3,409,190.91937538; 499,714.426179822; 652,460.91307165; ...

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 (sorted ascending by Count of Date).

Trend (Rate of Chg) has 2 members on this sheet

Members: Decreasing; Increasing

The formula is If ZN(([Rate $Chg])) - LOOKUP(ZN(([Rate $Chg])), -1)> 0 THEN "Increasing" Else "Decreasing" END

Results are computed along Date (sorted ascending by Count of Date).
For Rate $Chg, results are computed for each Date.

Trend (Rate of Chg) is sorted manually.

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