Thread: Array Formula functionality

I am trying to do the following procedures:

Array Formula setting.... for historical stock data download from a database.
The formula syntax is, (as per the database provider)

=sddeLink|Bars!'SYMBOL,PERIOD,#BARS,[DTOHLCV],{HEADERS},{HH:MM-HH:MM},{FILL}'

Example: =sddeLink|Bars!'IBM,15,1000,DTOHLCV,HEADERS,09:30-16:00'

SYMBOL – Represents the name of the symbol you wish to see.
PERIOD – Use Q for Quarterly, M for Monthly, W for Weekly, D for Daily or for an
intraday period just specify the number of minutes.
#BARS – Represents the number of bars to display.
DTOHLCV – Defines which data fields to display and in which order. See below for
a list.
D = Date T = Time O = Open H = High L = Low C = Close V = Volume
HEADERS – Use this option to display the names of the fields in columns above
the data.
HH:MM-HH:MM – Use this option to return only the bars within the specified time
range. Applies to intraday intervals only.
FILL – Use this option to fill blank bars with the last known Close value
sddelink - I think, is the dde link/application
BARS - I think, would be the database filename

I have copied the formula (after selecting the array cell area) into multiple sheets by grouping the sheets (a separate sheet for each stock/symbol).

The SYMBOL field, of the formula, is the only field that changes on each sheet.

Instead of me typing in the different/new symbol manually (into the array
syntax) on each sheet, is it possible to reference 'SYMBOL' to a cell value (eg. $A$1). I tried using the $A$1 format but it does not work ... I guess something to do with the apostrophe before the symbol text.

I would then like to group the sheets, and hit C+S+Enter once (versus a couple of 100 times), to download the data for the respective stock to it's resprective sheet.

Thanks in advance