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 |
