Re: how do I write this simple formula

[Philip <pschmi02@xxxxxxxxxxx>]

The closing price 4 days ago is written as:  Ref(C, -4)

So the close 4 days ago subtracted from today's close would be:

C - Ref(C, -4)


waheeb wrote:
> 
> I am writing a formula but would like to know how do I get the closing
> price 4 or 5 days a go.
> For example how do I subtracts the closing price of xyz stocks from today
> close. (close - ???)
> 
> Thanks for your help