Page 1 of 2 12 LastLast
Results 1 to 10 of 11

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. #1
    Board Regular
    Join Date
    Jul 2004
    Posts
    70

    Default 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. #2
    Board Regular SIXTH SENSE's Avatar
    Join Date
    Oct 2003
    Posts
    1,884

    Default

    Hi!
    Try this.
    Code:
    =INDEX(A:A,COUNTA(A:A))
    There is always a better way!!

  3. #3
    Board Regular
    Join Date
    Jul 2004
    Posts
    70

    Default Re: Using excel to track stock portfolio

    Sixth Sense,

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

  4. #4
    Board Regular SIXTH SENSE's Avatar
    Join Date
    Oct 2003
    Posts
    1,884

    Default

    Enjoy!
    There is always a better way!!

  5. #5
    Board Regular
    Join Date
    Jul 2004
    Posts
    70

    Default 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. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default 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
    =

    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.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  7. #7
    Board Regular
    Join Date
    Jul 2004
    Posts
    70

    Default Re: Using excel to track stock portfolio

    Yogi,

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

    Thanks

  8. #8
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default 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.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  9. #9
    Board Regular
    Join Date
    Jul 2004
    Posts
    70

    Default Re: Using excel to track stock portfolio

    Yogi,

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

    Thanks,
    fm757

  10. #10
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default 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.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com