logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
What is most efficient way to update new issues/ipos for explorer scanning? - What is most efficient way to update new issues/ipos for explorer scanning?
Options
Go to last post Go to first unread
Previous Topic Next Topic
jshee921  
#1 Posted : Sunday, March 7, 2010 8:45:54 AM(UTC)
jshee921

Rank: Member

Groups: Registered, Registered Users
Joined: 2/24/2010(UTC)
Posts: 16
Hi everyone I have an explorer question

lets say I have a exploration to look for stocks that make 1 month highs, and I am only interested in the toronto venture market.
by trial and errror, I found that exploration via the reuters data link is too slow to process the 2000 over stocks in the venture exchange, I download the venture stocks into the local data and exploration becomes much faster.

then the issue is this: every month new ipos get listed in the venture exchange,then what is the most efficient way to update this issues in my local data?

if i do not know what these new ipos are then wouldn't I have to create a new local data for the toronto venture exchange every month to screen for these new ipos?

kindly help.
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
Justin  
#2 Posted : Tuesday, March 9, 2010 11:32:04 AM(UTC)
Justin

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
The downside to Local Data is the maintenance involved in keeping the folders current. Still, in my opinion the benefits of local data outweigh the bad side, as long as you can get comfortable updating the local data.

The simplest way to make sure that new symbols are getting into your existing data folders is to:

-Update the Symbol Database (Tools-->Update Symbol Database)
-Go into File-->New-->Security-->Look-up
-Select the appropriate Type/Group (i.e. Stocks - Canadian / Toroto Stock Exchange)
-Click Select All
-Click Ok

This does not eliminate outdated securities. Any duplicate symbols will be skipped, and any new symbols will be added.

The only problem you will run into with this is that the 6,000 symbols per folder check is done before The DownLoader knows that most symbols are duplicates. So the number of symbols you select above via "Select All" + what is already in the local data folder cannot exceed 6,000 even though most symbols will in fact be skipped.

In the case where you exceed 6,000, you would just need to select smaller portions of the group at a time.
Back to top
jshee921  
#3 Posted : Wednesday, March 10, 2010 5:22:10 AM(UTC)
jshee921

Rank: Member

Groups: Registered, Registered Users
Joined: 2/24/2010(UTC)
Posts: 16
I see.
Then how I wish metastock can come out with a "magic button' to remove outdated stocks and update the database all at once without the hassle of this kind of maintainence

ie telchart TC2000 security base is constantly updated and this makes stock screening really hassle free

Thanks anyway for your reply
Back to top
johnl  
#4 Posted : Wednesday, March 10, 2010 6:48:03 PM(UTC)
johnl

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
Getting rid of old securities is easy. Go to File/open/views/details/ and sort on last date.
Highlight and delete old securities.
Back to top
Justin  
#5 Posted : Wednesday, March 10, 2010 8:29:18 PM(UTC)
Justin

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT

I do agree that it would be nice. The below tip can be a bit of a time saver:

Support Tip

How can I find and delete local securities that are no longer trading?

Contributed by Equis Support

A good technical analysis trader regularly cleans up the symbol lists they use for trading. Creating an exploration to identify securities that are no longer trading takes just a moment and saves you time in the future. The following method identifies securities that are no longer trading and provides a way to easily remove them from your lists.


Create a new exploration with the following formula:

Col A name: month, Col A formula: Month()
Col B name: day, Col B formula: DayOfMonth()
Col C name: year, Col C formula: Year()
Filter ( (Year() < 2009) OR (Month() < 2) )

Run the exploration. The results will be the securities that are no longer trading. Select all of the results and delete them.

Below is a step by step process of how to create this exploration:

1. Open MetaStock

2. Open the Tools menu

3. Select The Explorer

4. Click New

5. Name the new exploration (we suggest "no longer trading")

6. In Column A, type in the following:
- name: month

- formula: Month()

7. In Column B, type in the following:
- name: day

- formula: DayOfMonth()

8. In Column C, type in the following:
- name: year

- formula: Year()

9. In the filter column, type in the following
- ( (Year() < 2009) OR (Month() < 2) )

- Note: you'll want to change the '2009' and '2' to the current year and month before you run this exploration.

10. Click OK

11. Click Explore

12. Add your data folders to the Select Securities dialog

13. Click OK

14. Click Reports when complete and select the Results tab

15. Select the first security, hold down the Shift key and click on the last security

16. Right click on the selected securities

17. Select delete securities
Back to top
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.

Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET