Lazada Philippines
Lazada Philippines
Showing posts with label stock analysis. Show all posts
Showing posts with label stock analysis. Show all posts

Monday, August 31, 2015

Philippine Stock Market Trading Online Diary - Traders and Investors Spreadsheet use Microsoft Excel


Plan your trade Trade your Plan. Monitoring your buy and sell activities will give you the plan to make a better decision in market timing. With Microsoft Excel you can use as a tool in monitoring your stocks, transaction and recording your daily trade  and making an analysis. If you are disciplined and patient in monitoring and making analysis this will allow you to accumulate gains. The total value of your investment will go up.

This is an overview of the ms excel monitoring sheet  that is now downloadable.

Download here to get your free copy.


i. Overview:
       Sample Excel worksheet to track stock trading and daily stock record that will serve as analysis.

ii. Sample Work Interlink:


Worksheet 01: Tabulation of Fundamental Analysis
 Content: 
  •  Fundamental Analysis - Quarterly Earnings Percentage, Fair Value, STOCK Price link to Worksheet 6 for updated stock price, EPS growth, P/e, P/Bv, ROE, Dividend Yield
 Purpose: 
  •      the spreadsheet will serve as stock picks based from good fundamentals.
Microsoft Excel Tips:
  •    use conditional formatting for on the purpose of differentiating each stock.
WORKSHEET 01: FUNDAMENTAL ANALYSIS


Worksheet 02: Summary of Portfolio & Strategies
Content: 
  •     Portfolio Allocation where you will departmentalize your funds. 
  •     includes strategy investigation and summary of lessons based from your past experiences.
  •    Time management and allotment.
 Purpose: 
  •      the spreadsheet shows your percentage allocation of stocks
  •      shows summary of strategies/ observations based from your past experience
Microsoft Excel Tips:
  •    insert pie chart or other charts showing division of your stocks picks amount allotment.
WORKSHEET 02: SUMMARY OF PORTFOLIO AND ANALYSIS


Step 03: Stock Data Analysis/ Trade Plan / Daily Stock Record 
  Content: 
  •    Data Record (Price link to worksheet 6, -  Open Low, High, closing Price, Volume, Ave.   Price,)
  •   Technical Analysis (Support/Resistance, 5MA, MACD, Candlestick)
  •   Trade Plan Strategy (O-H order Plans either BUY/SELL)
 Purpose: 
  •      the spreadsheet use for analysis  and strategy plan
  •      shows summary of portfolio
Microsoft Excel Tips:
  •    interlink spreadsheet to minimize inputs of datas
WORKSHEET 03: STOCK ANALYSIS

Worksheet 04: Tradings Transactions Record
 Content: 
  •    Transactions Record includes fees like vats, commissions 
  •   Reasons of executing a trade
  •  Gains/Loss on the trade executed (links to cash flows)
  • PSEi index, EPHE, S & P 500
 Purpose: 
  •      the spreadsheet use to review transactions that will help to improve trading strategies
Microsoft Excel Tips:
  •    use of spreadsheet functions such as if, and, or
WORKSHEET 04: TRADING TRANSACTION RECORDS/ANALYSIS

Worksheet 05: Resource Fund Planning
 Content: 
  •     Equity Cash Flow (Daily, Weekly, Monthly)
  •   Dividends, IPO
  •  Capital Inflow/Outflow
 Purpose: 
  •      the spreadsheet use to review gains/loss on daily, weekly and monthly basis.
Microsoft Excel Tips:
  •    use link properties to minimize data inputs
WORKSHEET 05: RESOURCE FUND PLANNING

Worksheet  06: Monitoring Stock Prices
   Content:
  •   Stock Prices
  •  Timeline like Dividend Ex-date, IPOs, GDP announcement and other stock related 
 Purpose: 
  •      the spreadsheet use as data storage as well as monitoring prices
Microsoft Excel Tips:
  •    use as data storage and this will just link to different spreadsheets.


WORKSHEET 06: MONITORING STOCK PRICES


Worksheet 07: Research & Development
  Content:
  •   Research Tabulation on Philippine Economic Indicators
 Purpose: 
  •      the spreadsheet serve as a review the interconnection of economic indicators to movement of stocks
Microsoft Excel Tips:
  •   use conditional formatting
WORKSHEET 07 RESEARCH AND DEVELOPMENT


Note: Worksheets are interlink each other to minimize inputs. Use Functions like And, If , Or to simplify the worksheet. Conditional Formatting is a great tool to shows the difference of data s inputted.

Purpose:
  Having an exel worksheet will eventually minimize emotions on your trading due to established strategic trade plans. 

Sunday, August 30, 2015

PHILIPPINE STOCK TRADING ONLINE STRATEGY Take the complete Responsibility


Did you missed something when you buy and sell the stock?  Did you have a mistake? Do you have set of rules to Follow?. Did you follow your rules? How often do you make your trade? How do you allocate your fund in buying stocks. How many stocks do you buy? Are you a long term? short term or medium term? What is your risk appetite?

For the successful trader knows every action he takes, every decision he makes he and only he is responsible for that action.

When something going wrong instead of looking fo someone else to shoulder the blame you will accept responsibility, note it down and vow to never repeat it again. Simply you are willing to accept you are going to make mistakes again, but more importantly, you are going to learn and never repeat those mistakes. A vital component of any winning trader.


" I will find a system that fits me and I will become the best trader at this one style"

Objective:   This is to record my daily trade and to track down my own trade on daily basis.

Mission :    To develop a simple strategy with regards to Philippine Stock Market Trading that will result to a low risk but a very big profit trading.

Vision :      To establish and develop of what i called the "Emotion Less Trading"

This is my diary, My online diary



I. PORTFOLIO OVERVIEW
    - consist of fund allocation percentage, strategy investigation, trading time.

Click the image to enlarge
MODEL PORTFOLIO - STRATEGIES


II. STOCK RECORDS AND ANALYSIS: DAILY BASIS
    - strategy using Support/Resistance, Moving Average, MACD, Volume and Candlestick

Click the image to enlarge
STOCK RECORDS AND ANALYSIS

III. STOCK RECORDS OBSERVATIONS/LESSONS 
    - lessons, strategies, errors, observation that have been experienced during my past tradings.

Click the image to enlarge
STOCK RECORDS OBSERVATION/LESSONS

III.  STOCK GRAPHS ANALYSIS 
    - sample graph analysis employing my strategy.  using Support/resistance, 5-day Moving Average (5MA),       Moving Average (MACD), Relative Strength Index (RSI), Volume, Fibonacci,

Click the image to enlarge
TECHNICAL GRAPH ANALYSIS

RECOMMENDED LINK TO NEWBIES : CLICK HERE
      
Free Seminars:

Free Webinars

How to invest in the Philippine Stock Market for beginners:

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