Change rates in column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a table with column that has rates in it.

Table1 Columns = Time; Rate Change

I want to take the Column Rate change and convert it to a fund value that
starts at 1000 and changes based on the rate change.

Time; Rate Change
1 ; 1.05
2 ; 1.05
3 ; 0.95
4 ; 0.95
...... etc.

New Table:
Time; Fund
1 ; 100000
2 ; 105000
3 ; 110250
4 ; 104737.5
5 ; 99500.625
.... etc

Thanks for your help.
 
Jeff said:
Hi,

I have a table with column that has rates in it.

Table1 Columns = Time; Rate Change

I want to take the Column Rate change and convert it to a fund value
that starts at 1000 and changes based on the rate change.

Time; Rate Change
1 ; 1.05
2 ; 1.05
3 ; 0.95
4 ; 0.95
..... etc.

New Table:
Time; Fund
1 ; 100000
2 ; 105000
3 ; 110250
4 ; 104737.5
5 ; 99500.625
... etc

Thanks for your help.

I am not sure of what the formula is that would make the conversion, but
that would be first. Also what field type is this? Number, date-time,
text???
 
Jeff said:
The "Rate Change" is a number, "Time" is also a number.

OK, now what is the relationship between the Rate Change and Fund????

If the Rate Change is 1.05 what is the Fund? I can't tell if it should
be 105000 or 000548 or what?
 
Back
Top