Home

How to use excel to forecast prices

%3CLINGO-SUB%20id%3D%22lingo-sub-898389%22%20slang%3D%22en-US%22%3EHow%20to%20use%20excel%20to%20forecast%20prices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-898389%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20hoping%20to%20be%20able%20to%20forecast%20prices%20based%20of%20historical%20data%20using%20excels%20tools%20such%20as%20forecast%2C%20trend%2C%20LINSET%20or%20other.%20As%20many%20of%20the%20historical%20prices%20are%20considered%20indicators%20for%20other%20prices%20is%20there%20a%20way%20i%20can%20use%20X%20values%20prices%20to%20help%20predict%20Y%20value%20prices.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20have%20a%20spreadsheet%20with%20ideas%2C%20please%20let%20me%20know%20any%20thoughts%20on%20how%20to%20tackle%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-898389%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Contributor

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,

Related Conversations
Projecting Data Figures - Years in Advance
Jamos7 in Excel on
3 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies