Lazada Philippines
Lazada Philippines

Sunday, October 16, 2016

Goal setting and portfolio fund distribution using Microsoft Excel spreadsheet.


"PLAN EVERY TRADE AND TRADE EVERY PLAN"

FREE TEMPLATE
DOWNLOAD HERE:Spreadsheet 01: Equity Plan

Note: This is just a sample template using Microsoft Excel sheet. 
Red Font can be edited based from your strategy.
Spreadsheet 01: Equity Plan

Step 01: Goal Setting

   - What separates the winners from the losers?
     Its certainly not knowledge? I believe what really separates winners from loser is the ability to follow your rules without exception, regardless of the circumstances.Very few traders have the discipline to do this. Goal setting is a part of this where in you have a goal to follow your rules strictly and setting your target profit will give you the motivation to follow the rules and to discover more strategy to maximize your profit.

Step 02: Fund distribution

   - How many stock you will buy? How much is your allocated fund. How you will distribute? What is the percentage allocation of  each stock?  Either an investor or trader must answer these questions based on their rules or strategy to beat the market. To be a winner in the market you can never trade from emotion and the only way to eliminate emotion is to have iron discipline to follow your own plan. You must know your strategy and put into paper for a while and you when you are in to it you can store and picture it into your mind. If you want to become one of the few market winner you must "PLAN EVERY TRADE AND TRADE EVERY PLAN"

If you ever find your-self having to ask some-one for an opinion on a stock you hold then it can only be because you either have not made a plan, or you are second guessing the plan, in which case you may as well not bother making one in the first place.

Max stocks: 3
IPO: ( I used to subscribe IPO and the risk is high but its worth it)
Allocated Fund: (Don't use emergency funds its not advisable)
Percentage Allocation: (50,35,15)

Step 03 Schedule/Planning
Planning a trade should be no different fro planning a journey. You must plan for all kinds of events. Especially for the unforeseen ones. Most of the time a trade will go your way and the plan will barely have to be looked at but what if the share gaps down? fly's up? goes sideways for six weeks, the market crushes, the company announces a complete surprise announcement will makes the share gain P 10,000 in one day? If you arent prepared for these surprises then when one does happen you are going to find yourself wandering what to do. And once you are trading from the "hype" and not from the plan then expect your result to worsen.

Always allocate 1 hour a day for stock review and stock reading.

Coming Soon: Spreadsheet 02

2 comments:

Lazada Gadgets 2017

Lazada Philippines

D' trader

My photo
"To try your best to acquire an unflappable and supremely adaptable mind to enable you to see things as they actually are without clinging to preconceived notions" I love doing things that fascinate me. I love numbers. I really do. I found something that relates to my interest and its the stock market. I am a trader for over 5 years from now. Before that I try to invest in VUL which defines a combination of insurance and Equities and Bonds. Today my investments already matured and its worth it of the time when I struggle to pay for the premiums. Ive been challenge to work for this and I learned a lot about finance and investment. Since I am Civil Engineer in QS side, Managing Finance in the construction industry give me a broad knowledge in making expenditures and savings and we call that as VALUE ENGINEERING. I love writing about finance wherein I learn it from my own experience. I do love helping other people specially to my fellow OFW who want to manage their money properly. Come and join me to research more the world of INVESTING.
Lazada Philippines