Spreadsheet: 583276d1532352904-journal-for-trading-stocks-help-journalforstocks-updated
Sheet: Description

Cell | Description | Does it work? | Notes
Win / Loss | If the trade is a winner a Green cell with the text 'Win'. If the trade is a loser, a Red cell with the text 'Loss'. | YES
Open Date | Shows the date the trade was taken. | Yes
Open Time | Shows the time the trade was taken | Yes
Exit Date | Shows the exit date of the trade. | Yes
Exit Time | Shows the exit time of the trade. | Yes
Symbol | The ticker code for the company that I will trading shares in. (example: TSLA - Teslar) | Yes
Type | Long' means buying the stock hoping the price increased - Buy @ $1.00 Sell @ $1.50. 'Short' means selling the stock and buying it back at a lower price. Sell @ $1.50 buy back @ $1.00. | Yes
Setup | The reason/plan why to buy the stock. | Yes
Entry Price | The price I will enter the trade at. | Yes
Price Target | The price I will exit the trade to make a profit. | Yes
Stop Loss | The price I will exit the trade if the price action goes against my trade. Limits my loss | Yes
Risk Per Share | The amount I am willing to hold a losing trade before the Stop Loss kicks in. On a 'Long' trade will show as $0.50. On a 'Short' trade will show as -$0.50 | Yes
Profit Per Share | The amount of Profit I will make per share. On a 'Long' trade will show as $0.50. On a 'Short' trade will show as -$0.50 as the trade hit the 'Stop Loss' and I will close out the position. | Yes
Risk to Return Ratio | The amount I am willing to risk to gain the reward. I risk $0.50 per Share (willing to loose per share before I stop out) to make (profit) $1.60 per share. A '3' should be about right. Risk 1 to make 3 | Yes
Position Size | The value of the trade. (Number of Shares X Entry Price ) | Yes
Return $ | The value of Profit or Loss that I made on the trade. $1,500.00 If I make a losing trade, to have the loss in  brackets. ($1,500.00) | YES
Return % | The value of Profit or Loss I made on the trade shown in %. Gain would be 15%. [NAME] would be -15% | Yes and No | Return%  seems to be working I didn't change it.
Totals | Shows the totals of: Number of trades made - Amount of shares traded - running gain/loss profit total -
[NAME] | Shows the win rate of my trades - 10 trades, 7 wins, 3 losses will show --> 70% | YES | Same as # of winning trades
Total Gain / Loss | The amount of profit / Loss concurrently of all trades made. (example $1000.00 + $1500.00 - $500.00 + $2000.00 - $200.00 = $3800.00) | YES
Average gain /Profit | An average of the total gain / loss from above. | YES
Average win per trade | Average of the trades that I win.  $1000.00 + $1500.00 + $2000.00 = $4500.00 / 3 trades = $1.500.00 | YES
Average Loss per trade | Average of the trades that I loss. $500.00 + $200.00 = $700.00 / 2 trades = ($350.00) | YES
Largest Win | Largest Win - $1,200.00 | YES
Largest Loss | Largest Loss - ($1,200.00) | YES
Total Trades | Number of Trades made. | Yes
Average Shares per trade | Average number of shares per trade. 5000 shares traded / 5 trades = 1000 average | Yes
Average holding time for winning trades | Average time of holding a trade  that results in profit from entry to exit. | YES | Figures Hours only. Won't calculate days.
Average holding time for losing trades | Average time of holding a trade  that results in a loss from entry to exit. | YES | Figures Hours only. Won't calculate days.
[NAME] | Shows the [NAME] consecutive wins. | YES
[NAME] | Shows the [NAME] consecutive losses. | YES
Number of Winning Trades | Shows the number of wining trades - 10 trades,  7 wins will show --> 7 | YES
Number of Winning Trades | Shows the number of losing trades - 10 trades, 3 losses will show --> 3 | YES
Number of Winning Trades % | Shows the number of winning trades in % - 10 trades, 7 wins will show 70% | YES
Number of Winning Trades % | Shows the number of losing trades in % - 10 trades, 3 losses will show 30% | YES
 | On the first trade, I went short with an 'Entry Price' $9.75. My 'Price Target' is $8.00 . My 'Stop Loss' was at $10.32. I risked $0.57 per share as if the stock price went to $10.32 my Stop Loss would be hit and I will close my position at a loss ($570). I exited my position at $8.00 for a $1.75 Profit Per Share. My total profit was $1,750. The calculations were correct but the spread sheet it shows a '-' on "Risk Per Share/Profit Per Share/Return $/Return %" where they should not as it was a winning trade. How can I fix this?
 | On the second trade, I went 'long' with an 'Entry Price' $10.00. My 'Price Target' is $11.50. My 'Stop Loss' was at $9.50. I risked $0.50 per share as if the stock went to $9.50 my 'Stop Loss' would be hit and I will close my position for a loss ($500.00) My total profit was $1,500.00. All calculations seem to be correct.
 | On the third trade, I went short with an 'Entry Price' $9.75. My 'Price Target' is $8.00 . My Stop Loss was at $10.32. I risked $0.57 per share as if the stock price went to $10.32 my Stop Loss would be hit and I will close my position at a loss ($570). This time, the trade went against me and I lost the trade. Total lost $570.00. The spreadsheet shows the lost, but not in brackets, like this ($570.00), the 'Profit Per Share' should show -$0.57 and the 'Stop Loss' was hit. Also there are no '-' at the start of [Return %] value, like this -6%.
 | On the forth trade, I went 'long' with an Entry Price $10.00. My 'Price Target' is $11.50. My 'Stop Loss' was at $9.50. I risked $0.50 per share as if the stock went to $9.50 my 'Stop Loss' would be hit and I will close my position for a loss ($500.00). This time, the trade went against me and I lost the trade. Total loss $500.00. All calculations seem to be correct