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.