Bug Thinking

Menu
  • Home
  • Blogging
  • Health
  • Reviews
  • Technology
  • Tutorials
Home
Investments
PSE Stocks
PSE Trading Journal Spreadsheet V8.1 – What’s New & Why You Should Get One?

PSE Trading Journal Spreadsheet V8.1 – What’s New & Why You Should Get One?

Antoin Eoghan Mori April 24, 2018

PSE Trading Journal Spreadsheet
I am so delightful and excited to announce the latest release version of PSE trading journal spreadsheet (version 8.1) from AA Excel Spreadsheets! I had the chance to use and review the PSE Trading Journal Spreadsheet V7.3. It was very helpful because it helps me to review all of my trades. Not only that, it allowed me to revisit the bad and good strategies I did for my past trades. This is one of the few reasons why should a trader, whether a veteran or newbie, should have a document like this available. It will give you a high-level insight into how well are you performing with your trades. If you really are successfully gaining or little by little losing your capital. Now, let’s go back to the latest version of PSE trading journal spreadsheet (V8.1). But let us start by sharing this quote to our valued readers.

“Record where you bought and where you sold every single trade. Pretty soon you’ll have a track record of average losses and average wins, and the frequency of the wins and losses.” 

– by Mark Minervini

Practically speaking it does make sense, right? If you want to gauge your strategies and success in PSE stock trading then you need to have some sort of document to backtrack. And having a trading journal should do the trick! To be fair, having a documentation does not only apply on PSE stock trading but on almost any trading markets.

So, let’s now try the latest PSE Trading Journal Spreadsheet (V8.1)! Let’s explore how effective the new version and how does it differ from it’s predecessor versions.

Page Contents

  • AA Excel Spreadsheets’ PSE Trading Journal Spreadsheet version 8.1
    • Introducing PSE Trading Journal Spreadsheet version 8.1
      • Bank Transfers – Document all your Deposits and Withdrawals
      • Watchlist  – Let’s do a little bit of window shopping
      • Trade Log – Let’s get into the market
      • Trade Review – So what made you execute your trade?
      • Trade Plan – Make use of Trail Stop!
      • Stock Position – What you have and had!
      • Dividends – Stock and Cash
      • Monthly Reports, Now in candlesticks chart!
      • Dashboard – One look and it says it all
      • Archive & Settings – Backup is always important!
  • And To Sum Up Everything
    • Contact the developer
    • Download the PSE Trading Journal Spreadsheet (Trial version). Try it for yourself and experience how it works.
    • And here’s how we rated this product
        • User Review

AA Excel Spreadsheets’ PSE Trading Journal Spreadsheet version 8.1

After I received and opened for the first time the latest release version of this trading journal from our good friend in AA Excel Spreadsheet, I was really amazed! Why? Just look at the new Dashboard tab below as compared to the 7.3 version I review I did before! By the way, if I am not mistaken the steps on how to use PSE Trading Journal Spreadsheet version 8.1 is not different from the last 7.3 version I have.

Dashboard - Trading Journal Spreadsheet from AAES Version 7.3

Trading Journal Spreadsheet v7.3 Dashboard

PSE Trading Journal Spreadsheet Dashboard

PSE Trading Journal Spreadsheet v8.0 Dashboard

There’s a noticeable big difference, right? Let us try to dig a little bit more about this new PSE Stock Trading Spreadsheet version 8.1 tool.

Introducing PSE Trading Journal Spreadsheet version 8.1

In this review, I will show you how to use this latest version of PSE trading journal spreadsheet differently. Instead of just discussing each worksheet’s functionality, let’s do it in such a way like you’re using it in a real-life trading situation. Although, using this tool is not limited and doesn’t have really a strict process – well, except for the Trade Log and Bank Transfers. These 2 are the heart and soul of your whole journal, the way I see it.

For the sake of testing/simulation, we will be using mocked and pre-populated data for this whole review. The objective is to show you all how effective and how the latest PSE Stock Trading spreadsheet works!

Let’s begin!

Bank Transfers – Document all your Deposits and Withdrawals

PSE Trading Journal Spreadsheet - Bank Transfer

The very first thing that I’d do is document how much will I invest in the stock market. And as time goes by, I also need to input how much I’ve added or withdrew from my stock investment. It does not make any sense if you don’t input your investments or disinvestment in the stock market, right? How can you gauge your gains/losses if you will not fill-up this worksheet?

