Hi there,
I’m trying to do a really basic spreadsheet to understand how to calcuate position sizes. Could someone who knows what they are doing access this spreadsheet and update this thread to explain what needs to be changed? At the moment I get the right figures but it doesn’t use the SL/pips field and it should! The spreadsheet is at Calc.xls - Google Drive as I couldn’t upload it in here. I’m using the calculator to compare my answers at Position Size Calculator: Free Online Forex Position Sizing Calculator.
Would really appreciate it if someone could help.
Thanks!
p.s. all the stuff that comes up when I search refers mostly to calculators that don’t actually explain the methodology so that people are then tied down to use the calculator.
I looked at your spreadsheet, but all I see is a sheet of numbers. I can’t access the formulas, which I think is what you wanted so someone could tell you what to change(?). If you intended to share the full .xls file with the formulas, is this something you could put in a public folder in Dropbox or something similar? I know in Dropbox you can post a link to something in your public folder.