# Using excel to track stock portfolio

This is a discussion on Using excel to track stock portfolio within the Excel Questions forums, part of the Question Forums category; Lets say I use column A to keep a daily run of my portfolio value. A1 would be Jul 1 ...

1. ## Using excel to track stock portfolio

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

2. Hi!
Try this.
Code:
`=INDEX(A:A,COUNTA(A:A))`

3. ## Re: Using excel to track stock portfolio

Sixth Sense,

Thank you very much for the quick response. That works very well.

4. Enjoy!

5. ## Re: Using excel to track stock portfolio

One thing I did notice with this formula is that it doesn't work if you have two cells merged. Is the formula different if you are working with merged cells?

6. ## Re: Using excel to track stock portfolio

Hi fm757:

I can use the following formula in cell D1 ...

=LOOKUP(9.99999999999999E+307,A:A)

and here is an illustration ...

******** ******************** ************************************************************************>
 Microsoft Excel - Book1 ___Running: xl97 : OS = Windows XP
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 D1 =

A
B
C
D
1
1-Jul**10-Jul
2
2-Jul***
3
3-Jul***
4
4-Jul***
5
5-Jul***
6
***
7
6-Jul***
8
7-Jul***
9
8-Jul***
10
9-Jul***
11
***
12
10-Jul***
 Sheet2 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

7. ## Re: Using excel to track stock portfolio

Yogi,

That works great. I don't understand the formula, but it works great!

Thanks

8. ## Re: Using excel to track stock portfolio

Hi fm757:

I am glad it works for you.

What the formula is doing is LOOKing up the last numeric entry in column A, using the largest number that can be entered in EXCEL.

9. ## Re: Using excel to track stock portfolio

Yogi,

What does the 9.999999999999E+304 mean in the formula?

Thanks,
fm757

10. ## Re: Using excel to track stock portfolio

Hi fm757:

9.99999999999999E+307 in Scientific notation (which stands for 9.99999999999999*10^307) is the largest number that can be entered in EXCEL.

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•