In the world of investing and buying assets, it is necessary to be a very cautious person. Well, the numbers are not random.
In order to obtain a benefit from this, it is necessary to apply techniques, strategies and analysis that allow us to understand the behavior of financial investments.
One of these strategies is the so-called portfolio or investment portfolio. That for many years, remain applicable within the purchase of assets.
This article will explain everything about this investment strategy. And of course, we are going to show you the procedures to create an investment portfolio in spreadsheets using Excel.
what is a wallet or investment portfolio
When we are going to start investing, it is necessary that we have an adequate administration of our assets. For this, it is necessary to create a portfolio or portfolio and investment.
Now, this term is used to represent a set of investment assets that are managed together. And it arises mainly with the aim of varying the purchase of assets based on the relationships that exist between them.
For example, if we buy all our assets from a company like Amazon, we will be risking our entire investment in one direction. Therefore, in the event of a decline in our share price, the loss would be huge. Thus, it would be difficult for us to recover some of the investment.
This is where portfolio risks arise, these are used to take considerations when choosing the assets that will make up our investment portfolio. In the same way, there are portfolio theories, which propose the relationships that assets must have with each other to minimize loss and make an investment safely.
For example, some portfolio theories state that we must choose assets whose fluctuation is opposite and proportional, in this way, our loss is minimized but not recovered. Or, also indicate that we should allocate most of our portfolio to companies whose stock fluctuations are more stable, so the gain will be minimal but certain.
Procedure to follow to select our assets
To start making our portfolio, the first thing we must do is organize the assets individually. Here we must analyze the expected benefits, taking into account the risk that each asset runs.
Then, having our individual assets ready, it is necessary to establish the correlations that they present between them. For example, we must study if in case one goes down or up, how does the other react? In this way we can determine if they are independent, the relationship that exists or if one works as insurance for the other.
Now, we have to build our investment portfolio. To do this, in case we have only two assets. So it is easier to choose a portfolio theory that suits it. However, in most cases, we will have more than two assets, therefore it is necessary to choose portfolio theory that can be generalized to two or more assets.
Procedure to make a portfolio or investment portfolio in Excel
First of all, we must create two blocks where we identify the purchase of the market price of our assets. Therefore, here each of our assets must be identified in each block, leaving the space for the purchase price and market blank.
For the identification of the assets we must consider the following columns: the name of the company, the country of origin and the ticker.
Now, as for the purchase section, it is made up of the following columns: Portfolio percentage, purchase prices in original currency, purchase prices in euros, purchase exchange rate, number of shares in purchase, the total, purchases and commissions.
For the exchange rate section, it is necessary to use the excel function that returns the currency price when entering the exchange currencies. In this way, we will automatically obtain updates of the prices of these currencies.
As for the market price block, it is necessary to start with the same columns identified for the assets as explained above.
First, we locate the current price that the market drives, the market price in Europe, the variation of the final price, compared to the final price, the number of shares that were purchased, the latent purchase, finally, we place the contribution of the shares purchased .
