I can't find a way to do this for the other TSP funds, but given that the TSP doesn't pay dividends (it plows the dividends from the stocks back into the fund), the "yield" for other TSP funds isn't really relevant.Īpplying this Technique to other Closed Funds Therefore you must ensure that you use a valid date.Ĭode: Select all =index(ImportHtml("", "table", 0), 2, 2) This will work only if the date is a weekday when the share price is published. To get a fund's closing price on a particular date, try the following. ![]() The TSP Folio site is not an official TSP page, but I found it easier to extract the data from their webpage compared to similar TSP pages. G Fund - 1 and 2 (as shown in the formula above). ![]() if the fund is up 2.5% for the year, then the raw value will be 0.025.įor the other TSP funds, change the values of the first and third numbers in the formula (which are "1" and "2" in the G Fund example shown above, leaving the number "4" the same for all TSP funds) as follows: The value returned from this formula will be a decimal, e.g. To get the G Fund's YTD return from TSP Folio's Fund Page page, put this into a cell:Ĭode: Select all =Index(ImportHtml("", "table", 1), 4, 2) Make a copy of this Google Sheet if you'd like to see how some of these case studies work. Sample Google Sheet Illustrating various TSP Tips If I notice changes, I'll update this post (if I can remember - if not, PM me). You may need to adapt to the new web page by tweaking the row/column coordinates. The code above will output the current price of the G Fund directly into the cell.įor the other TSP funds, change the the URL path for each fund, as described in the explanation at the top of this post.ĭISCLAIMER: If the layout of the underlying TSP web page changes, then all bets are off. But thanks to the idea from this thread, I no longer need to do this!įor ordinary mutual funds, ETFs, or stocks, you can get the share price with this function: Lacking this ability, I have been manually updating the funds' prices manually every so often in my spreadsheet. Inspired by a similar thread from The529guy regarding TIAA-CREF funds that GoogleFinance cannot recognize, I wanted to see if there was a way to get real-time quotes for TSP funds in my Google Docs spreadsheet using a similar technique. If you are curious about how this works, or if you want to know of other similar Google sheet tricks and tips with the TSP, or how to do this technique with other "closed" funds that are not on stock exchanges, then read on. (Note: as of, this doesn't seem to be working yet for the newer Lifecycle funds with the mid-decade years but it works on L2030, L2040 and L2050.) ![]() For the other Lifecycle funds, change to L2025=1, L2030=1, etc.For the Lifecycle Income fund, change to Linc=1.For the F, C, S, and I funds, change to F=1, C=1, S=1 or I=1.Code: Select all =INDEX(ImportHtml("", "table", 1), 2,2)įor the other TSP funds, change the end of URL above from "G=1" to the following:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |