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