[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] Date Entry copied from Excel



PureBytes Links

Trading Reference Links

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 --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/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/