Results 1 to 3 of 3

Thread: Ask Tom: TSP Returns Calculator

  1. #1

    Join Date
    Jul 2007
    Location
    Europe
    Posts
    7,844
    Blog Entries
    279

    Default Ask Tom: TSP Returns Calculator

    Tom

    I still use the TSP Returns Calculator, it's the best thing since sliced bread, I actually input share prices every day, what I don't understand is how the share prices automatically populate to the rows below which have not yet been used?

    Attachment 29851


  2.  
  3. #2

    Default Re: Ask Tom: TSP Returns Calculator

    You just set it to = the value of the cell above.

    In the example above, row #153 G fund price = the value in row #152 above it. Then the next row does the same thing. Row #154 = the value in row 143.
    Assuming 152 is in Column A, the date is column B, and the G fund price is column C:

    The formula in C153 is "=c152"
    The formula in C154 is "=c153"
    etc.

    I hope that makes sense.

    The way it is set up, you only have to create a new row when you change allocation, entering the day's share price in the current line until you make an IFT. But the way you do it works too. Just a lot more rows.
    Tom
    Market Commentary | My Blog | TSP Talk Plus | |

    I am not a Registered Investment Advisor. Do your own due diligence.

  4.  
  5. #3

    Join Date
    Jul 2007
    Location
    Europe
    Posts
    7,844
    Blog Entries
    279

    Default Re: Ask Tom: TSP Returns Calculator

    Quote Originally Posted by tsptalk View Post
    You just set it to = the value of the cell above.

    In the example above, row #153 G fund price = the value in row #152 above it. Then the next row does the same thing. Row #154 = the value in row 143.
    Assuming 152 is in Column A, the date is column B, and the G fund price is column C:

    The formula in C153 is "=c152"
    The formula in C154 is "=c153"
    etc.

    I hope that makes sense.

    The way it is set up, you only have to create a new row when you change allocation, entering the day's share price in the current line until you make an IFT. But the way you do it works too. Just a lot more rows.
    Thanks Tom, it was more simple than I thought it would be, I must have been overthinking it

  6.  

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
SPY (C Fund) (delayed)
Ask Tom: TSP Returns Calculator
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Ask Tom: TSP Returns Calculator
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Ask Tom: TSP Returns Calculator
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Ask Tom: TSP Returns Calculator
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes