|
PureBytes Links
Trading Reference Links
|
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@xxxxxxxxxxx>
>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@xxx> 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@xxx
> > 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/
|