NexusFi: Find Your Edge


Home Menu

 





Outperforming the S&P 500


Discussion in Traders Hideout

Updated
      Top Posters
    1. looks_one Big Mike with 20 posts (15 thanks)
    2. looks_two ron99 with 11 posts (14 thanks)
    3. looks_3 SMCJB with 7 posts (2 thanks)
    4. looks_4 gtrader62 with 3 posts (0 thanks)
      Best Posters
    1. looks_one shodson with 5 thanks per post
    2. looks_two grausch with 1.7 thanks per post
    3. looks_3 ron99 with 1.3 thanks per post
    4. looks_4 Big Mike with 0.8 thanks per post
    1. trending_up 25,177 views
    2. thumb_up 52 thanks given
    3. group 14 followers
    1. forum 54 posts
    2. attach_file 5 attachments




 
Search this Thread

Outperforming the S&P 500

  #51 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,440 since Jun 2009
Thanks Given: 33,212
Thanks Received: 101,599

From the notes on IB's report:



Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
How to apply profiles
Traders Hideout
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
MC PL editor upgrade
MultiCharts
Trade idea based off three indicators.
Traders Hideout
Bigger Wins or Fewer Losses?
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
33 thanks
Tao te Trade: way of the WLD
24 thanks
My NQ Trading Journal
14 thanks
HumbleTraders next chapter
11 thanks
GFIs1 1 DAX trade per day journal
11 thanks
  #52 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,440 since Jun 2009
Thanks Given: 33,212
Thanks Received: 101,599


ron99 View Post
How does this factor for timing of withdrawals? If you withdraw on the 2nd vs on the 30th, this would affect ROI for the month.

For IB at least, during the reporting period the NAV will be used in combination with net deposit/withdrawal. The % return on capital is based on the starting balance on the first day of the reporting period. From that day forward, IB calculates the NAV +/- the deposit/withdrawal activity.

For the time period report (day by day return) it uses the NAV at the close from the prior day to calculate the return of the current day, also calculated at the close. So for example looking at my report, on January 20th I had a 18.38% return, meaning my account capital grew 18.38% close-to-close from Jan 19 to Jan 20. If I had a withdrawal on that same day, it would not effect the % return, as it is based on NAV.

Someone please feel free to correct me if I am wrong, but this is my understanding. I should probably double check to see if I am right so don't bet your life on it until you've done so for yourself.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #53 (permalink)
 grausch 
Luxembourg, Luxembourg
 
Experience: Advanced
Platform: TWS
Broker: Interactive Brokers
Trading: Stocks
Posts: 494 since May 2012
Thanks Given: 1,731
Thanks Received: 1,159



ron99 View Post
How does this factor for timing of withdrawals? If you withdraw on the 2nd vs on the 30th, this would affect ROI for the month.

Calculating the NAV on the day PRIOR to the withdrawal is required. If you withdraw on the 2nd, you would calculate a NAV per share as of the 1st, adjust your number shares and then recalculate your NAV per share at month-end. In my example above, if the withdrawal happened on the 2nd, the number of shares would be adjusted downwards to 909,0909. If the account is then at $9,500 at month end, the NAV per share would be 10.45.

I used to calculate my NAV on a daily basis, but that is not really required. You only need a starting NAV, a NAV on the day before withdrawals and then a NAV on your preferred return dates (month-end, quarter-end, or year-end).

Reply With Quote
Thanked by:
  #54 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,440 since Jun 2009
Thanks Given: 33,212
Thanks Received: 101,599

A quick verification:

On 3/17 I withdrew $75,000:



You can see it didn't effect the calculation for the daily return:



Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #55 (permalink)
 grausch 
Luxembourg, Luxembourg
 
Experience: Advanced
Platform: TWS
Broker: Interactive Brokers
Trading: Stocks
Posts: 494 since May 2012
Thanks Given: 1,731
Thanks Received: 1,159


Big Mike View Post
For IB at least, during the reporting period the NAV will be used in combination with net deposit/withdrawal. The % return on capital is based on the starting balance on the first day of the reporting period. From that day forward, IB calculates the NAV +/- the deposit/withdrawal activity.

For the time period report (day by day return) it uses the NAV at the close from the prior day to calculate the return of the current day, also calculated at the close. So for example looking at my report, on January 20th I had a 18.38% return, meaning my account capital grew 18.38% close-to-close from Jan 19 to Jan 20. If I had a withdrawal on that same day, it would not effect the % return, as it is based on NAV.

Someone please feel free to correct me if I am wrong, but this is my understanding. I should probably double check to see if I am right so don't bet your life on it until you've done so for yourself.

Mike

Mike, you are correct. The percentage return is calculated by calculating (NAVtoday / NAVyesterday) - 1. If you have a withdrawal on the 20th, then IB would need to adjust the NAVyesterday (19th) for that withdrawal. However, this is only applicable from the 20th onwards and no adjustment is made for the % calculation on the 19th.

IB's method is similar to the method I highlighted earlier. The algebra has just been shuffled around a bit and it is probably easier to calculate this way in Excel. I recall using this approach for my initial performance spreadsheets, but honestly can't remember why I changed. Could just be that it made troubleshooting in Excel easier.

Reply With Quote
Thanked by:




Last Updated on March 23, 2015


© 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