NexusFi: Find Your Edge


Home Menu

 





Question about calculating Rate of Return?


Discussion in Trading Journals

Updated
      Top Posters
    1. looks_one Quick Summary with 1 posts (0 thanks)
    2. looks_two smtlaissezfaire with 1 posts (2 thanks)
    3. looks_3 Godzilla with 1 posts (0 thanks)
    4. looks_4 MrGreen1 with 1 posts (0 thanks)
    1. trending_up 1,135 views
    2. thumb_up 2 thanks given
    3. group 3 followers
    1. forum 3 posts
    2. attach_file 1 attachments




 
Search this Thread

Question about calculating Rate of Return?

  #1 (permalink)
 MrGreen1 
Providence, Rhode Island/USA
 
Experience: Beginner
Broker: Tradovate, Finamark
Trading: ES, NQ
Posts: 12 since Feb 2020
Thanks Given: 3
Thanks Received: 5

I'm in the process of building my trading journal, and am messing around with some hypothetical numbers to try and understand the proper way to calculate rate of return. Please see the attached screenshot. I guess my question is, how do you include deposits and withdrawals in your calculation?

In the hypothetical example in the screenshot, would you include the deposit and withdrawal in calculating rate of return?

My understanding is that I would take the total of the beginning balance, plus any deposits, minus any withdrawals. Then take the net profit (gross profit minus commissions and fees) and divide that by the total of the beginning balance, deposits and withdrawals. Am I doing this right? Am I missing anything?

Thanks

Attached Images
 
Visit my NexusFi Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Exit Strategy
NinjaTrader
Are there any eval firms that allow you to sink to your …
Traders Hideout
Futures True Range Report
The Elite Circle
Better Renko Gaps
The Elite Circle
Build trailing stop for micro index(s)
Psychology and Money Management
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
23 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #3 (permalink)
 smtlaissezfaire 
Oakland, CA
 
Experience: Intermediate
Platform: Phone
Trading: US Treasuries Futures
Posts: 83 since Jun 2018
Thanks Given: 95
Thanks Received: 120


Sure, although it's very simplistic as it's not time weighting your capital (for instance, let's say you made 100% on that capital, but then at the end of the year deposited 100,000 - it would look like you didn't make very much).

Also, depending on what you are calculating, you might want to look at compound growth vs. average growth (although it shouldn't matter if you only have one holding period).

I found a series of finance courses on coursera helpful:

https://www.coursera.org/learn/portfolio-selection-risk-management (and you can checkout that whole series)

Also some stuff on investopedia:

https://www.investopedia.com/terms/t/time-weightedror.asp
https://www.investopedia.com/terms/m/money-weighted-return.asp

And:

https://www.betterment.com/resources/betterment-calculate-investment-returns/

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #4 (permalink)
Godzilla
Brisbane, Australia
 
Posts: 206 since Nov 2013
Thanks Given: 43
Thanks Received: 353

Try this.....I think this is what you are looking for....

https://www.get-digital-help.com/calculate-your-stock-portfolio-performance-with-net-asset-value-based-on-units-in-excel/

Reply With Quote




Last Updated on March 10, 2020


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts