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

in #cryptocurrency7 years ago (edited)


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:

Sort:  

Congratulations! This post has been upvoted from the communal account, @minnowsupport, by lucasgabd from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, and someguy123. The goal is to help Steemit grow by supporting Minnows and creating a social network. Please find us in the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.

If you like what we're doing please upvote this comment so we can continue to build the community account that's supporting all members.

This post has received a 3.64 % upvote from @bellyrub thanks to: @lucasgabd.

You should check out Cointracking Portfolio Manager.

It has

  1. Automatic import of trades through APIs.
  2. Average purchase and sale price reports.
  3. Booked and unbooked profits.
  4. Ability to calculate your taxes.
  5. Set up price notifications.

For details of how to use these features checkout this post.

I’ve been testing the platform already and its great. But subscription fee is too high for me...

Coin Marketplace

STEEM 0.19
TRX 0.13
JST 0.030
BTC 62907.89
ETH 3379.73
USDT 1.00
SBD 2.50