Advertisement
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
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)
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?
Just curious -- why not use a lot size calculator provided by myfxbook?
blufxnet posted:Just curious -- why not use a lot size calculator provided by myfxbook?
cause this one is complete, what they have in myfxbook is scramble calculator I don't like that...calculator should be complete, this one is complete with leverage with pip with balance all connected to each other..
Much easier for me...
I have manage to get it working, the problem now I think is the GBPJPY is it using a different formula?
MassZERO posted:blufxnet posted:Just curious -- why not use a lot size calculator provided by myfxbook?
cause this one is complete, what they have in myfxbook is scramble calculator I don't like that...calculator should be complete, this one is complete with leverage with pip with balance all connected to each other..
Much easier for me...
I have manage to get it working, the problem now I think is the GBPJPY is it using a different formula?
Hi, formula looks correct but try debugging it or else you can use =IF(B3="*XAUUSD*", N(((B4*B7*FX!B2)/B5)*FX!D2), N((B4 * B7 * FX!B2) / B5))this one
Brenda13 posted:MassZERO posted:blufxnet posted:
Just curious -- why not use a lot size calculator provided by myfxbook?
cause this one is complete, what they have in myfxbook is scramble calculator I don't like that...calculator should be complete, this one is complete with leverage with pip with balance all connected to each other..
Much easier for me...
I have manage to get it working, the problem now I think is the GBPJPY is it using a different formula?
Hi, formula looks correct but try debugging it or else you can use =IF(B3="*XAUUSD*", N(((B4*B7*FX!B2)/B5)*FX!D2), N((B4 * B7 * FX!B2) / B5))this one
Hi brenda Thanks the formula is working...Just asking about the correct formula for GBPJPY
My calculator base on your formula it seems to getting not the same result must be incorrect for GBPJPY
can you help me please brenda!the pip value and margin requirements for GBPJPY calculation formula...
Might not be correctly accounting for GBPJPYPIP Value =IF(B3="*XAUUSD*", ((B7 * FX!B2) * FX!C2) * B8, ((B7 * FX!B2) / FX!E2) * FX!C2 * B8)REQ MARGIN =IF(B3="*XAUUSD*", ((B4 * B7 * FX!B2) / B5) * FX!D2, (B4 * B7 * FX!B2) / B5)try this one
Brenda13 posted:
Might not be correctly accounting for GBPJPYPIP Value =IF(B3="*XAUUSD*", ((B7 * FX!B2) * FX!C2) * B8, ((B7 * FX!B2) / FX!E2) * FX!C2 * B8)REQ MARGIN =IF(B3="*XAUUSD*", ((B4 * B7 * FX!B2) / B5) * FX!D2, (B4 * B7 * FX!B2) / B5)try this one
It seem incorrect result..
can you please check is this correct for GPPJPY?
This is from Octa Calculator...
It seems its not the same result on my calculator...
