Easy Math problem, help

Discussion in 'Forex Trading' started by genevaroth, Sep 17, 2007.

  1. I am just brain clogged today- How do I figure out this problem;

    want to find out the total if I made .076% a day on my $20000 for 100 days (or 100 trades)- always close trades at end of day- so;

    $20000 + 0.076%= $20015.20
    next day
    $20015.20 + 0.076%= $20030.41
    and so on...


    I thought the formula it would be like;

    A = P (1 + rn )nt
    A = amount of money after t years
    P = principal, or the amount you originally put into the account
    r = interest rate, in decimals (so that 12% is 0.12)
    t = time, in years, that the money has been invested
    n = the number of times your money is compounded per year
    -------
    but the math does not work for the formula.

    anyone feeling smart today?
     
  2. it's to the power of...Use "^" in excel


    take the rate .12/(Periods You want to compound)
    so if Monthly then use .12/12

    add 1 to that...(1+.12/12)^(Periods In Months)

    so P*(1+.12/12)^n

    if you want days
    then use 365...or 250 Trade days
    so your year is 250 days

    will be P*(1+(.12/250))^(250*t)
    t= Years units

    cool?
     
  3. zer0

    zer0

    i will give you the answer my way

    I = Initial amount (20000$ in your case)
    r = daily rate of increase (0.076% or 0.00076 here)

    After n days of compounded growth your equity will be :

    E= I *(1+r)^n

    If n=100
    E= 20000* (1.00076)^100 = 20000 * 1.0789 = 21578.63 (increase of 7.89 %)
     
  4. get a calculator

    do x^y


    the values to use are 1 plus the daily % as a decimal for x and 100 for y.

    then the answer is multiplied by your starting capital, 20K.

    On an H/P your need to press the yellow key to get to the X^Y formula.
     
  5. do this in excel

    New sheet

    =A1*(1+A2)^A3
    put the above formula into any cell


    In cell A1 Put your account Value
    in a2 The Interst.. .12/250...whatever
    a3 what Period in days

    for a year from now use 250

    cool?
     
  6. 1 20,015 31 20,477 61 20,949
    2 20,030 32 20,492 62 20,965
    3 20,046 33 20,508 63 20,981
    4 20,061 34 20,523 64 20,996
    5 20,076 35 20,539 65 21,012
    6 20,091 36 20,555 66 21,028
    7 20,107 37 20,570 67 21,044
    8 20,122 38 20,586 68 21,060
    9 20,137 39 20,601 69 21,076
    10 20,153 40 20,617 70 21,092
    11 20,168 41 20,633 71 21,108
    12 20,183 42 20,648 72 21,124
    13 20,199 43 20,664 73 21,141
    14 20,214 44 20,680 74 21,157
    15 20,229 45 20,696 75 21,173
    16 20,245 46 20,711 76 21,189
    17 20,260 47 20,727 77 21,205
    18 20,275 48 20,743 78 21,221
    19 20,291 49 20,759 79 21,237
    20 20,306 50 20,774 80 21,253
    21 20,322 51 20,790 81 21,269
    22 20,337 52 20,806 82 21,286
    23 20,353 53 20,822 83 21,302
    24 20,368 54 20,838 84 21,318
    25 20,383 55 20,853 85 21,334
    26 20,399 56 20,869 86 21,350
    27 20,414 57 20,885 87 21,367
    28 20,430 58 20,901 88 21,383
    29 20,446 59 20,917 89 21,399
    30 20,461 60 20,933 90 21,415


    cool? :D
     
  7. =20000*1.0076^100

    in excel

    aggh, I hate mondays
     
  8. u need about 5500 Trade days to change that to 1,000,000 Bucks
    about 20 years

    Ln(1000,000)=n*20000*(1+.00076)

    Then n=Ln(1000,000)/(20000*(1+.00076))
    LN =Natural Log
     
  9. thanks guys!! :)