|
PureBytes Links
Trading Reference Links
|
>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@xxx> 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@xxx> 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/
|