Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 2/7/2008(UTC)
Posts: 2
|
Hi All
New to MS and first post here.
I am trying to set my folders up in a way that will help me work most efficiently. In favorites, I will have folders in the following sequence: Sectors - Industries - Stocks. I will first find the sector I want to trade followed by the industry I want to trade. Then I will scan the stocks in that industry to see whether I have any buy/sell signals. So far so good.
Here's where I am stuck - I only want to populate the stock folders with those stocks that are optionable. If the stock doesnt have options, I dont want it in the folder. How do I do identify those optionable stocks?
MS has a data folder called "optionable stocks" but they are not organized by sector or industry - so they dont help me.
Any Suggestions? Thanks alot.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
You may want to try to play around with export/import to and from excel. I know you can make the match in excel but importing the results back onto Metastock and into the correct folder is where I get fuzzy.
I have exported a list from MS into excel, matched with another list to find the "missing" stocks and
imported those "missing" stocks back into MS but it was done out and in to one folder. You may have to go folder by folder? Starting to sound like a bit of work.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 2/7/2008(UTC)
Posts: 2
|
Thanks John.
So export the optionable stocks to excel, then download the stocks by industry to excel and have excel tell me which stocks are on both lists. Then import that list back into MS. I bet that would work. But yea, probably a lot of work.
Is there maybe another measure that I could use as a proxy for "optionable?" For example, market cap?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
I would say market cap and volume if you are going to trade them. Good volume will allow you to
get in and out easily.
To get stuff like this and fundemental stuff into MS, the Metastock gang wanted a new monthly subscription to access fundemental info. I assumed they hooked it into an exploration somehow.
I think it died (correct me if I am wrong) due to lack of interest but I am not sure.
If it did die, a good upgrade would be to create a new "stock characteristics" file with fields you could
populate yourself from their server or excel (excel definately).
The fields would be generic - you can put whatever info you want in it and the sorts and selects would work.
The file would have one record per stock with end user populated fields.
In simple terms, a file that the fields:
1) can be used in explorations
2) anywhere data selection is possible
3) ability to use it to scroll through screens interactively.
The fields could be anything you want them to be (very generic).
Easiest and best way would be to import/export the file back and forth from excel then have MS build a sort/selelection window and master file each time the file is imported back into MS.
This way you avoid the folder limitations without a major overhaul of MS and we get that much more depth.
|
|
|
|
|
|
| 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.
