I need help with my trading calculator please!
Hi guys,
I'm making a calculator for trading forex.. to calculate the pip value combine with lot size and required margin..
I was able to make it by Gold, but other pairs I cant seems to make it work..I'm a bit confused can someone help me fix my calculator please...
I want it to work with forex pairs, I dont know the formula can someone help me...
https://docs.google.com/spreadsheets/d/13LrR0FQlctYgfpS2ZBE807Io1DB2QOIV_JJEAiTERy8/edit?usp=sharing
Brenda13 posted:You can try changing your formula to
PIP VALUE (For Forex Pairs)= ((B7 * FX!B2) / FX!E2) * FX!C2 * B8REQ Margin= (B4 * B7 * FX!B2 / B5)
Thanks Brenda... My problem now is how can I combine the formula... so it would work with gold and also with forex pairs?
MassZERO posted:Brenda13 posted:You can try changing your formula to
PIP VALUE (For Forex Pairs)= ((B7 * FX!B2) / FX!E2) * FX!C2 * B8REQ Margin= (B4 * B7 * FX!B2 / B5)
Thanks Brenda... My problem now is how can I combine the formula... so it would work with gold and also with forex pairs?
You can use the if condition to check whether it is Gold or forex pair and it will apply the formula accordingly. Pip Value: =IF(A1="XAUUSD", ((B7 * FX!B2) * FX!C2) * B8, ((B7 * FX!B2) / FX!E2) * FX!C2 * B8)Required Margin: =IF(A1="XAUUSD", (B4 * B7 * FX!B2 / B5) * FX!D2, (B4 * B7 * FX!B2 / B5))
Brenda13 posted:MassZERO posted:Brenda13 posted:You can try changing your formula to
PIP VALUE (For Forex Pairs)= ((B7 * FX!B2) / FX!E2) * FX!C2 * B8REQ Margin= (B4 * B7 * FX!B2 / B5)
Thanks Brenda... My problem now is how can I combine the formula... so it would work with gold and also with forex pairs?
You can use the if condition to check whether it is Gold or forex pair and it will apply the formula accordingly. Pip Value: =IF(A1="XAUUSD", ((B7 * FX!B2) * FX!C2) * B8, ((B7 * FX!B2) / FX!E2) * FX!C2 * B8)Required Margin: =IF(A1="XAUUSD", (B4 * B7 * FX!B2 / B5) * FX!D2, (B4 * B7 * FX!B2 / B5))
Thank so much Brenda13 for helping me!so sorry I'm just new to this, I will test this later to my google sheet calculator thanks much appreciated!
Brenda13 posted:MassZERO posted:Brenda13 posted:You can try changing your formula to
PIP VALUE (For Forex Pairs)= ((B7 * FX!B2) / FX!E2) * FX!C2 * B8REQ Margin= (B4 * B7 * FX!B2 / B5)
Thanks Brenda... My problem now is how can I combine the formula... so it would work with gold and also with forex pairs?
You can use the if condition to check whether it is Gold or forex pair and it will apply the formula accordingly. Pip Value: =IF(A1="XAUUSD", ((B7 * FX!B2) * FX!C2) * B8, ((B7 * FX!B2) / FX!E2) * FX!C2 * B8)Required Margin: =IF(A1="XAUUSD", (B4 * B7 * FX!B2 / B5) * FX!D2, (B4 * B7 * FX!B2 / B5))
Hi brend need help please, I was able to to the changes with the Pip Value it works..
the problem is the Required margin it doesnt work please help me....
MassZERO posted:Brenda13 posted:MassZERO posted:Brenda13 posted:You can try changing your formula to
PIP VALUE (For Forex Pairs)= ((B7 * FX!B2) / FX!E2) * FX!C2 * B8REQ Margin= (B4 * B7 * FX!B2 / B5)
Thanks Brenda... My problem now is how can I combine the formula... so it would work with gold and also with forex pairs?
You can use the if condition to check whether it is Gold or forex pair and it will apply the formula accordingly. Pip Value: =IF(A1="XAUUSD", ((B7 * FX!B2) * FX!C2) * B8, ((B7 * FX!B2) / FX!E2) * FX!C2 * B8)Required Margin: =IF(A1="XAUUSD", (B4 * B7 * FX!B2 / B5) * FX!D2, (B4 * B7 * FX!B2 / B5))
Hi brend need help please, I was able to to the changes with the Pip Value it works..
the problem is the Required margin it doesnt work please help me....
Might be having issues due to data structures. Try this one Formula=IF(A1="XAUUSD", ((B4 * B7 * FX!B2) / B5) * FX!D2, (B4 * B7 * FX!B2) / B5)- For XAUUSD: (B4 * B7 * FX!B2) / B5 calculates margin, then it’s multiplied by FX!D2 for adjustment- For Forex Pairs: (B4 * B7 * FX!B2) / B5 without extra multiplication
Hi brenda...
I added the formula to my excel on sheets please take a look
https://docs.google.com/spreadsheets/d/13LrR0FQlctYgfpS2ZBE807Io1DB2QOIV_JJEAiTERy8/edit?usp=sharing
Brenda13 posted:MassZERO posted:Brenda13 posted:MassZERO posted:Brenda13 posted:You can try changing your formula to
PIP VALUE (For Forex Pairs)= ((B7 * FX!B2) / FX!E2) * FX!C2 * B8REQ Margin= (B4 * B7 * FX!B2 / B5)
Thanks Brenda... My problem now is how can I combine the formula... so it would work with gold and also with forex pairs?
You can use the if condition to check whether it is Gold or forex pair and it will apply the formula accordingly. Pip Value: =IF(A1="XAUUSD", ((B7 * FX!B2) * FX!C2) * B8, ((B7 * FX!B2) / FX!E2) * FX!C2 * B8)Required Margin: =IF(A1="XAUUSD", (B4 * B7 * FX!B2 / B5) * FX!D2, (B4 * B7 * FX!B2 / B5))
Hi brend need help please, I was able to to the changes with the Pip Value it works..
the problem is the Required margin it doesnt work please help me....
Might be having issues due to data structures. Try this one Formula=IF(A1="XAUUSD", ((B4 * B7 * FX!B2) / B5) * FX!D2, (B4 * B7 * FX!B2) / B5)- For XAUUSD: (B4 * B7 * FX!B2) / B5 calculates margin, then it’s multiplied by FX!D2 for adjustment- For Forex Pairs: (B4 * B7 * FX!B2) / B5 without extra multiplication
Hi brenda,
I added the new formula on the sheet please check it out...
everything works except for the required margin when using gold, it seems sheet formula doesn't follow the calculations even if we put the correct formula... how can we fix this?
