RetiredGypsy
Full time employment: Posting here.
- Joined
- Mar 17, 2008
- Messages
- 979
I've been using Excel spreadsheets ever since I got a job to track expenses. It's been absolutely wonderful. In creating series of linked equations through different spreadsheets, I thought I'd learned a lot. So now that I'm trying to make real-time charts, I realize how little I've actually learned.
My goal is to track how much I've personally invested each day against how much my investments are worth each day, and the percentage of that difference. For example, if I've invested $50k in an S&P 500 index in total up to today, but the actual value of the stock and reinvested dividends has given me a total of $80k in that index, a 60% increase.
I really don't know enough to know what questions I should be asking, so I figured I'd turn to the wizened financial trackers here who know the ins and outs of Excel and see if what I'd like to do is even possible.
Can you have real-time charts in Excel? Where if you enter a number into a cell, it automatically updates a graph for you? Can it also calculate the percentage of difference? If you can, where can you find a reference or tutorial on how? My Google Fu is weak, and I haven't had any luck in finding the answer so far.
I don't know if it makes a difference, but I have the 2007 version.
My goal is to track how much I've personally invested each day against how much my investments are worth each day, and the percentage of that difference. For example, if I've invested $50k in an S&P 500 index in total up to today, but the actual value of the stock and reinvested dividends has given me a total of $80k in that index, a 60% increase.
I really don't know enough to know what questions I should be asking, so I figured I'd turn to the wizened financial trackers here who know the ins and outs of Excel and see if what I'd like to do is even possible.
Can you have real-time charts in Excel? Where if you enter a number into a cell, it automatically updates a graph for you? Can it also calculate the percentage of difference? If you can, where can you find a reference or tutorial on how? My Google Fu is weak, and I haven't had any luck in finding the answer so far.
I don't know if it makes a difference, but I have the 2007 version.