Derive values from percentage change

[XEVEN__]

I have the percentage change values in W but not the actual price data from say 1971 to 2009. Using excel 365 is there a formula where I can use my starting value of .43 in V9846, and use the percentage change values from column/row W9847 to go backwards and derive the actual values in column V?
Date in T, derived value in U, actual value from 2010 to present in V, percentage change data from 1971 to present in W

2/1/2010			3.3%
2/2/2010			2.6%
2/3/2010			0.1%
2/4/2010			-9.0%
2/5/2010			2.2%
2/8/2010			-2.1%
2/9/2010			3.5%
2/10/2010			-0.4%
2/11/2010		0.431	4.1%
2/12/2010		0.433	0.8%
2/16/2010		0.450	4.2%
2/17/2010		0.458	1.6%
2/18/2010		0.466	2.1%
2/19/2010		0.466	0.3%
2/22/2010		0.463	-0.2%
2/23/2010		0.445	-3.8%
2/24/2010		0.458	3.0%
2/25/2010		0.458	-0.2%
2/26/2010		0.464	0.5%
3/1/2010		0.484	4.7%

 

[JamesCanale]

This will do the trick from an excel point of view - but unless you have substantially more significant digits than appeared in your data above, it will quickly become uselessly divergent from actual history. It might be that excel doesn't even support that many significant digits. Look at my column E just looking ahead 2 weeks and it's already noticeably divergent.

MrExcelPlayground14.xlsx
	A	B	C	D	E
1	Date	Projection	Data	Change	Looking forward
2	2/1/2010	0.4295		3.30%
3	2/2/2010	0.4407		2.60%
4	2/3/2010	0.4411		0.10%
5	2/4/2010	0.4014		-9.00%
6	2/5/2010	0.4102		2.20%
7	2/8/2010	0.4016		-2.10%
8	2/9/2010	0.4157		3.50%
9	2/10/2010	0.4140		-0.40%
10	2/11/2010		0.431	4.10%
11	2/12/2010		0.433	0.80%	0.434
12	2/16/2010		0.45	4.20%	0.451
13	2/17/2010		0.458	1.60%	0.457
14	2/18/2010		0.466	2.10%	0.468
15	2/19/2010		0.466	0.30%	0.467
16	2/22/2010		0.463	-0.20%	0.465
17	2/23/2010		0.445	-3.80%	0.445
18	2/24/2010		0.458	3.00%	0.458
19	2/25/2010		0.458	-0.20%	0.457
20	2/26/2010		0.464	0.50%	0.460
21	3/1/2010		0.484	4.70%	0.486
Sheet30

Cell Formulas
Range	Formula
B2:B8	B2	=B3/(D3+1)
B9	B9	=C10/(D10+1)
E11:E21	E11	=C10*D11+C10

 

[XEVEN__]

Thanks James. This works fine for the picture/chart I am painting. You are right about the values migrating but they seem close enough for what I need. Being able to visualize the magnitude of price changes all the way back to 1971 helps put in perspective recent dramatic action.

Thanks again