NexusFi: Find Your Edge


Home Menu

 





Optimal F ( Position Size ) Spreadsheet/Excel


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one askerix with 2 posts (1 thanks)
    2. looks_two robert880 with 2 posts (2 thanks)
    3. looks_3 vpd1952 with 2 posts (0 thanks)
    4. looks_4 Pluto with 1 posts (2 thanks)
      Best Posters
    1. looks_one kevinkdog with 2 thanks per post
    2. looks_two Pluto with 2 thanks per post
    3. looks_3 robert880 with 1 thanks per post
    4. looks_4 askerix with 0.5 thanks per post
    1. trending_up 5,906 views
    2. thumb_up 8 thanks given
    3. group 6 followers
    1. forum 8 posts
    2. attach_file 1 attachments




 
Search this Thread

Optimal F ( Position Size ) Spreadsheet/Excel

  #1 (permalink)
vpd1952
memphis
 
Posts: 77 since Mar 2020
Thanks Given: 211
Thanks Received: 23

Does someone still happen to have what I believe was an Excel based ( Optimal F ) spreadsheet?

I remember it was from roughly 4 or 5 years ago

You could punch in your various Trading parameters ( Account size, Risk per trade Percent, Number of Contracts, etc. ) and it would populate your Optimal F for any particular trading scenario

Thanks so much to anyone who has it and would be willing to share and or can point me to it or one similar

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Exit Strategy
NinjaTrader
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
ZombieSqueeze
Platforms and Indicators
NexusFi Journal Challenge - April 2024
Feedback and Announcements
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
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
24 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #2 (permalink)
Pluto
Celebration, FL
 
Posts: 2 since Sep 2010
Thanks Given: 85
Thanks Received: 1


vpd1952 View Post
Does someone still happen to have what I believe was an Excel based ( Optimal F ) spreadsheet?

I remember it was from roughly 4 or 5 years ago

You could punch in your various Trading parameters ( Account size, Risk per trade Percent, Number of Contracts, etc. ) and it would populate your Optimal F for any particular trading scenario

Thanks so much to anyone who has it and would be willing to share and or can point me to it or one similar

Not sure if this is the one you are referring to, but see what you think.

Attached Files
Elite Membership required to download: Risk Adjusted Optimal F.xlsx
Reply With Quote
Thanked by:
  #3 (permalink)
vpd1952
memphis
 
Posts: 77 since Mar 2020
Thanks Given: 211
Thanks Received: 23


Pluto,
you are the best - this is the exact one I was looking for

Thank you so much for posting and sharing this

Reply With Quote
  #4 (permalink)
 robert880 
Chicago + IL
 
Experience: Beginner
Platform: NT
Trading: ES
Posts: 68 since Feb 2014
Thanks Given: 221
Thanks Received: 56

Wondering if anyone can help me understand. Say you calculate 10% (.1) for Kelly or optimal f. How do you turn that into the number of futures contracts one should trade? For example say I have a 100,000 account balance, Kelly % of .2, $1000 margin per ES futures contract, tick value $12.5. How many futures contracts can I put on per trade?

Reply With Quote
Thanked by:
  #5 (permalink)
 askerix 
Zurich Switzerland
 
Experience: None
Platform: NT
Trading: Ukulele
Frequency: Never
Duration: Never
Posts: 60 since Mar 2011
Thanks Given: 554
Thanks Received: 62


robert880 View Post
Wondering if anyone can help me understand. Say you calculate 10% (.1) for Kelly or optimal f. How do you turn that into the number of futures contracts one should trade? For example say I have a 100,000 account balance, Kelly % of .2, $1000 margin per ES futures contract, tick value $12.5. How many futures contracts can I put on per trade?

it does not directly rely to the tick value but more on your planned risk in $ per contract.

on a per Entry base you have to calculate your total_$risk (1000$)/per-contract-$risk, depending on your planned stop loss to get the contracts for this entry (round down to the next number for the number of contracts).


hth
askerix

Reply With Quote
Thanked by:
  #6 (permalink)
 robert880 
Chicago + IL
 
Experience: Beginner
Platform: NT
Trading: ES
Posts: 68 since Feb 2014
Thanks Given: 221
Thanks Received: 56


askerix View Post
it does not directly rely to the tick value but more on your planned risk in $ per contract.

on a per Entry base you have to calculate your total_$risk (1000$)/per-contract-$risk, depending on your planned stop loss to get the contracts for this entry (round down to the next number for the number of contracts).


hth
askerix

I think I follow.... So let's say that I use the calculator and it spits out 10% for optimal F. My account size is $100,000. I want to take an entry on the ES and my stop is 2 points ($100). In order to get the number of contracts would I do the following: 100,000 (account size) X .1 (optimal f or Kelly) = 10,000. Then 10,000 / $100 (risk per trade) = 100 Lots. Not sure why one would use margin since it does not represent how much risk you have in the trade. It's just the leverage that your broker lets you have. Do I have this correct?

Reply With Quote
Thanked by:
  #7 (permalink)
 askerix 
Zurich Switzerland
 
Experience: None
Platform: NT
Trading: Ukulele
Frequency: Never
Duration: Never
Posts: 60 since Mar 2011
Thanks Given: 554
Thanks Received: 62

yes, your math is correct.

Reply With Quote
  #8 (permalink)
larry007
Milano+Italy
 
Posts: 1 since Jan 2017
Thanks Given: 0
Thanks Received: 1

Is there anyone who uses Optimal F in their trading?

Reply With Quote
Thanked by:
  #9 (permalink)
 kevinkdog   is a Vendor
 
Posts: 3,647 since Jul 2012
Thanks Given: 1,890
Thanks Received: 7,338


larry007 View Post
Is there anyone who uses Optimal F in their trading?

I have (not currently though), but I have analyzed and run a bunch of tests with it.

On a given backtest, it can definitely be shown to be optimal.

The problem in real time going forward is that if (when!) things change with the trading strategy (win percentage changes, drawdown lengths or durations change, etc.) what was optimal in testing suddenly becomes not only far from optimum, but usually downright awful.

So, watch out. Run it live without real money for a few months first.

Follow me on Twitter Reply With Quote
Thanked by:




Last Updated on April 17, 2022


© 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