|
PureBytes Links
Trading Reference Links
|
Sorry that should have been VBA. That's Visual Basic for Applications. It's
a bit of code that will execute a set of instructions. Open file, do what
you want save the file, open the next,etc.
Unfortunately my XL macro writing skills aren't up to the task.
Perhaps somebody else in the group can help with that.
>From: "notharold" <notharold@xxxxxxxxxxx>
>Reply-To: equismetastock@xxxxxxxxxxxxxxx
>To: equismetastock@xxxxxxxxxxxxxxx
>Subject: Re: [EquisMetaStock Group] How do you convert ALL symbols from
>Metastock format
>Date: Thu, 16 Mar 2006 22:01:50 -0000
>
>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/
|