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 History of dividend payment for stocks in the US stock market Large Block Ratio Indicator	How-to Lessons How to generate buy/sell signals from a trading system How to copy and paste drawing tools How to debug a downloader How to quickly add a ticker symbol How to run QuantShare offline
Related Forum Threads Creating a List of Symbols? handle stock split during simulation if close price as filter how to use AI? How do you retrieve the entry and exit price for a position? how to draw Flag (Bullish) on chart?	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 create and backtest thousands of trading rules in less tha... How to use the new Market Regimes Feature in QuantShare Trading S... How to Backtest an Intraday Stock Trading System with EOD Ranking