Thanks, Chem! This is a nice little program.
Here is the spreadsheet I talked about on Friday. It tracks the real-time % changes of the component EAFE funds and then using their EAFE weightings, calculates an overall % change. I found the macro coding online while trying to find a list of the different Yahoo tags and thought I could put it to good use tracking I fund changes.
1. This is done in MS Excel and uses a macro. That means you need to enable the macro when you start up the spreadsheet.
2. It works on Excel versions 2002 or later. If you have trouble loading it, please check your version of Excel to see if this is the problem.
--------------------------------------------------------------------------------------------------------------------
17JAN07--Corrected spreadsheet to track Nikkei 300, instead of Nikkei 225.
02MAR07--Updated spreadsheet given new data about DX.
09APR07--Updated new tsp.gov import bug I found.
02JUL07--Dynamic coded the spreadsheet to fix TSP.gov's table format changing. (This should permanently fix the bug I found on 09APR07.)
12JUL07--Found opportunity to speed up coding.
24AUG07--Added cell to allow for copy+paste of timed updates.
24AUG07--Updated the composition of the I fund based on new data from TSP website.
23DEC07--Changed CAC 40 symbol from ^FCHI to ^CAC.
16FEB08--Changed Ireland symbol to ^I:IEDOW and Portugal symbol to ^I:PTDOW.
22APR08--Updated symbols for Japan, Greece, and Ireland.
20OCT08--Updated program to reflect the new location of the Index data.
27JAN09--Addressed TSP.gov redirect issue.
03FEB09--Corrected sort method to work with earlier Excel versions.
I fund lookup
Last edited by ChemEng; 02-03-2009 at 07:18 PM.
Thanks ChemEng! I've been trying to get something going on this and was not able to.
Im glad that you found this utility useful! Although Im still not certain that Im tracking the right symbols on the spreadsheet. (Note I did update it this morning to track the Nikkei 300 instead of the Nikkei 225.)
Is there anyone out there that could double check the listing to make sure its tracking the right ones?
ChemEng, I track these major world indices:
^N300,^FTSE,^FCHI,^SSMI,^GDAXI^,AORD,^MIBTEL,^IBEX ,^AEX,^OMXSPI,^HSI,^FIDOW,^BFX,^IEDOW,^STI,OMXC20. CO,^OSEAX,^GRDOW,^ATX,^PTDOW,^NZ50
You may have to check if you got FINLAND (^FIDOW 1.40% included. The above link lists the indices from top to bottom according to its countries' weight.
Last edited by ebbnflow; 01-17-2007 at 09:39 PM.
Great spreadsheet! Thanx for sharing.
Perhaps with your excel expertise, you could come up with a spreadsheet that calculates/estimates the (I) Fund price increase/decrease for the day?
"Treat your wife with honor, respect, and understanding as you live together so that you can pray effectively as husband and wife." 1 Peter 3:7
Updated I fund lookup spreadsheet today. Will post here any updates that get made to it.
This is a good place for a sticky!
"Treat your wife with honor, respect, and understanding as you live together so that you can pray effectively as husband and wife." 1 Peter 3:7
Updated new tracker to fix a new tsp.gov import bug I found.
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