I fund tracker...

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.

Thanks for the comments. Ill add this feature in the next version of the tracker. It will probably be next week before I can get to it though, Im pretty heavily engaged with work and family (wife's due in 4 weeks!!) right now.
 
Thanks for the comments. Ill add this feature in the next version of the tracker. It will probably be next week before I can get to it though, Im pretty heavily engaged with work and family (wife's due in 4 weeks!!) right now.
Congrats on the new addition to your family. Your first?
BTW--thanks from me also for your spreadsheet. Use it everyday.
Debbie:)
 
Thanks for the comments. Ill add this feature in the next version of the tracker. It will probably be next week before I can get to it though, Im pretty heavily engaged with work and family (wife's due in 4 weeks!!) right now.
4 weeks!! Wow, Congratulations! It won't be long now. Nothing but fun from now on.:D
 
Thanks for the comments. Ill add this feature in the next version of the tracker. It will probably be next week before I can get to it though, Im pretty heavily engaged with work and family (wife's due in 4 weeks!!) right now.

Congratulations! Enjoy them before they grow old on you :laugh:
 
It seems ^FCHI is no longer a valid ticker symbol.

Do you have an update?

Thank you!:)
 
Sorry about that. The front page was right, but I accidentally added a "." at the end of the hyperlink in the thread that was screwing things up.

Thanks for the heads up!
 
ChemEng:

It seems that the symbols are changed again, I got 3 that did not work, including Nikkei... Would appreciate if you can update it when you have the time. TIA.
 
Im not exactly sure what is going on. There most definitely is a ^N300 on Yahoo. So I am guessing it is a temporary glitch with yahoo finance. I have updated the funds it looks for in the mean time to give something close. If it continues to act up, I think it may have to find a different way to go at getting the data (that isnt immediately apparent to me right now).

I fund lookup

Good luck!
 
Im not exactly sure what is going on. There most definitely is a ^N300 on Yahoo. So I am guessing it is a temporary glitch with yahoo finance. I have updated the funds it looks for in the mean time to give something close. If it continues to act up, I think it may have to find a different way to go at getting the data (that isnt immediately apparent to me right now).

I fund lookup

Good luck!
U must be having other problems other than the symbols...the Yahoo symbols I use have been reporting this morning as usual....been that way for about a month or so....I don't detect any symbol change...
 
U must be having other problems other than the symbols...the Yahoo symbols I use have been reporting this morning as usual....been that way for about a month or so....I don't detect any symbol change...
That is why I am thinking there is something going on with the way Yahoo is broadcasting its CSV files for specific markets. There most certainly is a ^N300 index--you can view it in Yahoo Finance. But when you try to access the CSV, you get an error. If you do the same exact approach with ^N225, it works.

The only thing I can think of is that theres an issue on Yahoo's end.
 
Back
Top