Update the Stock Exchange Associated With U.S. Stocks

Update the Stock Exchange Associated With U.S. Stocks - Market Field

by QuantShare, 5183 days ago		Share \|

In order to keep your symbol database up-to-date, here is a trading item that automatically updates the exchange name of your US Stocks. The item downloads three symbols list; each list contains stocks that are listed in a specific exchange (NYSE, NASDAQ and AMEX). After a list is downloaded, each stock it contains is updated and associated with the corresponding stock exchange.
Stock that are not listed in one of these lists are usually delisted stocks, non-active stocks (due to bankruptcy for example) or stocks that are not listed on a major exchange (Over-the-counter or OTC markets such as the OTC Bulletin Board and Pink OTC Markets).

Before running this downloader, you can create a global script and update the exchange name of each US Stock you have in database. You can set the exchange name to empty or set it to "OTC" so you can recognize the stocks that are not listed on a major stock exchange (NYSE, NASDAQ and AMEX).
Although this step is not necessary, it can help you create a clean database; so here is the script:

Symbol[] symbols = Symbols.GetSymbols();
for(int i=0;i<symbols.Length;i++)
{
Symbol sym = symbols[i];
if(!sym.Name.StartsWith("^") && !sym.Name.StartsWith("_"))
{
sym.Market = "OTC";
}
}

Simple replace "OTC" by "" if you want to unset the exchange name of your stocks. To execute the script, select "Tools" in the menu then click on "Script Editor". Create a new file, paste the formula then click on "Execute".

Note that this item also adds new symbols in case a stock was not found in your database. These are maybe new listings or companies that recently had an IPO.

You can also use Industry and Sector Information for the US Stock Market to update the industry and sector name of stocks available in your database.