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

[Metastockusers] Re: Rogue data. Fix suggestions please?



PureBytes Links

Trading Reference Links

Ok Roy, sounds sensible!

cav


--- In Metastockusers@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxxx> 
wrote:
> 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
> 
> Roy Larsen
> www.metastocktips.co.nz
> 
> 
> 
> 
> ----- Original Message ----- 
> From: cav609 
> To: Metastockusers@xxxxxxxxxxxxxxx 
> 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
> 
>   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

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

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

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