=List of publicly traded firms in Georgia=
*A Firms on NYSE NASDAQ AMEX yr 2016**An 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.
* PublicFirms**excel and txt file of public traded firms with records since Jan 2010 across the entire compustat database. The excel file shows is filtered to augusta companies * The files show (in order on the excel sheet)
**at (total assets)
**intan (intangible assets)
**intano (other intangibles)
**revt (total revenuein millions)
**xrd (research and development expense)
**exchg (stock exchange code)
*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:
**Best to do this in Internet explorer or Firefox so that once the file is completed, it can be downloaded directly (as opposed to Chrome)
*Step 1: Choose a date range
*Step 2: choose GVKEY.