Custom Report

 

This report can be created by selecting the Reports / Custom... command from within any window.

 

This report type allows you to define what data will appear on the report. You can use memorized reports to create custom reports to fit your preferences. The Custom Settings Dialog allows you to pick which fields will be displayed on the report. The latest custom settings are memorized from report to report as well as from Fund Manager session to session. For data fields that begin on the starting report date, and end on the ending report date, the available option descriptions include (between) and the column labels include (btw). For data fields that begin at the inception of the particular investment, and end on the ending report date, the available options descriptions include (ending) and the column labels include (end). For data that pertain to the beginning report date the available options descriptions include (beginning). For data that pertain to the ending report date the available options descriptions include (ending). For data that pertains to only the shares still owned on the ending report date the text “current” or “-C” will be included in the column label. For all of the “-C” fields the FIFO accounting method is used to determine the owned shares.  In addition to the built-in fields you can write equations to define your own User-Defined Custom Report Fields.  The available built-in field descriptions, column labels and a description of each field is given in the table below:

 

 

Field Name

Column Label Description

%Gain (between)

%Gain (btw) The out of pocket percent gained from the report starting date through the report ending date. (%Gain (btw) = Gain (btw) / OOP basis (btw))

%Gain_AI (between)

%Gain_AI (btw)

The out of pocket percent gained from the report starting date through the report ending date, including accrued interest. (%Gain_AI (btw) = Gain_AI (btw) / OOP basis_AI (btw))

%Gain (current)

%Gain-C (end)

The out of pocket percent gain on shares owned on the ending report date. (%Gain-C (end) = Gain-C (end)/OOP-C basis (end))

%Gain (inception)

%Gain (end)

The out of pocket percent gained from inception through the report ending date. (%Gain (end) = Gain (end) / OOP basis (end))

%Gain price (between)

%Gain price (btw)

The percent gain in share price from the beginning to ending report dates.  Differs from %Gain-F (between) in that distributions are not included.  The value reported for the portfolio is the average.

%Gain price (inception)

%Gain price (end)

The percent gain in share price from the price inception date to ending report dates.  Differs from %Gain-F (inception) in that distributions are not included.  The value reported for the portfolio is the average.

%Gain-F (between)

%Gain-F (btw)

The percent gain in NAV from the beginning to ending report dates. For all the % Gain-F figures the portfolio numbers are averages.

%Gain-F (inception)

%Gain-F (end)

The percent gain in NAV from the price inception date to the ending report date.

%Gain-F 1 year (ending)

%Gain-F (1y)

The percent gain in NAV for the specified time period prior to the ending report date.

%Gain-F 10 years (ending)

%Gain-F (10y)

%Gain-F 3 months (ending)

%Gain-F (3m)

%Gain-F 3 years (ending)

%Gain-F (3y)

%Gain-F 5 years (ending)

%Gain-F (5y)

%Gain-F 6 months (ending)

%Gain-F (6m)

%Gain-I (between)

%Gain-I (btw)

The percent gain on investment from the beginning to ending report dates. If there are no transactions, this performance figure is not applicable and is reported as "N.A.".

%Gain-I (inception)

%Gain-I (end)

The percent gain on investment from the inception date to the ending report date. If there are no transactions, this performance figure is not applicable and is reported as "N.A.".

%Gain-I 1 year (ending)

%Gain-I (1y)

The percent gain on investment for the specified time period prior to the ending report date. If there are no transactions, this performance figure is not applicable and is reported as "N.A.".

%Gain-I 10 years (ending)

%Gain-I (10y)

%Gain-I 3 months (ending)

%Gain-I (3m)

%Gain-I 3 years (ending)

%Gain-I (3y)

%Gain-I 5 years (ending)

%Gain-I (5y)

%Gain-I 6 months (ending)

%Gain-I (6m)

%Gain-V (between)

%Gain-V (btw)

The percent gain of value from the beginning to ending report dates. If the beginning value is zero, this figure is not applicable and is reported as "N.A.".

%Gain-V (inception)

%Gain-V (end)

The percent gain of value from the inception date to the ending report date.

%Gain-V 1 year (ending)

%Gain-V (1y)

The percent gain of value for the specified time period prior to the ending report date. If the beginning value is zero, this figure is not applicable and is reported as "N.A.".

%Gain-V 10 years (ending)

%Gain-V (10y)

%Gain-V 3 months (ending)

%Gain-V (3m)

%Gain-V 3 years (ending)

%Gain-V (3y)

%Gain-V 5 years (ending)

%Gain-V (5y)

%Gain-V 6 months (ending)

%Gain-V (6m)

Account

Account

Account number assigned for investment or portfolio property

Account Fee distributions (between)

Acct Fee dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

Account Fee distributions per share (between)

Acct Fee dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Account of parent portfolio

Parent account

Account number of the containing (parent) portfolio

Accounting method

Accounting method

The investment's accounting method property

Accrued interest (beginning)

Accrued interest (beg)

Amount of accrued interest as of the beginning report date

Accrued interest (between)

Accrued interest (btw)

Change in accrued interest between starting and ending report dates.

Accrued interest (btw) = Accrued interest (end) - Accrued interest (beg)

Accrued interest (ending)

Accrued interest (end)

Amount of accrued interest as of the ending report date

Accrued interest days (beginning)

Accrued interest days (beg)

Number of days interest has accrued as of the beginning report date

Accrued interest days (ending)

Accrued interest days (end)

Number of days interest has accrued as of the ending report date

