|
PureBytes Links
Trading Reference Links
|
Hi Walter.
It sounds like it is a book worth buying. But not for the moment for me.
Best regards.
Lars
Walter Lake skrev:
> Hi Lars
>
> This book is a more intermediate book, in the line of Walkenbach but more
> smoothly written. No sudden leaps in coding to make you scratch your head.
>
> Whereas the "Excel 97 Developer's Handbook" published by Microsoft is a
> "cowboy" book ... a real "no-holds barred" ... lets party with Excel type
> book. It assumes that you know what you are doing at all levels. It's much
> more advanced.
>
> Will read the chapters again and then post the "cells" and "range" methods
> for VBA coding of formulas, in addition to the "name" method.
>
> Best regards
>
> Walter
>
> ----- Original Message -----
> From: Lars Andersson <Lars.Andersson@xxxxxxxxxxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxx>
> Sent: Monday, November 15, 1999 4:54 AM
> Subject: Re: formulas
>
> | Hi Walter.
> | I know what you mean. I have not learn this yet and I donīt think I ever
> do that. The book you mention seems to be very good
> | so perhaps I buy it.
> | Thatīs not fun when you get 65 000 + rows filled just wonder how to do
> this.
> | Best regards.
> | Lars
> |
> | Walter Lake skrev:
> |
> | > Hi Lars
> | >
> | > Glad that you liked the coding.
> | >
> | > One of the problems I've been working with is learning different ways to
> | > code Excel "in-cell" formulas into VBA code. For example one of Ton's
> | > Profit/Loss Index formulas:
> | >
> | > "... -Where the Formula for the "Units" (col I) cell on Row 3 is:
> | > =ABS(IF(A3>C3;((A3)/C3)+1;IF(A3<C3;((-C3)/A3)-1;0))) ..."
> | >
> | > Using the Macro Recorder and changing the ";" to "," you get this:
> | > ActiveCell.FormulaR1C1 =
> | >
> "=ABS(IF(RC[-7]>RC[-5]((RC[-7])/RC[-5])+1,IF(RC[-7]<RC[-5]((-RC[-5])/RC[-7])
> | > -1,0)))"
> | >
> | > Not many of the reference books i.e., Walkenbach, WROX, Steve Roman, 21
> | > Days, etc. have much on writing formulas in VBA code. A new book "Excel
> 2000
> | > Developer's Handbook" by Marion Cottingham at
> | >
> | > www.sybex.com
> | > http://www.sybex.com/cgi-bin/rd_bookpg.pl?2328back.html
> | >
> | > Has the following chapters which are quite complete:
> | >
> | > "Part II: Naming Formulas, Functions, and Constants
> | > Chapter 4: All About Formulas and Functions
> | > Chapter 5: But Names Will Never Hurt Me!
> | > Chapter 6: Using Constants
> | > etc ..."
> | >
> | > In Chapter 5, the author writes extensively about "naming" the formula
> when
> | > you enter it into Excel and then using the name in your VBA code. Lots
> of
> | > good ideas especially for Metastocker's who have indicator code etc. to
> | > write into Excel. It also makes documenting much easier.
> | >
> | > Of course, it's the "filling down" part that always messes me up and I
> end
> | > up with 65,000 + rows filled <G>.
> | >
> | > Best regards
> | >
> | > Walter
> |
|