|
PureBytes Links
Trading Reference Links
|
Werner
I've had a look at your original post and I don't think what you want in terms of dates can be done
in a single pass exploration with MS. As far as I can see different dates would need to be handled
in different columns.
The best I can suggest is that you think about setting up a count for days of the week (columns A-E)
and run the exploration 100+ times by advancing the exploration date week after each run. When there
are multiple events for any issue it's impossible to record the date for each event - you can record
the first event or the last event date with a single exploration, but no more than that. You do not
need the GV.dll to count events within a single issue over a specific period of time. This can be
done easily enough using Cum("event") once you have coded "event".
Where the GV.dll comes in handy is that it enables you to count across multiple issues. You can do a
similar thing using Cum() by transferring the exploration report to Excel and summing the columns
there. The GV approach means you don't have to go to Excel, that's all.
Roy
----- Original Message -----
From: <WKRAG@xxxxxxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Tuesday, March 02, 2004 10:38 AM
Subject: Re: [EquisMetaStock Group] Roy to the rescue
> What a great response!
> Thanks a lot Roy.
> This is more than I expected.
>
> I have been a MS user for only about 6 months now and am still
> learning. What you have suggested needs a little bit of "digestion"
> on my side. But I will go to work and try to set this up.
>
> Thanks also for the caveats concerning possible results. I will be
> cautious. Well, yes, I would be trading in Euros, not Dollars as the
> Mark is gone as we do have a single European currency now in most
> European countries.
>
> Final question: What is the MS directory the DLL you mentioned, needs
> to be copied into?
>
> Thanks a lot,
>
> Werner
>
>
>
> --- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxxx>
> wrote:
> > 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@xxxx>
> > 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
>
>
>
>
>
>
------------------------ 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/BefplB/TM
---------------------------------------------------------------------~->
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/
|