How to use excel to forecast prices

Hi,

I am hoping to be able to forecast prices based of historical data using excels tools such as forecast, trend, LINSET or other. As many of the historical prices are considered indicators for other prices is there a way i can use X values prices to help predict Y value prices.

I am have a spreadsheet with ideas, please let me know any thoughts on how to tackle this issue.

Many thanks,