|
PureBytes Links
Trading Reference Links
|
You may please check whether you save the data file in .csv format.
(Do not use .xls format). Using .csv format and not .xls and
selecting the ASCII text format for the souce file in downloader
solves many of the problems.
To summarise the whole procedure:
1) Keep the headers/data format in the daily data file as
<TICKER>,<DATE>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOLUME>.
- Keep the date format as mm/dd/yy
- Keep the volume figures as numerical without any
formatting for (,)
2) Delete all other coumns in the data file and save
it in the .csv format
3) Use ASCII text format in downloader under the
Tools -> Convert -> (Source - File type) ASCII Text
and
(Destination File Type) MetaStock
Hope this is useful.
Shriman
--- In equismetastock@xxxxxxxxxxxxxxx, "normhe2000" <norm@xxxx> wrote:
> Thank you Dusant for your message. I went into the regional date
> settings and changed both the short and long date format to
mm/dd/yy
> and gave it a go. Unfortunately, I still got the "invalid date"
when
> I tried to save it in Downloader. It's strange but I didn't have
> this problem before - so I must be doing something different -
what?
> is the question. I am using Win XP PRo which I have used before.
>
> I have used Netfile to download daily quotes and they go fine (as
> you know, Netfile gets the data from Yahoo). It seems the
historical
> data from Yahoo to Excel as a .csv file causes the problem with the
> date. I have played with all the different date formats in excel
but
> to no avail.
>
> Any other ideas would be greatly appreciated. Your time and
thoughts
> are most appreciated.
>
> Thanks. Norm.
>
> --- In equismetastock@xxxxxxxxxxxxxxx, Dusant <cooldush@xxxx> wrote:
> > This has something to do with your regional setting in the
control
> panel.
> >
> > Change your basic date format to mm/dd/yy, and the problem shud
be
> fixed.
> >
> > Dusant
> > ----- Original Message -----
> > From: normhe2000
> > To: equismetastock@xxxx
> > Sent: Sunday, May 01, 2005 9:18 AM
> > Subject: [EquisMetaStock Group] Date Entry copied from Excel
> >
> >
> > I am a real newby trying Metastock. I have taken historical
stock
> > data from Yahoo and downloaded to excel. I am trying to copy it
> to the
> > particular stock in downloader. I keep getting an "invalid date"
> so
> > hence cannot save it. The booklet says to use mm/dd/yy but the
> date
> > data in downloader seems to be dd/mm/yyyy. I have tried a variety
> of
> > date formats from excel but keep getting "invalid date".
> >
> > Any help would be appreciated with this frustrating and very
> basic
> > issue.
> >
> > Thanks. Norm.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/equismetastock/
> >
> > 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.
> >
> >
> > Yahoo! India Matrimony: Find your life partneronline.
------------------------ Yahoo! Groups Sponsor --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/BefplB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> 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/
|