Re: Metastock and Excel: Creating Text File

["Wayne" <wayner@xxxxxxxxx>]

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.
 
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.
 
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.
 
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>