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

Re: [amibroker] Re: JScript equivalent of 'push' of PERL.



PureBytes Links

Trading Reference Links




Hi Ron,
 
see green below 

 
----- Original Message ----- 
From: "ronbo" <<A 
href=""><FONT face=Arial 
size=2>ronbo@xxxxxxxxxxxxxx>
To: <<A 
href=""><FONT face=Arial 
size=2>amibroker@xxxxxxxxxxxxxxx<FONT face=Arial 
size=2>>
Sent: Tuesday, March 16, 2004 10:54 AM
Subject: RE: [amibroker] I have a problem with 
Export .csv and Import Wizard

thanks John for the reply--re #1--yea i knew it 
was something like that--i thought it was a bigger #thore #2--when i 
view your .csv file, the YDM format is displayed as 4/14/2003.
 
I show this as well; Other than 
because of an Excel bug, I don't know why the '04' in '04/15/3' which is 
actually 'YY/DD/M' in the XLS file converts to 4/14/2003 in the CVS 
file.
i did as you suggested and created a Custom 
date format that works.  thedate in the .xls file also contains the 
time "3/15/2004  6:00:23 PM"--thisfrom D2.
 
right; this is how it displays 
in the edit field, but hopefully in D2 itself, you see '15-3-2004' (D-M-YYYY; 
which I mislabelled as DM-YYYY in D1)i'll try the AB export, edit 
in Excel and change the Date format using acustom format and i'll see what 
happens and then Import.good 
luck!
 
thanks,ron-----Original 
Message-----From: john gibb [mailto:jgibb1@xxxxxxxxxxxxx]Sent: Monday, 
March 15, 2004 6:10 PMTo: <A 
href=""><FONT face=Arial 
size=2>amibroker@xxxxxxxxxxxxxxxSubject: 
Re: [amibroker] I have a problem with Export .csv and 
ImportWizardHi Ron,1) the 'large number' is the number 
of days since 1/1/1900 or thereabouts.2) RE changing your date format: 
see the attached where I have done justthat (with Excel 97, no less!) via 
Format | Cells | Category: Custom (andthen just put in the Type field: 
'm/d/yy', 'y/d/m', or 'd-m-yyyy')HTH,-johnPS: I also 
included the CSV file created from the XLS file, via Save 
As---Outgoing mail is certified Virus Free.Checked by AVG 
anti-virus system (<FONT face=Arial 
size=2>http://www.grisoft.com).Version: 
6.0.619 / Virus Database: 398 - Release Date: 
3/10/2004------------------------ Yahoo! Groups Sponsor 
---------------------~-->Buy Ink Cartridges or Refill Kits for your HP, 
Epson, Canon or LexmarkPrinter at MyInks.com. Free s/h on orders $50 or more 
to the US & Canada.<A 
href=""><FONT face=Arial 
size=2>http://www.c1tracking.com/l.asp?cid=5511<A 
href=""><FONT face=Arial 
size=2>http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM<FONT 
face=Arial 
size=2>---------------------------------------------------------------------~->Send 
BUG REPORTS to <FONT face=Arial 
size=2>bugs@xxxxxxxxxxxxxSend SUGGESTIONS 
to <FONT face=Arial 
size=2>suggest@xxxxxxxxxxxxx<FONT face=Arial 
size=2>-----------------------------------------Post AmiQuote-related 
messages ONLY to: <FONT 
face=Arial size=2>amiquote@xxxxxxxxxxxxxxx 
(Web page: <A 
href=""><FONT face=Arial 
size=2>http://groups.yahoo.com/group/amiquote/messages/<FONT 
face=Arial size=2>)--------------------------------------------Check 
group FAQ at: <A 
href=""><FONT 
face=Arial 
size=2>http://groups.yahoo.com/group/amibroker/files/groupfaq.html<FONT 
face=Arial size=2> Yahoo! Groups Links<*> To visit your group 
on the web, go to:     <A 
href=""><FONT face=Arial 
size=2>http://groups.yahoo.com/group/amibroker/<FONT 
face=Arial size=2><*> To unsubscribe from this group, send an email 
to:     <A 
href=""><FONT face=Arial 
size=2>amibroker-unsubscribe@xxxxxxxxxxxxxxx<FONT face=Arial 
size=2><*> Your use of Yahoo! Groups is subject 
to:     <A 
href=""><FONT face=Arial 
size=2>http://docs.yahoo.com/info/terms/<FONT face=Arial 
size=2> 


Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html








Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/amibroker/ 
To unsubscribe from this group, send an email to:amibroker-unsubscribe@xxxxxxxxxxxxxxx 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.