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

Re: [EquisMetaStock Group] How do you convert ALL symbols from Metastock format



PureBytes Links

Trading Reference Links

Thanks for that.  I'm afraid I don't know what a VBNA macro is or 
how to get it......





--- In equismetastock@xxxxxxxxxxxxxxx, "Ron Berlin" <rsb_44@xxx> 
wrote:
>
> I thought I had sent this. If so, sorry.
> 
> 
> The Downloader will send tickers and data out as individual excel 
files - 1 
> per ticker. Insert a column adjacent to the ticker column. 
Concatonate as 
> has been suggested. Do copy paste special values for the 
concatonated 
> column, Deleite the original column. You now have the data with 
new tickers. 
> You need a VBNA macro open each file in a folder, perform the task 
and save 
> the file.
> 
> 
> >From: "notharold" <notharold@xxx>
> >Reply-To: equismetastock@xxxxxxxxxxxxxxx
> >To: equismetastock@xxxxxxxxxxxxxxx
> >Subject: Re: [EquisMetaStock Group] How do you convert ALL 
symbols from 
> >Metastock format to Yahoo format?
> >Date: Thu, 16 Mar 2006 11:02:40 -0000
> >
> >Dusant,
> >
> >I'd thought of this but I want to carry across all the data too. 
As
> >far as I can tell it is not possible to copy all the symbols from 
my
> >database, change them, and then re-attach them to the data.
> >
> >Notharold
> >
> >
> >--- In equismetastock@xxxxxxxxxxxxxxx, Dusant <cooldush@> wrote:
> > >
> > > Use a spreadsheet, col1 contains the original ticker, col2 
contains
> >the extension, col3 =concatenate(col1,col2).
> > >
> > > Save the file as text.
> > >
> > > Dusant
> > > http://www.geocities.com/cooldush
> > >   ----- Original Message -----
> > >   From:   notharold
> > >   To: equismetastock@
> > >   Sent: Wednesday, March 15, 2006 8:44   PM
> > >   Subject: [EquisMetaStock Group] How do   you convert ALL 
symbols
> >from Metastock format to Yahoo format?
> > >
> > >
> > > i.e. XXX ---> XXX.L
> > >
> > > NB there are over 2000 of   them and I want to do it in one 
go! I
> >can do
> > > one at a time but it is   taking ages!
> > >
> > >
> > > ---------------------------------
> > >  Jiyo cricket on Yahoo! India cricket
> > > Yahoo! Messenger Mobile Stay in touch with your buddies all the
> >time.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> >
>









------------------------ Yahoo! Groups Sponsor --------------------~--> 
Try Online Currency Trading with GFT. Free 50K Demo. Trade 
24 Hours. Commission-Free. 
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/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/