SpreadSheets
How To Read The Spreadsheets.
Here are the basics of how my spreadsheet works and what the various columns and rows track. As time goes on, I will be building new features onto the sheet. The following may or may not be an up-to-date representation and instruction set.
Title and Starting Port Balance.
My Pre-Trade Entry Balance. Balance Before Urealized Profits/Losses.
Last date and time the spreadsheet has been updated
Last (5) Trade-Related actions I have taken. I do this, in part, to avoid over-posting here on every little action that I take. When paid subscriptions are active (not paused), I will likely have a paid subscribers chat enabled which will also detail many of these actions.
Each column is labeled with the most self-explanatory label I could think of given the space limitations.
Ticker Symbol is the symbol of the investment or trade I have open orders or trades in.
Number of Tokens is the number of tokens or shares I will be trading.
Entry Price per Token - how much I paid for each token/share.
Money in Trade - how much of my portfolio balance in dollars I have allocated for this particular position.
Balance Allocation - the percentage of my portfolio I have allocated. Typically, this should be 10-20%.
Entry Date - Date of entry into the trade.
Target(s) - this is the target price that I am shooting for. I plan on exiting at this price. However, it should be noted that this target or these targets are often moving targets. Reason? The target is initially chosen upon entry time. Often, the data on my charts will change: new levels are found, new patterns, new trendlines, or the price action is faster/slower than expected. Sometimes there is news. Etc., etc. Stuff changes all the time and therefore I will often adjust both my target and my stop limit (next).
Stop Limit - this is the price I have chosen to exit should the trade go south. Again, this is a moving target (see Target(s) explanation).
Risk/Reward - This is the amount of reward per risk at the time of entry. So, for instance, if I have a 3/1 risk/reward ratio, it simply means that the amount of reward is 3 times greater than the risk-based upon my target set at the time of entry and the stop limit.
Exit Date - the date I have exited the trade.
Exit Price - the price at which I have exited.
% Profit - percent of profit I have made.
% Loss - percent of loss on a trade.
Weight - (see balance allocation, same thing)
Profit/Loss - This is the dollar amount of my profit or loss.
Money Out of Trade - the dollar amount I took out of the trade.
Days in Trade - the number of days I remain in this trade.
Additionally, in the first column under Ticker Symbol, you will see Stable Coin and Open Trades. Stable Coin is how much of my portfolio is in some type of virtual cash (USD, USDT, USDC, etc.) and Open Trades are the trades I am currently in. Some of these trades may be Longs and some of these trades may be Shorts. If there is a short trade I enter (rarely), it will be denoted by the word “short” after the ticker (i.e.- XRP Short).
Near the bottom of my spreadsheet you will find:
Closed Trades are all the trades that I have closed.
My Wins vs Losses ratio. In the above, I have 143 winning trades to 61 losses.
Finally, on the bottom half of the spreadsheet, you will see the following:
Average Profit Per Trade is the average profit (or loss) of ALL trades regardless of weight.
APY shows a very rough estimate of what percentage of gain my portfolio is currently on pace to make every year.
Pre-Trade Balance again reflects my current portfolio balance minus current Open Trade unrealized profit or loss.
There is one more item to note. See the Average row from the screen capture above? At the end of this row, you will see the number 12. This number denotes the average time that it has taken me to make a trade, from entry to exit. Generally, I am a swing trader. So, this number should remain around 14 days give or take a few. That is about the average time per each of my trades.
Hope this helps.
Let me know in the comments if you have any further questions on the spreadsheet.
Greatly appreciated!