Alert count (active)

#Alerts active

Number of active alerts

Alert count (complete)

#Alerts complete

Number of completed alerts

Alert count (expired)

#Alerts expired

Number of expired alerts

Alert distance (ending)

Alert distance

Difference between actual price and closest active alert trigger price on ending report date

Alert distance percentage (ending)

Alert distance %

Percentage change required from actual price before reaching the closest active alert trigger price on ending report date

Alert trigger price (ending)

Alert trigger

Closest active alert trigger price on ending report date

Alpha (ending)

Alpha (end)

Alpha as of the ending report data.  See Benchmark and Alpha Calculation.

Alternate Symbol

Alt-Symbol

Investment property of alternative symbol to use when Use Alternate Symbol When Retrieving from Historical Quote Server is enabled

Asset type

Asset type

The largest percentage asset type

Average out of pocket purchase price (current)

Avg purchase price-C (end)

Average out of pocket purchase price for the shares still owned on the ending report date. Does not include reinvestments.

Average purchase price (between)

Avg purchase price (btw)

Average purchase price of each share bought with purchases and reinvestments between the beginning and ending (inclusive) report dates

Average redemption price (between)

Avg redemption price (btw)

Average redemption price of each share sold between the beginning and ending (inclusive) report dates

Average Value (between)

Avg value

Average value between the starting and ending report dates (inclusive). Weekends are ignored.

Average Volume (between)

Avg volume

Average trading volume between the starting and ending report dates (inclusive)

Beta (ending)

Beta (end)

Beta as of the ending report data.  See Benchmark and Beta Calculation.

Bond term

Bond term

Number of years from the ending report date to the maturity date for investments with their income style set to "Bond Interest".  Weighted by face value for non-investment calculations.

Change in price (between)

NAV change (btw)

The change in closing share price from the report starting date through the report ending date

Change in price from previous

NAV change

The change in closing share price from the ending report date to the previous day

Change in value (between)

Value change (btw)

The change in value from the report starting date through the report ending date

Change in value from previous

Value change

The change in value from the ending report date to the previous day

Commission fees (between)

Comm fees (btw)

Sum of all commission fees paid on transactions between the beginning and ending (inclusive) report dates.

Commission fees per share (between)

Comm fees /s (btw)

Sum of all per share commission fees paid on transactions between the beginning (inclusive) and ending (inclusive) report dates. Sum is reported in fees/share.

Contributions (between)

Contributions (btw)

Value added between the beginning and ending (inclusive) report dates.  See External Cash Flow.

Correlation (ending)

Correlation (end)

Correlation coefficient as of the ending report data.  See Benchmark and Correlation.

Coupon rate

Coupon rate

Coupon rate of investments with their income style set to "Bond Interest"

Currency

Currency N (D)

Both the Native currency and the currency currently being Displayed.

Current yield

Current yield

Current Yield for investments with an assigned income style.  The "current yield" is defined as the annual payout as a percent of the market price on the ending report date.  For example, if a bond has a coupon rate of 8% and the current bond's share price is 95, the current yield is 8.42%.

CUSIP

CUSIP

Investment property: "CUSIP"

<Custom Investment Properties>

 

Each custom investment property is available.  The field name and column name both use the assigned label in the Custom Investment Properties Dialog.

Date acquired, end (ending)

Acquired end (end)

End of date range the shares owned on the ending report date were acquired. Uses the first in first out accounting method.

Date acquired, start (ending)

Acquired start (end)

Start of date range the shares owned on the ending report date were acquired. Uses the first in first out accounting method.

Date owned, end (between)

Owned end (btw)

End of date range shares were owned within the report's date range

Date owned, start (between)

Owned start (btw)

Start of date range shares were owned within the report's date range

Day count, down (between)

#Days down (btw)

Number of "down" days between the beginning and ending (inclusive) report dates.  For investments/symbols, this is the change in price, for all other calculations, value is used.  The calculation ignores weekends.

Day count, flat (between)

#Days flat (btw)

Number of "flat" days between the beginning and ending (inclusive) report dates.  For investments/symbols, this is the change in price, for all other calculations, value is used.  The calculation ignores weekends.

Day count, up (between)

#Days up (btw)

Number of "up" days between the beginning and ending (inclusive) report dates.  For investments/symbols, this is the change in price, for all other calculations, value is used.  The calculation ignores weekends.

Default cash account

Def Cash

The assigned default cash account. As asterisk after the account name indicates multiple cash accounts are assigned.

Description

Description

For investments their "Description" field, for sub-portfolios their "Memo" field

Distributed dist. per share (between)

Dist dist /s (btw)

Sum of all per share distributed distributions received between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Distributed dist. per share (current)

Dist dist-C /s (end)

Sum of all per share distributed distributions received by only the shares owned on the ending report date. Sum is reported in distributions/share.

Distributed distributions (between)

Dist dist (btw)

Sum of all distributed distributions received between the beginning and ending (inclusive) report dates

Distributed distributions (current)

Dist dist-C (end)

Sum of all distributed distributions received by only the shares owned on the ending report date.

Distribution transaction count (between)

#Dist (btw)

Number of distributions recorded between the beginning and ending (inclusive) report dates

Distribution transaction count (total)

#Dist (all)

Total number of distributions recorded

Dividend yield (between)

Div yld (btw)

The annualized dividend yield earned for the date range of the report. Distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates are included in the calculation. The value is a percentage.

Dividend yield (inception)

Div yld (end)

