Using excel to track stock portfolio

[fm757]

Lets say I use column A to keep a daily run of my portfolio value. A1 would be Jul 1 value, A2 would be Jul 2 value and so on down the column. Now in cell D1 I want displayed the current days value(last cell value in column A). Is this possible to do with excel?

Thanks

 

[fm757]

Thanks Yogi for explaining that! The formula works great.


fm757