|
PureBytes Links
Trading Reference Links
|
Bob,
Maybe you can answer an array-related question.
I have a stock price program I use that uses a DDE link to feed
data to excel.
I can set up the DDE link 2 ways:
1. Just put a DDE link in each of 4 cells: one for the Bid, one for
the Ask, one for the Last, and one for the volume.
2. Have a single DDE link that returns Bid, Ask, Last, and Volume,
but instead of having it go to one cell, use the array functionality to
enter the DDE link while having 4 cells selected.
Which is the more efficient way of doing it from the standpoint of
processor use?
Thanks,
Cash
Date sent: Mon, 15 Jul 2002 07:50:03 -0400
From: "Umlas, Robert" <rumlas@xxxxxxxx>
Subject: Re: Array or not to array
> http://www.emailoffice.com/excel/arrays-bobumlas.html
> explains it all ---
> I totally disagree on "array formulas s/be condemned" -- I would only
> suggest you don't fill your spreadsheets with them -- they often calculate
> slower than other formulas, and if another can be used, do so. But certainly
> don't avoid them -- you can do things with them that can't be done
> otherwise!
>
> Bob Umlas
> KPMG Tax Technology
> Excel MVP
> --------------------------------
>
> -----Original Message-----
> From: Chris Campbell [mailto:jabberwocky521@xxxxxxxxx]
> Sent: Sunday, July 14, 2002 2:50 PM
> To: EXCEL-L@xxxxxxxxxxxxxxxxxxxx
> Subject: Array or not to array
>
> Hi Bob,
>
> I understand from the email I have seen that you are
> the array guru.
>
> I have seen formulas written something like
>
> =Function(A1:A10,B2:B4) called arrays when the values
> in B2:B4 were 5,1,2. While at the same time a formula
> written =Function(A1:A10,{5,1,2}) was argued not to be
> an array. I'm not clear on the distinction?
>
> I also discovered another approach used by list
> members:
>
> =Sumproduct(Function(A1:A10,B2:B4)) which was listed
> as not being an array function. How does this stuff
> all work? Is there a good source to explain these
> ideas.
>
> One final question why do you use arrays when they are
> so strongly condemed?
>
> Thanks for your input,
> Chris
> :)(:
|