STOCK function previous close price

Hi,

I am having problems with the Stock function on my iMac with the [previous close] and the [last price] being listed as identical.

I am aware that last price is the last price available to me, ie the last price of trading on the previous day.

What I need is the previous close price of the day previous to that, not yesterday's close.

I have attempted StockH but can't seem to get the date right eg today()-1, perhaps I'm completely on the wrong track.

I enter the data like this:

A2 = stock symbol eg (ABC.AX)

C2 = previous close eg =(stock(A2),previous close)

D2 = last eg =(stock(A2),last)