My Philippine stocks diary - September 2015 Week 02

  A good starting point for self examination is to review your own investment or trading record over the past few years. Even if you have made a profit, careful examination may reveal that the record owes a considerable debt to one particular investment whose success was due as much to chance as to any other positive factor.

 Even successful point for self-examination is to review your own investing, then 

DISCLAIMER
Please be advised that this is not recommendation to BUY or SELL. Manage your OWN risk.

RECOMMENDED LINK TO NEWBIES : CLICK HERE

      

Free Seminars:

  Free Stock Market 101 Seminar

Free Webinars

   PSE Academy free Webinars

How to invest in the Philippine Stock Market for beginners:

  Smart Pinoy Investor by Omeng Tawid

SEPTEMBER 2015 WEEK 02

"For GOD didn't give us spirit of fear, but of power, love and self control." - 2 Timothy 1:7

STOCK PICK with good fundamental analysis:

Click the image to enlarge

FUNDAMENTAL ANALYSIS

i.  TABLE ANALYSIS

SEPTEMBER 07, 2015

TA09072015 - TECHNICAL ANALYSIS

Notes:

SEPTEMBER 08, 2015

TA09082015 - TECHNICAL ANALYSIS

Notes:

SEPTEMBER 09, 2015

TA 09092015 -TECHNICAL ANALYSIS

Notes: I add NIKKEI index japan - all signals turn green, I just make a good BUY on my AC 

Notes 09092015

SEPTEMBER 10, 2015

TA 09102015 - TECHNICAL ANALYSIS

Notes 09102015

SEPTEMBER 10, 2015

TA09112015

ii.  GRAPHS 09072015

A. STOCK 01  -  Ayala  Land  Inc. (ALI) 
Click the image to enlarge

B. STOCK 02 - Metropolitan Bank Corp. (MBT)
Click the image to enlarge

C. STOCK 04 - Ayala Corp. (AC)
Click the image to enlarge

D. STOCK 05 - First Philippine Holdings (FPH)
Click the image to enlarge

E. STOCK 06 -  Cosco Capital Inc. (COSCO)
Click the image to enlarge

Note: O-H order done before 9:00 AM September 01, 2015 
In making an Order always ask pray and ask the guidance of the Lord.

EXECUTION:
Click the image to enlarge

Last Friday Execution September 04, 2015

Note on Strategy : 
09072015: I was able to sold out my stock and based from my readings on my excel all reversal downtrend it make sense to sold out ALI at 34.80 last Friday and now it closed @ 33.65 (-3.21% down)  And also NIKKEI index signal for a downtrend  followed by Europe then US index. Global weakness is at stake right now. Then 20% only of my portfolio will be traded actively. Others will still on hold and wait for reversal UPTREND.

09092015: Due to surge in prices of  different index in ASIA, I  execute a buy order at this day with 80% of my portfolio. Its worth making the decision to trade at this moment because of the momentum going on globally on stock prices. this allow me to take patience to wait and I think  its a good start to trade but when something goes wrong I can easily exit with that small profit.

summary of my portfolio

09102015: Despite a surge of NIKKEI japan index by 7.71 and followed by Europe Index like DAX Germany, still lot of worries on the FED rate hike wherein good result from the job output. With this, PSEI is affected and technical analysis shows again a downtrend. I made again the decision to sold some of my stocks even just a small profit to stay on the sideline with the buying power whenever there is a good opportunity, I will just jump in and make the necessary BUY. Always measure the risk you are going to face specially on this roller coaster ride type of market.


09112015: In check with EPHE index uptrend, PSEI will follow its upward movement. With this, My ALI stock remain invested with 8000 shares. I had a mistake in buying FGEN and EDC and I am late to make a sell order due to emotion and this makes my loss for this day. Its a negative movement and. since they are borrowing now to banks to pay debt of the maturing bonds, this means the downtrend happening maybe the cause of this  falling prices. Despite of my loss incurred, my JGS balance it with a profit. Lesson learned: CONTROL your emotions on making a trade.

Read More

How to use Sample MS EXCEL spreadsheet? Philippine Stock Monitoring Tool for better result.

My goal is to show how to use ms excel sheet in monitoring stock prices. Ms Excel sheet is a widely used software in offices and other related data analysis. Having a tool in monitoring stock prices will allow you to develop certain rules. The following rules stated on the images is a sample strategy that you can adapt and you can improve as you go along the way.

This article will show to you how to think for yourself, ignore tha day to day noise and make profitable investment decision on your own analysis and set of rules.

Successful Monitoring is built on three core principle:

1. Knowing when to buy and sell.
2. Doing your homework.
3. Having a margin of safety.

UPDATED MONITORING LINK:
SEPTEMBER WEEK2

DOWNLOAD HERE:
https://drive.google.com/file/d/0B2FEBrxaHeHiSTNCMEdEaEVXbzg/view?usp=sharing

