Global Investor | GI Bookshop | Harriman House | Holborn | Politicos | Financial Conferences | Finance Glossary | Investor Education | Derivatives | Financial Gurus | Tracker 101
Home Subject index Bookshop Tools Glossary Help
I want to learn about
Global-Investor.com > Incademy.com > Portfolio management

Portfolio management

Introduction| Course| Q&As | Recommended reading| Quiz |
1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21   
339

20. Setting up a portfolio spreadsheet

It is vital to set up a spreadsheet to track your portfolio. This will make it easier to administer, as well as helping you invest in a more disciplined way. Many financial websites now offer portfolio management tools though investors may prefer to devise their own customised spreadsheet using Microsoft Excel or similar software.

When doing this, the temptation is to focus on the amount of money you have paid, or the price per share. But what you should be most concerned with at all times is performance, performance, performance. Concentrate on your percentage gain or loss since you bought. Try to measure this

1. In absoluteHow much have you made?
2. In annualisedAt this rate, how much will you make in a year?
3. In relative termsHow are you doing relative to your benchmark?

Always rank your shares by one of the first two measures. That way, you can see at a glance which are your strongest and weakest performers. This will assist you in holding, or even adding to, your best holdings and weeding out your worst.

Recommend Reading

Book offers!

Fear, Greed and Panic
Fear, Greed and Panic
David Cohen
Our price: £20.99
Normally: £29.99
Public Private Partnerships
Public Private Partnerships
E. R. Yescombe
Our price: £42.49
Normally: £49.99
IPOs and Equity Offerings
IPOs and Equity Offerings
Ross H. Geddes
Our price: £54.39
Normally: £63.99
Google
Web www.incademy.com