Recalc Concept | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Where
you are trying to go — Investment Planning:
Investor's
CalcStation | How
you are going to get there — Portfolio
Management: Investor's
WorkStation | How
well you have done — Modified Dietz Performance
Calculator: PerfCalc
| What you need to think about, know, do, have, use,
forget, and avoid — Investing Principles
and Perspectives: In
My Opinion | Home
| Contact
Us | Free
30-Day Software Trials | Prices/Order
Recalc is intended as a user shortcut to selecting and saving a new analysis range for selected or global accounts when creating combined reports.
In earlier versions of PerfCalc, the user had to go to each account, select and save two user dated Market Value entries, go to Load, and print a combined report in which all portfolios would appear; each with its own analysis range as determined by the Market Value entries selected and saved @ each account. In most situations, the user would enter and save the same dated Market Value ranges @ each account, so the analysis range for all accounts @ the combined report would be the same; typically monthly, quarterly, annually. If the user wanted to generate a combined report with a different analysis range for some or all accounts, he/she had to go back to each account, select and save a new analysis range, go to Load, and print a new analysis range report; MVW to MVX. The calculation was correct, but getting there was cumbersome. Global Analysis Recalc speeds up the changing of an analysis range process. There are three basic combined report situations:
Global Accounts Have Different Selected and Saved Market Value Analysis Ranges If you want to create a combined report for all/global accounts as currently saved @ each account with different analysis ranges, uncheck 'Only Marked," and click on the Printer icon.
If account A, B, and C were saved at each account as MVW to MVZ and account D was saved at the account as MVY to MVZ, that is how they would appear @ the combined Account. All accounts will be listed with performances being time-weighted based on the number of days relative to all other accounts in the report.
Global Accounts With Common Market Value Analysis Range Entries If you know that all of the accounts, global accounts, have at least the same dated Market Value entries for the new analysis range, go to Load, uncheck 'Only Marked," go to From/To where all of the dated Market Value entries that are @ the individual accounts will appear, select a range, click on Calculate, and click on the Printer Icon.
In the illustration above, the possible global Recal Options would be MVW to MVY, MVW to MVZ, or MVY to MVZ. Accounts With The Same Market Value Analysis Range Entries and Individual Accounts With Different Selected and Saved Dated Market Value Entries If you have a new account(s) that you want to include in a new analysis range that has an SMV within an analysis range and an EMV within or the same as EMV of the new analysis range.... Account D below is an example.
Save Account D at the account @ MVX to MVY or MVX to MVZ. Assume Account D is reset and saved @ MVX to MVZ. Go to load, check 'Only Marked," @ From/To select MVW and MVZ for example, select accounts A, B, and C or select all accounts and then deselect D. Click Calculate. Accounts A, B, and C will be reset and saved to the new analysis range MVW to MVZ. Reselect all accounts (A to D) and click Print. Accounts A to C will have the same analysis range; MVW to MVZ and account D will appear as MVX to MVZ; all accounts being time-weighted.
Sidebar: Should you make a mistake and select an account(s) (D) that was not in existence for the entire analysis range and performed a Recalc for all accounts (A, B, C, and D) @ MVW to MVZ, PerfCalc will enter a system MV (in this case MVW @ D) and PerfCalc will use the closest dated MV $ as the value (in this case MVX).
|