VISION: sharing ideas to develop and simplify  monitoring  of stocks using MS EXCEL SHEET.
To develop strategy that is effective in minimizing risk while maximizing stock profit.
To establish a trading plan before the start a market and not by simple "tsamba".

STEP 01: STRATEGY

SPREADSHEET 02: SUMMARY OF EQUITY

NOTES: this can be edited

STOCK PICK - based from your drop down filtered spreadsheet 01: fundamentals link  to each company name (stock pick 01-03(medium term), stock pick 04-05 (short term), stock pick 6 - trading) gray color

CODE/SYMBOL- based from your drop down filtered spreadsheet 01: fundamentals link  to each company SYMBOLS

TYPE - based from your drop down filtered spreadsheet 01: fundamentals link  to each company CATEGORY

juan dela cruz - you can put your name to customize your model portfolio.

ALLOCATION- percentage allocation of each stock is dependent on your preference.

20%- total amount of equity to be traded is dependent on your risk reward ration at that time for me I used 20% of my total portfolio in and out in the market due to global weakness. (you just change the percentage then the amount will be computed automatically)

STRATEGY INVESTIGATION- the real purpose of these is to set your own strategy plan based from an effective previous trade plan.

TIME MANAGEMENT -  allocation of your time specially to those who are not full time in trading ( I suggest trade plan is start, noon break and closing time.

STEP 02: DATA INPUTS 

SPREADSHEET  06 WATCH LIST DATA INPUT

NOTES: DATA INPUTS

A. Copy quotes watch list (from col financial) 

    - watch list is based from your 12 top picks on spreadsheet 01: fundamentals (yellow color)

    - use google chrome browser.

B. Paste special - VALUE on spreadsheet "current trading watch list"

    - watch list is based from your 12 top picks on spreadsheet 01: fundamentals (yellow color)

    - use this one to update prices.

C. Paste special - VALUE on spreadsheet "today"

    - watch list is based from your 12 top picks on spreadsheet 01: fundamentals (yellow color)

    - inputs used to update spreadsheet 07: monitoring stock prices

      (red fill-lower stock price previous, green fill- higher price previous) 

   - closing period

always update lower tables on spreadsheet 06 - copy paste special (yesterdays price list) 

closing period

STEP 03: DATA INPUT 02 - AVERAGE PRICE

COL FINANCIAL QUOTES - TRADED PRICE

SPREAD SHEET 03 TECHNICAL ANALYSIS

SPREADSHEET 03 : TECHNICAL ANALYSIS

NOTES: DATA INPUTS

A. Copy average price yesterday and paste special -  value a@ previous column

B. Data Input (from col financial quotes-traded price) 

    - average price traded for the day

    - after stock market closing

legend: (green fill -  higher average price, red fill - lower average price)

STEP 04: DATA INPUT 03 - OPENING PRICE 

   - purpose to determine the color of the candlestick and when there is a DOJI

COL FINANCIAL: QOUTES

•  Input Opening price @ opening price table (from col financial)

STEP 05: DATA INPUT 04 - GRAPH DATA INPUT ANALYSIS

GRAPH 01

SPREADSHEET 03: TECHNICAL ANALYSIS

NOTES: DATA INPUTS

For MACD only

A. Copy MACD value and paste special -  value a@ MACD previous column 

B. Data Input (from graph provided by col financial - quotes-charting) 

    (use internet explorer in chart)

SUPPORT - A

RESISTANCE - B

5MA (5 day moving average) - C

MACD - D

Notes:

 Each trader have a different time frame and that makes every trader have different analysis. beware tips from other people. You might not know you have a different time frame.

STEP 06: TECHNICAL TABLE ANALYSIS

Go to Link: https://www.blogger.com/blogger.g?blogID=1574269398077451413#editor/target=post;postID=7711473229695250172

SPREADSHEET 06 & 04

ACTION TO BE TAKEN: 

    A. EXECUTING A BUY

•  If you're analysis is to BUY ALI - Input BUY1 - means you want to buy ALI with a price order of 35.10(price is based from your analysis). Automatically your plan to buy ALI will be shown on spreadsheet 04 ALI 1 row ( see highlighted gray ) 
• Then if it is executed just type the word "EXECUTED" and re input the value 35.10 (highlighted gray). 
• If not executed just delete the word BUY1 on the table
• Then on your next buy order, input BUY2  and so on until BUY4.
• I divided into 4 transaction to minimize trading 

Notes: 

On the table provided, you can put your reason of buying that stock that will serve as your record.If you put a BUY1....4 on action taken table, you will see that following data will be automatically recorded (percentage gain/loss,total traded amount and percentage) and also on spreadsheet 08 cash flows.computations on fees, commissions are already included at the transaction)

SPREADSHEET 04 & 06

   B. EXECUTING A SELL

