Historical data

Make sure you have version 0.74.1 or later

EOD data:

HD(<symbol>, <field>, <date>, <feed>)

1 Minute:

HM(<symbol>, <field>, <date/time>, <feed>) 

any period multiple of minute:

H(<symbol>, <field>, <date/time>, <period>, <feed>) 

If there are many historical quotes per symbol then it is better to use a series definition formula(SDF) which groups common parameters. The formula 'S' is then used request each quote.

=SDF(<symbol>, <period, <days to retrieve>, <feed>)
=S(<reference to a SDF formula>, <time>, <field>)
or
=S(<reference to a SDF formula>, <offset in period units 0, -1, -2 ...>, <field>)
parameter description
symbol symbol
field the field to get it may be one of these: VOLUME, OPEN, HIGH, LOW, CLOSE, TOTAL
time time specification (Excel time)
offset offset backwards in period units 0, -1, -2 …
period in minutes
feed the feed to use

Excel with quote list