|
Hi Cav
I didn't mean to suggest that you use the "Merge"
function to merge the two halves of data back together again. There's more than
one way to skin a cat. I'd be creating a text file (or 6) of the shortest
segment of data (Convert tool, MetaStock to text file), then loading that back
into the longer segment (Convert tool, text file to MetaStock) . 3000
securities makes for a rather large text file so you might want to do it 500
securities at a time. 6 passes sounds a bit easier than 3000. I don't see a
problem though, just a little time.
Kind regards
----- Original Message -----
Sent: Wednesday, June 15, 2005 10:17 PM
Subject: [Metastockusers] Re: Rogue data. Fix suggestions
please?
Oh dear! At first sight this seemed like the way do do
it ...
but ... when merging the two data sets the Downloader requires each
and every security to be merged individually. It still ends up
being a manual opeation across 3500 - 4000 securities (:- In which
case deleting straight from the Downloaders data sheet is more
straight
forward.
Or is there an option in the downloader I'm missing?? If
not, then
is there a third-party add-on that could handle this kind of
excercise? Some sort of hack??? Anything ..... apart from having
to do the damn thing more than 3000 times?
In
desperation!
cav
--- In Metastockusers@xxxxxxxxxxxxxxx,
"cav609" <cav609@xxxx> wrote:
> Roy
>
> As always,
thanks for the useful advice. Fingers crossed lol!
>
>
Regards
>
> cav
>
>
> --- In
Metastockusers@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxxx>
>
wrote:
> > Hi Cav
> >
> >
> > There's a
Delete tool in the MetaStock Downloader. Look under
> >
Tools/Delete/Data. You are given the option to select securities
> and
choose
> > a "Before" or "After" date.
> >
> >
After taking a backup and making another copy of the data you
> should
be
> > able to delete one side of the offending date (using before in
one
> copy and
> > after in the other) then merge the two
back into one.
> >
> > I've done just such an operation but
it was a long time ago. All
> the tools
> > you need are right
there in the Downloader, but don't forget to
do
> a backup
>
> before you start. The Delete function is unforgiving if you get
it
> wrong.
> >
> >
> > Kind regards
>
>
> > Roy Larsen
> > www.metastocktips.co.nz
> >
Free formulas and MS links
> >
> >
> >
>
>
> >
> > ----- Original Message -----
> >
From: "cav609" <cav609@xxxx>
> > To:
<Metastockusers@xxxxxxxxxxxxxxx>
> > Sent: Tuesday, June 14, 2005
2:36 AM
> > Subject: [Metastockusers] Rogue data. Fix suggestions
please?
> >
> >
> > > Hi
> > >
> > > I seem to have a rogue bit of data in my MS data files. One
non-
> > > trading day, a holiday, appears as as an entry within
all of
my
> > > securities. (Dont ask how it appeared there -
all my own
fault!)
> > >
> > > Anyone have any
ideas how I can delete just one days data
across
> all
> >
> securities without having to manually delete within each
> security
-
> > > the Downloader as far I can see only allows edits on one
> security at a
> > > time? Are there any third party
ons that will do something
like
> this?
> > >
>
> > Any help more than greatly appreciated!
> > >
>
> >
> > >
> > >
> > >
> >
>
> > >
---------------------------------------------------------------
--
>
---------------
> > > Yahoo! Groups Links
> > >
>
> > a.. To visit your group on the web, go to:
> >
> http://groups.yahoo.com/group/Metastockusers/
>
> >
> > > b.. To unsubscribe from
this group, send an email to:
> > >
Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
> > >
> > > c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms
of
> Service.
> > >
> >
>
Yahoo! Groups Links
|