Discussions
»
Product and Service Development
»
MetaStock
»
Can I get a list of codes from Excel into Favorites folder?
Rank: Member
Groups: Registered, Registered Users, Subscribers Joined: 9/25/2005(UTC) Posts: 23 Location: Melbourne, Australia
|
Hi, I would like to compile a favorites folder from an excel list of codes.
Is there an easy way to do this or do I have to add them all manually? :?:
Cheers
Charmeta
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users Joined: 9/13/2004(UTC) Posts: 673 Location: Salt Lake City, UT
|
You could construct a .SYM file for easy access to those symbols. Column A should contain the ticker, and there should be no other columns in the file. Save the Excel file as a .CSV (Comma Delimited) file. However, when you save the file, put the filename in quotation marks and put a special .SYM extension on the end (i.e. "MyStocks.SYM"). Save this file in the DownLoader folder (Typically C:\\Program Files\\Equis\ he DownLoader). You can now access this list of symbols either through the DownLoader (File>New>Security>Lookup, it will show up under the Type field) or you can see this list directly in MetaStock through the Data On Demand button (i.e. File>Open>Reuters DataLink).
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers Joined: 9/25/2005(UTC) Posts: 23 Location: Melbourne, Australia
|
Hi Pyradius, thanks for your reply.
I am using EOD V9.1 & I created a SYM file as you described. Do I need to sign up with reuters datalink?
I want to do an exploration on the file.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users Joined: 9/13/2004(UTC) Posts: 673 Location: Salt Lake City, UT
|
If you want to use that list in MetaStock directly you would need Reuters DataLink to go with the EOD version. In the DownLoader, you could construct local files using that list and download from the supported vendors within the DownLoader (Dial/Data, Signal, Telescan, Reuters DataLink).
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
Can I get a list of codes from Excel into Favorites folder?
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.