Jump to comment

Updated to the latest version on February 27th, 2008.

Excel is a magical tool, and some functions can achieve unexpected results. This table from the forum "Winning Politics" is a good example. It is not so much a form as a tool, a tool for managing funds. This year is a year of prosperous investment. First, stocks skyrocketed, and now it's the turn of fund investment to skyrocket. Of course, some related tools will also come into being. So what's the difference between this management tool?

The author Xiao Yu said alone:

This tool is not suitable for people with extensive personality.

1. My form is that the interest generated during the subscription and issuance of new funds is converted into fund shares, while others (including almost all websites) are not considered, resulting in inconsistency with the actual holding shares.

2. "Unreredeemed" and "redeemed" are separated from each other, which is more convenient for analysis and statistics and leaves historical transaction records.

3. Fully consider the factors of fund dividends (cash dividends, dividends transferred to investment), and the actual income and net guarantee value reflected in the table will not be wrong because of fund dividends (try someone else's table to see if the net guarantee value will be wrong when the fund dividends).

4. A "fund utilization table" is added, so that the available funds can be seen at a glance, the total net assets can also be seen at a glance, and the inflow and outflow of funds are recorded, which is simply a bank account.

This tool is of little use to me, but it may be of great help to people who invest in funds, and even if you don't play with funds, it is a good way to study the function of forms and take it as an example to learn.