Skip to main content

Closing Stock Listing

Zhongshan College of UESTC

This app can help you retrieve Chinese closing-stock data when stock closes in Excel 2013.

Before you begin, you should input a row or column of data such as sh601006,sh600292,sh600116,sh600452,sh601991,sz000958,sz000531

-Select the data correctly

-Select the radio row/col, row means that the closing stock data will be written rowwise, and col means columnwise.

-Select the start cell the data will be written

-Click write button

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet