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

Re: Metastock and Excel: Creating Text File



PureBytes Links

Trading Reference Links

Triple witching is the option expiration that occurs on the third Friday
of every
third month. Options expire on stocks, futures, etc. (March, June,
Sept. December)

Claud

Kush wrote:
 
Hi,  Would
someone tell me what is meant by"Triple witching Friday"?  Kush
<BLOCKQUOTE dir=ltr 
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
 

 

----- Original Message -----

<DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Wayne

To: metastock@xxxxxxxxxxxxx

Sent: Saturday, September 21, 2002
2:19 AM

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 dothis, go to Start/Printers
and Faxes/Add a Printer (I am using XP; this mayvary)
and create a new driver. When it gets to which port (LPT1,LPT2) you are
touse, select FILE:Print
to File. In the next step, for the type of driver, selectGeneric
/ 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 ActiveChart,
change "As" from Graphics to Text. At the bottom, if you select PrintPreview,
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 thebasic data-
O,H,L,C,V,OI. The second has the date column again, with all of yourindicators. If
you create the .txt file, it will be saved in the Metastock folder. There
is apparentlyno other option
here. It will print
out this way; however, if you actually create the .txt file, the file will
bebroken 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,
anddelete the extra date
columns. If you have trouble doing this, you can, as AntonioCarcelen
suggested, just highlight the indicator, right-mouse click it, select Copy,go
to Excel, and select Paste. This will do the same thing. Regards, WayneVictoria,
BC, Canada  
<BLOCKQUOTE dir=ltr 
  style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
----- Original Message -----

<DIV 
    style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Theo Lockefeer

To: 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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
----- Original Message -----

<DIV 
      style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Wayne

To: 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 haveto
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 inthe
print preview that all the indicators are included. However,it
breaks them up somewhat in the text file, and it is moreawkward. I
think it is easiest to make a split window, drag eachindicator
to Excel, and delete the extra date columns. Regards, Wayne
<BLOCKQUOTE dir=ltr 
      style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
----- Original Message -----

<DIV 
        style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Theo Lockefeer

To: 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 Excelbut
how do i copy and paste "all the indicator data" in an Easy wayto
Excel ? Any help appriciated. i
hope everone is doing well in this market (my system performsok
: up 6,62% in less then 4 days) there is only one flawn :me
:) Good weekend, Theo