Hot answers tagged database
From On Valuing Constant Maturity Swap Spread Derivatives "The CMS tickers are represented as USSWAPyy, where yy is the year indicator. For Example the tickers for CMS 30 yrs and CMS 2 yrs are USSWAP30 and USSWAP02 respectively"
Issue has been sorted. I'll post here for anyone else looking: I downloaded the Tickers in excel format from the NAz website: http://www.nasdaq.com/screening/companies-by-industry.aspx?exchange=NASDAQ Using the Bloomberg terminal in uni and the excel API i have the ticker list in column A and i input the following in column B: =BDP(A2&" US Equity","...
Only top voted, non community-wiki answers of a minimum length are eligible