|
PureBytes Links
Trading Reference Links
|
Hi Ton
Column A ... the Name ... was not included.
I copied Columns B to H (<Ticker> to <Vol>) from Excel2000 to a separate XL
workbook and saved as ".csv" file.
I opened the CSV file with "Quick View Plus" and copied to Notebook ".txt"
file.
Metastock opened it without "sneezing" or errors.
Maybe, when I am feeling more charitable towards this program, I'll figure
out something more straight forward. Hopefully by V8.5
Thanks for all of your help and great emails over the years.
Best regards
Walter
----- Original Message -----
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: "Metastock-List" <metastock@xxxxxxxxxxxxx>
Sent: Sunday, March 19, 2000 4:34 PM
Subject: Re: computers
| > Hi Ton, Lionel, Cab, James and others who wrote.
| >
| > Ton ... sorry to have dumped all that stuff into an email. After 164 <G>
| > variations, <DATE> was the key that made the conversion work, not
<DTMMDDYY>
| > etc.
| >
|
| -----------------
| Fund Name <TICKER> <PER> <DTDDMMYY> <HIGH> <LOW> <CLOSE> <VOL>
| AIC Advantage II A D 3/16/00 7.61 7.61 7.61 0
| AIC Diversified Canada AD D 3/16/00 30.17 30.17 30.17 0
| AIC RSP American Advantage ARAMA D 3/16/00 4.84 4.84 4.84 0
| AIC RSP Global Advantage ARGA D 3/16/00 5.7 5.7 5.7 0
| AIC RSP Global Diversified ARGD D 3/16/00 5.47 5.47 5.47 0
| AIC RSP Value ARV D 3/16/00 4.33 4.33 4.33 0
| AIC RSP World Advantage ARWA D 3/16/00 6.03 6.03 6.03 0
| AIC RSP World Equity ARWE D 3/16/00 5.88 5.88 5.88 0
| AIC Value AVAL D 3/16/00 40.52 40.52 40.52 0
| -----------------
| DTMMDDYY is not the same as DTYYMMDD(your column contents).
| But you are right about the <DATE> working "again" in v6.5+.
| It didn't give proper results in earlier versions, at least not with some
ASCII formats
| (too after trying 180+ odd times) and at that time it was better to omit
and use
| the DTxxxxxx header instead(naturaly, only if you would spell the digits
correctly !!).
|
| Did you now Convert from ASCII to MSK or from Excel to MSK?
| Did you also use the Fund Name column header?
| Didn't Convert protest with errors?
|
| Regards,
| Ton Maas
| ms-irb@xxxxxxxxxxxxxxxx
| Dismiss the ".nospam" bit (including the dot) when replying.
| Homepage http://home.planet.nl/~anthmaas
|
|
| ----- Original Message -----
| From: "Walter Lake" <wlake@xxxxxxxxx>
| To: <metastock@xxxxxxxxxxxxx>
| Sent: zondag 19 maart 2000 17:05
| Subject: Re: computers
|
|
| > Hi Ton, Lionel, Cab, James and others who wrote.
| >
| > Ton ... sorry to have dumped all that stuff into an email. After 164 <G>
| > variations, <DATE> was the key that made the conversion work, not
<DTMMDDYY>
| > etc.
| >
| > Lionel ... I reason that I like engineering sites is that they are
usually
| > the clearest and most straight forward. It doesn't get any easier than
that.
| > Sorry.
| >
| > For those of you that "speak" math, the H exponent formulas are on page
120+
| > of Christopher May's Non-linear Pricing. The usual R/S analysis VB code
can
| > be found at Peters' site that I posted earlier.
| >
| > The H explicative is an old joke, "before the exponent there was the
| > explicative".
| >
| > The H P&L is based on running optimizing routines for the H lookback
period
| > and plotting the P&L for the current "favourite".
| >
| > Mandlebrot originally named it check his stuff out.
| >
| > Best regards
| >
| > Walter
|
Attachment Converted: "f:\eudora\attach\XL to MS.gif"
|