[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Metastockusers] Re: System Tester Results (Redu) Idea for Scott



PureBytes Links

Trading Reference Links


I'll give this one more try Scott.

Open the system tester.

Open the test sumary you want to look at and then open the test page
where the results for the individual stocks are shown.

Click on the symbol column and make sure they're sorted alphabetically
or if you only want the positive ones click on the %gain column and
sort that way.

Left Click on the first one. It will turn blue.

Hold down the shift key, scroll down to the last one you want to copy
and left click on it. Now you have the list blue

Right click on the blue somewhere. Then when the popup menu comes up,
select copy to clipboard.

Open Excel, select the upper most left cell, open the edit menu and
select paste.

Eliminate the columns you don't want. Keep the sympbol column and the
%gain column for my experiment. 

To put the symbols in MS copy the symbol column by highlighting the
symbols only.

Open Word. Use the edit tab, select paste special, select unformatted
text, and paste the symbols in. You should have one long column and
that's all.

Use the replace function to replace all of the paragraph marks with
semicolon's.

Separate the big group of stocks into smaller sub groups.

Open the file tab in MS, select new, create your group for the
downloader and paste symbols into the new group. 

For my experiment, run the systems test each year separately for ten
years.

Take each test, sort by symbol, paste the results into a worksheet. 

Take each work sheet and copy the symbol and it's %gain data into a
new single worksheet.  

Now you can compare each symbol year by year to see how many times out
of ten years that symbol showed a profit. You can eliminate all of the
symbols that had the majority of the ten year period negative and keep
the positive ones.

Then you simply run your system everyday and make millions. 

All of these steps work. If you can't make them work on your machine
call tech support. It's free. 










