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 CompRule Conditional Trailing Stop Exit 2013-10-18 Plot Economic Indicators on a Chart Historical Index Composition	How-to Lessons How to generate buy/sell signals from a trading system How to copy and paste drawing tools How to drag & drop indicators in charts How to filter stocks in a market composite How to add a trading indicator to a chart
Related Forum Threads Creating a List of Symbols? handle stock split during simulation if close price as filter How to create a watchlist of scrips that are in an intermediate u... How do I find the close price for an entry matching a custom DB How can I incorporate earnings release data into my backtests scr...	Blog Posts How to create a trading system, screen and composite using earnin... How to Optimize a Trading System with Thousands of Billions of Co... How to Switch On/Off Trading Rules in Your Stock Trading System How to measure market strength with the composite tool How scripts communicate with each other