Lazada Philippines
Lazada Philippines
Showing posts with label Free Download template. Show all posts
Showing posts with label Free Download template. Show all posts

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

Sunday, October 9, 2016

Philippine Stocks Market: Dividends and Rights update using Microsoft Excel


Philippine Stocks Market: Dividends and Rights update using Microsoft Excel

Stocks dividend and rights may also affect the way how you read your charts and the best way to monitor is to make a tabulation of updates monthly. This is how a successful trader tracks his trading. Always remember to plan your trade and trade your plan.

Points to remember:

  1. Stockholder must have the stock before the ex date to be entitled for the dividend. Payment is in the form of cash or  stocks.
  2. Buying stocks on ex date doesn't entitled you for the dividend.
Click here to download the Ms excel sheet template:


Table updates for the month of October.

For other free templates downloads:

Visit my webpage free ms excel spreadsheets

Wednesday, October 5, 2016

Philippine Stock Market Computation Tool for Short Trading


Microsoft Excel template is a powerful tool in monitoring your buy and sell activities.
It helps you time for the computation of your losses or gains in the stock market.

Download this sample template and you can use for automatic computation of gains and losses in the Philippine stock market. Col Financial clients can use this tool to project their target earnings or looses whenever they will buy and sell stocks in the philippine stock market.

Download it here
Computation Tool - PSE 



Note: Sample template Data
            Stock Code: X
            Company Name: Xurpass
             Buy Price: 13.94
             Sell Price: 13.94

When you buy 10,000 shares of X at 13.94 and sell it at 13.94 you will loss an amount of 1519.46  (-1.09%) loss.

To download more templates in monitoring your stocks Download here


Fresh Stock analysis click here:
Q4 2016 October Monitoring





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