NexusFi: Find Your Edge


Home Menu

 





Need help calculating Daily NAV, 3 trade example


Discussion in Currencies

Updated
    1. trending_up 1,441 views
    2. thumb_up 0 thanks given
    3. group 1 followers
    1. forum 1 posts
    2. attach_file 0 attachments




 
Search this Thread

Need help calculating Daily NAV, 3 trade example

  #1 (permalink)
nycgags
Miami Florida United States
 
Posts: 1 since Feb 2013
Thanks Given: 0
Thanks Received: 0

Hi -

I guess I don't need my NAV, what I need is my ROI (buddy told me they are not the same) for my algo.

I trade 6E and never have overlapping trades in 1 day.

My broker requires a margin of $1237.50 per contract.

My system only makes 1 trade at a time (no overlap). I also know what the maximum I can lose on any given trade when the trade is initiated via the stop loss order I place (this can be a different amount for each trade)

Commissions come out to $2.91 per contract each way (both buy and sell). Each tick that 6E moves is worth $12.50 per contract traded (trading 6E).

I adjust the number of contracts per trade using a simple risk calculation which I won’t bother going into, but just know it fluctuates between trades based on balance, risk factor (10%) and max loss size. I know 10% is overly aggressive most futures traders use a number of 1-5% and I am playing around with a few different models, but for this example, # of contracts is using a risk factor of 10%.

So here is an example where I am trying to calculate my ROI for 1 day:

All 3 trades occur in the same day

Starting balance = $6,000.00
Trade 1: SELL 3 6E @126.58 -- MAX LOSS = 16 ticks x $12.50 per tick x 3 contracts = $600 | margin required = $3712.50 = (1237.5 x 3)
Result: BUY 3 6E @126.41 -- gained 17 ticks x 3 contracts or 51 total ticks
Gross: ((3x126.58 – 3x126.41) / 0.01) x 12.50 = $637.50
Commissions: 3 x 2 x $(2.91) = $(17.46)
PNL: = $620.04
Ending balance = $6,620.04

Starting balance = $6,620.04
Trade 2: BUY 2 6E @126.34 -- MAX LOSS = 19 ticks x $12.50 per tick x 3 contracts = $475 | margin required = $2475.00 = (1237.5 x 2)
Result: SELL 2 6E @126.21 -- lost 13 ticks x 2 contracts or (26) total ticks
Gross: ((2x126.21 – 2x126.34) / 0.01) x 12.50 = $(325.00)
Commissions: 2 x 2 x $(2.91) = $(11.64)
PNL: = $(336.64)
Ending balance = $6,283.40

Starting balance = $6,283.40
Trade 3: SELL 3 6E @126.08 -- MAX LOSS = 16 ticks x $12.50 per tick x 3 contracts = $600 | margin required = $3712.50
Result: BUY 3 6E @125.92 -- gained 16 ticks x 3 contracts or 48 total ticks
Gross: ((3x126.08 – 3x125.92) / 0.01) x 12.50 = $600
Commissions: 3 x 2 x $(2.91) = $(17.46)
PNL: = $582.54
Ending balance = $6,865.94

Ok so my PNL on the day is simply: ($6,865.94 - $6,000.00) = +865.94 -- overall gained 73 ticks

So now I need to calculate my ROI for the day, I have the numerator = ($6,865.94 - $6,000.00) = $865.94 = PNL below
So now I need to figure out the denominator. I figure there are 4 different ways to go about this:

A. PNL / SUM ( margin )
B. PNL / (SUM ( margin ) + SUM ( max loss ))
C. PNL / (MAX ( margin ) + SUM ( max loss ))
D. PNL / SUM ( max loss )

Here are the different results:

A. 865.94 / (9900) = 8.7469%
B. 865.94 / (9900 + 1675) = 7.4811%
C. 865.94 / (3712.50 + 1675) = 16.073%
D. 865.94 / (1675) = 51.698%

I’m leaning towards C, but would happily be surprised if D was true since the margin is not really at risk, well I guess it is if the broker fails to place my initial stop loss order in their system but that is highly unlikely.

The whole reason I am trying to do this is to eventually calculate my Sharpe's but I needed to start somewhere.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Deepmoney LLM
Elite Quantitative GenAI/LLM
Better Renko Gaps
The Elite Circle
Are there any eval firms that allow you to sink to your …
Traders Hideout
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Online prop firm The Funded Trader (TFT) going under?
Traders Hideout
 
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
GFIs1 1 DAX trade per day journal
22 thanks
NexusFi site changelog and issues/problem reporting
22 thanks
The Program
20 thanks




Last Updated on April 15, 2013


© 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