• If you're analysis is to SELL ALI - Input SELL1 - means you want to sell ALI with a price order of 38(price is based from your analysis). Automatically your plan to sell ALI will be shown on spreadsheet 04 ALI 1 row ( see highlighted gray )
•  then if it is executed copy the gain/loss value and paste special besides executed word and you can now delete "EXECUTED" on the table to record the transaction. 
• If not executed just delete the word SELL1 on the table
• Then on your next sell order, input SELL2  and so on until SELL4.
• I divided into 4 transaction to minimize trading for stocks 01 to 3.

Notes:

On the table provided, you can put your reason of selling that stock that will serve as your record. If you put a SELL1....4 on action taken table, you will see that following data will be automatically recorded (percentage gain/loss,total traded amount and percentage) and also on spreadsheet 08 cash flows. Computations on fees, commissions are already included at the transaction).

STEP 06: CASH FLOWS

SPREADSHEET 08 - CASH FLOWS

Note: adjustment is in the part of equity trade to be equal on your portfolio. Capital input and additional capital will be placed on ADD-ON column every month. 

- The table shows how much you gain  or loss by daily, weekly, monthly. 

- IPO and dividends is also included here for the computation of equity value.

UPDATED TABULATION 09042015

TA09042015 - TECHNICAL ANALYSIS

TIPS:
Use the QUOTE - SIX PACKS by col financial to monitor the 6 STOCK PICKS

RECOMMENDED LINK TO NEWBIES : CLICK HERE

      

Free Seminars:

  Free Stock Market 101 Seminar

Free Webinars

   PSE Academy free Webinars

How to invest in the Philippine Stock Market for beginners:

  Smart Pinoy Investor by Omeng Tawid

If you have questions with regards to the sample template being shared, Please don't hesitate to post a comment on this blog or you can contact me @ philippine.stocksdiary@gmail.com

Read More

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. 

Read More

My Philippine stock market diary goes online

Always plan your trade and Trade your plan. This graphs includes fundamental aspect of companies listed in the Philippine stock market. Samples were given as an illustration on how you will tabulate and will be serve as monitoring tool

i. OVERVIEW:

     contains research related to Philippine Stock Market, Company Disclosures to PSE which includes new developments, programs, earnings and other related news pertaining to a company.

ii. RESEARCH:

A. Philippine Economic Indicators (updated 8/31/2015)

PEI 8312015

B. Company Announcement related to Stock Picks  (As of month of August)

   1. Stock Pick 06 -  COSCO

          - Buy Back Share Program amounted to 1 billion php.

http://edge.pse.com.ph/companyDisclosures/form.do?cmpy_id=50

A. Data Research from COL Financial

BUY BACK OF SHARES:

September 8, 2015
Buy Back Share - Belle Corporation
Buy Back Share - Vista Land

Read More

My Philippine stocks diary - September 2015 Week 01

  A good starting point for self examination is to review your own investment or trading record over the past few years. Even if you have made a profit, careful examination may reveal that the record owes a considerable debt to one particular investment whose success was due as much to chance as to any other positive factor.

 Even successful point for self-examination is to review your own investing, then 

DISCLAIMER
Please be advised that this is not recommendation to BUY or SELL. Manage your OWN risk.


SEPTEMBER 2015 WEEK 01

"if you are intelligent the market will teach you caution and fortitude, sharpen your wits, and reduce your pride. If you are foolish and refuse to learn a lesson, it will ridicule you, laugh you to scorn, break you, and toss you on the rubbish heap." - Frank J Williams

STOCK PICK with good fundamental analysis:

Click the image to enlarge

FA 01: FUNDAMENTAL ANALYSIS

i.  TABLE ANALYSIS

August 31, 2015

TA8312015: TECHNICAL ANALYSIS

September 1, 2015

TA9012015: TECHNICAL ANALYSIS

notes09012015

inter market analysis: global weakness 09012015
Note: it goes down more than 2% but it recoup on the closing price - Global weakness

September 02, 2015

TA09022015: TECHNICAL ANALYSIS

Notes09022015

 September 03, 2015

TA09032015 - TECHNICAL ANALYSIS

Notes09032015

SEPTEMBER 04, 2015

TA09042015 - TECHNICAL ANALYSIS

ii.  GRAPHS

A. STOCK 01  -  Ayala  Land  Inc. (ALI) 
Click the image to enlarge

ALI 08/31/2015

B. STOCK 02 - Metropolitan Bank Corp. (MBT)
Click the image to enlarge

MBT 08/31/2015

C. STOCK 04 - Ayala Corp. (AC)
Click the image to enlarge

AC 08/31/2015

D. STOCK 05 - First Philippine Holdings (FPH)
Click the image to enlarge

FPH 08/31/2015

E. STOCK 06 -  Cosco Capital Inc. (COSCO)
Click the image to enlarge

COSCO 08/31/2015

Note: O-H order done before 9:00 AM September 01, 2015 
In making an Order always ask pray and ask the guidance of the Lord.

EXECUTION:
Click the image to enlarge

O-H ORDER 08/31/2015

O-H ORDER   09/02/2015

O-H ORDER 09/03/2015

Read More