To show the unrealized gain and loss require the new Excel feature - Data Types. Unfortunately, this feature doesn’t work at the moment for Excel 2016.
Candlestick chart is a style of bar-chart used primarily to describe price movements of a security,
derivative, or currency over time. This chart type is often used in combination with the volume bars chart
for technical analysis of stock and foreign exchange patterns.
Candlestick chart is a style of bar-chart used primarily to describe price movements of a security,
derivative, or currency over time. It is a combination of a line-chart and a bar-chart, in that each bar
represents the range of price movement over a given time interval. It is most often used in technical
analysis of equity and currency price patterns.