How to calculate Lot Size in Excel ? Hello guys,I am trying to create a trading journal on Excel that tells me what Lot Size to take in order to risk only (let's take an example) 1% of my Total Capital.I did some research and here is the formula :Lot Size = (Account Balance x Risk Percentage) / (Stop-Loss in Pips x Value per Pip)Th... 485 Apr 21 at 19:24