Easy Math problem, help

G

genevaroth

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?
 
Quote from genevaroth:

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?
More...

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? :D
 
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
 
You must log in or register to reply here.
Back
Top