The annualized dividend yield earned from inception to the ending report date. Distributions (distributed and reinvested) from inception to the ending report date, inclusive, are included in the calculation. The value is a percentage.

Dividend distributions (between)

Div dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

Dividend distributions per share (between)

Div dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in dividends/share.

Exchange rate (beginning)

Beg Exchange

Exchange rate to the default currency at the start of the beginning report date. (This is the rate from the date prior to the report's starting date.)

Exchange rate (ending)

End Exchange

Exchange rate to the default currency on the ending report date

Exempt from management fees

Fee exempt

Investment property Exempt From Management Fees

Expected dividend yield (ending)

Exp div yld (end)

Annualized dividend yield expected to be earned in the future.  The value is a percentage.  Calculation is based on the ending share price, the last received dividend amount, and frequency of dividends.  If the investment's properties have specified a dividend income style then the number of payments per year is used for the frequency of dividends.  Otherwise, the frequency of prior recorded dividends is used.  In this case, possible frequencies are 1 year, semi-annually, quarterly, or monthly.  Defaults to quarterly if only a single dividend is recorded.

Face value

Face value

Face value of investments with their income style set to "Bond Interest".  See Recording Bond Transactions.

Filename

Filename

The investment filename

Foreign Tax distributions (between)

Frgn tax dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

Foreign Tax distributions per share (between)

Frgn tax dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Gain (between)

Gain (btw)

The value gained from the report starting date through the report ending date.

Gain (btw) = End value + Dist dist (btw) - Beg value - Invested (btw)
or
Gain (btw) = End value + Withdrawals (btw) +
Withdrawn dist (btw) - Contributions (btw) - Beg value

Gain (current)

Gain-C (end)

The value gained by only the shares still owned on the ending report date. (Gain-C (end) = End value - OOP-C basis (end))

Gain (inception)

Gain (end)

The value gained from inception through the report ending date. (Gain (end) = End value - OOP basis (end))

Gain due to exchange rate (between)

Gain ER (btw)

The portion of gain (Gain (btw)) due to exchange rate from the beginning to ending report dates. Excludes the portion of the gain due to market appreciation. (Gain (btw) = Gain MA (btw) + Gain ER (btw))  [more info]

Gain due to exchange rate (inception)

Gain ER (end)

The portion of gain (Gain (end)) due to exchange rate from inception through the report ending date. Excludes the portion of the gain due to market appreciation. (Gain (end) = Gain MA (end) + Gain ER (end))  [more info]

Gain due to market appreciation (between)

Gain MA (btw)

The portion of gain (Gain (btw)) due to market appreciation from the beginning to ending report dates. Excludes the portion of the gain due to exchange rate. (Gain (btw) = Gain MA (btw) + Gain ER (btw))  [more info]

Gain due to market appreciation (inception)

Gain MA (end)

The portion of gain (Gain (end)) due to market appreciation from inception through the report ending date. Excludes the portion of the gain due to exchange rate. (Gain (end) = Gain MA (end) + Gain ER (end))  [more info]

Gain per share (between)

Gain/s (btw)

The per share value gained from the report starting date through the report ending date. (Gain/s (btw) = End NAV + Total dist /s (btw) - Beg NAV)

Gain per share (inception)

Gain/s (end)

The per share value gained from price inception (NAV incptn) through the report ending date. (Gain/s (end) = End NAV + Total dist /s (end) - Beg NAV)

Gain per share due to exchange rate (between)

Gain/s ER (btw)

The portion of per share value gain (Gain/s (btw)) due to exchange rate from the beginning to ending report dates. Excludes the portion of the gain due to market appreciation. (Gain/s (btw) = Gain/s MA (btw) + Gain/s ER (btw))  [more info]

Gain per share due to exchange rate (inception)

Gain/s ER (end)

The portion of per share value gain (Gain/s (end)) due to exchange rate from price inception (NAV incptn) through the report ending date. Excludes the portion of the gain due to market appreciation. (Gain/s (end) = Gain/s MA (end) + Gain/s ER (end))  [more info]

Gain per share due to market appreciation (between)

Gain/s MA (btw)

The portion of per share value gain (Gain/s (btw)) due to market appreciation from the beginning to ending report dates. Excludes the portion of the gain due to exchange rate. (Gain/s (btw) = Gain/s MA (btw) + Gain/s ER (btw))  [more info]

Gain per share due to market appreciation (inception)

Gain/s MA (end)

The portion of per share value gain (Gain/s (end)) due to market appreciation from price inception (NAV incptn) through the report ending date. Excludes the portion of the gain due to exchange rate. (Gain/s (end) = Gain/s MA (end) + Gain/s ER (end))  [more info]

Gain_AI (between)

Gain_AI (btw)

The value gained including accrued interest from the report starting date through the report ending date. (Gain_AI (btw) = End value + End accrued interest + Dist dist (btw) - Beg value - Beg accrued interest - Invested (btw))

Hidden

Hidden

Whether an investment or portfolio is marked as hidden

High (beginning)

Beg high

Highest trading price on the beginning report date

High (ending)

End high

Highest trading price on the ending report date

Highest Close (between)

Highest NAV

Highest closing price between starting and ending report dates (inclusive)

Highest High (between)

Highest High

Highest high price between starting and ending report dates (inclusive)

Highest value (between)

Highest value

Highest value between the beginning and ending report dates (inclusive)

Historical price count (between)

#Prices (btw)

Number of price points recorded between the beginning and ending (inclusive) report dates

Historical price count (total)

#Prices (all)

Total number of price points recorded

Historical quote server

Historical server

Historical quote server assigned for retrieving prices

Ignore when reconciling

Recon. ignore

Whether an investment is marked to ignore when reconciling

Income style

Income style

The income style investment property (No Income, Bond Interest, or Dividends)

Interest Income distributions (between)

Int Inc dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

Interest Income distributions per share (between)

Int Inc dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Invert retrieved price

Invert price

Investment property to invert when retrieving

Invested (between)

Invested (btw)

Net out of pocket contributions made by the investor. The sum of all purchases minus all redemptions within the specified date range. (Does not include reinvested distributions.)  Includes OOP cost of Transfer In transactions.  Transfer Out transactions reduce this amount by the OOP cost transferred out.

Investment goal

Investment goal

The largest percentage investment goal

Investment inception date

Inv incptn

Date of first transaction

Investment stack order

Stack #

The order in the investment stack (the first investment is number 1)

Investment type

Investment type

The investment type (Stock, Mutual Fund, etc...)

Last purchase price

Last purchase price

Last share price paid from either a purchase or reinvestment, independent of report dates

Last redemption price

Last redemption price

Last share price received from a redemption, independent of report dates

Latest distribution date

Last dist

Date of last distribution

Latest price date

Last price

Date of latest recorded price

Latest purchase date

Last buy

Date of last purchase

Latest reconciled date

Last reconciled

Date last reconciled

Latest redemption date

Last sell

Date of last redemption

Latest transaction date

Last tran

Date of last transaction (purchase, redemption, transfer, or distribution)

Long term cap. gains per share (between)

LTCG /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in dividends/share.

Long term capital gains (between)

LTCG (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

Losing investment count (between)

Losers

The number of losing investments as determined by a negative gain (Gain_AI (between)) between the beginning and ending report dates

Lots fully specified

Specified

Have all the lots been fully specified.  This is required in order to report capital gains using the Specific Lot method.

Low (beginning)

Beg low

Lowest trading price on the beginning report date

Low (ending)

End low

Lowest trading price on the ending report date

Lowest Close (between)

Lowest NAV

Lowest closing price between starting and ending report dates (inclusive)

Lowest Low (between)

Lowest Low

Lowest low price between starting and ending report dates (inclusive)

Lowest value (between)

Lowest value

Lowest value between the beginning and ending report dates (inclusive)

LT Cap Gain distributions (between)

LTCapGn dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

LT Cap Gain distributions per share (between)

LTCapGn dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Management Fee Method

Fee Method

Method used to calculate management fees

Maturity date

Maturity date

Maturity date of investments with their income style set to "Bond Interest"

Maximum drawdown

Maximum drawdown

The maximum drawdown of the share price between the beginning and ending report dates (inclusive)

Medium term cap. gains per share (between)

MTCG /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in dividends/share.

Medium term capital gains (between)

MTCG (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

Moving average 1 week (ending)

MA 1W

The share price moving average for the specified number of weeks prior to the ending report date.

Moving average 10 weeks (ending)

MA 10W

Moving average 15 weeks (ending)

MA 15W

Moving average 20 weeks (ending)

MA 20W

Moving average 25 weeks (ending)

MA 25W

Moving average 26 weeks (ending)

MA 26W

Moving average 30 weeks (ending)

MA 30W

Moving average 35 weeks (ending)

MA 35W

Moving average 40 weeks (ending)

MA 40W

Moving average 45 weeks (ending)

MA 45W

Moving average 5 weeks (ending)

MA 5W

Moving average 50 weeks (ending)

MA 50W

Moving average 52 weeks (ending)

MA 52W

MT Cap Gain distributions (between)

MTCapGn dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

MT Cap Gain distributions per share (between)

MTCapGn dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Next income date

Next income date

Date after ending report date the next income payment is expected.  Income is determined from the income style investment property.

Next income value

Next income value

Value of the next expected income payment.  Income is determined from the income style investment property.

Normalized standard deviation of price (between)

Std dev % (btw)

The standard deviation divided by the average share price between the beginning and ending report dates (inclusive). For the portfolio total line, the end value weighted average is shown.  See also: Standard deviation of price

Normalized standard deviation of price (inception)

Std dev % (incptn)

The standard deviation divided by the average share price from the NAV inception to the ending report date (inclusive). For the portfolio total line, the end value weighted average is shown.  See also: Standard deviation of price

Note count (between)

#Notes (btw)

Number of notes recorded between the beginning and ending (inclusive) report dates

Note count (total)

#Notes (all)

Total number of notes recorded for this investment

OOP basis per share (current)

OOP-C basis /s (end)

Current average out of pocket cost for each share owned on the ending report date (OOP-C basis (end)/End shares). The cost is calculated for only the shares still owned on the ending date.

OOP basis per share (inception)

OOP basis /s (end)

Historical average out of pocket cost for each share owned on the ending report date (OOP basis (end)/End shares). The cost is calculated from inception to the ending report date. This figure may be different than Tax basis /s (end).

OOP Gain per share (current)

Gain-C /s (end)

The out of pocket per share value gained by only the shares still owned on the ending report date. ((Gain-C /s (end) = End NAV - OOP-C basis /s (end))

OOP Gain per share (historical)

Gain-H /s (end)

The out of pocket per share value gained from inception through the report ending date. ((Gain-H /s (end) = End NAV - OOP basis /s (end))

Open (beginning)

Beg open

Opening price on the beginning report date

Open (ending)

End open

Opening price on the ending report date

Other distributions (between)

Other dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

Other distributions per share (between)

Other dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Out of pocket basis (between)

OOP basis (btw)

Out of pocket cost basis for the report date range: out of pocket contributions plus the beginning value (OOP invested (btw) + Beg value). This figure is your break-even value over the report date range.

Out of pocket basis with AI (between)

OOP basis_AI (btw)

Out of pocket cost basis for the report date range including accrued interest: out of pocket contributions plus the beginning value plus beginning accrued interest (OOP invested (btw) + Beg value + Beg accrued interest). This figure is your break-even value over the report date range when factoring in accrued interest.

Out of pocket basis (current)

OOP-C basis (end)

Total out of pocket contributions (contributions - distributed distributions) for only the shares currently held as of the ending report date. This is your break even value for the shares held on the ending report date.

Out of pocket basis (ending)

OOP basis (end)

Total out of pocket contributions (contributions - withdrawals - distributed distributions) made from inception to the ending report date, inclusive. This figure is your break-even value over the full history.

Out of pocket invested (between)

OOP invested (btw)

Total out of pocket contributions (contributions - withdrawals - distributed distributions) made between the beginning and ending (inclusive) report dates.

Owner

Owner

Name of client that owns this item

Password enabled

Password

Whether or not password protection is enabled

Path and filename

Path

The investment path and filename

Payment frequency

Payment frequency

Payment frequency of investments with their income style set to "Bond Interest"

Percent change in value from previous

% value change

The percent change in value from the ending report date to the previous day. Formula: 100.0 * (end - previous) / previous

Percentage of parent object (beginning)

Beg % parent

The percentage of the immediate parent object.  The parent object can be either a sub-total or the report portfolio when sub-totals are off.  The parent of a sub-portfolio is the containing sub-portfolio.  For link sub-portfolios, the parent of the link target is used (not the parent of the link).  The parent object of sub-total lines that are not sub-portfolios is the report sub-portfolio.  Percentage is on the beginning report date.

Percentage of parent object (ending)

End % parent

Percentage is on the ending report date.  See notes above for Beg % parent.

Percentage of portfolio (beginning)

Beg %port

The percentage of the total portfolio value on the beginning report date

Percentage of portfolio (ending)

End %port

The percent of the total portfolio value on the ending report date

Portfolio hierarchy

Portfolio hierarchy

The location in the portfolio hierarchy

Portfolio parent

Portfolio parent

Name of the containing (parent) portfolio

Price inception date

NAV incptn

Date of first recorded price

Price multiplier

Price multiplier

Investment's multiplication factor for retrieved prices

Price trend

Price trend

Daily price change for the last 7 days, up to the ending report date.  Each day is represented as '+', '-', or '=' with the latest change on the right.  Weekends are ignored.

Projected annual income

Projected annual income

Expected income for the next year after the ending report date.  Income is calculated based off income investment property.

Purchase transaction count (between)

#Buy (btw)

Number of purchase transactions recorded between the beginning and ending (inclusive) report dates

Purchase transaction count (total)

#Buy (all)

Total number of purchase transactions recorded, not including reinvestments

Purchases (between)

Purchases (btw)

Sum of all out of pocket purchases plus reinvestments between the beginning and ending (inclusive) report dates.  Amount includes any commissions paid.

Purchases out of pocket (between)

Purchases-OOP (btw)

Sum of all out of pocket purchases (does not include reinvestments) between the beginning and ending (inclusive) report dates.  Amount includes any commissions paid.

Purchases out of pocket (current)

Purchases-C (end)

Sum of all out of pocket purchases for the shares still owned on the ending report date. Does not include reinvestments

Quote server

Quote server

Quote server assigned for retrieving prices

R-Squared (ending)

R-Squared (end)

R-Squared as of the ending report data.

Redemptions (between)

Redemptions (btw)

Sum of all redemptions between the beginning and ending (inclusive) report dates.  Amount is sell value, before subtracting off any commissions.  Does not include any negative reinvestments or transfer outs.

Redemptions out of pocket (between)

Redemptions-OOP (btw)

Sum of all redemptions between the beginning and ending (inclusive) report dates. Amount is out of pocket value, after subtracting off any commissions. Does not include any negative reinvestments or transfer outs.

Reinvested dist. per share (between)

Reinv dist /s (btw)

Sum of all per share reinvested distributions received between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Reinvested dist. per share (current)

Reinv dist-C /s (end)

Sum of all per share reinvested distributions by only the shares owned on the ending report date. Sum is reported in distributions/share.

Reinvested distributions (between)

Reinv dist (btw)

Sum of all reinvested distributions between the beginning and ending (inclusive) report dates

Reinvested distributions (current)

Reinv dist-C (end)

Sum of all reinvested distributions by only the shares owned on the ending report date

Retained dist. distributions (between)

Retained dist (btw)

Retained distributed distributions between the beginning and ending (inclusive) report dates.  See External Cash Flow.

Retrieve price

Retrieve price

Whether an investment is set to retrieve prices from the internet

Return of Capital distributions (between)

RtrnCap dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

Return of Capital distributions per share (between)

RtrnCap dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

ROI yield (between)

ROI (btw)

The ROI yield from the beginning to ending report dates. If a price has not been recorded for the beginning of the yield term, Fund Manager will try to interpolate one, up to your specified interpolation range. If an interpolated price is used for the calculation, an asterisk (*) will be displayed next to the yield.

ROI yield (inception)

ROI (end)

The ROI yield starting on the investment inception date (earliest transaction) through the ending report date. (For the total portfolio figure the earliest inception date of all investments is used for the beginning date.)

ROI yield (owned between)

ROI (own-btw)

The ROI yield for the period shares were owned between the beginning and ending report dates.  If shares were owned for multiple periods the date range spans all ownership periods within the report dates.  To view these dates use Date owned, start (between) and Date owned, end (between).  If an interpolated price is used for the calculation, an asterisk (*) will be displayed next to the yield.

ROI yield 1 year (ending)

ROI (1y)

The ROI yield for the specified time period prior to the ending report date. If a price has not been recorded for the beginning of the yield term, Fund Manager will try to interpolate one, up to your specified interpolation range.

ROI yield 10 years (ending)

ROI (10y)

ROI yield 3 months (ending)

ROI (3m)

ROI yield 3 years (ending)

ROI (3y)

ROI yield 5 years (ending)

ROI (5y)

ROI yield 6 months (ending)

ROI (6m)

Sector

Sector

The largest percentage sector

Sell transaction count (between)

#Sell (btw)

Number of sell transactions recorded between the beginning and ending (inclusive) report dates

Sell transaction count (total)

#Sell (all)

Total number of sell transactions recorded

Share price (beginning)

Beg NAV

Share price at the start of the beginning report date. (This is the closing price from the date prior to the report's starting date.)

Share price (ending)

End NAV

Share price on the ending report date

Share price native (ending)

End NTV NAV

Share price (always in the native currency) on the ending report date. Price is always displayed in the assigned currency, independent of whether Exchange Rate Adjusted is on or off.

Share price plus dist. (beginning)

Beg NAV+D

Share price plus sum of all previous distributions on the beginning report date

Share price plus dist. (ending)

End NAV+D

Share price plus sum of all previous distributions on the ending report date

Shares (beginning)

Beg shares

Number of shares owned at the start of the beginning report date. (This is the number owned at the close of the date prior to the report's starting date.)

Shares (ending)

End shares

Number of shares owned on the ending report date

Shares acquired (between)

Acquired shares

Total change in share balance between start and end report dates (inclusive)

Shares purchased (between)

Purchased shares

Number of shares purchased between starting and ending report dates (inclusive). Shares are adjusted for splits.

Shares redeemed (between)

Redeemed shares

Number of shares redeemed between starting and ending report dates (inclusive)

Shares reinvested (between)

Reinvested shares

Number of shares reinvested between starting and ending report dates (inclusive)

Sharpe Ratio (ending)

Sharpe Ratio (end)

Sharpe Ratio as of the ending report data.  See Benchmark and Sharpe Ratio.

Skip historical quote server

Skip hist server

Investment property Skip Retrieving From Historical Quote Server

Skip primary quote server

Skip primary server

Investment property Skip Retrieving From Primary Quote Server

Split factor, composite (between)

Split * (btw)

The composite split factor for all splits between the beginning and ending (inclusive) report dates. For example, if there were two splits during the period of 2:1 and 3:1, this value would be reported as 6:1.

Split factor, composite (inception)

Split * (end)

The composite split factor for all splits from the price inception date to the ending report date.

Split transaction count (between)

#Splits (btw)

Number of splits recorded between the beginning and ending (inclusive) report dates

Split transaction count (total)

#Splits (all)

Total number of splits recorded

ST Cap Gain distributions (between)

STCapGn dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

ST Cap Gain distributions per share (between)

STCapGn dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Standard deviation of price (between)

Std dev (btw)

The standard deviation of the share price between the beginning and ending report dates (inclusive). For the portfolio total line, the end value weighted average is shown.  See also: "Normalized standard deviation of price" and "Standard deviation of returns".

Standard deviation of price (inception)

Std dev (incptn)

The standard deviation of the share price from the NAV inception to the ending report date (inclusive). For the portfolio total line, the end value weighted average is shown.  See also: "Normalized standard deviation of price" and "Standard deviation of returns".

Standard deviation of returns (ending)

Std dev returns (end)

The standard deviation of monthly returns as of the ending report date.  See Standard Deviation of Returns.

Standard deviation of returns annualized (ending)

Std dev returns annualized (end)

The annualized standard deviation of monthly returns as of the ending report date.  See Standard Deviation of Returns.

Symbol

Symbol

The investment symbol

Tax basis per share, Assigned Method

Tax basis /s Assigned

The per share tax cost basis. The basis is calculated using the assigned accounting method of each investment.  When calculating for a combined object, such as symbol, asset type, sub-portfolio, etc, this field will only be reported if all investments in that object have the same assigned accounting method.

Tax basis per share, AVG (ending)

Tax basis /s AVG (end)

The per share tax cost basis for the shares owned on the ending report date. The cost basis is calculated using the average cost accounting method.

Tax basis per share, FIFO (ending)

Tax basis /s FIFO (end)

The per share tax cost basis for the shares owned on the ending report date. (The per share amount initially spent to obtain the shares owned on the ending report date, including purchase commission/load.) The cost basis is calculated using the first in first out accounting method. This amount may be different than OOP-C basis /s (end) because of distributions.

Tax basis per share, Specific Lot

Tax basis /s ID

The per share tax cost basis for the currently owned shares. The cost basis is calculated using the specific lot accounting method.

Tax basis realized gain LT, Assigned Method (between)

Tax rlz gain LT Assigned (btw)

The long term (LT) realized taxable gains within the report's date range. The calculation uses the assigned accounting method of each investment.  See also: Capital Gains Report.

Tax basis realized gain MT, Assigned Method (between)

Tax rlz gain MT Assigned (btw)

The medium term (MT) realized taxable gains within the report's date range. The calculation uses the assigned accounting method of each investment.  See also: Capital Gains Report.

Tax basis realized gain ST, Assigned Method (between)

Tax rlz gain ST Assigned (btw)

The short term (ST) realized taxable gains within the report's date range. The calculation uses the assigned accounting method of each investment.  See also: Capital Gains Report.

Tax basis realized gain, Assigned Method (between)

Tax rlz gain Assigned (btw)

The realized taxable gains within the report's date range. The calculation uses the assigned accounting method of each investment.  Gains for all holding terms are included.  See also: Capital Gains Report.

Tax basis realized gain, Assigned Method (inception)

Tax rlz gain Assigned (incptn)

The realized taxable gains from inception through the ending report date. The calculation uses the assigned accounting method of each investment.  Gains for all holding terms are included.  See also: Capital Gains Report.

Tax basis realized gain, AVG (between)

Tax rlz gain AVG (btw)

The realized taxable gains within the report's date range. The calculation uses the average cost accounting method.  Gains for all holding terms are included.  See also: Capital Gains Report.

Tax basis realized gain, AVG (inception)

Tax rlz gain AVG (incptn)

The realized taxable gains from inception through the ending report date. The calculation uses the average cost accounting method.  Gains for all holding terms are included.  See also: Capital Gains Report.

Tax basis realized gain, FIFO (between)

Tax rlz gain FIFO (btw)

The realized taxable gains within the report's date range. The calculation uses the first in first out accounting method.  Gains for all holding terms are included.  See also: Capital Gains Report.

Tax basis realized gain, FIFO (inception)

Tax rlz gain FIFO (incptn)

The realized taxable gains from inception through the ending report date. The calculation uses the first in first out accounting method.  Gains for all holding terms are included.  See also: Capital Gains Report.

Tax basis realized gain, Specific Lot (between)

Tax rlz gain ID (btw)

The realized taxable gains within the report's date range. The calculation uses the specific lot accounting method.  Gains for all holding terms are included.  See also: Capital Gains Report.

Tax basis realized gain, Specific Lot (inception)

Tax rlz gain ID (incptn)

The realized taxable gains from inception through the ending report date. The calculation uses the specific lot accounting method.  Gains for all holding terms are included.  See also: Capital Gains Report.

Tax basis unrealized gain per share, Assigned Method

Tax unrlz gain/s Assigned

The per share unrealized taxable gains. The gain is calculated using the assigned accounting method of each investment.

Tax basis unrealized gain per share, AVG (ending)

Tax unrlz gain/s AVG (end)

The per share unrealized taxable gains for the shares owned on the ending report date (End NAV - Tax basis /s AVG (end))

Tax basis unrealized gain per share, FIFO (ending)

Tax unrlz gain/s FIFO (end)

The per share unrealized taxable gains for the shares owned on the ending report date (End NAV - Tax basis /s FIFO (end))

Tax basis unrealized gain per share, Specific Lot

Tax unrlz gain/s ID

The per share unrealized taxable gains for the currently owned shares. The cost basis is calculated using the specific lot accounting method.

Tax basis unrealized gain LT, Assigned Method

Tax unrlz gain LT Assigned

The unrealized long term (LT) taxable gains. The gain is calculated using the assigned accounting method of each investment.

Tax basis unrealized gain MT, Assigned Method

Tax unrlz gain MT Assigned

The unrealized medium term (MT) taxable gains. The gain is calculated using the assigned accounting method of each investment.

Tax basis unrealized gain ST, Assigned Method

Tax unrlz gain ST Assigned

The unrealized short term (LT) taxable gains. The gain is calculated using the assigned accounting method of each investment.

Tax basis unrealized gain, Assigned Method

Tax unrlz gain Assigned

The unrealized taxable gains. Gains for all holding terms are included.  The gain is calculated using the assigned accounting method of each investment.

Tax basis unrealized gain, AVG (ending)

Tax unrlz gain AVG (end)

The unrealized taxable gains for the shares owned on the ending report date (End value - Tax basis AVG (end))

Tax basis unrealized gain, FIFO (ending)

Tax unrlz gain FIFO (end)

The unrealized taxable gains for the shares owned on the ending report date (End value - Tax basis FIFO (end))

Tax basis unrealized gain, Specific Lot

Tax unrlz gain ID

The unrealized taxable gains for the currently owned shares. The cost basis is calculated using the specific lot accounting method.

Tax basis, Assigned Method

Tax basis Assigned

Tax cost basis. The cost basis is calculated using the assigned accounting method of each investment.

Tax basis, AVG (ending)

Tax basis AVG (end)

Tax cost basis for the shares owned on the ending report date. The cost basis is calculated using the average cost accounting method.

Tax basis, FIFO (ending)

Tax basis FIFO (end)

Tax cost basis for the shares owned on the ending report date.  The cost basis is calculated using the first in first out accounting method.

Tax basis, Specific Lot

Tax basis ID

Tax cost basis for the currently owned shares. The cost basis is calculated using the specific lot accounting method.

Tax free

Tax free

Whether an investment is marked with the tax-free property

Time-weighted return (between)

TWR (btw)

The Time-Weighted Return from the beginning to ending report dates.  If a price has not been recorded for the beginning of the yield term, Fund Manager will try to interpolate one, up to your specified interpolation range.  If an interpolated price is used for the calculation, an asterisk (*) will be displayed next to the yield.

Time-weighted return (inception)

TWR (end)

The Time-Weighted Return starting a day after the inception date (earliest transaction, or earliest price if there are no transactions) through the ending report date.

Time-weighted return 1 year (ending)

TWR (1y)

The Time-Weighted Return for the specified time period prior to the ending report date.  If a price has not been recorded for the beginning of the yield term, Fund Manager will try to interpolate one, up to your specified interpolation range.

Time-weighted return 10 years (ending)

TWR (10y)

Time-weighted return 3 months (ending)

TWR (3m)

Time-weighted return 3 years (ending)

TWR (3y)

Time-weighted return 5 years (ending)

TWR (5y)

Time-weighted return 6 months (ending)

TWR (6m)

Total distributions (between)

Total dist (btw)

Sum of all distributions (all types, distributed and reinvested) between the beginning and ending (inclusive) report dates.

Total distributions (current)

Total dist-C (end)

Sum of all distributions (all types, distributed and reinvested) received by only the shares owned on the ending report date

Total distributions per share (between)

Total dist /s (btw)

Sum of all per share distributions (all types, distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Total distributions per share (current)

Total dist-C /s (end)

Sum of all per share distributions (all types, distributed and reinvested) received by only the shares owned on the ending report date. Sum is reported in distributions/share.

Transaction entry preference

Transaction entry

The investment's transaction entry preference

Transaction retrieve

Transaction retrieve

The name of the broker or fund company being retrieved from for a sub-portfolio if "Retrieve Transactions" is enabled.  Blank for sub-portfolios not marked to retrieve.  Investments will display the broker/fund company name if they belong to a sub-portfolio marked for retrieve.  If an investment belongs to more than one sub-portfolio marked for retrieval, this field will be shown as "<multiple>" (this usually indicates a configuration problem, as an investment shouldn't be retrieved from more than one source).

Transfers In, market value (between)

Transfers In (btw)

Market value of all Transfer In transactions between the beginning and ending (inclusive) report dates

Transfers In, OOP (between)

Transfers In-OOP (btw)

Out of pocket value of all Transfer In transactions between the beginning and ending (inclusive) report dates

Transfers Out, market value (between)

Transfers Out (btw)

Market value of all Transfer Out transactions between the beginning and ending (inclusive) report dates

Transfers Out, OOP (between)

Transfers Out-OOP (btw)

Out of pocket value of all Transfer Out transactions between the beginning and ending (inclusive) report dates

Turnover

Turnover

Annualized turnover between the beginning and ending (inclusive) report dates.  Lesser of purchases/redemptions divided by value.

Update price when retrieving transactions

TRN updts price

Investment property Update Price when Retrieving Transactions

Use Alternate Symbol for Hist. Quote Server

Use Alt-Symbol hist server

Investment property Use Alternate Symbol When Retrieving from Historical Quote Server

User-defined 1 distributions (between)

User-def 1 dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

User-defined 1 distributions per share (between)

User-def 1 dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

User-defined 2 distributions (between)

User-def 2 dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

User-defined 2 distributions per share (between)

User-def 2 dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

User-defined 3 distributions (between)

User-def 3 dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

User-defined 3 distributions per share (between)

User-def 3 dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

User-defined 4 distributions (between)

User-def 4 dist (btw)

Sum of all specified distribution type distributions (distributed and reinvested) between the beginning and ending (inclusive) report dates

User-defined 4 distributions per share (between)

User-def 4 dist /s (btw)

Sum of all specified distribution type distributions per share (distributed and reinvested) between the beginning and ending (inclusive) report dates. Sum is reported in distributions/share.

Value (beginning)

Beg value

Market value at the start of the beginning report date. (This is the closing value from the date prior to the report's starting date.)

Value (ending)

End value

Market value on the ending report date

Value + accrued interest (beginning)

Value_AI (beg)

Market value plus accrued interest at the start of the beginning report date. (This is the closing value from the date prior to the report's starting date.)

Value + accrued interest (ending)

Value_AI (end)

Market value plus accrued interest on the ending report date

Value native (ending)

End NTV value

Market value (always in the native currency) on the ending report date. Value is always displayed in the assigned currency, independent of whether Exchange Rate Adjusted is on or off.

Volume (beginning)

Beg volume

Trading volume on the beginning report date

Volume (ending)

End volume

Trading volume on the ending report date

Winning investment count (between)

Winners

The number of winning investments as determined by a positive gain (Gain_AI (between)) between the beginning and ending report dates

Winning investment percentage (between)

Winning %

The percentage of winning investments relative to the total number of winning + losing investments

Withdrawals (between)

Withdrawals (btw)

Value removed between the beginning and ending (inclusive) report dates.  See External Cash Flow.

Withdrawn dist. distributions (between)

Withdrawn dist (btw)

Withdrawn distributed distributions between the beginning and ending (inclusive) report dates.  See External Cash Flow.

Yield to maturity (YTM)

YTM

Yield To Maturity for investments with an income style of "bond interest".  The bond's "Yield To Maturity" (YTM) is reported as of the ending report date.

See Also

User-Defined Custom Report Fields

About Reports

Custom Settings Dialog

Report Settings Dialog

Report Window - Menu Commands

Report Preferences

Memorized Report Dialog

Report Colors

 


Fund Manager Home