In the Stocks menu, there is an option something like `Save
analysis
results in results.txt'. If you run this, output is sent to C:\M-
C\results.txt, which is a CSV file that can be loaded directly into
Excel for further analysis.
Re your second question, the simple answer (as far as I am aware) is
no, although you could run a BT on a stock, or better sill, run
Portfolios/Analyze 40 stocks, on a daily basis, to generate an HTML
file (C:\M-C\back-testing.html or C:\M-C\TAsummary.html
respectively), both of which can be loaded directly into Excel.
Alternatively, load results.txt into Excel, where the Buy/Sell
signals are shown in the second column. You could then either (1)
copy the relevant results into a master XLS of your own or (2)
develop a VB macro in Excel to automate the same thing, either of
which would show the patterns across time. In this way, you would
gradually build up a day-by-day Buy/Sell signal list.
In this context, the portfolio approach allows analysis of up to 40
stocks (in BC v 4.33.3) simultaneously.
If you want to do the same across historical data, you would need to
run separate TA's across a historical quote file, which you had
edited accordingly, by repeatedly removing one day's data at a
time
from the file, to reflect the same day-to-day activity. A very
tedious job.
As I said � the simple answer (as far as I am aware) is no.
David
--- In [EMAIL PROTECTED], "fernand251" <[EMAIL PROTECTED]>
wrote:
>
>
> I enjoy your program and i am wondering if it can provide also
daily
> numbers rather then charts so i can copy them into Excel. For
> example, retrieving the MFI for Microsoft on August 15,2004 so i
can
> understand why it went wrong on Back-testing for a certain period
> (because volume was too high/low, prices where high/low, because i
> was off by 0.05%, etc)
>
> Is there also a way to know if for a given stock, for a certain
> period the signal it had produce;
>
> August 15; sell;2 buy;3
> August 16; sell;1 buy;4
> august 17; sell;1 buy;5
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/bestcharts/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
