Position size spreadsheet | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Which would you prefer: increasing lot size or TP size? 24 replies

At what lot size/account size do you have scale issues? 39 replies

Point equivalent is calculated with the account size or traded size? 4 replies

Spreadsheet to calculate Pip P/L from Duka's Position Report 8 replies

Lot size, contract size, max position ? 1 reply

Attachments: Position size spreadsheet
Exit Attachments

Position size spreadsheet

  • #1
  • First Post: Nov 30, 2007 8:27pm Nov 30, 2007 8:27pm
Hi


Does anyone have a position size/money management spreadsheet for a GBP based micro account they can share? I'm looking for a simple/quick way to calculate the lot size. Something that will work out the lot size from a fixed percentage risk ,account balance and stop size.

thanks

FXP
  • #2
  • Nov 30, 2007 10:19pm Nov 30, 2007 10:19pm
Quoting fxprocessor
Hi


Does anyone have a position size/money management spreadsheet for a GBP based micro account they can share? I'm looking for a simple/quick way to calculate the lot size. Something that will work out the lot size from a fixed percentage risk ,account balance and stop size.

thanks

FXP

AccountSize * PercentRisk / Stoploss(inPips) / PipValue = Lots

So

$1000 * 2% / 30pips/ $10 = 0.07 Lots

I just threw this together so you can see what I mean
Attached File(s)
File Type: xls LotSize.xls   14 KB | 2,898 downloads
  • #3
  • Nov 30, 2007 10:30pm Nov 30, 2007 10:30pm
Wow, I was wondering how I could do this! Thanks for providing!
  • #4
  • Dec 1, 2007 5:23am Dec 1, 2007 5:23am
Quoting smjones
AccountSize * PercentRisk / Stoploss(inPips) / PipValue = Lots

So

$1000 * 2% / 30pips/ $10 = 0.07 Lots

I just threw this together so you can see what I mean
thanks Scott
  • #5
  • Dec 1, 2007 5:36am Dec 1, 2007 5:36am
Here is another that I made and posted in another thread. Just change the info in the yellow area.
Attached File(s)
File Type: xls Risk(1).xls   15 KB | 2,235 downloads
Nothing is impossible, with a willing mind!
  • #6
  • Dec 1, 2007 7:17am Dec 1, 2007 7:17am
Many thanks for taking time to post your spreadsheet but I'm ideally looking for something that will update prices from metatrader (which will propagate the correct pip value in the spreadsheet) like this

http://www.forexfactory.com/showthre...ferrerid=29330

but for a GBP account.

I didnt explain what i was looking for very well so thanks again.




Quoting Trader_V
Here is another that I made and posted in another thread. Just change the info in the yellow area.
  • #7
  • Dec 1, 2007 8:55am Dec 1, 2007 8:55am
This still isn't what you're looking for, but it's one step closer.

Someone around here knows how to get the MT4 update for price into it. Until then, scroll down and right and plug them in manually.

I don't know who did this, but it's slicker than the one I came up with.

Rob
Attached File(s)
File Type: xls Position sizing .xls   17 KB | 1,760 downloads
  • #8
  • Dec 1, 2007 9:14am Dec 1, 2007 9:14am
Quoting blueruby
This still isn't what you're looking for, but it's one step closer.

Someone around here knows how to get the MT4 update for price into it. Until then, scroll down and right and plug them in manually.

I don't know who did this, but it's slicker than the one I came up with.

Rob
Here is an example from MT4 of a DDE to draw in live prices.
Attached File(s)
File Type: xls DDE-Sample.xls   16 KB | 1,117 downloads
  • #9
  • Edited Dec 2, 2007 8:39am Dec 1, 2007 9:47am | Edited Dec 2, 2007 8:39am
Here is BlueRuby's spread sheet with dynamic pip values and DDE MT4 feed built in.
Attached File(s)
File Type: xls Position sizing with dynamic PipValues and MT4 DDE .xls   18 KB | 1,637 downloads
  • #10
  • Dec 1, 2007 10:04am Dec 1, 2007 10:04am
Here's a link to a spreadsheet I created sometime back. The link has info on how to modify and config DDE.
http://www.forexfactory.com/showthre...5631#post55631
In trading, there is no bullshit. You either make money or you don't.
  • #11
  • Dec 1, 2007 11:18am Dec 1, 2007 11:18am
Quoting smjones
Here is BlueRuby's spread sheet with dynamic pip values and DDE MT4 feed built in.
And if you are using a mini feed like IBFX, you just need to edit DDE entires and add an "m" to the end of the pair.
To be one with the market, you must first be one with yourself.
  • #12
  • Dec 1, 2007 11:48am Dec 1, 2007 11:48am
Thanks everyone. I will look through all of these :-)
  • #13
  • Last Post: Oct 17, 2020 7:19pm Oct 17, 2020 7:19pm
Quoting smjones
Here is BlueRuby's spread sheet with dynamic pip values and DDE MT4 feed built in. {file}
Thank you very much
0 traders viewing now