How to calculate Lot Size in Excel ?

Hello guys,

I americium trying to make a trading diary connected Excel that tells maine what Lot Size to instrumentality successful bid to hazard lone (let's instrumentality an example) 1% of my Total Capital.

I did immoderate probe and present is the look :

Lot Size = (Account Balance x Risk Percentage) / (Stop-Loss successful Pips x Value per Pip)

The occupation is, successful bid to cipher the Value per Pip, I seemingly request the Lot Size (according to the Value per Pip formula) :

Value per Pip = Lot Size x Quote Currency Pip

So it seems that I request the Value per Pip to cipher the Lot Size, but I request the Lot Size to cipher the Value per Pip. Here is my occupation guys.

And by the way, however does Lot Size Calculator enactment past ? I was utilizing the 1 signifier Myfxbook and it lone needs the Risk Amount and the Stop Loss (in pips) to find the close Lot Size...

Any assistance would beryllium greatly appreciated !