|
PureBytes Links
Trading Reference Links
|
<FONT face=Arial color=#0000ff
size=2>Peter,
<FONT face=Arial color=#0000ff
size=2>
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 face="Kunstler Script" color=#008000
size=5>Regards,
<FONT face="Kunstler Script" color=#008000
size=5>
Gordon
Sutherland
<FONT
face=Tahoma size=2>-----Original Message-----From: drakov2002
[mailto:pradovan@xxxxxxxxxxxxxx] Sent: Saturday, 12 July 2003 5:26
p.m.To: equismetastock@xxxxxxxxxxxxxxxSubject: Re:
[EquisMetaStock Group] downloading files from excelI
don't know what i am doing wrong. 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
thereit then came up with yellow triangle and 900 errors of warning
2074which 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 resultRegardsPeter 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=1705>
375617:HM/A=1663535/R=0/SIG=11ps6rfef/*<A
href="">http://www.ediets.com/start.cfm?c>
ode=30504&media=atkins> click here
> > <<A
href="">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:equismetastock-unsubscribe@xxxxxxxxxxxxxxxYour
use of Yahoo! Groups is subject to the <A
href="">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.
|