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
  • https://store-images.s-microsoft.com/image/apps.24898.ac0df76f-f735-4115-8761-6e92ee31f4da.ba8258ae-6eb1-4e8a-b759-0d84e74756e7.a9e8ca6c-04d2-4243-8ead-ad26951f3c3a.jpeg
    https://store-images.s-microsoft.com/image/apps.24898.ac0df76f-f735-4115-8761-6e92ee31f4da.ba8258ae-6eb1-4e8a-b759-0d84e74756e7.a9e8ca6c-04d2-4243-8ead-ad26951f3c3a.jpeg
    https://store-images.s-microsoft.com/image/apps.27507.ac0df76f-f735-4115-8761-6e92ee31f4da.ba8258ae-6eb1-4e8a-b759-0d84e74756e7.d6f448a5-45be-4b17-ae68-fbae7162cff5.jpeg