![]() R Multiple: P&L divided by the initial risk.P&L: The actual P&L, including commission.I have it set to calculate based on the number of shares entered in column E. Comm: Commission for both sides of the trade.Initial risk: Dollars at risk based on the initial stop.Trade #: Just used for some calculations later.This formula must be modified each day to include the latest rows. Expectancy: An average of column K (R Multiple). ![]() Here's some details about the columns included: It's not the most elegant spreadsheet but it does what I need. I uploaded it to the server so feel free to download a copy if you're interested. I've had quite a few requests for a copy of the spreadsheet I use for my trading journal. 2021 UPDATE: Read my guide to the Best Trading Journals tips on how to successfully maintain your journal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |