Optimal F ( Position Size ) Spreadsheet/Excel - futures io
futures io



Optimal F ( Position Size ) Spreadsheet/Excel


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one askerix with 2 posts (0 thanks)
    2. looks_two vpd1952 with 2 posts (0 thanks)
    3. looks_3 robert880 with 2 posts (0 thanks)
    4. looks_4 Pluto with 1 posts (1 thanks)
    1. trending_up 1,292 views
    2. thumb_up 1 thanks given
    3. group 4 followers
    1. forum 6 posts
    2. attach_file 1 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Optimal F ( Position Size ) Spreadsheet/Excel

(login for full post details)
  #1 (permalink)
vpd1952
memphis
 
 
Posts: 59 since Mar 2020
Thanks: 104 given, 17 received

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

Journal Challenge April 2021 results (now extended!):
Competing for $1800 in prizes from Jigsaw
looks_oneMaking a Living with the Microsby sstheo
(114 thanks from 18 posts)
looks_twoSalao's Journalby Salao
(36 thanks from 8 posts)
looks_3Deetee’s DAX Trading Journal (time based)by Deetee
(33 thanks from 14 posts)
looks_4Learning to Profit - A journey in algorithms and optionsby Syntax
(14 thanks from 9 posts)
looks_5Maybe a little bit different journalby Malykubo
(13 thanks from 12 posts)
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Would You Sell Your System?
75 thanks
Big Mike in Ecuador
57 thanks
The Crude Dude Oil Trading System
52 thanks
The New Micro Contract - MICRO BITCOIN coming May 2021
25 thanks
futures io site changelog and issues/problem reporting
24 thanks
 
(login for full post details)
  #2 (permalink)
Pluto
Celebration, FL
 
 
Posts: 2 since Sep 2010
Thanks: 75 given, 1 received


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
Register to download File Type: xlsx Risk Adjusted Optimal F.xlsx (12.2 KB, 92 views)
Reply With Quote
The following user says Thank You to Pluto for this post:
 
(login for full post details)
  #3 (permalink)
vpd1952
memphis
 
 
Posts: 59 since Mar 2020
Thanks: 104 given, 17 received


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
 
(login for full post details)
  #4 (permalink)
 robert880 
Chicago + IL
 
Experience: Beginner
Platform: NT
Trading: ES
 
Posts: 68 since Feb 2014
Thanks: 221 given, 54 received

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
 
(login for full post details)
  #5 (permalink)
 askerix 
Switzerland
 
Experience: None
Platform: NT
Trading: Ukulele
 
Posts: 44 since Mar 2011
Thanks: 450 given, 41 received


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
 
(login for full post details)
  #6 (permalink)
 robert880 
Chicago + IL
 
Experience: Beginner
Platform: NT
Trading: ES
 
Posts: 68 since Feb 2014
Thanks: 221 given, 54 received


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
 
(login for full post details)
  #7 (permalink)
 askerix 
Switzerland
 
Experience: None
Platform: NT
Trading: Ukulele
 
Posts: 44 since Mar 2011
Thanks: 450 given, 41 received

yes, your math is correct.

Reply With Quote


futures io Trading Community Psychology and Money Management > Optimal F ( Position Size ) Spreadsheet/Excel


Last Updated on February 25, 2021


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Journal Challenge w/$1,800 in prizes!

April

Seven Trading Mistakes Solved With Smart Trading Tools w/Brannigan Barrett

Elite only
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts