Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 10/6/2005(UTC)
Posts: 51
|
Can anyone explain how to search and find all outdated symbols for deletion?
The sort function doesnt seem to sort by date.
Thanks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Kadip, This is a very common question and as such there have been many asnswers. Some of the solutions that spring to mind: 1. Get a decent data vendor. My data vendor moves stocks that are no longer trading from my main Equities folder to a Dead Equities folder. I keep the data on these companies for backtesting purposes but they do not figure in my explorations for current trading stocks. (Its also a good idea to keep Equities, Indexes, Options, Warrants and other derivatives in a separate location for better houskeeping. A good data vendor will also have a method to achieve this.) 2. Use the downloader to view the equities in a folder and delete them individually by the last date traded. This might have to be done every day if your data vendor sends you the data again for the companies that you have already deleted. Again, the importance of having a good data provider. 3. Check out a commercial product called StockDelete from Paritech ( http://www.paritech.com/paritech-site/support/stockdelete/
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 10/6/2005(UTC)
Posts: 51
|
Wabbit-
Thanks a lot for the ideas-
fyi- I'm using Reuters data from Equis- I would have expected it to be cleaned periodically, but...........perhaps I need to switch to a cheaper and cleaner source!
Thanks- Ill try the solutions you referenced!
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
I am not sure of the Reuters data stream, but another option is to periodically delete all the data you have, then re-download the data as only those stocks still trading stocks are included?
wabbit [:D]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 10/6/2005(UTC)
Posts: 51
|
Wabbit-
I just noticed an easy way to find and delete- the download report which occurs after every download shows all securities for which your system requested prices but for which no prices were available from the data vendor. Highlight them, right click and you can delete all at once- seems easy.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
kadip,
Good tip. I am sure someone else will find this information useful. As for me, as I have mentioned, I leave all this to my data provider.
Thanks
wabbit [:D]
|
|
|
|
|
|
| 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.
