108monkeys
New Member
- Joined
- Jan 13, 2008
- Messages
- 25
- Office Version
- 2010
Hi All,
I am trying to use formulae for a trading calculator which uses a minimum working amount (A2:A12) of $30 and increments it to 10 percent once it is over $500. It then calculates profits F2:F12 based on wins (C2:C12) or losses (C2:C12).
This works fine when I am using a test balance (G2:G12) to calculate the amount (A2:12) and the dividends (F2:F12) but when I try to change the test balance (G2:G12) as is shown the actual balance values (I2:I12) by adding the result as shown in the formula of the actual balance (H2:H12), the starting value (A2:A12) seems to loop and returns a zero value in the test balance (G2:G12). How can I use the actual balance even thought the amount and return are based on this value?
As mentioned above I have included the formula values in the adjacent field to assist. Is there a better way of doing this which is Excel friendly?
Hope you can help.
Thanks, Hanuman.
I am trying to use formulae for a trading calculator which uses a minimum working amount (A2:A12) of $30 and increments it to 10 percent once it is over $500. It then calculates profits F2:F12 based on wins (C2:C12) or losses (C2:C12).
This works fine when I am using a test balance (G2:G12) to calculate the amount (A2:12) and the dividends (F2:F12) but when I try to change the test balance (G2:G12) as is shown the actual balance values (I2:I12) by adding the result as shown in the formula of the actual balance (H2:H12), the starting value (A2:A12) seems to loop and returns a zero value in the test balance (G2:G12). How can I use the actual balance even thought the amount and return are based on this value?

As mentioned above I have included the formula values in the adjacent field to assist. Is there a better way of doing this which is Excel friendly?
Hope you can help.
Thanks, Hanuman.