"Trading History" to the rescue! A simple spreadsheet to track your trades - like it? please give it an upvote


Hey dear steemers. how is it going?
So, I've been trading now and then as a past time, since I really enjoy graphics and the logic behind it.

Since I'm pretty new into this world I missed to have a way to keep track of the positions opened and the outcomes of each position, so I can study and learn with my mistakes, and keep track of my progress.

i've been reading about position sizing and risk management and decided to create a spreadsheet that wouldn't take me a really long time to fill with data.

trading history spreadsheet.png

Right now you input only the date you started the trade and the date you went ouy of it.
As well as the amount of money you go in and the outcome.
There's also a comment collumn so you can take notes on each trade and a space to put a trading view screenshot of what you saw at the moment.

The spreadsheet will give you how many days you stayed in the trade, the % outcome of this particular trade and the % outcome in relation with the total you have in your trading account.

On the top right you can also set up the total you have and the % you'll use for trading (standard is set to 25% for trade but you can change it). As well as the máx risk per trade, by standard in 1%. This would be the maximum amount it'd be ok for you to loose in a particular trade, so you can set up your stops and calculate your position size accordingly

Here you have a link to check the spreadsheet and download it

All values are made up, not real values. ;)

I'm really interested on knowing your opinion about it.
Any suggestions to improve this file without making it to complex and time-taking?
What do you think is missing?
How do you track your trades?

Was this usefull? consider making a small donation:

BTC: 19YfJdvz5tq7UtYD7LJkC8Znpk2d5NcrYP
DCR: DsSpx5gSARRkSvwMQL8w1Z83jmPSFdSWcKM
LTC: LPKJoxUoLbCLvGVjxp2KU9dVQ42gqRzGBD


If you like this post please give it an upvote, resteem and follow me. Steem on!

for other social media websites:
reach me at Malabarize-se on Youtube, facebook, Google+ or @lucasgabd on Twitter

Picture source: Wikimedia commons and my own screenshot.

Thanks a lot dear friends!
Talk to you soon!

My latest posts:

H2
H3
H4
3 columns
2 columns
1 column
5 Comments