Thursday, September 11, 2014

Stock Symbol Change History Nasdaq

Symbols of stocks change due to various reason at the exchange.

A quick google check took me to this url :

http://www.nasdaq.com/markets/stocks/symbol-change-history.aspx

The problem was it was 19 pages . There was no easy way to download them all.

So wrote a small snippet of code that goes through each page and downloads it.

The following code gives you a way to download the stock symbols change.

NASDAQ Symbol Change Matlab code

NASDAQ Symbol change history Excel file


Sunday, August 24, 2014

CUSIP Lookup

I recently updated my old code that looks up a cusip and gets the symbol from fidelity website.

convert stock cusips to stock symbols

Another way is to directly get the list of cusips from SEC published 13f lists here (in pdf) :

13f lists

Please note that redistribution of CUSIPS is not permitted.

It took me some effort to get the CUSIPS out of the pdf files.

If anybody is interested, you can buy it here. This includes the matlab code only.
13f cusip list extractor matlab code









Saturday, March 29, 2014

ETF Covered Calls - New Blog

I have started a new blog that gives information on ETF covered calls. Here I port an excel sheet that calculates the Covered Call Strategy returns for optionable ETFs.

http://etfcoveredcalls.blogspot.com

ETF Covered Calls