|
PureBytes Links
Trading Reference Links
|
Hello again Spyros !
First of all : thanks for your time and appriciated help.
2) something else then Excel Macro's :
i noticed that the Zig zag sometimes gives a "reversal signal"
on one day and undo's it the next day : does this sounds familiar to you
?
( i am using the Zig zag with a 3 days moving Average of the zig zag
and when the Zig zag goes below the 3 day moving average it gives a
sell
mostly confirmed the next day by a SR ZZ validity signal)
sometimes also the SR ZZ gives a buy (or sell) and the next day it is
undone ??)
Then the Excel part :
Please look at my TL remarks :
----- Original Message -----
From: "SR" <raftsp@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxxxxxxx>
Sent: Wednesday, September 25, 2002 9:39 PM
Subject: RE:Re: Auto-deleting Date columns in Excel
> Theo:
>
> I have a greek version of Excel 2000, so I am not sure about the
translation
> of the menu items. Let's try anyway!
>
> 1. To make a macro in Excel:
> Select "Tools" - and the second item beneath "Macros".
> Now click on the first tab (probabbly named "Toolbars") and then click on
> the first button named "Create" or "New" or something like that.
> Name the toolbar "My Toolbar" or whatever.
> Now click on the second tab, scroll down to "Macros" and select it.
> Drag the smiling face icon on your newly created toolbar to make a new
> button.
> Now right-click on the face on your toolbar. A drop-down menu appears.
Name
> this button "DeleteDateCol" or whatever.
TL : until here : i get it :)
> Now click on the last item of the same drop-down menu, locate and select
the
> sub named "ThisWorkbook.DeleteDateColumns"
TL : this i cannot get to work , the last item of this drop-down menu is
(translated)
"to point Macro at"
i cannot select the
sub named "ThisWorkbook.DeleteDateColumns"
because it isnot there ?
> Close the windows you don't need. Leave your toolbar there or drag it
where
> you want.
> Now try it: Drag some indicators from MS, click your button and watch the
> date columns being deleted!
TL : i suppose that i had to bring the macro in
"ThisWorkbook.DeleteDateColumns"
(which i donot have (anymore)
The things below i have to check still
Spyros : thanks a lot !
Greetings from Belgium
Theo Lockefeer
>
>
> 2. Search for a free utility called "MacroMaker". If you want a really
> powerful macro utility, go to CE software
> and buy "Quickeys". It worths every penny!
>
> 3. Option Compare method should be put in the General Declarations section
> of Visual Basic. That's how VB or VBA
> knows what method it should use to compare strings ..
>
> I hope this helps. If your Excel menus are different than mine then you
must
> find a way to tell me how they look like.
> I used the English version in the past, but this one is unfortunately in
> Greek, so if I tell you the Greek names they will "sound Greek to you" :-)
>
> Spyros
>
>
>
>
> Date: Mon, 23 Sep 2002 16:52:50 +0200
> From: "Theo Lockefeer" <sky40912@xxxxxxxxx>
> Subject: Re: Auto-deleting Date columns in Excel (read this instead!)
>
> Spyros :
>
> Thanks !
>
> Please look at my TL remarks.
>
>
>
>
> - ----- Original Message -----
> From: "SR" <raftsp@xxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxxxxxxx>
> Sent: Monday, September 23, 2002 12:53 PM
> Subject: Auto-deleting Date columns in Excel (read this instead!)
>
>
> >
> >
> > Here is a sub-routine in VBA that deletes the columns with a "Date"
> header.
> > Just paste it in the VBA workbook code and click RUN.
>
>
>
> > If you like you can create a macro that will call it from inside the
Excel
> > workbook, so you will not
> > have to switch every time to VBA to run it.
>
> TL : how ?
>
> > It's also a good idea to use a macro utility to make copy-pasting
multiple
> > indicators between MS and Excel
> > a single click's task.
>
> TL : that would be ideal ! Do You have that macro ?
>
>
> >
> > Make sure that the first line "Option Compare Text" appears before any
> other
> > procedures.
>
> TL : Can you explain : Why ?
>
>
> Thanks again !
>
> Theo
>
>
> TL : i was up +6,62 % last week but whip-sawing put me back on earth
> money management saved my ass again !
> ( Zig zagging as we say :) ) )
>
>
>
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/2002
|