Inside this Bank Transfers worksheet, it is a must that you input ALL of your deposits and/or withdrawals. On top of this page, you will see a summary of your asset. Information such as your:

  • Initial capital for the current month
  • The amount you have deposited for the month
  • Cash Dividend gains for the month
  • Net (Gain/Loss) for the month
  • The amount you have withdrawn for the month
  • Ending capital for the month
  • Current Cash Balance
  • Total Deposits for your port
  • Total Withdraws from your port
  • Total Capital + Profits (from your trades)
  • To-date cash/capital

ALL entries, small or big, should be documented here. As I’ve mentioned earlier, the information here is very vital for your journal!

Watchlist  – Let’s do a little bit of window shopping

PSE Trading Journal Spreadsheet - Watchlist

We always recommend to our friends/colleagues – “If there is no plan, then there should be no trade!“.

Imagine yourself as a student who has not done his homework or studied anything about the topic that will be discussed for tomorrow’s class. What do you think will happen? It’s either you will feel, you’ve missed a lot and everything is too blurry during the class discussion. OR, if you attempted to engage yourself in the discussion then there’s a big chance that you will FAIL! You’re lucky if you can survive!

This is the same high-level analogy that we wanted to describe before you enter a trade. The Watchlist worksheet can help you in planning your trade by adding your target stock/company under your radar. Then you have to set your Entry and Exit plans or price. And remember to be strict with your plans. The Entry and Stop alert columns are among the new features of PSE trading journal version 8.x.

We’ve seen a lot of traders losing a lot just because of emotions – that includes me! Try to study first and get a confluence when and why you should enter. For the sake of example, let’s say you are a swing trader or position trader and you are looking at $SMPH (SM Prime Holdings, Inc.). Since traders are more inclined in Technical analysis, you will need a tool that can give you the price actions and indicators that will help you. I recommend using either Investagrams Chart or Tsupetot’s PSE Chart Tool. The image below was done through Investagrams.

As you can see in the graph, although Stoch + RSI seems to be in the position to move upwards, and the Bollinger bands is getting more constricted. However, the trend is still bearish if you look into the price action movements and the price is below the MA20, MA50, MA100 respectively. Moreover, MACD and RSI are showing the same thing. BUT this is a good opportunity for long term investors/traders – even for swing and position traders. Especially that we have seen the confirmation candle from the closing price.

On the next trading day, I just need to make sure that I follow my entry and if my plan does not go my way – then I have to immediately execute my Exit!

Trade Log – Let’s get into the market

PSE Trading Journal Spreadsheet - Trade Log

The very heart of PSE Trading Journal Spreadsheet tool – the Trade Log worksheet! This is the most important worksheet of all which I have already mentioned. Aesthetically speaking, the only changes I can see here is the refresh data button (right side of Market Value) and the color/theme of the summary report. The old functionalities of the previous version are still there. You can still set your Target price (TP), and Cut-loss (CL) in a percentage format. So to recap again, here’s the high-level steps on how to use the Trade Log worksheet:

  1. Input your buy/sell transactions under the Trading Log.
  2. The Fees are automatically computed based on the standard fees for most Trading platforms. But in case that there are fee corrections, like in IPO or Mutual fund trades then you can manually indicate the fees. Also, use to backup original fees in case of changes in fees or taxes.
  3. Record your decision making on each trades, add notes and trades setups.
  4. Automated cut loss and target price settings by %, Enter positive % value for target price or enter negative % value for the cutloss price.

Trade Review – So what made you execute your trade?

PSE Trading Journal Spreadsheet - Trade Review

Sounds new to you? It may do sound something new feature if you’re used to having the old version (7.x) of PSE Trading Journal. But it is not really new if you take a closer look. Trade Review worksheet is what used to be known as the Dashboard of the old PSETJ version 7.x.

However, there is slight changes and here are they:

  • Trade Evaluation Note Statistics (Entry/Exit and Emotion stats can be customized)
  • Additional 2 rows entry for Trade Set-ups.
  • Added This Week and Previous Week Performance

