|
PureBytes Links
Trading Reference Links
|
I was able to replicate your problem using the date as a number
field. It needs to be text.
See if the date column on the spread sheet you're converting is
aligned to the left or the right.(Make the column very wide. It's
easier to see.)
If left it's text as is required and your problem lies elsewhwere.
If aligned right it's a number. Convert the number using Text
(Mycell,"mm/dd/yy"). The quotation marks are required.
You may also want to try checking in at:
http://tech.groups.yahoo.com/group/xltraders/
They are very helpful
--- In equismetastock@xxxxxxxxxxxxxxx, "rsb_44" <rsb_44@xxx> wrote:
>
>
> From the Downloader Help file:
>
> 1.The data must be in columns.
> Each column must have a heading that describes what data is in the
> column. The only required columns are DATE and CLOSE. Optional
> columns are TICKER, PER, OPEN, HIGH, LOW, VOLUME, and O/I. The
> column names must be spelled as shown here. The column headings
must
> all be on the same row.
>
> 2.The dates must be in the mm/dd/yy style and must be formatted as
> text labels (i.e., the @DATE function cannot be used).
>
> 3.The data must be in ascending order (dates increase as you move
> down the spreadsheet).
>
> 4.The spreadsheet cannot be open when attempting to perform the
> actual conversion in The DownLoader.
>
> As an "experiment" try converting a single file from MS to Excel.
> Then see what is happening to the dates. It is likely that the date
> formatting in the newly created Excel file is what you will neeed.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> The following is from the Downloader Help File--- In
> equismetastock@xxxxxxxxxxxxxxx, dave <adest@> wrote:
> >
> > Metastock downloader will handle the dates best if they are set
to
> 31/12/1997
> > when you import. Have a look at the options.
> >
> > Its my understanding that Metastock format stores a 1 in front of
> the shortened date.
> >
> > eg
> >
> > 1971231
> >
> > But this should have no bearing on your import - but your vendor
> may have
> > exported it with the extra digit which will upset the Downloader.
> >
> > Solutions:
> >
> > 1. Ask your vendor to send it in metastock format! Easy
> >
> > 2. If he can't (which would surprise me) what you probably have
to
> do is write a
> > small macro in excel to put the date back to normal format dates
by
> stripping the
> > extra digit.
> >
> >
> >
> >
> > http://www.invest-store.com/wavetrader/resource/emailoffers.html
> >
> >
> > On Thu Jan 10 4:43 , 'draggiedriver' <draggiedriver@> sent:
> >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hello everyone.
> > >
> > >
> > >
> > >I've been having a problem with date formats and importing into
my
> > >
> > >database. If anyone can help, I'd be most grateful.
> > >
> > >
> > >
> > >My vendor has been helping me with a derived-data stream, and
sent
> me
> > >
> > >some history to check, in the form of a .csv file. Problem was,
> the
> > >
> > >date column was in native format (1/1/1900 = day 1).
> > >
> > >
> > >
> > >This was a new one to me, but I was told how to convert the data
> column
> > >
> > >to date format in Excel, and then I tried to import via the
> Downloader
> > >
> > >into my database. Using my local date format, I came up with a
> repeated
> > >
> > >DL nag saying 'invalid date', so then I tried the US date format
> to no
> > >
> > >avail.
> > >
> > >
> > >
> > >I wondered if anyone can help me with this?
> > >
> > >
> > >
> > >Kind regards to all.
> > >
> > >
> > >
> > >D
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> 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/
|