|
PureBytes Links
Trading Reference Links
|
Hi Peter
Sorry that I missed this email. I've got lots stacked up and unread.
XLA's for 97 and 2000 are different from the earlier Excel versions in that
you can just put in the password. (As you mentioned) However, xla's from
Excel 7 or Excel 5 need to be decompiled back to a workbook, the code is
altered and then put back into an xla.
Most of the xla's with frequently used functions that I have are from
traders and they won't allow me to release them. Basically, what you do is
move all of your frequently used subs into a workbook that has a drop down
menu for the subs on the main Excel Toolbar. etc. then put it into an xla
add-in so that they are always available. Just like the popular "power
tools" add-ins.
What are you interested in coding / developing? Do you use Access for
trading or trading analysis?
Best regards
Walter
----- Original Message -----
From: "Peter E. Gialames" <investor@xxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, September 07, 2000 4:36 PM
Subject: RE: GPF
| Walter,
|
| I don't think you need to decompile an XLA ... you can modify the code in
| the Visual Basic Editor. Unless the code is password protected and you do
| not know the password.
|
| QP2 has an XLA (QP2COM.XLA) that is easily modified in the VB Editor.
|
| I am curious as to how to set up frequently used 'tools' in an XLA so that
| they are easily accessible. I have come a long way in programming Excel,
| but I have a hard time with programming functions/indicators that can be
| used 'frequently'. Do you have an example?
|
| Thanks in advance,
| Peter Gialames
|
| -----Original Message-----
| From: owner-metastock@xxxxxxxxxxxxx
| [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Walter Lake
| Sent: Thursday, September 07, 2000 10:07 AM
| To: Metastock bulletin board
| Subject: GPF
|
|
| Thanks for your emails
|
| The traders that I know really like it for it's ease of use and accurate
| signals. Personally, I try to refrain from buying anything anymore. Too
much
| free and very inexpensive stuff is available to modify for my own
interests
| and trading setup.
|
| After the 30 days is up, the program should continue to produce signals.
| These can be saved to XL, only the production of the equity charts etc.
are
| disabled. Not a serious loss.
|
| To others that wrote:
|
| GPF is a program that uses XL, whereas a "program" such as "Position Cost
| Averaging" is a workbook in XL. Lots of work is being done with that
| workbook by other traders. The web site leaves a lot to be desired. <G>
|
| http://www.stocksystem.com/
|
| To others:
|
| Put your regularly used "tools" into an XLA and then they will always be
| available to you. If you mess up or want to change your XLA you will need
an
| decompiler to go from your XLA back to the xls.
|
| Best regards
|
| Walter
|
|
|
|