|
PureBytes Links
Trading Reference Links
|
Werner
Getting the date into the format you want is nigh impossible but I know you can get close enough for
it to be acceptable. There are two problems to deal with. The first of these is that there is no
effective way to eliminate the four decimal places from the report column so you will need to live
with this. The second problem is that of avoiding single digit precision errors when merging day,
month and year into one column. Even when the year is truncated down to two significant digits you
will probably need to take steps to prevent errors creeping in (wrong month or year reported).
By comparison getting a count is very easy. Once the code is set up this is a two step process using
Mark Pyle's GlobalVar.dll. a copy of this called GV.dll is available at Jose's website. See the top
of the page at
http://users.bigpond.com/prominex/pegasus.htm#roy
Once the dll is installed (in the appropriate folder) and MS has been rebooted to register its
presence then you can create the following indicator which serves to initialise/reset the count
prior to an exploration.
{Count Reset}
A:=ExtFml("GV.SetVar","Count1",0);
A; 1;
Dropping this indicator onto a chart unscaled will show two lines, zero and one, and force the
global variable called "Count1" to zero. Having the indicator display two different values ensures
that it doesn't get "lost" off the bottom of a chart window. Once it has been dropped onto a chart
it should be deleted although no immediate problem will be caused by leaving it in place. If the
indicator is "refreshed" for some reason then it will cause the count to reset so this is why it is
best deleted after use.
Place the following code in an exploration column to give an ascending count of each issue. Remember
that the count will increment in the order that issues are presented so the count that appears in
the report may differ from what you expect.
{Count Exploration}
{Column A}
LastValue(ExtFml("GV.GetVar","Count1")) + 1;
And the filter code can be used to count all issues or only those that pass the filter conditions.
It's easily possible to set this counter up so that it either counts ALL issues or only those that
meet the filter conditions. Counting all issues when using a filter can be confusing because there
will be gaps in the report column.
{Filter}
Filter:= 1;
A:=LastValue(ExtFml("GV.GetVar","Count1"));
B:=ExtFml("GV.SetVar","Count1",A + Filter);
Filter;
The last count will not necessarily be at the end of the report if issues are presented out of the
preferred order. In most cases left clicking on the count column header will sort into
ascending/descending order and the highest count number is of course the total count required.
A word of warning before you try and use this for accumulating dollars and cents {marks and
penny's?} as a result. The dll appears to operate in single precision mode so errors in accumulation
creep in. Used in this fashion though there appears to be no problem.
Hope this helps. Ask if you need further help.
Roy
----- Original Message -----
From: <WKRAG@xxxxxxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Tuesday, March 02, 2004 8:40 AM
Subject: [EquisMetaStock Group] Roy to the rescue
> Dusant,
> thank you for your reply.
> I searched the archives for "parameters", "summing" but no luck.
> Roy is all over the place with very good answers but not to this one
> (I think).
>
> Roy, if you (or maybe Jose) is reading this, can you come to the
> rescue?
>
> Thank you,
>
> Werner
> --------------------------------------------------------------
> > Werner,
> > I had posted a similar question in this group about three months
> back, and Roy (as usual) has posted a formula for it.
> > I suggest a search of the archives where the subject was something
> like summing of certain parameters.
> > It did not suit my purpose, so I did not store it.
> > Sorry.
> > A painful way would be to run an exploration for each day,
> exporting the result into a spreadsheet and creating a database.
> > Dusant
> > Chief Architect
> > www.candlestrength.com
> >
> > ----- Original Message -----
> > From: <WKRAG@xxxx>
> > To: <equismetastock@xxxxxxxxxxxxxxx>
> > Sent: Monday, March 01, 2004 19:36 PM
> > Subject: [EquisMetaStock Group] Number of Stocks count
> >
> >
> > > Good day,
> > >
> > > I was wondering if the following is possible with MS:
> > >
> > > I want to count the number of stocks depending on my own
> criteria,
> > > something like this:
> > >
> > > Number of stocks which:
> > >
> > > made a new 10 day high and
> > > closed up more than 3% and
> > > had increased volume
> > >
> > > Now, I want a list of dates (let's say for the last 2 years) and
> the
> > > corresponding NUMBER of STOCKS that qualify. The list should look
> > > like this:
> > >
> > > 01/01/2003 100
> > > 01/02/2003 110
> > >
> > > and so forth.
> > >
> > > Is this possible with MS ?
> > >
> > > Thank you,
> > >
> > > Werner
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
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/
|