|
PureBytes Links
Trading Reference Links
|
I have just thought of a realy simple & nice solution. (Yet to be tested)
Convert the RANK to a decimal,
Then tag (Add) the Rank to the DateNum() value.
<MSG>
At 09:10 AM 22/02/2004, you wrote:
>Thanks Herman,
> I didn't noticed the DayOfYear() function, Odd how you can miss things
>like this.
>
>Basicaly, This is what Im thinking.
>
>Transform the Year into a 1 digit number. aka your previous sugestion.
>(This should enable a range of 10 years, ie 0-9)
>The Day of Year - Effectively converts Month/Day (x4 Digits) into 3 Digits.
>That leaves 3 digits spare (And possibly decimals) to use as ranking digits.
>
>Speaking of decimals, I wonder how many significat Decimals could be held????
>ie Convert the entire number to a fraction and store it that way !!!
>
><MSG>
>
>
>
>At 11:20 PM 21/02/2004, you wrote:
> >Have a look at the DayOfYear(), it might come in handy to create a
> >DayOfDecade() or DayOfCentury() function which you could could use
> >instaeda of an arbitrary index.
> >
> >Next you could write a function DaysSince() (TJ?) That would solve all
> >problems.
> >
> >have fun,
> >herman
> >-----Original Message-----
> >From: Michael.S.G. [mailto:OzFalcon@xxxxxxxx]
> >Sent: Friday, February 20, 2004 11:05 PM
> >To: amibroker@xxxxxxxxxxxxxxx
> >Subject: RE: [amibroker] Can anyone help me Sort this out....
> >
> >Herman,
> > Yes - This is one way (Mabie the only) way of working around the
> problem.
> >Though a little messy - Im sure I could live with it.
> >We'll see if anything else comes up.
> >
> > Thanks,
> > Michael.
> >
> >
> >
> >At 01:49 PM 21/02/2004, you wrote:
> > >You could convert DateNum() to a DateIndex which will be a much smaller
> > >number. You would have to pick a first date for zero, your reference, or
> > >count backwards from today... depend on your application.
> > >
> > >The DateIndex would simply be the number of bars before a given point. For
> > >10 years you should have a maximum count of about 10*250=2500 which is
> > >much smaller than you datenum.
> > >
> > >Interesting problem,
> > >good luck,
> > >herman.
> > >-----Original Message-----
> > >From: Michael.S.G. [mailto:OzFalcon@xxxxxxxx]
> > >Sent: Friday, February 20, 2004 8:45 PM
> > >To: amibroker@xxxxxxxxxxxxxxx
> > >Subject: [amibroker] Can anyone help me Sort this out....
> > >
> > >Has anyone yet got around the DateNum() / 32 bit float limitation yet?
> > >
> > >This is a real Turd of a problem - And I'd like to know if there are any
> > >workarounds/solutions?
> > >
> > >For me - I wish to Transform DateNum() to a Ranking system I can sort
> > >under AA.
> > >
> > >But two limitations are stoping me.
> > >1) The use of Strings in AB appears to be as single variables. (Not
> Arrays).
> > >2) Transforming the value from DateNum creates a number greater than 7
> > >significant digits. Inducing the 32bit Float limitation.
> > >
> > >For those unaware of the above constrictions, Here is a sample AFL to show
> > >you.
> > >
> > >// Combined Sort for AA.
> > >//
> > >// Filter = "Curent Stock"
> > >//
> > >// Range = "All Quotes"
> > >
> > >// Create a Date/Rank to Sort with.
> > >//
> > >// Doesn't work (Strings can not be arrays?)
> > >SortStr = "" + Year() + "/" + Month() + "/" + Day() + ":" + Close;
> > >//
> > >// Doesn't work (Larger than 7 digits - 32bit Float)
> > >SortVar = (DateNum()*100) + Close;
> > >
> > >
> > >AddColumn(Close,"Close",1.2);
> > >AddTextColumn(SortStr,"SortStr",1.2);
> > >AddColumn(SortVar,"SortVar",1.2);
> > >
> > >//Filter
> > >Filter = 1;
> > >
> > >
> > >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/)>http://groups.yahoo.c
> >
> om/group/amiquote/messages/)>http://groups.yahoo.com/group/amiquote/messages/)
> > >--------------------------------------------
> > >Check group FAQ at:
> > ><<http://groups.yahoo.com/group/amibroker/files/groupfaq.html>http://grou
> >
> ps.yahoo.com/group/amibroker/files/groupfaq.html>http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
> >
> > >
> > >
> > >
> > >
> > >
> > >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/)>http://groups.yahoo.c
> >
> om/group/amiquote/messages/)>http://groups.yahoo.com/group/amiquote/messages/)
> > >--------------------------------------------
> > >Check group FAQ at:
> > ><<http://groups.yahoo.com/group/amibroker/files/groupfaq.html>http://grou
> >
> ps.yahoo.com/group/amibroker/files/groupfaq.html>http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
> >
> > >
> > >
> > >
> > >Yahoo! Groups Sponsor
> > >ADVERTISEMENT
> > ><<http://rd.yahoo.com/SIG=12c79jstj/M=274551.4550177.5761904.1261774/D=
> eg >
> roupweb/S=1705632198:HM/EXP=1077418184/A=2019528/R=2/*http://ad.doubleclick.net/jump/N3349.yahoo1/B1282054.27;abr=!ie4;abr=!ie5;sz=300x250;code=18634;dcopt=rcl;ord=1077331784041180?>http://rd.yahoo.com/SIG=12c79jstj/M=274551.4550177.5761904.1261774/D=egroupweb/S=1705632198:HM/EXP=1077418184/A=2019528/R=2/*http://ad.doubleclick.net/jump/N3349.yahoo1/B1282054.27;abr=!ie4;abr=!ie5;sz=300x250;code=18634;dcopt=rcl;ord=1077331784041180?>
> > >Click Here
> > ><<http://rd.yahoo.com/SIG=12c79jstj/M=274551.4550177.5761904.1261774/D=
> eg >
> roupweb/S=1705632198:HM/EXP=1077418184/A=2019528/R=2/*http://ad.doubleclick.net/jump/N3349.yahoo1/B1282054.27;abr=!ie4;abr=!ie5;sz=300x250;code=18634;dcopt=rcl;ord=1077331784041180?>http://rd.yahoo.com/SIG=12c79jstj/M=274551.4550177.5761904.1261774/D=egroupweb/S=1705632198:HM/EXP=1077418184/A=2019528/R=2/*http://ad.doubleclick.net/jump/N3349.yahoo1/B1282054.27;abr=!ie4;abr=!ie5;sz=300x250;code=18634;dcopt=rcl;ord=1077331784041180?>Click
>
> >
> > >Here
> > >[]
> > >
> > >
> > >
> > >----------
> > >Yahoo! Groups Links
> > > * To visit your group on the web, go to:
> > > *
> > >
> >
> <<http://groups.yahoo.com/group/amibroker/>http://groups.yahoo.com/group/amibroker/>http://groups.yahoo.com/group/amibroker/
>
> >
> > >
> > > *
> > > * To unsubscribe from this group, send an email to:
> > > *
> > >
> >
> <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
> >
> > >
> > > *
> > > * Your use of Yahoo! Groups is subject to the
> > >
> >
> <<http://docs.yahoo.com/info/terms/>http://docs.yahoo.com/info/terms/>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/)>http://groups.yahoo.co
> m/group/amiquote/messages/)
> >--------------------------------------------
> >Check group FAQ at:
> ><http://groups.yahoo.com/group/amibroker/files/groupfaq.html>http://group
> s.yahoo.com/group/amibroker/files/groupfaq.html
> >
> >
> >
> >
> >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/)>http://groups.yahoo.co
> m/group/amiquote/messages/)
> >--------------------------------------------
> >Check group FAQ at:
> ><http://groups.yahoo.com/group/amibroker/files/groupfaq.html>http://group
> s.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/>http://groups.yahoo.com/group/amibroker/
>
> >
> > *
> > * To unsubscribe from this group, send an email to:
> > *
> >
> <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
> >
> > *
> > * Your use of Yahoo! Groups is subject to the
> > <http://docs.yahoo.com/info/terms/>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
>Yahoo! Groups Links
>
>
>
>
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:
http://docs.yahoo.com/info/terms/
|