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 Scale-in Trading Strategy Percentage of Stocks Trading Above their Pivot Point	How-to Lessons How to generate buy/sell signals from a trading system How to draw distances on a chart? How to get trading orders from a portfolio programmatically How to create a mobile database/account How to plot support and resistance lines automatically
Related Forum Threads Creating a List of Symbols? handle stock split during simulation if close price as filter how to download nifty50 chart? how to download Intraday data for NSE Nifty - S&P CNX Nifty How do I simulate if then statements for the simulator?	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 Display the Year-to-Date Excess Return in a Pivot Table How to use the new Market Regimes Feature in QuantShare Trading S... How to Backtest an Intraday Stock Trading System with EOD Ranking