Chem:
Thanks for the update. I had to go back to page one of this thread to find the updated version. It works well.
Thanks again.
Updated spreadsheet again. Thought of a simple way to compensate for the changes in variable table formats that TSP.gov uses around holidays. Let me know if this works!
Chem:
Thanks for the update. I had to go back to page one of this thread to find the updated version. It works well.
Thanks again.
Heres the I fund lookup not on the front page.
Attachment 1733
Updated spreadsheet. Found a way to speed it up if you're like me and use it multiple times a day. Enjoy!
Thank you, I used it all the time. Keep up the good work!!
Thanks for all of your hard work. I use this often through the day. Even after noon to check on the $ direction.
Debbie
This latest version works with Excel 2000 (my copy anyway). The older versions (at least the last ones I tried) did not so wanted to let others know in case they thought they wouldn't be able to use this wonderful application. Thanks ChemEng!
Updated the spreadsheet to include a cell to enable quick and easy estimates to be posted in the I-fund thread. The process is simple.
Press Get Data! button.
Point to cell G36.
Copy that cell.
Paste data into message box in 350z's I fund thread.
Post message.
One other small update. If there is a FVC for todays markets, then you enter it into cell G34. (It will add itself into the estimate text automatically.)
Let me know if you have any problems.
Last edited by ChemEng; 08-24-2007 at 11:20 AM.
Updated the composition of the I fund based on new data from TSP website. The latest version of this sheet should have ^FTSE as the first index instead of ^N300.
ChemEng:
Thanks very much for the spreadsheet. I have a favor to ask though. In your macro updating the share prices and I fund current %, can you also pull in the % for the C (^GSPC) and S (^DWCPF)funds? These are the 2 funds I used to track C and S. I can handle the simple spreadsheet, but have no idea how to do macros, especially to pull in real data!
Thank you mucho!
I agree. Keeping an Eye on C and S funds all in the same spreadsheet would be helpful.
Two steps forward, one step back.
S&P500 (C Fund) (delayed) (Stockcharts.com Real-time) |
DWCPF (S Fund) (delayed) (Stockcharts.com Real-time) |
EFA (I Fund) (delayed) (Stockcharts.com Real-time) |
BND (F Fund) (delayed) (Stockcharts.com Real-time) |
||
Yahoo Finance Realtime TSP Fund Tracking Index Quotes |
Bookmarks