MT4 Position Size Calculator Excel Spreadsheets | Page 2 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Looking for Excel Spreadsheets (Please post here) 17 replies

Visual Position Size Calculator 65 replies

Mt4 order entry vs position size calculator 3 replies

Simple Lot Size Calculator using Excel (Only 3 Inputs!) 7 replies

Position size calculator in Excel 2 replies

Attachments: MT4 Position Size Calculator Excel Spreadsheets
Exit Attachments

MT4 Position Size Calculator Excel Spreadsheets

  • #21
  • Aug 18, 2008 5:39am Aug 18, 2008 5:39am
Quoting ssherwood76
Here is the ODL version with CAD/JPY added and lot sizes are calculated with the ODL's spread. Also, Sheet 2 has an area to manage fundamentals.

Enjoy.
ssherwood,

It's a great tool. I am using openoffice calc and your file opens all right. But how do I insert other symbols in this sheet as I need info on other symbols in this live sheet.

thanks again for sharing this wonderful tool.
  • #22
  • Aug 18, 2008 2:05pm Aug 18, 2008 2:05pm
Sadly, the mini one does not work for Alpari.I checked and they offer up to micro lots.

Does anyone have any pointers on how I could make it work? I get "This formula contains unrecognized text" for all fields containing the "m" suffix after the currency pair.

The standard one works...really weird.I think I'm going to email them as well just in case and ask.
  • #23
  • Edited Dec 6, 2018 6:53am Dec 5, 2018 5:29pm | Edited Dec 6, 2018 6:53am
Hobby dabblers and entities too lazy or incapable of learning to create a formulated spread sheet will not benefit from this post. No time for questions - go figure - construct - innovate.

Quote
grandaevus
1:30 is a draconian leverage restriction. It should be minimum 1:50. I'll have to transfer my funds from LMAX to an ASIC regulated broker. What will you do Phylo?
Quote
Phylo
For various reason I am unable to comment further.
Quote
Phylo
A clearer reality is in view and we have had time to reassess, remodel, recalculate, reprogram etc., etc.

As a member of a family consortium - agreement between father and sons - we collectively hold a number of accounts.

As far as ESMA is concerned and remaining UK or Offshore based, of necessity we will be batting for both sides. It is what it is - pros and cons - cold unemotional logic dictates adapt, strategies and move on.

For accounts requiring FSCS protection we do not find 1:30 draconian and negative balance protection is further incentive not to move funds offshore.

For one or two accounts not requiring FSCS protection and 1:30 restrictive AU & NZ brokers listing liquidity sources are preferred selections.
https://www.forexfactory.com/showthr...8#post11169008
https://www.forexfactory.com/showthr...3#post11169013
https://www.forexfactory.com/showthr...9#post11173529
https://www.forexfactory.com/showthr...25#post8896625

https://www.forexfactory.com/showthr...8#post10921918
https://www.forexfactory.com/showthr...8#post10924108
https://www.forexfactory.com/showthr...3#post10926553
https://www.forexfactory.com/showthr...3#post11140533
TSLA: 30-Dec-22 123.18 // 16-Jun-23 260.54 **111.51%**
  • #24
  • Edited Jan 7, 2019 10:33am Jan 6, 2019 4:21pm | Edited Jan 7, 2019 10:33am
Quoting ssherwood76
I designed two position size spreadsheets in excel that work with MT4. They import the ASK price from the MT4 platform and calculate the correct lot size to risk whatever percentage you choose.{file}
Hi ssherwood76, hi everybody!

Thank you for your spreadsheet - I like it, but I can't quite figure parts of it out. Apparently I am the only one. Can you help me with this? Also, is there anybody out there who knows what's happening in this spreadsheet? I appreciate any help.

1) In the "Carry" section (box 1) what does the "rate" mean?
2) If my risk tolerance is 1%, then why is it that in the Stop column (box 2) the numbers do not match my risk tolerance? It seems to me that those numbers are hypothetical and they aren't connected to Risk (box 3). As follows the numbers in the "Gain in % and pips section" (box 4) are based on the Stop Column in box 3. Is it right?
3) Excel says that the USDJPY C9 cell formula (box 5) is inconsistent with other formulas "on this area." Is it because the Yen is calculated with different pip value and so it's not a real problem?

thanks in advance,


attim
Attached Image (click to enlarge)
Click to Enlarge Name: Image1.jpeg Size: 337 KB
  • #25
  • Edited 7:23am Jan 7, 2019 6:49am | Edited 7:23am
Quoting M.A.C.Doug
Thats the best trade size calculator I have ever seen. It means you get accurate calculation quickly so you dont miss getting good entries. Thanks for sharing this
Hi M.A.C.Doug,

Neither ssherwood76 nor most of the other guys are very active since 2015. I like his mini and standard spreadsheet (and I have created a micro one) at least the parts I understand from it; however, some parts are just not intelligible to me. I see that you understand how it works. Can you help me with this? I would appreciate it. In post #24 I have described my problem (the post before this).

thank you in advance,

AttiM
  • #26
  • Jan 21, 2019 9:45pm Jan 21, 2019 9:45pm
Quoting AttiM
{quote} Hi M.A.C.Doug, Neither ssherwood76 nor most of the other guys are very active since 2015. I like his mini and standard spreadsheet (and I have created a micro one) at least the parts I understand from it; however, some parts are just not intelligible to me. I see that you understand how it works. Can you help me with this? I would appreciate it. In post #24 I have described my problem (the post before this). thank you in advance, AttiM
I don't use this risk calculator. It is too complicated and you have to manually update some of the values. I use the risk calculator on Myfxbook to workout my position size.
https://www.myfxbook.com/forex-calcu.../position-size

I will try to answer your questions about this spreadsheet as best I can though

1. rate means the interest charged or paid by your broker for holding positions. Also called "swap"

2. The calculator is working out what your position size will be based on your stop and your risk. You enter the desired stop size based on the trade you want to enter. You enter the risk % you want to take. The calculator works out your position size.

3. I have no idea but I think it has to do with how the yen price is expressed. You will have to work out yourself if its ok or not
BTC Return This Year: na
  • #27
  • Edited 7:01pm Jan 25, 2019 3:12pm | Edited 7:01pm
Quoting M.A.C.Doug
{quote} I don't use this risk calculator. It is too complicated and you have to manually update some of the values. I use the risk calculator on Myfxbook to workout my position size. https://www.myfxbook.com/forex-calcu.../position-size I will try to answer your questions about this spreadsheet as best I can though
Hi,

Thanks for your reply M.A.C. Doug. Meanwhile I redesigned the spreadsheet, in my own primitive way, and adjusted it to my needs.

AttiM
  • #28
  • Mar 20, 2019 5:40pm Mar 20, 2019 5:40pm
Are you guys looking for something like this? I find it far more useful than a spreadsheet. I abandoned my spreadsheet method when someone put me on to this indicator.
Attached File(s)
File Type: ex4 3ClickPositionCalc_Indicator (1).ex4   256 KB | 1,031 downloads
  • #29
  • Last Post: Oct 7, 2021 3:51am Oct 7, 2021 3:51am
I use this one from FX Merge and also you can connect trading results

Inserted Video
0 traders viewing now