|
PureBytes Links
Trading Reference Links
|
Hi Jayson,
Found the reason why. After reading the excellent pdf on Composites
by Herman van den Bergen:
http://www.amibroker.net/3rdparty/IntroToAtc.pdf
Here's the part from the pdf:
-----------------------------8<-------------------------
"Coping with Volume overflow"
I have run a composite on a universe of some 1300 stocks with the
following code......(snip snip: code and explanation that the Volume
composite behaves erratic).
Answer: Divide volume by 1000 or more to avoid overflow of integer
volume field AddToComposite(V/1000,"~Universe" ,"v");
Volume field is stored as an 32 bit integer number which has the
range of - 2^31 to 2^31
–1 [Tomasz Janeczko]
-----------------------------8<-------------------------
Cheers Glenn
--- In amibroker@xxxxxxxxxxxxxxx, "Jayson" <jcasavant@xxxx> wrote:
> Glenn,
> You may have some holes in the DB... try the purify tool....
>
> Regards,
> Jayson
> -----Original Message-----
> From: Glenn [mailto:glennokb@x...]
> Sent: Friday, January 23, 2004 7:39 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Negative composite value?
>
>
> Hi,
>
> I have a database of about 1400 stocks and when I run an
> Addtocomposite ie:
>
> TotalTurnover = V * C;
> AddToComposite(TotalTurnover,"~Turnover","V");
>
> I'm getting some large negative numbers.
>
> If I run an "Explore" using:
>
> TotalTurnover = V * C;
> AddColumn(TotalTurnover,"TotalTurnover",1.3);
> Filter=1;
>
> ...on the same database and set the range to the same date with
> negative turnover.
>
> I exported this to Excel and sum() the turnover, the
> result is definately not negative.
>
> Thanks for any help.
>
> Cheers Glenn
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 Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->
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:
http://docs.yahoo.com/info/terms/
|