Basic Google Sheets Trade Journal based on Excel version made by Alex from PrimeTrading (substack, twitter, discord).
NEW: Includes 30 days free trial of full package with charts and reports! To get the full potential from the trade journal after those 30 days, buy the full package for a one time payment of $35.
What you get for free for ever
- Open and close trades via dialogs
- Various statistics like average wins/losses, max. wins/losses, Risk/Reward Ratio etc.
- Diagrams showing win/loss ratio and avg. win/loss visually
- Profit / loss, open heat, open profit etc.
- All of the above can be filtered via a customizable date-selector.
- Customizable technical setups
- Direct link to TradingView
- Import data from prior version and Alex’ latest trading journal
- Equity deposits / withdrawals for most accurate calculations of various KPIs
- Max. exposure calculation
- Position sizing tool
DISCLAIMER
Use at your own risk! Although I have strived to make everything correct and tested thoroughly , I can not be held legally responsible for any decisions made, based on the data / diagrams in this spreadsheet.
The sheet is operating with dollar amounts, so it’s not suitable if you trade in other currencies!
Financial data (ticker description and current price) is fetched via the built-in GoogleFinance function which is known to fail from time to time. A refresh of the sheet often helps.
Google does not pull in stock data from all exchanges in the world, but you always maintain description and current price manually.
Prices from GoogleFinance may be delayed up to 20 min.
Only tested in Google Chrome browser (latest version)!
By using the Trading Journal you consent to the above!
Documentation:
https://docs.google.com/document/d/1t3rHTk1zHBoL180Szht9Q5cQzcfeeGkxii9fAE5BjWI/edit?usp=share_link