|
PureBytes Links
Trading Reference Links
|
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 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/
|