NexusFi: Find Your Edge


Home Menu

 





I would like a Fixed Ratio position sizing spreadsheet


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one PandaWarrior with 2 posts (1 thanks)
    2. looks_two Quick Summary with 1 posts (0 thanks)
    3. looks_3 forrestang with 1 posts (0 thanks)
    4. looks_4 rocky9281 with 1 posts (0 thanks)
    1. trending_up 10,681 views
    2. thumb_up 11 thanks given
    3. group 7 followers
    1. forum 8 posts
    2. attach_file 1 attachments




 
Search this Thread

I would like a Fixed Ratio position sizing spreadsheet

  #1 (permalink)
 
PandaWarrior's Avatar
 PandaWarrior 
In the heat
 
Experience: None
Posts: 3,165 since Mar 2010
Thanks Given: 6,329
Thanks Received: 13,405

Does anyone have a Fixed Ratio position sizing spreadsheet they can share? I have one from Rockwell Trading but its a bit inflexible. Thanks

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trade idea based off three indicators.
Traders Hideout
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Increase in trading performance by 75%
The Elite Circle
ZombieSqueeze
Platforms and Indicators
MC PL editor upgrade
MultiCharts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
31 thanks
Tao te Trade: way of the WLD
24 thanks
My NQ Trading Journal
14 thanks
GFIs1 1 DAX trade per day journal
10 thanks
Diary of a simple price action trader
10 thanks
  #3 (permalink)
 
tigertrader's Avatar
 tigertrader 
Philly, Pa
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader
Trading: ES, ZB
Posts: 6,482 since Jul 2010
Thanks Given: 6,662
Thanks Received: 36,258



PandaWarrior View Post
Does anyone have a Fixed Ratio position sizing spreadsheet they can share? I have one from Rockwell Trading but its a bit inflexible. Thanks


Don't know if you've seen these indicators...

Home | PositionSizer

Risk Manager

Follow me on Twitter Reply With Quote
  #4 (permalink)
 
PandaWarrior's Avatar
 PandaWarrior 
In the heat
 
Experience: None
Posts: 3,165 since Mar 2010
Thanks Given: 6,329
Thanks Received: 13,405


tigertrader View Post
Don't know if you've seen these indicators...

Home | PositionSizer

Risk Manager

I've seen those. But I'm just looking for a simple spreadsheet I can plug my daily trades into and end up with a possible position size for the following day. Has to be Fixed Ratio....

Simplicity is the ultimate sophistication, Leonardo da Vinci


Most people chose unhappiness over uncertainty, Tim Ferris
Started this thread Reply With Quote
Thanked by:
  #5 (permalink)
 
liquidcci's Avatar
 liquidcci 
Austin, TX
 
Experience: Master
Platform: ninjatrader, r-trader
Trading: NQ, CL
Posts: 866 since Jun 2011
Thanks Given: 610
Thanks Received: 1,091

Panda I use a fixed ratio system and this is the software I use. You setup a csv spreadsheet and can copy your trades into it. The program reads that spreadsheet and you can analyze your data using fixed ratio as well as other methods. I use it on my live trades and it is fantastic to plug a back test into it. Backtesting you can use the software to find your optimal fixed ratio and see what the draw downs with position sizing applied are like etc.

Money management software :: Market System Analyzer

"The day I became a winning trader was the day it became boring. Daily losses no longer bother me and daily wins no longer excited me. Took years of pain and busting a few accounts before finally got my mind right. I survived the darkness within and now just chillax and let my black box do the work."
Reply With Quote
Thanked by:
  #6 (permalink)
 
forrestang's Avatar
 forrestang 
Chicago IL
 
Experience: None
Platform: Ninja, MT4, Matlab
Broker: CQG, AMP, MB, DTN
Trading: E/U, G/U
Posts: 1,329 since Jun 2010
Thanks Given: 354
Thanks Received: 1,047

I have one that you may/may not find useful.

If you still haven't found something you would like, send me a pm and I can send it to you.

Reply With Quote
  #7 (permalink)
Pamirat
Switzerland
 
Posts: 4 since Jun 2011
Thanks Given: 3
Thanks Received: 1

Hello I have created one myself...


you should be able to change all the parameters

have fun

Attached Files
Elite Membership required to download: Fixed Ratio Contracts table.xlsx
Reply With Quote
  #8 (permalink)
rocky9281
Kolkata,India
 
Posts: 100 since Feb 2011
Thanks Given: 52
Thanks Received: 40

Can anyone help me to calculate the appropriate delta and the "rate of decrease" for a particular market?I guess that will be something really helpful and practical approach to the subject.

I trade CNX Nifty (India-NSE).

Reply With Quote
  #9 (permalink)
status1
Lake grove NY
 
Posts: 1 since Dec 2019
Thanks Given: 0
Thanks Received: 0

How would I go about creating a fixed ratio for option spreads ?

I would like to start creating one but I am not sure how to start
I am doing option spreads on SPX and I have some gains so I am thinking if I could scale up but I also want to reduce some of the risk if possible

Reply With Quote




Last Updated on December 31, 2019


© 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