From here, you can review your past executions and strategies. You will be able to check what went right and what went wrong. It is also a good gauge of how emotionally you are when trading. The developer has prepared a few common examples of emotions that most traders experienced in the market. Based on my observation, two of them is very popular and common – GREED and FOMO (Fear of missing out)! As Nicolas Darvas once said:

“The CAUSE-of-ERROR tables helped me immeasurably. As I drew them up one after the other I was learning something from each trading.”

Use this sheet to reflect and make a better or improve your next trading strategy!

Trade Plan – Make use of Trail Stop!

PSE Trading Journal Spreadsheet - Trade Plan

Since you have already executed your trade, Trade Plan worksheet will automatically populate your stock position on this page. By default, it will show you your calculated cut loss, target price, and trail stop values. The functionalities is the same as with the previous version wherein you can do the following:

  1. Manual Last Traded Price (LTP) option, in case the real-time market price doesn’t work. any value input will overwrite the auto price column.
  2. Cutloss, Target price and Trail stop calculation by %: Enter the desired percentage for each setting.
  3. Trail stop price: Enter exact trail stop price based on your technical analysis.
  4. Plan portfolio preview option: Select from options to preview your portfolio value once your plan has been executed.

Stock Position – What you have and had!

PSE Trading Journal Spreadsheet - Stock Position

The Stock Position worksheet will simply show you what stocks you currently have and what you had previously. Also, it will show you a summary report above the following information:

  • Overall Trade Statistics – A quick glance on the number of your winning and losing trades with the ratio. Also, the average profit and loss with the ratio.
  • Top gainers and losers by the amount
  • Total realized gains and loss

Dividends – Stock and Cash

PSE Trading Journal Spreadsheet - Dividends

The Dividends worksheet, nothing special really on this part of the whole workbook aside from you documenting each dividend you accumulate – stock/cash. But do note the instructions for Stock Dividends. According to the developer:

For STOCK DIVIDEND, Enter the data in Trade Log sheet without the stock price.

Example:

| DATE | STOCK CODE | BUY | PRICE LEAVE BLANK | STOCK SHARES RECEIVED |
Stock shares and the average price will be adjusted accordingly.

Monthly Reports, Now in candlesticks chart!

PSE Trading Journal Spreadsheet - Monthly Reports

Yet another improvement in the interface of PSE Trading Journal Spreadsheet! And it now has a Monthly performance chart – in candlesticks form! It’s like the stock price action now!

So here’s the update from the developer.

  • Monthly Performance Chart: From the line chart to candlestick chart, sorted months from newest to oldest
  • Added trade statistics per month.

Note on Candlestick chart:

  • Gap Up: Additional Deposit
  • Gap Down: Withdrawal
  • Volume: Sum of Buy and Sell Transactions Cost.
  • Green Candle: Close the Period with Gain
  • Red Candle: Close the Period with Loss

A really cool way to present reports while dealing with stocks!

Dashboard – One look and it says it all

The new Dashboard worksheet contains different charts and important summary reports.  As usual, it may look too overwhelming at first glance! It looks cluttered and there is too much information just looking on one worksheet. In summary, this is what the developer said about the new Dashboard:

  • Distribution of Gains and Losses – From the book “Think and Trade Like A Champion” by Mark Minervini. The ideal distribution is to have as many outliers as possible on the right and the fewest on the left, attaining a “skewed” curve.
  • Win Rate Trade Expectancy – A 20 trades expectancy based on win rate%, average win%, and average loss%.
  • Overall Trade Statistics – Win/Loss and Profit/Loss Ratio on all trades and Gain/Loss expectancy per trade calculation.
  • Performance Per Period – Automatically calculate your Weekly, Monthly, Quarterly, and Yearly Performance.
  • Trade Statistics: Statistics per trade.
  • Trade Set-up Statistics: Results of each trade set-up (Win Rate% and Profit rate%).
  • Trade Evaluation: Results of notes statistics from “Trade Review” sheet.

But admittedly, just looking at the Dashboard worksheet gives me the whole picture of my trades! So, hat’s off to you AA Excel Spreadsheets!!!

Archive & Settings – Backup is always important!

PSE Trading Journal Spreadsheet - Archive and Settings

