Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 1/8/2010(UTC)
Posts: 7
Was thanked: 2 time(s) in 1 post(s)
|
I have a large number of securities in my database that have not been active for many years, including those for companies that are no longer in business, and I would like to remove these items from my database.
With the Downloader, I can "Copy and Delete Source" or simply "Delete" those securities with a Last Date showing (say) anything with 2012 or earlier. But there are so many of them, that this manual process is very time consuming.
I would like to automate this process. For example it would be nice if I could select "all stocks with a Last Date < 2013 to be copied to another folder and delete the source security".
Is there an easy way to automate this, or a utility that will do it for me?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
Late response, but the MetaStock Symbol Utility files will completely replace pre-defined folders with newer versions of those same pre-defined folders. However, Smart Chart data is lost when doing this.
You can run an Exploration to identify securities no longer trading, although this will not add missing symbols (IPO's, etc) into your lists, only identify ones that have not received data for a specified amount of time.
How can I find the local securities which are no longer trading? (valid for version 11 and prior):
You can do this in order to know which securities
can be removed from your lists. It
identifies which securities have not traded in the amount of time you specify,
and lists them so you can remove the ones you no longer follow.
- Column A, type in the
following:
Month()
- In Column B, type in the
following:
DayOfMonth()
- In Column C, type in the
following:
Year()
- In the Filter Column, type in
the following changing “2000” to
the current year and “2” to the current month.
( (Year() < 2000) OR (Month()
< 2) )
- Add your data folders to the
Select Securities dialog
- Click Reports when complete
- Select the first security,
hold down the Shift key and click on the last symbol
- Right Click on the selected
securities
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 1/8/2010(UTC)
Posts: 7
Was thanked: 2 time(s) in 1 post(s)
|
Thanks Justin. It works like a charm.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/5/2006(UTC)
Posts: 129
Location: Norgate Data
|
Or you could use my free plugin that allows you to look at the last date in the price series and compare it to the current date and determine the number of days difference:
(this removes the issue of selecting a year and a month etc.)
|
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
