Likes Likes:  0

View Poll Results: TSPLookup is useful to me because it:

Voters
46. You may not vote on this poll
  • gets the market quotes.

    18 39.13%
  • estimates the EAFE / I Fund.

    27 58.70%
  • lets me see my portfolio in action.

    23 50.00%
  • projects my account balance.

    14 30.43%
  • provides the current TSP share prices.

    20 43.48%
Multiple Choice Poll.
Page 2 of 13 FirstFirst 123412 ... LastLast
Results 13 to 24 of 154

Thread: TSPLookup - Introduction, Comments & Questions Thread

  1. #13

    Join Date
    Feb 2007
    Location
    O'Fallon, Missouri
    Posts
    404

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    NIce app Jayhawker.
    Where is the Money?

  2.  
  3. #14

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    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.

  4.  
  5. #15

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Quote Originally Posted by AIF View Post
    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.

  6.  
  7. #16

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Quote Originally Posted by jayhawker View Post
    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.
    It worked this time. I think it was a temporary problem.
    Thank you,
    AIF

  8.  
  9. #17

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    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.

  10.  
  11. #18

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    It shows the paperclip guy for me. I'm pretty tired of that guy.


  12.  
  13. #19

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Quote Originally Posted by fabijo View Post
    It shows the paperclip guy for me. I'm pretty tired of that guy.
    Interesting. I make an attempt to determine if Clippit was your current office assistant then change it to Links. You must have a later version of Office than I do.

    Oh well. You can change the Office Assistant using the instructions above. Try the cat!

  14.  
  15. #20

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    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!

  16.  
  17. #21

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Quote Originally Posted by fabijo View Post
    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!
    Thanks fabijo!

    I looked at your monkey files... 57 years worth of data is a LOT of data. I'm still studying it - trying to figure out what it all means. On first glance, I don't see how adding macros would help. Maybe you could cut it down to the past 20 years or so!

    Ed.

  18.  
  19. #22

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    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.

  20.  
  21. #23

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    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.

  22.  
  23. #24

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    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.

  24.  
Page 2 of 13 FirstFirst 123412 ... LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
S&P500 (C Fund) (delayed)
TSPLookup - Introduction, Comments &amp; Questions Thread
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
TSPLookup - Introduction, Comments &amp; Questions Thread
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
TSPLookup - Introduction, Comments &amp; Questions Thread
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
TSPLookup - Introduction, Comments &amp; Questions Thread
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes