[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] [BATCH ADDING SYMBOLS] in DOWNLOADER?



PureBytes Links

Trading Reference Links

I have replied earlier to this.
 
Create the new data files using the Downloader. It can be done in one step, using the File\New\Security and clicking on the look up button.
 
The Auto.Sym file should be placed in your Downloader subdirectory.
 
Dusant
 
  ----- Original Message ----- 
  From:   Michelle 
  To: equismetastock@xxxxxxxxxxxxxxxx   
  Sent: Saturday, July 01, 2006 4:59   AM
  Subject: Re: [EquisMetaStock Group]   [BATCH ADDING SYMBOLS] in DOWNLOADER?
  

        
Thanks Dusant, for the detailed reply. However, I am
not sure if we both   understand what I am trying to
accomplish, so I followed your steps, and   took it as
far as I can go.

Attached see auto.sym

What I want   to do, is have it so The Downloader, will
use this file, as a means to   download data for all
those symbols, without me having to manually add   them
to a MASTER FILE. 

I have the symbols, but The Downloader will   want
dates, a date to start from. I am not sure how to
accomplish this.   

To add symbols manually is way too slow. Imagine, if
you want to   add the SP500, you have to add 500 stocks
manually? What if you want to add   3000 stocks? It is
easy to get a list of stocks in ASCII... I just   need
to get them so I can use it along with the Downloader.
I have ASCII   symbols lists, now I need a Metastock
Master file from it. Say, from a   starting date, of
January 1, 2000.

Attached is AUTO.SYM

I   looked in The Downloader, but did not see a way on
how I could take   AUTO.SYM, into a Master File, for
downloading from a specified   date.

What do you think?

Michelle


--- Dusant <dusant_ap@xxxxxxxxxxx>   wrote:

> I remember that I had made an ASCII file and saving
>   it as a filename.sym.
> 
> Here is the text from the MS help   file.
> ========
> 1. Open a new ASCII file in a text editor   (e.g.
> WordPad, Notepad).
> 2. Type the list of securities to add   to the Symbol
> Look-up dialog using the following format:
>   
> <security name>,<symbol>,<exchange>
>   
> Example:
> Microsoft,MSFT,NASD
> Apple   Computer,AAPL,NASD
> Oracle,ORCL,NASD
>   Iomega,IOM,NYSE
> 
> Each individual security must be entered on   a
> separate line in the text editor. The <exchange>
> and   <security name> entries are completely optional.
> 
> You   may also create an ASCII file using the
> following format:
>   
> <symbol>
> 
> Example:
> MSFT
>   AAPL
> ORCL
> IOM
> 
> In the example above, the ASCII   file contains only
> one field per line (i.e., the symbol). Since   the
> <security name> is not provided, The DownLoader will
>   attempt to provide a <security name> from the
> existing symbol   look-up list. For example, since
> the symbol look-up list in The   DownLoader associates
> the symbol "MSFT" to the security name   "Microsoft,"
> the name "Microsoft" will automatically be used   in
> the <security name> field. However, if The
> DownLoader   does not find a match for the <symbol> in
> the existing list, the   symbol itself will be used in
> place of the <security   name>.
> 
> 
> 3. Save the ASCII file with the extension   �.SYM�
> (e.g. �COMPUTER.SYM�).
> 
> Note that when   you save the file in Notepad or
> Wordpad, it will add a �.TXT�   extension after
the
> file name (e.g. "COMPUTER.SYM.TXT").   Rename the
> file so the Symbol Look-up dialog correctly
>   recognizes the file format.
> 4. Place the ASCII file in the same folder   as The
> DownLoader program. (e.g. �c:\Program
>   Files\Equis\The DownLoader�)
> 5. Open The DownLoader and display   the Symbol
> Look-up dialog.
> 
> The name of the newly   created symbol look-up file
> will be displayed in the Type menu of the   Symbol
> Look-up dialog.
> =========
> 
> I do not   know whether it is still available in newer
> versions of MS.
>   
> If the above described procedure still works, then
> it can be   easily created in a spreadsheet and
> exported to a text file.
>   
> Dusant
> 
> ----- Original Message ----- 
> From:   Michelle 
> To: equismetastock@xxxxxxxxxxxxxxxx   
> Sent: Wednesday, June 28, 2006 3:41 PM
> Subject:   [EquisMetaStock Group] [BATCH ADDING
> SYMBOLS] in DOWNLOADER?
>   
> 
> 
> I need to know of a way to batch add symbols to   the
> downloader. Doing
> it one-by-one with two-thousand stocks,   is
> idiotic. Does anyone have
> a solution for easily adding   multiple symbols to a
> stock list?
> 
> I have the symbols   in ASCII, need to get them in
> the downloader, and
> then update   my metastock list.
> 
> I appreciate ideas/suggestions on how best   to 
> accomplish this.
> 
> Michelle
> trader_gurl@xxxxxxxxx
>   
> (yes write me privately if you want - it's okay)
> 
>   
> .
> 
> 
> #ygrp-mlmsg { FONT-SIZE: small;   FONT-FAMILY:
>   arial,helvetica,clean,sans-serif}#ygrp-mlmsg TABLE {
>   }#ygrp-mlmsg SELECT { FONT: 99%
>   arial,helvetica,clean,sans-serif}INPUT { FONT: 99%
>   arial,helvetica,clean,sans-serif}TEXTAREA { FONT:
> 99%   arial,helvetica,clean,sans-serif}#ygrp-mlmsg PRE
> {   FONT: 100% monospace}CODE { FONT: 100%
> monospace}#ygrp-mlmsg {   LINE-HEIGHT:
> 1.22em}#ygrp-text { FONT-FAMILY:   Georgia}#ygrp-text
> P { MARGIN: 0px 0px 1em}#ygrp-tpmsgs { CLEAR:   both;
> FONT-FAMILY: Arial}#ygrp-vitnav { FONT-SIZE: 77%;
>   MARGIN: 0px; PADDING-TOP: 10px; FONT-FAMILY:
> Verdana}#ygrp-vitnav   A { PADDING-RIGHT: 1px;
> PADDING-LEFT: 1px; PADDING-BOTTOM: 0px;   PADDING-TOP:
> 0px}#ygrp-actbar { CLEAR: both; MARGIN: 25px 0px;
>   COLOR: #666; WHITE-SPACE: nowrap; TEXT-ALIGN:
> right}#ygrp-actbar   .left { FLOAT: left; WHITE-SPACE:
> nowrap}..bld { FONT-WEIGHT:   bold}#ygrp-grft {
> PADDING-RIGHT: 0px; PADDING-LEFT: 0px;   FONT-SIZE:
> 77%; PADDING-BOTTOM: 15px; PADDING-TOP: 15px;
>   FONT-FAMILY:
> Verdana}#ygrp-ft { PADDING-RIGHT: 0px;   BORDER-TOP:
> #666 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 77%;
>   PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY:
>   verdana}#ygrp-mlmsg #logo { PADDING-BOTTOM:
> 10px}#ygrp-vital {   PADDING-RIGHT: 0px; PADDING-LEFT:
> 8px; MARGIN-BOTTOM: 20px;   PADDING-BOTTOM: 8px;
> PADDING-TOP: 2px; BACKGROUND-COLOR:
>   #e0ecee}#ygrp-vital #vithd { FONT-WEIGHT: bold;
> FONT-SIZE: 77%;   TEXT-TRANSFORM: uppercase; COLOR:
> #333; FONT-FAMILY:   Verdana}#ygrp-vital UL {
> PADDING-RIGHT: 0px; PADDING-LEFT:   0px;
> PADDING-BOTTOM: 0px; MARGIN: 2px 0px; PADDING-TOP:
>   0px}#ygrp-vital UL LI { CLEAR: both; BORDER-RIGHT:
> #e0ecee 1px solid;   BORDER-TOP: #e0ecee 1px solid;
> BORDER-LEFT: #e0ecee 1px solid;   BORDER-BOTTOM:
> #e0ecee 1px solid; LIST-STYLE-TYPE:   none}#ygrp-vital
> UL LI .ct { PADDING-RIGHT: 0.5em; FONT-WEIGHT:   bold;
> FLOAT: right; WIDTH: 2em; COLOR: #ff7900;
> TEXT-ALIGN:   right}#ygrp-vital UL LI .cat {
> FONT-WEIGHT: bold}#ygrp-vital A {   TEXT-DECORATION:
> none}#ygrp-vital A:hover {
> TEXT-DECORATION:   underline}#ygrp-sponsor #hd {
> FONT-SIZE: 77%; COLOR:   #999}#ygrp-sponsor #ov {
> PADDING-RIGHT: 13px; PADDING-LEFT:   13px;
> MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 6px;
> PADDING-TOP:   6px; BACKGROUND-COLOR:
> #e0ecee}#ygrp-sponsor #ov UL {   PADDING-RIGHT: 0px;
> PADDING-LEFT: 8px; PADDING-BOTTOM: 0px; MARGIN:   0px;
> PADDING-TOP: 0px}#ygrp-sponsor #ov LI {
> PADDING-RIGHT:   0px; PADDING-LEFT: 0px; FONT-SIZE:
> 77%; PADDING-BOTTOM: 6px;   PADDING-TOP: 6px;
> LIST-STYLE-TYPE: square}#ygrp-sponsor #ov LI A   {
> FONT-SIZE: 130%; TEXT-DECORATION: none}#ygrp-sponsor
> #nc {   PADDING-RIGHT: 8px; PADDING-LEFT: 8px;
> MARGIN-BOTTOM: 20px;   PADDING-BOTTOM: 0px;
> PADDING-TOP: 0px; BACKGROUND-COLOR:
>   #eee}#ygrp-sponsor .ad { PADDING-RIGHT: 0px;
> PADDING-LEFT: 0px;   PADDING-BOTTOM: 8px; PADDING-TOP:
> 8px}#ygrp-sponsor .ad #hd1 {   FONT-WEIGHT: bold;
> FONT-SIZE: 100%; COLOR: #628c2a; LINE-HEIGHT:   122%;
> FONT-FAMILY: Arial}#ygrp-sponsor .ad A {
>   TEXT-DECORATION: none}#ygrp-sponsor .ad A:hover {
>   TEXT-DECORATION:
> underline}#ygrp-sponsor .ad P { MARGIN: 0px}o   {
> FONT-SIZE: 0px}..MsoNormal { MARGIN: 0px}#ygrp-text
> TT {   FONT-SIZE: 120%}BLOCKQUOTE { MARGIN: 0px 0px
> 0px 4px}..replbq {   }
> 
> ---------------------------------
>   Yahoo! India Answers: Share what you know. Learn
> something new Click   here
> Catch all the FIFA World Cup 2006 action on Yahoo!
> India   Click here
> 
> [Non-text portions of this message have   been
> removed]
> 
> 
> 
> 
> 

