This dialog is available in the Portfolio Editor by selecting the View / List Columns.... menu command, or right mouse click on the Portfolio Editor list view header, and choose Customize... from the popup menu.
This dialog allows you to customize which data fields are shown as columns in the Portfolio Editor. You can also adjust the order of the data fields.
You can also save different sets of columns to display to templates and then quickly switch between templates.
All available data fields are listed. To include a data field in the right hand side list view, place a check mark next to that field. To re-order the list, select a field, and choose the Move Up or Move Down buttons. To restore the program defaults for the list view, select the Reset button.
You can also re-order the columns in the Portfolio Editor list directly, by clicking and dragging a column's header to the new desired location. Fields that display numerical values are calculated for today's date. The following fields are available:
|
Name |
investment or sub-portfolio name |
|
Symbol |
investment symbol |
|
Type |
investment type (stock, mutual fund, etc...) |
| Currency | Assigned and displayed currency. Shown as "N (D)" where N is the native/assigned currency, and D is the displayed currency. |
| Description | investment description or sub-portfolio memo |
| Account # | investment or sub-portfolio account number |
| Investment Goal | Largest investment goal category for an investment or sub-portfolio. If the investment or sub-portfolio belongs to more than one investment goal an asterisk (*) will be displayed after the name of the largest investment goal. |
| Asset Type | Largest asset type category for an investment or sub-portfolio. If the investment or sub-portfolio belongs to more than one asset type an asterisk (*) will be displayed after the name of the largest asset type. |
| Sector | Largest sector category for an investment or sub-portfolio. If the investment or sub-portfolio belongs to more than one sector an asterisk (*) will be displayed after the name of the largest sector. |
| Password | whether or not the investment is password protected |
| Hidden | whether or not the investment or sub-portfolio is marked as hidden |
| Invert Prices | whether or not the investment is set to invert prices when retrieving |
| Transaction Entry | investment transaction entry preference |
| Retrieve Price | whether or not investment is set to retrieve prices, and if either the primary or historical servers are set to be skipped |
| Quote Server | investment quote server assignment or for sub-portfolios this is the default quote server |
| Historical Quote Server | investment historical quote server assignment or for sub-portfolios this is the default historical quote server |
| Alt HQS Symbol | displays any assigned alternate symbol to use when retrieving from the historical quote server |
| 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). |
| CUSIP | investment CUSIP or ISIN |
| Tax Free | whether or not investment is marked as tax-free |
| Accounting Method | investment's assigned accounting method |
| Income Style | investment's assigned income style |
| Maturity Date | maturity date for investments with an income style of "Bond Interest" |
| Coupon Rate | coupon rate for investments with an income style of "Bond Interest" |
| Payment Frequency | payment frequency for investments with an income style of "Bond Interest" |
| Issue Date | issue date for investments with an income style of "Bond Interest" and a payment frequency of "At maturity" |
| # Prices | number of recorded closing prices in either an investment or sub-portfolio |
| # Purchases | number of recorded purchase type transactions in either an investment or sub-portfolio |
| # Transfers In | number of recorded transfer in type transactions in either an investment or sub-portfolio |
| # Redemptions | number of recorded redemption type transactions in either an investment or sub-portfolio |
| # Transfers Out | number of recorded transfer out type transactions in either an investment or sub-portfolio |
| # Distributions | number of recorded distribution transactions (any type of distribution) in either an investment or sub-portfolio |
| # Splits | number of recorded split transactions in either an investment or sub-portfolio |
| # Notes | number of recorded investment notes in either an investment or sub-portfolio |
| Filesize | size of investment *.dat or portfolio *.mm4 file, in bytes |
| Location | full path of directory containing investment's *.dat or portfolio's *.mm4 file |
| Filename | filename for investment's *.dat or portfolio's *.mm4 file |
| Price | investment latest/closing price |
| Shares | number of shares owned in an investment |
| Value | market value of investment or sub-portfolio |
| Value Change | change in market value of investment or sub-portfolio from yesterday to today |
| Value Change-LD | Similar to Value Change, but the calculation end date is the date of the last recorded price data point (instead of today). "LD" stands for "Last Data". |
| Volume | investment trading volume |
| High | investment high price |
| Low | investment low price |
| Open | investment opening price |
| Change | change in investment price from yesterday to today |
| Change-LD | Similar to Change, but the calculation end date is the date of the last recorded price data point (instead of today). "LD" stands for "Last Data". |
| % Change | For investments this is the percentage change in price from yesterday to today. For sub-portfolios this is the percentage change in value from yesterday to today. |
| % Change-LD | Similar to % Change, but the calculation end date is the date of the last recorded price data point (instead of today). "LD" stands for "Last Data". |
| % of Portfolio | percentage of selected sub-portfolio on left hand side for investment or sub-portfolio |
| OOP Historical Basis | Total out of pocket contributions (purchases - redemptions - distributed distributions) made from inception through today, inclusive. This figure is your break-even value over the full history. |
| OOP Historical Basis Per Share | Per share value of historical OOP basis. (OOP Historical Basis / Shares) |
| OOP Historical Gain | Gain/loss from inception through today, inclusive. (Value - OOP Historical Basis) |
| OOP Historical Gain Per Share | Per share value of historical OOP gain. (OOP Historical Gain / Shares) |
| OOP Historical %Gain | Percent gain/loss from inception through today, inclusive. (OOP Historical Gain / OOP Historical Basis) |
| OOP Current Basis | Total out of pocket contributions (purchases - distributed distributions) for only the shares currently owned. This is your break even value for the shares held as of today. |
| OOP Current Basis Per Share | Per share value of current OOP basis. (OOP Current Basis / Shares) |
| OOP Current Gain | Gain/loss on shares currently owned. (Value - OOP Current Basis) |
| OOP Current Gain Per Share | Per share value of current OOP gain. (OOP Current Gain / Shares) |
| OOP Current %Gain | Percent gain/loss on shares currently owned. (OOP Current Gain / OOP Current Basis) |
| Basis | Tax cost basis for the shares currently owned. (The amount initially spent to obtain the shares currently owned, including purchase commission/load.) The cost basis is calculated using the assigned accounting method. When displaying for sub-portfolios, if all contained investments do not have the same accounting method, this figure will not be displayed. |
| Basis Per Share | Per share value of basis. (Basis / Shares) |
| Unrlz Gain | Unrealized taxable gain/loss for the shares currently owned. (Value - Basis) |
| Unrlz Gain Per Share | Per share value of unrealized gain using assigned accounting method. (Unrlz Gain / Shares) |
| Unrlz %Gain | Percent gain/loss on shares currently owned. (Unrlz Gain / Basis) |
| FIFO Basis | Tax cost basis for the shares currently owned. (The amount initially spent to obtain the shares currently owned, including purchase commission/load.) The cost basis is calculated using the first in first out accounting method. |
| FIFO Basis Per Share | Per share value of FIFO basis. (FIFO Basis / Shares) |
| FIFO Unrlz Gain | Unrealized taxable gain/loss for the shares currently owned. (Value - FIFO Basis) |
| FIFO Unrlz Gain Per Share | Per share value of unrealized gain using FIFO accounting method. (FIFO Unrlz Gain / Shares) |
| FIFO Unrlz %Gain | Percent gain/loss on shares currently owned. (FIFO Unrlz Gain / FIFO Basis) |
| AVG Basis | Tax cost basis for the shares currently owned. (The amount initially spent to obtain the shares currently owned, including purchase commission/load.) The cost basis is calculated using the average cost accounting method. |
| AVG Basis Per Share | Per share value of AVG basis. (AVG Basis / Shares) |
| AVG Unrlz Gain | Unrealized taxable gain/loss for the shares currently owned. (Value - AVG Basis) |
| AVG Unrlz Gain Per Share | Per share value of unrealized gain using AVG accounting method. (AVG Unrlz Gain / Shares) |
| AVG Unrlz %Gain | Percent gain/loss on shares currently owned. (AVG Unrlz Gain / AVG Basis) |
| Spec Lot Basis | Tax cost basis for the shares currently owned. (The amount initially spent to obtain the shares currently owned, including purchase commission/load.) The cost basis is calculated using the specific lot accounting method. |
| Spec Lot Basis Per Share | Per share value of specific lot basis. (Spec Lot Basis / Shares) |
| Spec Lot Unrlz Gain | Unrealized taxable gain/loss for the shares currently owned. (Value - Spec Lot Basis) |
| Spec Lot Unrlz Gain Per Share | Per share value of unrealized gain using specific lot accounting method. (Spec Lot Unrlz Gain / Shares) |
| Spec Lot Unrlz %Gain | Percent gain/loss on shares currently owned. (Spec Lot Unrlz Gain / Spec Lot Basis) |
| Yield xx | ROI yield for specified time period, ending today. Customize the periods with General Preferences - Yields Dialog. |
| Yield MTD | ROI yield for the current Month To Date |
| Yield QTD | ROI yield for the current Quarter To Date |
| Yield YTD | ROI yield for the current Year To Date |
| Yield Inception | ROI yield from the investment or sub-portfolio inception to today |
| Mov Avg xx | share price moving average for the specified number of weeks prior to today |
| Default Cash Account | assigned default cash account |
| Last Reconciled | date the investment or sub-portfolio was last reconciled |
| First Price | date of earliest recorded price in investment or sub-portfolio |
| Last Price | date of latest recorded price in investment or sub-portfolio |
| First Transaction | date of earliest recorded transaction in investment or sub-portfolio |
| Last Transaction | date of latest recorded transaction in investment or sub-portfolio |
| Last Distribution | date of latest recorded distribution of any type in investment or sub-portfolio |
| Last Purchase | date of latest recorded buy transaction in investment or sub-portfolio |
| Last Redemption | date of latest recorded sell transaction in investment or sub-portfolio |
| Acquired - Start | Start of date range the shares currently owned were acquired. Uses the first in first out accounting method. |
| Acquired - End | End of date range the shares currently owned were acquired. Uses the first in first out accounting method. |
| Alert Trigger | Closest active alert trigger price |
| Alert Distance | Difference between actual price and closest active alert trigger price |
| Alert Distance % | Percentage change required from actual price before reaching the closest active alert trigger price |
| Price Trend | Daily price change for the last 7 days. Each day is represented as '+', '-', or '=' with the latest change on the right. Weekends are ignored. |
| Custom Investment Properties | All 10 of the custom investment properties |
| Accrued Interest | amount of accrued interest as of today |
| Model Portfolio | assigned model portfolio for this sub-portfolio (Advisor version only) |
| Bill To Account | assigned bill to account for this sub-portfolio (Advisor version only) |
| Management Fee Method | assigned management fee method for this sub-portfolio (Advisor version only) |
| Allocation Target | assigned allocation target for this sub-portfolio (Advisor version only) |