--- In Metastockusers@xxxxxxxxxxxxxxx, "Scooter" <mariani@xxxx> wrote:
> If only it was that easy. I can not get the data out of MS, short of
> manually transferring every symbol. I select the results but the
only right
> mouse click option is "discard". I have tried all the Windows tricks
I know,
> no luck.
> Scott
>   -----Original Message-----
>   From: Metastockusers@xxxxxxxxxxxxxxx
> [mailto:Metastockusers@xxxxxxxxxxxxxxx]On Behalf Of John
>   Sent: Thursday, April 14, 2005 6:19 PM
>   To: Metastockusers@xxxxxxxxxxxxxxx
>   Subject: [Metastockusers] Re: System Tester Results (Redu) Idea
for Scott
> 
> 
> 
>   I'm sorry Scott, I meant to say copy results from the system tester,
>   not the explorer. You open your test results page and follow the steps
>   I've explained. Highlight the results you want to transfer to excel,
>   copy to the clipboard, etc.
> 
> 
> 
> 
> 
>   --- In Metastockusers@xxxxxxxxxxxxxxx, "Scooter" <mariani@xxxx> wrote:
>   > Super,
>   > Thanks for taking some time to help me!
>   >
>   > I know how to get the results from the Explorer, I do not know how
>   to get
>   > the results from the System Tester.
>   > I am excited to try what you suggest but need a little more help to
>   start.
>   >
>   > Scott
>   >   -----Original Message-----
>   >   From: superfragalist [mailto:jackolso@x...]
>   >   Sent: Thursday, April 14, 2005 11:05 AM
>   >   To: Metastockusers@xxxxxxxxxxxxxxx
>   >   Subject: [Metastockusers] System Tester Results (Redu) Idea
for Scott
>   >
>   >
>   >
>   >   Scott,
>   >
>   >   Here's an idea that you can use to test your theory. I
explained how
>   >   to copy results from an exploration into excel and then from excel
>   >   back into various MS lists.
>   >
>   >   Run your systems test year by year on your expert.
>   >
>   >   Sort the test alphabetically, and then copy the entire test
for each
>   >   year into a new excel worksheet for that year.
>   >
>   >   From each worksheet copy the symbol and it's annual percentage
return
>   >   into a new worksheet. Once you have delete symbols that don't
match
>   >   across all ten columns, you can delete all of the symbols
except the
>   >   first year's. You'll be left with a year by year comparison of the
>   >   return on each symbol with your expert.
>   >
>   >   You can then see which symbols were consistently profitable
and which
>   >   one weren't. This will answer your question.
>   >
>   >
>   >
>   >
>   >
>   >   --- In Metastockusers@xxxxxxxxxxxxxxx, "Scooter"
<mariani@xxxx> wrote:
>   >   > Super,
>   >   > I did read Mr. Wright's series of articles as you suggested
>   >   previously. I
>   >   > found it very informative. I found that I was already doing many
>   of the
>   >   > things he suggested in developing a system. I have applied
many of
>   >   the ideas
>   >   > he talked about since reading the articles, more like a book!
>   >   >
>   >   > He does not address the validity of throwing out losers,
based on a
>   >   system
>   >   > test, from an available list of potential stocks to trade.
>   >   >
>   >   > I know there are a cagillion system developing books to
read. I will
>   >   pick up
>   >   > a few to read when I have the time.
>   >   >
>   >   > Can you C&P system test results from MS8.0?
>   >   >
>   >   > Scott
>   >   >
>   >   >
>   >   >  -----Original Message-----
>   >   > From: superfragalist [mailto:jackolso@x...]
>   >   > Sent: Wednesday, April 13, 2005 8:34 PM
>   >   > To: Metastockusers@xxxxxxxxxxxxxxx
>   >   > Subject: [Metastockusers] Re: System Tester Results (Redu)
>   >   >
>   >   >
>   >   >
>   >   >   Looks like you're using the systems tester without much
>   knowledge of
>   >   >   systems development.
>   >   >
>   >   >   Read a few books on system design and then you'll see you're
>   wasting
>   >   >   your time.
>   >   >
>   >   >   There's a very good article on this coming up in the May
issue of
>   >   >   Roy's newsletter.
>   >   >
>   >   >   Don't ask for book recommendations because one book won't
do it.
>   >   >   You'll need to read around a dozen or so systems development
>   books to
>   >   >   get a really good take on how things work. Once you've
done that,
>   >   >   you'll soon figure out that using TA by itself is not the best
>   method
>   >   >   for picking stocks to trade, the performance of any system
>   based on TA
>   >   >   is going to dramatically change each year with a lot of losing
>   years,
>   >   >   there are no indicators that work even reasonably well
across a
>   >   >   variety of stocks or in changing market conditions, and
searching
>   >   >   thousands of stocks every night for something to trade is in
>   the long
>   >   >   run a losing idea.
>   >   >
>   >   >   Does that mean you can't make money using TA. You can, but you
>   have to
>   >   >   have a well thought out strategy and apply the strategy
>   appropriately
>   >   >   for the market conditions.
>   >   >
>   >   >   I'm amazed at how many people that refuse to spend a dime on
>   >   >   education, information, good data or anything else that
might help
>   >   >   them, but they'll pay a guru thousands for useless trading
>   methods or
>   >   >   lose thousands more making bad trades. It's baffaling.
>   >   >
>   >   >   You can read Charlie Wright's series of articles called
>   Trading as a
>   >   >   Business. That will give you some basics about how to approach
>   this.
>   >   >   Read all the articles in the series. They all have something
>   important
>   >   >   to say.
>   >   >
>   >   >   http://www.elitetrader.com/tr/index.cfm?s=17
>   >   >
>   >   >   Give Roy's newsletter a try. It's all about MS with the
code for
>   >   >   everything discussed in it. You'll learn more from that in a
>   few hours
>   >   >   of reading the back issues than you will from playing with the
>   systems
>   >   >   tester for next few years.
>   >   >
>   >   >   www.metastocktips.co.nz
>   >   >
>   >   >
>   >   >
>   >   >
>   >   >
>   >   >
>   >   >
>   >   >   --- In Metastockusers@xxxxxxxxxxxxxxx, "Scooter"
>   <mariani@xxxx> wrote:
>   >   >   > O.k.,
>   >   >   > I have finally cooked the indicators enough (nothing new) to
>   come up
>   >   >   with a
>   >   >   > system that is profitable over several different period back
>   tests,
>   >   >   at least
>   >   >   > in MS. My question is, do I remove the loosing or zero trade
>   tickers
>   >   >   from my
>   >   >   > potential list of tradable tickers I will run my Exploration
>   on when
>   >   >   looking
>   >   >   > for a new trading opportunity? MS seems to be keen on
"cleaning
>   >   up" by
>   >   >   > removing the losers. Doesn't make sense to me to say
because the
>   >   >   tickers did
>   >   >   > not hit or make a profit over x amount of periods they
will not
>   >   make a
>   >   >   > profit in the future. Or does it increase my potential
>   >   profitability by
>   >   >   > removing them? Can I somehow export the remaining ticker
>   symbols to
>   >   >   excel or
>   >   >   > csv so I can adjust my HSQuote list accordingly?
>   >   >   > Thanks, Scott
>   >   >
>   >   >
>   >   >
>   >   >
>   >   >
>   >   >
>   >
>  
--------------------------------------------------------------------------
>   > --
>   >   > --
>   >   >   Yahoo! Groups Links
>   >   >
>   >   >     a.. To visit your group on the web, go to:
>   >   >     http://groups.yahoo.com/group/Metastockusers/
>   >   >
>   >   >     b.. To unsubscribe from this group, send an email to:
>   >   >     Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
>   >   >
>   >   >     c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of
>   >   Service.
>   >
>   >
>   >
>   >
>   >
>   >
>  
--------------------------------------------------------------------------
> --
>   > --
>   >   Yahoo! Groups Links
>   >
>   >     a.. To visit your group on the web, go to:
>   >     http://groups.yahoo.com/group/Metastockusers/
>   >
>   >     b.. To unsubscribe from this group, send an email to:
>   >     Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
>   >
>   >     c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>   Service.
> 
> 
> 
> 
> 
>
----------------------------------------------------------------------------
> --
>   Yahoo! Groups Links
> 
>     a.. To visit your group on the web, go to:
>     http://groups.yahoo.com/group/Metastockusers/
> 
>     b.. To unsubscribe from this group, send an email to:
>     Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
> 
>     c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.





------------------------ Yahoo! Groups Sponsor --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/zMEolB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Metastockusers/

<*> To unsubscribe from this group, send an email to:
    Metastockusers-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/