Removing inactive symbols from a dataset
Author: Sammy_G
Creation Date: 6/25/2011 2:46 PM
profile picture

Sammy_G

#1
Does there exist a script (or other solution) for removing inactive symbols from an individual dataset? There may be tens (? hundreds) in some of my datasets so a manual solution is not practical.
profile picture

Eugene

#2
Loop by DataSetSymbols, find symbols that didn't have price changes for the last N days, append all the rest (i.e. active symbols) to a string, copy it from the Debug window, and paste in the Symbols frame, then click 'Apply Symbol Changes'.
profile picture

Sammy_G

#3
Thanks!!
profile picture

Eugene

#4
Thinking out loud: if I ever consider a WL6 version of "Data Truncation Utility", removing inactive symbols could be a possible option (requiring a restart though).
profile picture

Cone

#5
Re: Data Truncation Utility
I've already got a script for this, but it's not polished.
profile picture

Eugene

#6
Working on it.
profile picture

abegy

#7
I'm interesting on this solution too. Are you working to have it compatible with the Metastock data format ?
profile picture

Eugene

#8
No, not possible. This is a universal solution that caters to the providers which implement the "BarDataStore" i.e. Wealth-Lab's built-in mechanism for storing and maintaining local history of data in .WL files. Thereby...

* Will work with: Fidelity, MSN, Yahoo, Google, QuoteMedia, PiTrading, TradingBlox, Market Sentiment, Finam, CBOE, Random, Bloomberg Free, IQFeed, Taipan?...

* Will not work with: MetaTrader, Metastock, ASCII, Database, Excel, Bloomberg Static, Watchlist, COTCollector, MTiQs?, Telecharts, Zerich, DDE...
profile picture

Eugene

#9
P.S. With data sources like Metastock or ASCII one should use specific utilities like The Downloader (MS) or Notepad (ASCII).
profile picture

Eugene

#10