SpreadSheet
Discover more from Stewdamus' Chart Analysis & Trade Alerts
Traders,
I have been asked in the past to explain how my spreadsheet works and what the various columns and rows track. So, allow me to break it down a bit for you.
Denotes the starting balance, $10,000.
How many successful closing trades in a row we have won.
Last date and time the spreadsheet has been updated
Current portfolio allocation in USD, USDC, USDT, or other stablecoin
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 - date I have exited the trade.
Exit Price - 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 Open Orders and Open Trades. Open Orders are the orders I have set to trigger upon a preconceived price target (or other trigger) 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.
Closed Trades are all the trades that I have closed and will also have a Longs and a Shorts category.
If I have leverage any trades you will see an x followed by the multiple I have leveraged the trade at. For example, ETH x5 means that I have leveraged an Ethereum trade at a multiple of 5x.
Finally, on the bottom half of the spreadsheet you will see the following:
Average is the average profit (or loss) per ALL trades
Weighted Avg.** denotes the variable portfolio increase or decrease based upon the percentage of balance being allocated to that particular trade vs. a consistently even balance being allocated per trade (i.e.- 10% per trade, every trade, all year)
APY*** shows what percentage of gain my portfolio is currently set to make in the given year. This changes often based upon the most recently closed trade data.
Balance reflect my current portfolio balance minus current Open Trade profit or loss.
There is one more item to note. See the Average row from the screen capture above? All the way at the end of this row you will see the number 16. 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 trade.
Hope this helps.
Let me know in the comments if you have any further questions on the spreadsheet.
Link to Spreadsheet:
SpreadSheet
Greatly appreciated!