My   Yahoo Profile:
http://profiles.yahoo..com/trader_gurl

__________________________________________________
Do   You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around   
http://mail.yahoo.com   

[Non-text portions of this message have been removed]



   #ygrp-mlmsg {	FONT-SIZE: small; FONT-FAMILY: arial,helvetica,clean,sans-serif}#ygrp-mlmsg TABLE {	}#ygrp-mlmsg SELECT {	FONT: 99% arial,helvetica,clean,sans-serif}INPUT {	FONT: 99% arial,helvetica,clean,sans-serif}TEXTAREA {	FONT: 99% arial,helvetica,clean,sans-serif}#ygrp-mlmsg PRE {	FONT: 100% monospace}CODE {	FONT: 100% monospace}#ygrp-mlmsg  {	LINE-HEIGHT: 1.22em}#ygrp-text {	FONT-FAMILY: Georgia}#ygrp-text P {	MARGIN: 0px 0px 1em}#ygrp-tpmsgs {	CLEAR: both; FONT-FAMILY: Arial}#ygrp-vitnav {	FONT-SIZE: 77%; MARGIN: 0px; PADDING-TOP: 10px; FONT-FAMILY: Verdana}#ygrp-vitnav A {	PADDING-RIGHT: 1px; PADDING-LEFT: 1px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px}#ygrp-actbar {	CLEAR: both; MARGIN: 25px 0px; COLOR: #666; WHITE-SPACE: nowrap; TEXT-ALIGN: right}#ygrp-actbar .left {	FLOAT: left; WHITE-SPACE: nowrap}..bld {	FONT-WEIGHT: bold}#ygrp-grft {	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 15px; PADDING-TOP: 15px; FONT-FAMILY:
 Verdana}#ygrp-ft {	PADDING-RIGHT: 0px; BORDER-TOP: #666 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY: verdana}#ygrp-mlmsg #logo {	PADDING-BOTTOM: 10px}#ygrp-vital {	PADDING-RIGHT: 0px; PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 8px; PADDING-TOP: 2px; BACKGROUND-COLOR: #e0ecee}#ygrp-vital #vithd {	FONT-WEIGHT: bold; FONT-SIZE: 77%; TEXT-TRANSFORM: uppercase; COLOR: #333; FONT-FAMILY: Verdana}#ygrp-vital UL {	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 2px 0px; PADDING-TOP: 0px}#ygrp-vital UL LI {	CLEAR: both; BORDER-RIGHT: #e0ecee 1px solid; BORDER-TOP: #e0ecee 1px solid; BORDER-LEFT: #e0ecee 1px solid; BORDER-BOTTOM: #e0ecee 1px solid; LIST-STYLE-TYPE: none}#ygrp-vital UL LI .ct {	PADDING-RIGHT: 0.5em; FONT-WEIGHT: bold; FLOAT: right; WIDTH: 2em; COLOR: #ff7900; TEXT-ALIGN: right}#ygrp-vital UL LI .cat {	FONT-WEIGHT: bold}#ygrp-vital A {	TEXT-DECORATION: none}#ygrp-vital A:hover {
	TEXT-DECORATION: underline}#ygrp-sponsor #hd {	FONT-SIZE: 77%; COLOR: #999}#ygrp-sponsor #ov {	PADDING-RIGHT: 13px; PADDING-LEFT: 13px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 6px; PADDING-TOP: 6px; BACKGROUND-COLOR: #e0ecee}#ygrp-sponsor #ov UL {	PADDING-RIGHT: 0px; PADDING-LEFT: 8px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px}#ygrp-sponsor #ov LI {	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 6px; PADDING-TOP: 6px; LIST-STYLE-TYPE: square}#ygrp-sponsor #ov LI A {	FONT-SIZE: 130%; TEXT-DECORATION: none}#ygrp-sponsor #nc {	PADDING-RIGHT: 8px; PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; BACKGROUND-COLOR: #eee}#ygrp-sponsor .ad {	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 8px; PADDING-TOP: 8px}#ygrp-sponsor .ad #hd1 {	FONT-WEIGHT: bold; FONT-SIZE: 100%; COLOR: #628c2a; LINE-HEIGHT: 122%; FONT-FAMILY: Arial}#ygrp-sponsor .ad A {	TEXT-DECORATION: none}#ygrp-sponsor .ad A:hover {	TEXT-DECORATION:
 underline}#ygrp-sponsor .ad P {	MARGIN: 0px}o {	FONT-SIZE: 0px}..MsoNormal {	MARGIN: 0px}#ygrp-text TT {	FONT-SIZE: 120%}BLOCKQUOTE {	MARGIN: 0px 0px 0px 4px}..replbq {	}
 				
---------------------------------
 Yahoo! India Answers: Share what you know. Learn something new Click here
Catch all the FIFA World Cup 2006 action on Yahoo! India Click here

[Non-text portions of this message have been removed]





------------------------ Yahoo! Groups Sponsor --------------------~--> 
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/