Simple Stock Trading Journal with Excel Marco（vba）

Author：肉松郁弥
发布时间：April 4, 2021
11212views
75 comments
4073 words
Categories：投资理财工具

![image.png](https://do1024.com/usr/uploads/2021/04/2741250945.png)

## Hi guys~

There is a customized excel file with Macro, named “Stock Trading Journal V1.4.4” developed by me, aiming to help you better keep track of the investment on stocks.

### This file contains two sheets:

trading and holding. Trading sheet is to input and record information of every transaction you have made while holding sheet is a summary of your stock holdings and investment history.

![image.png](https://do1024.com/usr/uploads/2021/04/253178053.png)

### Trading sheet consists of four parts:

- input info
- trading details
- table
- query & outcome and charts

When there is a new transaction, please input the transaction info including: trade date, stock code or name, price, quantity and then click the corresponding action made: Long, Short, Short Buy or Short Sell. All the cells for transaction info are a MUST, i.e. any of the info missing will trigger a error message box “ Pls complete the info”. Trade date is displayed in “mm-dd-yyyy” format.

![image.png](https://do1024.com/usr/uploads/2021/04/1058554204.png)

Every transaction info that is input will be synchronized to trading details table with more info such as, is the buying action a catch up or cover up for the same stock and the average price for it, is the selling action a stop profit (T/P) or stop loss (S/L) and how much profit or loss has been realized. Also you can write down your trading basis and reflections on the transaction.

![image.png](https://do1024.com/usr/uploads/2021/04/3763208735.png)

For frequently- trading investor who wants to know your outcome in a certain period or on a specific stock, the query part can help. Query by date range, input start date and end date separately, and click the green button ”Calculate”. Or query by individual stock, type in the stock code or name and click “Query” button, you will get your no. of profit and loss times as well as profit and loss amount under your query criteria.

Pls be noted, both “Ttl Capital” and “Ttl Realized Profit” are a sum up amount of all stocks which means the two has no relations with your query.

![image.png](https://do1024.com/usr/uploads/2021/04/3126657915.png)

![image.png](https://do1024.com/usr/uploads/2021/04/1823383710.png)

The charts show more vividly and clearly your portfolio, profit and loss and success rate.

![image.png](https://do1024.com/usr/uploads/2021/04/3531444588.png)

There is also “Carry Forward” part, you can input previous record of no. and amount of profit and loss, say, record for the last half year, these previous history will be accumulated to the new trading info, which allows you to have a full picture of investment outcome for a certain period.

![image.png](https://do1024.com/usr/uploads/2021/04/4212126223.png)

Holding sheet summarizes your transactions briefly including total No. of shares on hand, transaction and liquidation date and calculates holding days too. All information on holding sheet is automatic and source data comes from the information on trading sheet. Generally, you don’t need to do anything on holding sheet.

![image.png](https://do1024.com/usr/uploads/2021/04/154041200.png)

![image.png](https://do1024.com/usr/uploads/2021/04/3492807294.png)

## Download

This file is free to download.

<button class="btn m-b-xs btn-success  " onclick='window.open("https://do1024.com/usr/uploads/2021/04/3406264660.zip","_blank")'>DOWNLOAD</button> ←Click HERE.

Welcome to leave your comments, suggestions and advice so that we can make it better for use.

Feel free to leave message to me if there is any bug or you have difficulty opening or using it.

### Unzip password:

<div class="hideContent">此处内容需要评论回复后（审核通过）方可阅读。</div>

![image.png](https://do1024.com/usr/uploads/2021/04/2407632683.png)

A password is required to open the file. Password is accessible after you leave your comments .
If it doesn’t work after comments, try to refresh the page please.

***Appreciate help from Katrina Xu on this English version file and instructions.***

Last modification：April 4th, 2021 at 02:24 pm

请博主喝一杯咖啡

75 comments

cnc
May 26th, 2023 at 06:26 pm

thanks

Reply
chulo
May 7th, 2023 at 11:26 pm

Esta bueno

Reply
F
February 17th, 2023 at 11:55 pm

password please

Reply
F
February 17th, 2023 at 11:26 pm

thanks

Reply
vbalover
February 3rd, 2023 at 08:55 pm

thanks

Reply
Sabre
January 21st, 2023 at 04:39 am

Great!

Reply
testeurvba
November 2nd, 2022 at 11:46 pm

该评论仅登录用户及评论双方可见

Reply
ken
September 29th, 2022 at 12:18 pm

good

Reply
nobre
September 17th, 2022 at 01:32 am

great

Reply
hscent
September 16th, 2022 at 04:30 am

该评论仅登录用户及评论双方可见

Reply
abcmy
September 11th, 2022 at 02:35 pm

thanks for sharing

Reply
Jason
September 11th, 2022 at 06:15 am

good

Reply
navid
September 8th, 2022 at 02:47 am

good

Reply
mylor
August 20th, 2022 at 12:56 am

thank you a lot

Reply
Mark
August 17th, 2022 at 06:35 pm

looks great!

Reply
Alex
August 8th, 2022 at 03:05 am

Thanks

Reply
John Nguyen
August 4th, 2022 at 08:46 pm

Thanks

Reply
bhavesh
August 4th, 2022 at 07:17 pm

good one

Reply
Amir
August 1st, 2022 at 03:59 pm

thtas good

Reply
The Loser
July 24th, 2022 at 06:22 pm

Looks like a great idea

Reply

Simple Stock Trading Journal with Excel Marco（vba）

肉松郁弥 • 2021 年 04 月 04 日