|
PureBytes Links
Trading Reference Links
|
Wayne :
Thanks a lot !
Please look at my TL remarks.
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Wayne
To: <A title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Friday, September 20, 2002 10:49
PM
Subject: Re: Metastock and Excel:
Creating Text File
Hi Theo:
To print out data from Metastock as a text
file, rather than just creating a picture:
1) First, you will need to create a new print
driver, which can print to a file. To do
this, go to Start/Printers and Faxes/Add
a Printer (I am using XP; this may
vary) and create a new driver. When it gets to
which port (LPT1,LPT2) you are to
use, select FILE:Print to File. In the next step,
for the type of driver, select
Generic / Text Only. Finish creating the
driver.
TL : works fine now.
2) Create the chart you want to in Metastock.
Click on Print. For the printer type,
select the new one you have just created (Generic
/ Text Only). Beside Active
Chart, change "As" from Graphics to Text. At the
bottom, if you select Print
Preview, you can see what it looks like. I would
also suggest that under Properties,
you change the layout to horizontal
(Landscape).
You will see that, if you were to print it out,
two pages are created. The first has the
basic data- O,H,L,C,V,OI. The second has the date
column again, with all of your
indicators.
If you create the .txt file, it will be saved in
the Metastock folder. There is apparently
no other option here.
It will print out this way; however, if you
actually create the .txt file, the file will be
broken up into somewhat awkward columns. You may
have trouble working with this.
TL : yes.
I would again suggest that the easiest way is to
drag each indicator to Excel, and
delete the extra date columns. <FONT
face=Arial size=2>If you have trouble doing this, you can, as Antonio
Carcelen suggested, just <FONT face=Arial
size=2>highlight the indicator, right-mouse click it, select Copy,
go to Excel, and select Paste. <FONT
face=Arial size=2>This will do the same thing.
TL : the best way !
Thanks again.
Good weekend from Belgium
Theo Lockefeer
Regards,
Wayne
Victoria, BC, Canada
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Theo
Lockefeer
To: <A title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Friday, September 20, 2002 2:39
AM
Subject: Re: Metastock and Excel
Wayne :
i forgot how to print to a file : could you (or
someone else)
point me again to the right solution
?
Thanks
Theo
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Wayne
To: <A title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Friday, September 20, 2002
10:03 AM
Subject: Re: Metastock and
Excel
Hi Theo:
I originally asked for help on getting data
into Excel,
a little while ago.
1)It appears that you can also drag each
indicator into Excel.
It will, however, copy the date with
each, so you may have
to delete several date columns.
2)An alternative to this is, as someone
pointed out to me,
you can print out the text data to a file.
You will see in
the print preview that all the indicators are
included. However,
it breaks them up somewhat in the text file,
and it is more
awkward.
I think it is easiest to make a split window,
drag each
indicator to Excel, and delete the extra date
columns.
Regards,
Wayne
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Theo
Lockefeer
To: <A
title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Thursday, September 19, 2002
11:57 PM
Subject: Metastock and Excel
Hello friends,
of course it is possible to copy & past
the O,H,L,C to Excel
but how do i copy and paste "all the
indicator data" in an Easy way
to Excel ?
Any help appriciated.
i hope everone is doing well in this market
(my system performs
ok : up 6,62% in less then 4 days)
there is only one flawn :
me :)
Good weekend,
Theo
<FONT face=Arial
size=2>
|