How to handle Duplicate Symbols?

How to handle Duplicate Symbols?

jjj
2011-12-14 18:23:46

What is the preferred method of handling duplicate symbols?

If multiple markets are added in the same account, the Change symbol names window pops up. If there are more than a few duplicates, this is way too cumbersome.

Can symbol names be downloaded with the exchange appended so duplicates won't occur?

If Ignore is selected in the Change symbol names window, is there some way to re-download these duplicates with different names as a later step?

Thanks for you help!

QuantShare
2011-12-15 04:28:37

One solution is to update symbol names (in Excel for example) before adding them to QuantShare.
You can for example, add a list in a new account, export that list, make modifications then import it in the original account.

Or instead of exporting the list, you can create a script to update symbol names:

You can change a symbol name using the Global Script (Tools -> Script Editor):

Symbols.RenameSymbol("SAY", "SAYCY");

jjj
2011-12-15 09:32:53

It seems the simplest solution is to copy Name1 to Name?

Can this be done in the Bulk Updater?

Or is there an option to use the qualified Name1 for Name when the list of symbols is processed?

Thanks!

QuantShare
2011-12-15 10:19:17

You can't update "Name" field in Bulk Updater and you can't set Name1 instead of Name when loading symbols.

You have to update the data before it is processed.

QuantShare
2011-12-15 10:24:40

Best Answer

Here is a script that changes Name field to Name1 for all active symbols: (Tools -> Script Editor)

Symbol[] symbols = Symbols.GetSymbols();
for(int i=0;i < symbols.Length;i++)
{
Symbol symbol = symbols[i];
if(symbol.Name1.Length > 0)
{
Symbols.RenameSymbol(symbol.Name, symbol.Name1);
}
}

Get more messages

No more messages

Back


Trading Items How far are the close prices from the support line Conditional Trailing Stop Exit 2013-10-18 CompRule Historical Index Composition Plot Economic Indicators on a Chart	How-to Lessons How to generate buy/sell signals from a trading system How to download new quotes when selecting a chart How to drag & drop a stock to a static watchlist How to filter stocks in a market composite How to print a chart
Related Forum Threads Creating a List of Symbols? handle stock split during simulation if close price as filter How to download data for selected symbols ? Looping within a screener and how to use RemoveSameSignals How to create a Trading Object	Blog Posts How to Optimize a Trading System with Thousands of Billions of Co... How to create a trading system, screen and composite using earnin... How to create your own technical analysis indicators How to Pick the Best Trend Indicators How to use QuantShare screener to trade penny stocks