|
PureBytes Links
Trading Reference Links
|
Hey Gordon, please bore me as I am also
interested
C<font size=2 color=navy
face=Arial>heers
Tim
<span
lang=EN-US >-----Original
Message-----
From: Gordon Sutherland
[mailto:gosuth@xxxxxxxxxxxx]
Sent: Sunday, 13 July 2003 10:00
AM
To: equismetastock@xxxxxxxxxxxxxxx
Subject: RE: [EquisMetaStock
Group] downloading files from excel
<font size=3
face="Times New Roman">
<font size=2 color=blue
face=Arial>Peter,
<font size=3
face="Times New Roman">
<font size=2 color=blue
face=Arial>I have
spent some moew time today going over your problem of not being able to convert
XL history file back to 1900 into Metastock. I have succeeded again in the task
(but not without some fiddling with formats etc). Rather than bore this Group I
will email you directly with an ASCII text file for the ticker XAO (Australian
All Ordinaries) and a Metastock binary .dat file together with three gif
files showing the settings for the three dialogue boxes for the downloader that
worked for me. Will send email later today.
<font size=3
face="Times New Roman">
<font size=5
color=green face="Kunstler Script">Regards,
<font size=3
face="Times New Roman">
<font size=5
color=green face="Kunstler Script">Gordon Sutherland
-----Original Message-----
From: drakov2002
[mailto:pradovan@xxxxxxxxxxxxxx]
Sent: Saturday, 12 July 2003 5:26
p.m.
To: equismetastock@xxxxxxxxxxxxxxx
Subject: Re: [EquisMetaStock
Group] downloading files from excel
<font size=2
face="Courier New">I don't know what i am doing
wrong. <span
>
I changed the custom format to mmm/yyyy and used
the downloader -
convert.
in options i used monthly.
i made sure first date was blank - it
had / / still in there
it then came up with yellow triangle and 900
errors of warning 2074
which is: unable to convert numeric data.
the file only went back to 1930 - which is
frustrating as i want to
look at the great depression and the decade
leading up to it.
I then tried putting first date 31/1/1900 - same
result
Regards
Peter Radovan
--- In equismetastock@xxxxxxxxxxxxxxx, Gordon
Sutherland
<gosuth@xxxx> wrote:
> I downloaded your file from the files area
and opened it in XL. I
> noticed that you have formatted the date as
MMM/YY. I changed this
to a
> custom format of MMM/YYYY and then downloaded
using the
downloader. I
> used Options to make sure the download would
pick up monthly data
and
> that the "first date" was left
blank. The file downloaded just
fine back
> to 1900.
>
> I suspect your problem is that the MS Windows
Operating System
does not
> know whether Jan/00 is Jan/1900 or Jan/2000
and Microsoft's Control
> Panel Regional Settings defaults to 1930 when
you are non-specific.
>
> Hope this helps.
>
> Regards,
>
> Gordon Sutherland
>
> -----Original Message-----
> From: drakov2002 [mailto:pradovan@xxxx]
> Sent: Saturday, 12 July 2003 12:13 p.m.
> To: equismetastock@xxxxxxxxxxxxxxx
> Subject: [EquisMetaStock Group] downloading
files from excel
>
>
> I have been having trouble using the
downloader to download files
> from excel.
> These have been historical data files
> I have put one on the files section as an
example called: share
> prices from 1900.
> As with all the others I put the proper
headings: date, open,
high,
> low, close, volume, open interest.
> They have all been monthly figures.
> With all of them I have been getting a yellow
triangle message
after
> I converted - which says that there is a
number of errors.
> However the files came out okay on metastock
except for this 1900
> one.
> It only downloaded the data back to 1930
instead of 1900.
> How do i fix this and stop the yellow
triangles?
>
>
>
> Yahoo! Groups
Sponsor
>
> ADVERTISEMENT
>
>
<<a
href="">http://rd.yahoo.com/M=194081.3551198.4824677.1261774/D=egroupweb/S=1
705
>
375617:HM/A=1663535/R=0/SIG=11ps6rfef/*<a
href="">http://www.ediets.com/start.cf
m?c
> ode=30504&media=atkins> click
here
>
> <http://us.adserver.yahoo.com/l?
M=194081.3551198.4824677.1261774/D=egrou
> pmail/S=:HM/A=1663535/rand=435640829>
>
> To unsubscribe from this group, send an email
to:
> equismetastock-unsubscribe@xxxxxxxxxxxxxxx
>
>
>
> Your use of Yahoo! Groups is subject to the
Yahoo! Terms of Service
> <<a
href="">http://docs.yahoo.com/info/terms/>
.
To
unsubscribe from this group, send an email to:<font size=2
face="Courier New">
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
Your use of
Yahoo! Groups is subject to the Yahoo!
Terms of Service.
<font size=3
face="Times New Roman">
<font size=2
face="Courier New">To unsubscribe from this
group, send an email to:<span
>
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
Your use of
Yahoo! Groups is subject to the Yahoo!
Terms of Service.
Yahoo! Groups Sponsor
ADVERTISEMENT
To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|