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

Re: 6.52 Update Problem



PureBytes Links

Trading Reference Links

Find the answers below your questions.

Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.



----- Original Message -----
From: Leo
To: metastock@xxxxxxxxxxxxx
Sent: zaterdag 15 mei 1999 17:28
Subject: Re: 6.52 Update Problem
>
>
> Good Morning,
> With the 6.52 version, I can't use the download from excel. So I think there
> is some program bugs. To probe it, I have done the following steps :
>
> - First I unloaded my curent metastock version and successfully reloaded
>   the 6.5 version and the 6.52 eod patch  loaded from Equis site.
>
> - I choiced 4 stocks from my data base, and I downloaded these stocks
>   into an excel format file ( stock1, 2,3,4 ).
>
> - I obtained the two first in sequence in the excel file from the line 1 to 1171,
>   then an empty zone from 1172 to 1761 ( 589 empty line !!! ), then the third
>   stock from 1761 to 2349, then an empty zone from 2349 > > to 3518
>   ( 1169 empty lines !!!!! ), and the forth stock from 3518 to 4106.
>
> First problem why these empty lines in the excel file ?

First of all, when converting multiple securities from MetaStock to Excel
(or v.v.) you do not have to provide a Destination filename. MetaStock will
give the Excel-file (or any file) an abriviated (8 characters max) tickercode
for filename. Automaticaly.
It will also add the Periodicity character (eg D for daily data) to the filename
(on the 8th position) and I don't know why it does so, but it does.
However, providing a name will have the Convert Tool assume that you
want all the securities' data converted to that one(1) single Excel-file only.
Since the standard procedure for Excel-convert jobs (especialy when
converting any Historical data) to or from an Excel-file, is that this conversion
will also take place per one(1) security(=ticker) only, then it also explains why
your 4 securities were jammed(dumped) into the one(1) file, eg as it was
messing up this standard procedure.

> - Then I deleted all these empty lines, and I tried to load the new excel file
>    into a new metastock file. I only obtained a stock, instead of four. The
>    stock I obtained has the code of my first stock (stock 1 ) and the values of
>    the last one  (stock4).
> 
> So, this my difficulties to use the excel download.

See the standard conversion procedure explanation above for an Excel-file
to succesfully convert to MetaStock (or v.v. from MetaStock to Excel), when
using Historical data, eg "One security per file only".
Should you wish to convert only one(1) single days' data, eg where the (field)
column for the dates down, only holds one single day for the entire date-column,
only then you are allowed to use multiple securities/tickers.
Also make sure to save the Excel-file in the very old Excel 4.0 file format
(the from 1994 stemming - single worksheet only - format).
See further the online Help or also the DL-manual p72-73.

> Of course I have kept on my file the two excel files ( the original one, and the
> deleted empty line file) and the new one stock metastock file that I can send
> to justify my text

> Thank you very much if somebody can bring a solution to these problems.
> Best Regards.
> Robert Vialet