I am working in an I.T. industry for 18 years now as of writing this article and I think I’d be in the position to stress to my readers that backup is very important! This is most especially when you are tracking your investments where money is involved! The Archive & Settings worksheet can automatically compress your data especially reached the trade log limit. Or for the sake of maintenance you can compress it monthly.  This feature will compress the “trade log” and “bank transfer” data while retaining all important reports. Your journal “cash balance” and “stock positions” should match your actual portfolio before using this feature. Just follow the instructions from the worksheet and you are good to go!

Also, if your broker charges different fee settings, then you can update the Broker’s Fee Settings.

Lastly, if you want a fresh start or if you want to use your PSE Trading Journal spreadsheet for another broker, you can use the DELETE TRADE DATA.

And To Sum Up Everything

So there you have it, the latest PSE Trading Journal spreadsheet version 8.1! There’s too much more to say but it is up to you to explore.

For me, the tool is very helpful especially when reviewing my previous trades and planning for new ones. Also, it’s not like any other products where the seller will just leave you in the air after purchasing the product. When you contact the developer is very kind and accommodating to his clients! And he provides support for any reported bugs or issues. He also accepts suggestions.

Contact the developer

Here are the options how you can contact the developer to inquire, get a trial version, or purchase the Premium version.

  • AA Excel Spreadsheets on Facebook
  • Or our Contact form below
Please input here your questions, inquiries to the PSE Trading Journal developer.

Download the PSE Trading Journal Spreadsheet (Trial version). Try it for yourself and experience how it works.

If you want to get the latest TRIAL version and try how PSE Trading Journal spreadsheet works, then send us your email address below and you will get the links from the automated response. If you have any further questions or inquiries, please use the options above.

And here’s how we rated this product

  • Portability
  • Accessibility
  • Data Retention
  • Data Accuracy
  • Support
4.8

Our verdict

PSE Trading Journal Spreadsheet V8.1 is fully loaded with very informative charts, tables and information. Overall, for me, the tool is very handy and useful! This is specially when tracking your trades. You can track your historical mistakes and wins which will help you improve your future trades!

If you get the chance to use this tool, we encourage you to rate it please! Also, if you have comments about this product – positive or negative, please add it below so that it reaches the developer to fix/improve.

Sending
User Review
2.67 (9 votes)
Share on X (Twitter) Share on Facebook Share on Pinterest Share on LinkedIn
Prev Article
Tags:How To Our Picks PSE Review Spreadsheet Stocks Trading

2 Comments

  1. Ronnel Vargas

    Hi,

    This is to request if you could share the trial version of the trading journal spreadsheet, please?.

    Thank you!

    Regards,
    Ronnel Vargad

    April 8, 2019
    • Arsie Organo Jr.

      Sorry, I am not the developer. You can contact him through his FB page.

      April 8, 2019

Interesting Articles

  • Learn How To Plan Your Trade Using A Trading Journal Spreadsheet (PSE)
    Learn How To Plan Your Trade Using …

More From The Author

  • Real-Life Flying Car Will Be Available By 2020 – AeroMobil
    Real-Life Flying Car Will Be Available By …
  • Top Benefits of Using Smart Switch for Galaxy S7 You Need To Know
    Top Benefits of Using Smart Switch for …
  • Steps How To Setup SOCKS5 Proxy Using Chrome Extension
    Steps How To Setup SOCKS5 Proxy Using …
  • Apple iOS 8.2 Update Battery Trick To Make It Last Longer
    Apple iOS 8.2 Update Battery Trick To …
  • Meet Kharbon, A True Wireless Waterproof Earbuds (IP67) with Battery Life That Can Last For A Month
    Meet Kharbon, A True Wireless Waterproof Earbuds …
  • Finding The Best GPS Fleet Tracking System Simple Tricks
    Finding The Best GPS Fleet Tracking System …
  • Introducing NOIR- The Eyes and Ears of Your Security System
    Introducing NOIR- The Eyes and Ears of …
  • 5 Best Mobile VPN Apps for 2019 and Why You Need Them
    5 Best Mobile VPN Apps for 2019 …
  • How Pneumatic Linear Actuators Work
    How Pneumatic Linear Actuators Work
  • The Amazing Technology in Nursing Uniforms
    The Amazing Technology in Nursing Uniforms

Bug Thinking

Copyright © 2025 Bug Thinking
All Rights Reserved. Sitemap · RSS Feeds · About Us · Contact Us · Archives · Privacy Policy · Cookie Policy