|
Excel Books
| |
Books that I own and use while developing in Excel
|
|
|
Stock Charts in Microsoft Excel.
Excel Dashboards by ExcelUser.com - Instructional eBook and Ready-to-Use Workbooks.
|
This page explains how to use Excel's candlestick-style OHLC stock charts, how to make your own using built-in line chart features (high-low lines and up-down bars), and how to combine line chart and XY chart series to produce stock charts with open and close tickmarks, so you can dispense with the candlestick chart's up-down bars altogether.
Top of Page
|
|
When an Open-High-Low-Close chart is created in Excel, the result is a candlestick chart. The bar spans the range from open to close and the drop lines show the low and high extremes, with a white fill indicating an increase and a black fill indicating a decrease. Personally I find this confusing, because I have to read the data to recall whether white fill means up or down.
Stock charts in the newspaper and on line show a tick mark to the left of the low-high drop lines for open and one to the right for close. This page describes my procedure for left-handed opening price tick marks.
Top of Page |
|
A common problem people have is adding an extra series to a stock chart. It would be very helpful to add a market index, for example, or another moving value to a stock chart to see how the stock price moves with respect to another factor. This can be done, but you need to follow a few extra steps.
Top of Page |
|
Want a stock chart that's always going up? Seriously, how do you switch a stock chart's Date and Value axes? Well, you can't do this to Excel's built in stock charts, but you can chart exactly the same information in a scatter chart with error bars.
Top of Page
|
|
Often it is desirable to plot multiple series so that their values are normalized to an initial value of, say, 100. This is particularly useful when comparing performance of stock prices on a relative basis. This article shows how to use dynamic ranges and dynamic charts to display normalized values.
Top of Page
|
|
|
Waterfall Chart
Box and Whisker
