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

Re: [amibroker] Re:Addition



PureBytes Links

Trading Reference Links

Dimitris,

If you look at the  AddColumn docs:
http://www.amibroker.com/guide/afl/afl_view.php?name=ADDCOLUMN

you will see the following example:
formatDateTime - produces date time formated according to your system settings
AddColumn( DateTime(), "Date / Time", formatDateTime ); 

This is (I guess) what you want.

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "DIMITRIS TSOKAKIS" <TSOKAKIS@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Tuesday, April 15, 2003 8:30 AM
Subject: [amibroker] Re:Addition


> Tomasz,
> Since we can not work with YYYYMMDD format, the solution is to change 
> to DD/MM/YYYY, it is equally recognised from the import wizard and it 
> is automatically available in the AA result list.
> I suppose now that the missing data repair is finished, using the 
> convention to put the last existing OHLCV in the hole[s].
> Do you have any plans for hole detection/repairing solution ?
> I see many people unhappy when the first composite taste is bitter, 
> because of their missing data.
> Dimitris Tsokakis
> --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <amibroker@xxxx> 
> wrote:
> > Dimitris,
> > 
> > Answered already.
> > Numbers are in IEEE single precision (32 bit) format
> > (7 significant digits). YYYYMMDD is 8 digits.
> > 
> > The 24 bits (including the hidden bit) of mantissa in a 32-bit 
> floating-point number represent approximately 7 significant decimal 
> digits. Unlike the real number system, which is continuous, a 
> floating-point system has gaps between each number. If a number is 
> not exactly representable, then it must be approximated by one of the 
> nearest representable values. 
> > 
> > See also:
> > http://www.math.grin.edu/~stone/courses/fundamentals/IEEE-reals.html
> > http://groups.yahoo.com/group/amibroker/message/1043
> > 
> > 
> > 
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com
> >   ----- Original Message ----- 
> >   From: Dimitris Tsokakis 
> >   To: amibroker@xxxxxxxxxxxxxxx 
> >   Sent: Monday, April 14, 2003 12:37 PM
> >   Subject: [amibroker] Re:Addition
> > 
> > 
> >   To be more specific, I want to transform Datenum() to YYYYMMDD 
> format.
> >   The 
> > 
> >   Filter=1;
> > 
> >   AddColumn(DateNum(),"",1.0);
> > 
> >   AddColumn(Column0+19000000,"",1.0);
> > 
> >   does not help.
> >   Dimitris Tsokakis
> > 
> > 
> >         Yahoo! Groups Sponsor 
> >        
> >        
> > 
> >   Send BUG REPORTS to bugs@xxxx
> >   Send SUGGESTIONS to suggest@xxxx
> >   -----------------------------------------
> >   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 
> > 
> >   Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
> Service.
> 
> 
> 
> 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 
> 
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 
> 
> 
>

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get a FREE REFINANCE QUOTE - click here!
http://us.click.yahoo.com/2CXtTB/ca0FAA/i5gGAA/GHeqlB/TM
---------------------------------------------------------------------~->

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 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/