447
edits
Changes
Jump to navigation
Jump to search
Augusta Startup Ecosystem (view source)
Revision as of 17:36, 26 September 2017
, 17:36, 26 September 2017→List of publicly traded firms in Georgia
*A excel file list of publicly traded firms (on NYSE, NASDAQ, or American Stock Exchange), with their data for Jan 1 2016-Jan 1 2017, pulled from compustat (https://wrds-web.wharton.upenn.edu/wrds/ds/compm/funda/index.cfm?navId=84), can be found in E:\McNair\Projects\Innovation Districts\Augusta Startup Ecosystem. It's filtered to show only Georgia companies. It's called "Firms on...". The list files also appear in E:\McNair\Projects\Publicly Traded Firms Data.
* The file shows (in order on the excel sheet)
**naics (North American industry classification code)
**state
*Directions for pulling general data from https://wrds-web.wharton.upenn.edu/wrds//ds/compm/funda/index.cfm?queryID=807962 with filters for Fundamentals Annual:
*Step 1: Choose a date range
*Step 2: choose GVKEY.
*Step 3: choose data items. In the search bar below, search for information you want. You can search either the abbreviation or the description itself. Once you choose a piece of information (i.e., Stock Exchange Code), a window pops up above Step 3 indicating that you can filter by these pieces of information, in addition to having them in your output file. To filter by Stock exchange, for example, click (in the Conditional Statements window) the drop down arrow, click "Stock Exchange Code". In the far right box, input the code that corresponds to each Stock Exchange (can only be found before Stock Exchange code is selected as a variable type in Step 3. If it's selected, deselect it, find it in the search box, and click on the question mark). To add more, click either "OR" or "AND" and add another code. Select all desired variables and all desired filters on those variables.
*Step 4:
**Output format: select tab-delimited text.
**Compression type: Select none
**Date format: choose either the first option or the last one.
=Documentation=
