|
PureBytes Links
Trading Reference Links
|
I 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 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@x...]
> 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
>
>
<http://rd.yahoo.com/M=194081.3551198.4824677.1261774/D=egroupweb/S=1
705
>
375617:HM/A=1663535/R=0/SIG=11ps6rfef/*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
> <http://docs.yahoo.com/info/terms/> .
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy 1, Get 1 FREE
Control Cravings & Hunger EZ! Fast Acting Natural Oral Spray - $19.97
http://www.challengerone.com/t/l.asp?cid=2866&lp=ezappetite3.html
http://us.click.yahoo.com/rJIe0D/99VGAA/ySSFAA/BefplB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|