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