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) |
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. |
User-Defined Custom Report Fields