Company names in CSMAR

When you download data from the China Stock Market & Accounting Research Database (CSMAR) you get no company names in the output. In the WRDS interface you can’t mark a company name variable, and it’s also not given by default. All you get are Stock Codes, like 00002 or 600168.

In the other interface for CSMAR you can only get names when you select the China Listed Firm’s Corporate Governance Research Database and then choose the Basic Information. Then click on the tab Company Profile and select (at least) ‘Company name in English’ and ‘Stock Code’.

CSMAR

You will get a (zipped) Excel-file with Stock Codes and names. With the function Vlookup in Excel you can add the names to your other files with data from CSMAR.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s