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
<tbody>
</tbody><colgroup><col><col><col span="5"></colgroup>
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>