On 3 Jun 2002, at 10:06, Mike G wrote:
> Basically, I look to see whether the currect date exists by retrieving
> the high and low for the date. If it succeeds, I calculate whether the
> new price is higher than the existing high or lower than the existing
> low. Then I update the high, low and l
I have a database containing stock data which I want to keep up to date.
The relevant fields are the symbol, date, high, low, and last prices.
When a new price comes in for an existing date, I want to update the high if the price
is higher, the low if the price is lower, and I always want to u
