Realistically, how many ETFs can Fire track at the same time? How long to
compile say 10 years of advancing / declining issues and advancing /
declining volume data on the S&P 500 index? Where do you get the
constituent lists for the ETFs and indexes used in the compilations? To
track more than a few indexes and ETFs you can be talking about thousands of
constituents. How does it manage that and still provide usably fast
results?
Thank you.
Best,
L. P. Carhartt
________________________________
From: equismetastock@xxxxxxxxxxxxxxx
[mailto:equismetastock@xxxxxxxxxxxxxxx]
On Behalf Of superfragalist
Sent: Friday, August 01, 2008 10:17 PM
To: equismetastock@xxxxxxxxxxxxxxx
Subject: [EquisMetaStock Group] To count total number of securities which
are above 1
Fire is a good program. The breadth indicators can be coded also to
provide many statistical comparisons besides the ones that are hard
coded into the program.
One of Fire's strongest features is the calculation of the external
relative strength. The external relative strength is one of the best
performing ranking filters and high probability trade filters I've
tested.
Well worth the money.
But it's a tool. It doesn't pick winning trades automatically, but it
can improve whatever your constraints are for picking winning trades.
Super
--- In equismetastock@xxxxxxxxxxxxxxx
<mailto:equismetastock%40yahoogroups.com> , mike milliken <mmilliken22@xxx>
wrote:
>
> I would suggest to buy the FIRE Plug IN ...its worth it you want to
use it to follow the breadth ...it won't give you the names but the
gross number of S&P securities over their 20,50,&200 day moving
average help point to the health of the market...i would ignore plug
ins that pick turning point in the market - Mike
>
> --- On Fri, 8/1/08, Pierre Tremblay <pt2000@xxx> wrote:
>
> From: Pierre Tremblay <pt2000@xxx>
> Subject: Re: [EquisMetaStock Group] To count total number of
securities which are above 10 days moving average
> To: equismetastock@xxxxxxxxxxxxxxx
<mailto:equismetastock%40yahoogroups.com>
> Date: Friday, August 1, 2008, 4:49 PM
>
>
>
>
>
>
>
>
> Suresh,
>
> You can use the Explorer to do that.
>
> In col A :
>
> C <= MOV(C,10,E)
>
> And in the filter :
>
> col A
>
>
> When you run the Exploration, you have to watch the "Percent
Rejected". The last number you will see is the percentage of
securities wich are above 10 days exponential moving average.
>
> Pierre Tremblay
>
>
>
>
> ----- Original Message -----
> From: Suresh Thanki
> To: equismetastock@ yahoogroups. com
> Sent: Friday, August 01, 2008 10:00 AM
> Subject: [EquisMetaStock Group] To count total number of securities
which are above 10 days moving average
>
>
>
> Dear All,
>
> How to write the formula in MS to count the total number (and/or
> percentage) of securities which are above 10 days moving average
> within the group of securities like S & P 500 or any other Index
> group ?
>
> I have a database of securities traded on particular day.
>
> In simple arithmetic form, I want to know,
>
> % = Number of scrip above 10 days moving average *100 /
> Total number of scrip traded on that day
>
> Suresh Thanki
>