Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Charting Stock Trendline
One method of doing stock analysis has to do with identifying a trendline. The trendline needs to be a straight line that crosses three or more points of the low stock price. (see example below). Can anyone think of a way of doing this in Excel? The trendline that exists within Excel is a based on a regression so it's not straight.
Thanks for looking. - Paul Here's the data I used to create the graph above (I drew the red line) High Low Close 1-Jul 7.5 5 6 2-Jul 16.5 11 13.2 3-Jul 15 10 12 4-Jul 21 14 16.8 5-Jul 22.5 15 18 6-Jul 28.5 19 22.8 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing rows that don't show the lowest stock each day | Excel Discussion (Misc queries) | |||
Stock Location Sorting Problem | Excel Discussion (Misc queries) | |||
Trendline Extract | Charts and Charting in Excel | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
I need a template for stock | Excel Worksheet Functions |