Forecast using last two values in a column D and E

[ubulib]

am using forecast to tell me a value for a trend of two values.Forecast(x,known y,known x) x is the current date on column A,Known y should be an array of last two values in column F from current date(what am looking for)known x is all the date in column A matching known y.
to illustrate this is where the excel data is coming from column A2:A66 are the dates on x-axis,B2:B66 are high points. Column D identifies points D57,D47.D40,D35,D32,D27 AND D23.if trend lines are drawn between two last points as shown, column F should calculate the points on this lines i.e. F58,F56,F44,F24.what formulate can be insert in column F to pick last two values in column D and "draw a trendline" on these two points thus forecast values with corresponding blank cells on column D?
Please help

Date	High	Low	Hh	Ll	FH	FL
12/1/2016	1.0668	1.0584
12/2/2016	1.069	1.0625
12/5/2016	1.0796	1.0505	1.0796	1.0505
12/6/2016	1.0785	1.0698
12/7/2016	1.0768	1.071
12/8/2016	1.0861	1.0597	1.0861
12/9/2016	1.063	1.0531
12/12/2016	1.0652	1.0525
12/13/2016	1.0667	1.0603
12/14/2016	1.067	1.0497	1.067
12/15/2016	1.0539	1.0366		1.0366
12/16/2016	1.0473	1.0401
12/19/2016	1.0479	1.0393
12/20/2016	1.0417	1.0352		1.0352
12/21/2016	1.0451	1.0382
12/22/2016	1.0499	1.0423	1.0499
12/23/2016	1.0467	1.0427
12/26/2016	1.0468	1.044
12/27/2016	1.0463	1.0432
12/28/2016	1.048	1.0372		1.0372
12/29/2016	1.0493	1.0408
12/30/2016	1.0649	1.0484	1.0649
1/2/2017	1.0526	1.045
1/3/2017	1.049	1.034		1.034
1/4/2017	1.0499	1.039
1/5/2017	1.0614	1.0481	1.0614
1/6/2017	1.0612	1.0524
1/9/2017	1.0582	1.0511
1/10/2017	1.0627	1.0551
1/11/2017	1.0622	1.0454		1.0454
1/12/2017	1.0684	1.0572	1.0684
1/13/2017	1.0671	1.0596
1/16/2017	1.0636	1.058
1/17/2017	1.0719	1.0595	1.0719
1/18/2017	1.0714	1.0628
1/19/2017	1.0676	1.0589		1.0589
1/20/2017	1.0709	1.0625
1/23/2017	1.0769	1.0694
1/24/2017	1.0774	1.072	1.0774
1/25/2017	1.0769	1.0711
1/26/2017	1.0765	1.0658
1/27/2017	1.0725	1.0658
1/30/2017	1.074	1.062		1.062
1/31/2017	1.0812	1.0684
2/1/2017	1.0807	1.0732
2/2/2017	1.0828	1.0756	1.0828
2/3/2017	1.0797	1.0716
2/6/2017	1.0797	1.0706
2/7/2017	1.0749	1.0656
2/8/2017	1.0711	1.064
2/9/2017	1.0709	1.0651
2/10/2017	1.0667	1.0607
2/13/2017	1.0658	1.0592
2/14/2017	1.0633	1.0561
2/15/2017	1.0609	1.0521		1.0521
2/16/2017	1.0679	1.059	1.0679
2/17/2017	1.0676	1.0605
2/20/2017	1.0633	1.0603
2/21/2017	1.0615	1.0526
2/22/2017	1.0574	1.0493		1.0493
2/23/2017	1.0595	1.0537
2/24/2017	1.0618	1.0557
2/27/2017	1.063	1.0552
2/28/2017	1.063	1.0571
3/1/2017	1.0588	1.0515

<tbody>
</tbody><colgroup><col><col><col span="5"></colgroup>

 

[mole999]

Your original post was auto moderated, posting again will not release that, it requires a moderator and you should have received a system email to inform you of that

 

[ubulib]

guys
even macros or VBA solutions are welcome

 

[ubulib]

guys
even macros or VBA solutions are welcome

l have managed to solve this