avibrazil / investorzilla

Use your investments spreadsheet (Excel, Google Sheets) containing assets’ ledger and balance to get powerful insights of your investments health and performance, in multiple currencies, including crypto and market indexes.
GNU General Public License v3.0
4 stars 1 forks source link

model portfolio vs proposed portfolio #9

Open johnfelipe opened 11 months ago

johnfelipe commented 11 months ago

Need for a solution to handle portfolio calculations and interactions.

The proposed portfolio refers to the recommended investment allocation for a client’s portfolio. It is a portfolio composition suggested by financial advisors based on the client’s profile and investment goals. The proposed portfolio takes into account various factors such as risk tolerance, investment horizon, and financial objectives.

the client’s portfolio is composed of different financial products, such as funds (also known as FIC, Collective Investment Funds) and titles (e.g., stocks). Each product generates a balance for the client, representing the value of their investments. The client’s portfolio is the aggregation of these balances.

The model portfolio, on the other hand, is the recommended allocation of investments at the asset level. Instead of specifying individual funds or titles, the model portfolio suggests the percentage allocation for different asset types. For example, it may recommend allocating 50% to variable income products, 30% to fixed income products, and 20% to alternative investments.

The proposed portfolio is derived from the model portfolio but allows for customization and adjustments based on the client’s preferences. The client can make changes to the proposed portfolio by modifying the allocation percentages or adding/removing specific funds or titles. These changes reflect the client’s investment decisions and preferences.

the proposed portfolio requires a user-friendly interface where financial advisors can interact with the data. The interface should allow them to edit values, add or delete funds/titles, and recalculate the portfolio composition and performance in real-time. The proposed portfolio should be dynamic and responsive to changes made by the advisor.

Overall, the proposed portfolio is a customizable investment allocation recommended by financial advisors based on the model portfolio. It allows for adjustments and modifications to suit the client’s preferences and investment decisions. The goal is to provide a user-friendly interface that enables financial advisors to interact with the portfolio data, make changes, and recalculate the portfolio composition and performance in real-time.

Example in sheet: SNAG-0052

avibrazil commented 11 months ago

Investorzilla was not designed as a tool to help on future asset allocation or future portfolio building.

But, its virtual fund capabilities (ability to create an instant fund from multiple aggregated assets) can be hacked to sort of look like an asset allocation tool.

For this, your funds or assets will have to be historical data of these assets, such as share value on each date.

johnfelipe commented 11 months ago

But can u put profitability and volatility?

El mar, 12 dic 2023, 9:54 p. m., Avi אבי Alkalay אלקלעי < @.***> escribió:

Investorzilla was not designed as a tool to help on future asset allocation or future portfolio building.

But, its virtual fund capabilities (ability to create an instant fund from multiple aggregated assets) can be hacked to sort of look like an asset allocation tool.

For this, your funds or assets will have to be historical data of these assets, such as share value on each date.

— Reply to this email directly, view it on GitHub https://github.com/avibrazil/investorzilla/issues/9#issuecomment-1853186766, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADIWFA6M5KZIQY4PKHZSGLYJEKHLAVCNFSM6AAAAABASF7P5KVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNJTGE4DMNZWGY . You are receiving this because you authored the thread.Message ID: @.***>