NexusFi: Find Your Edge


Home Menu

 





Need help calculating Daily NAV, 3 trade example


Discussion in Currencies

Updated
    1. trending_up 1,448 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?
What broker to use for trading palladium futures
Commodities
How to apply profiles
Traders Hideout
REcommedations for programming help
Sierra Chart
MC PL editor upgrade
MultiCharts
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 




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