- How to Import Data
- File Formats
- How to Import with Copy & Paste
- How to Set Column Headers
- Paste Special
- Paste Special Example: The decimal separator
- How to Append Data into Existing Columns
Join the Community
The Stocks command can be used to visualize stocks using two different styles, Candlestick and OHLC (open high, low close). For more information on Candlestick charts see Wikipedia.
To use this command, you will need to have columns in the data table corresponding to the open, high, low and close, as shown in the example table below.
The Style can be modified from Candlestick to OHLC (open high, low close).
Line and Fill
The Line style changes the color of the outline.
The Fill colors have two tiles that the color when the stocks increase or decrease.
To apply a Mask use the date format, year:month:day.
Table of Contents