Is something wrong with the file? It will not download properly for me! I was able to download it yesterday but the corrected version is not downloading properly. The site says its a 181.41 KB file but I can only download about 134 KB.
gets the market quotes.
estimates the EAFE / I Fund.
lets me see my portfolio in action.
projects my account balance.
provides the current TSP share prices.
NIce app Jayhawker.
Where is the Money?
Is something wrong with the file? It will not download properly for me! I was able to download it yesterday but the corrected version is not downloading properly. The site says its a 181.41 KB file but I can only download about 134 KB.
Since I can't get to the download site from here at work, I asked a friend to download the file, unzip it, and open it. He did so successfully.
There may have been a problem with the server the file is stored on. Please try again. And I will check the process tonight and change the link if necessary.
I'm working on finding a new, dependable home for the file that can be reached by everyone all the time.
Ed.
In an effort to keep the many TSPLookup users informed (and to bump this thread to the top in a most self-serving way), I’m instituting the “Infrequently Asked Question of the Day.” I’ll post the IAQD after the IFT rush so as not to (further) annoy users. So, without further ado:
Infrequently Asked Question of the Day #1
Love the spreadsheet! Awesome job! But I’m already sick and tired of the cat that pops up every time I update from the main spreadsheet! Can I change the cat to something else?
Yes! You can change the office assistant.
1) Select the Excel Help from the top menu
2) Select Show the Office Assistant
3) Move your cursor to the now visible Office Assistant and right-click
4) Select Choose Assistant
5) Click the <Next> and <Back> buttons to view the selections.
6) Select OK when viewing the assistant you want to use.
I chose Links (the cat) as the default because I personally like cats. And the timing of how the cat enters and exits seemed to work well for the spreadsheet. Rocky (the dog) works pretty well, as does Clippit (the much-maligned paper-clip) and Merlin (the magician.) F1 (the robot/transformer looking thingie) is slow to enter and to exit. But any assistant you choose will appear and disappear when you update.
Thanks for your question! Ed.
It shows the paperclip guy for me. I'm pretty tired of that guy.
By the way, your Excel skills are excellent. It is a masterpiece. I should probably do more research about using macros. I could probably cut down my file sizes considerably by using a macro instead of using the same statements over 14000 times!
All:
You can expect an update to TSPLookup on Monday or Tuesday. A couple of users have made good suggestions that I want to implement. I'm listening! If YOU have any suggestions or have found any problems, please send me a pm or post here.
Thanks,
Ed.
Today's Infrequently Asked Question of the Day. (You get two today because I was "indisposed" yesterday.)
#2
The built-in help states there are 12 spots to enter Yahoo symbols I want to track. There are actually 13. Can’t you count???
Yes, I can count. I know how many are there. I’m superstitious. I couldn’t bring myself to say there were – that number you wrote. And you can use all of them.
#3
Cool spreadsheet! Why are some of the currencies rates quoted in US$ per foreign currency units and others quoted in foreign currency units per US$?
Good question! It’s just the way it’s always been done. From the Federal Reserve Bank of New York website: “We report some rates in U.S. dollars per foreign currency unit and others in foreign currency units per U.S. dollar, following a long-standing convention.”
I could have just as easily shown the currencies in the same relationship to the US$. I didn’t simply because I didn’t want to go against convention.
Thanks for the questions. Ed.
Jayhawker now has a separate page where you can read more information and download the utility... www.tsptalk.com/tsplookup
Tom
Market Commentary | My Blog | TSP Talk Plus | |
I am not a Registered Investment Advisor and this is not investment advice. Please do your own due diligence.
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