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?
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?
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 %)
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.
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?
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?
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