Loading...
Continue to Myfxbook.com
Continue to Myfxbook.com
Čeština
Deutsch
English
Español
Français
Indonesia
Latviešu
Melayu
Polski
Português(Brasil)
Português(Portugal)
Slovenčina
Svenska
Türkçe
Vietnamese
Русский
हिंदी
ไทย
日本語
简体字
繁體中文
한국어
Sign In
Sign Up
Open an account with FOREX.com
FX Tools:
Economic Calendar
Interest Rates
FX Calculators
News
spreads
Sentiment
Forex Heat Map
Correlation
Market Hours
Home
tradesbystan
Posts
Share
Share this page!
Advertisement
Posts by
tradesbystan
How to calculate Lot Size in Excel ?
in
General
Apr 21, 2024 at 19:24
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)The problem is, in order to calculate the Value per Pip, I apparently need the Lot Size (according to the Value per Pip formula) :Value per Pip = Lot Size x Quote Currency PipSo it seems that I need the Value per Pip to calculate the Lot Size, but I need the Lot Size to calculate the Value per Pip. He...
You have an Ad Blocker!
Myfxbook is a site supported by advertisements. Here are two ways for you to continue browsing:
Ad Free Subscription
or
Disable your Ad Blocker
Already subscribed?
Sign In
You're not logged in
This feature is available for registered members only.
Registration is free and takes less than a minute.
Click the sign up button to continue.
Unless you're already a member and enjoying our service, then just sign in.
Keep up to date with the markets
Enable notifications to receive real-time important market updates:
Economic Calendar
Forex News
You can disable notifications at any time from your browser.
Unblock Notifications
You've blocked browser notifications for Myfxbook.com. Please enable it:
You can disable notifications at any time from your browser.
PREVIOUS
CONSENSUS
ACTUAL