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 3 of 13 FirstFirst 12345 ... LastLast
Results 25 to 36 of 154

Thread: TSPLookup - Introduction, Comments & Questions Thread

  1. #25

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Quote Originally Posted by tsptalk View Post
    Jayhawker now has a separate page where you can read more information and download the utility... www.tsptalk.com/tsplookup
    Thanks Tom!

    Okay! I'm done with the update and it will be available for download this evening. When you click on the download link and see the filename "TSPLookup2.zip" you'll know you're getting the latest and greatest version.

    Some fixes were made in the Dashboard. The code/logic for this form is complicated and I didn't quite have it correct. The changes are:

    1) When entering share values in the Dashboard, if the user entered something other than a number or a decimal point (i.e.; a letter or two decimal points), execution of the program would halt with an error on the tab change event.

    Resolution: Trapped this error. The user can now only enter numbers - with or without a single decimal point.


    2) If, in the evening after the TSP share values are current, the user entered their share values for tomorrow, these values would overwrite the previous days values when the spreadsheet was opened the next day.

    Resolution: Now, the user cannot update their share values after the share prices are current and the tab reads "Tomorrow." Also, now the user cannot update their share values on Sunday.


    3) When the user opened the spreadsheet in the morning before the US markets have opened for the day, the tabs "Today's Estimate" and "TSP Fund Quotes" would show the previous day's closing results for the F, C and S funds temporarily skewing the totals (just) until the US markets opened. Not a big deal and I'm sure most users understood the data they were seeing was from the day before, but I tried to fix it anyway.

    Resolution: Assuming the date/time data from Yahoo is correct and in the correct format (and that's a big IF with Yahoo lately) the previous day's closing results will no longer appear when viewing these two tabs. (I might have to revisit this if it doesn't work correctly consistently.)


    4) The links to PayPal and my email address didn't work in the "About" form.

    Resolution: D'OH! Is this why YOU haven't sent any money??? C'mon users... you've got tens of thousands of $$$ invested. $10 is pocket money, chump change, a decent tip. Send money!

    That's all folks! Enjoy!

    Ed.

  2.  
  3. #26

    Join Date
    Feb 2007
    Location
    San Diego, CA
    Posts
    6,999

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Your post on 350z's thread
    Quote Originally Posted by jayhawker View Post
    EAFE final: -.215 or -5 cents.
    is NOT the TSPlookup "I fund" results I am seeing on the spreadsheet.


    What am I missing?

    Nevermind....estimate....it's estimating
    Last edited by Frixxxx; 04-23-2007 at 04:12 PM. Reason: more

  4.  
  5. #27

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Quote Originally Posted by Frixxxx View Post
    Your post on 350z's thread

    is NOT the TSPlookup "I fund" results I am seeing on the spreadsheet.


    What am I missing?

    Nevermind....estimate....it's estimating
    I'll count this as the "Infrequently Asked Question of the Day!"

    Honestly, I posted the EAFE quote from bloomberg.com instead of from the spreadsheet in 350z's thread today because the Yahoo quote for FTSE was wrong. The Yahoo quotes are going to be wrong on occasion. It's annoying as all get out but I can't control it. I have complained to Yahoo though.

    Thanks for your question. Ed.


  6.  
  7. #28

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Infrequently Asked Question of the Day

    #5 - Can you add the L-Funds to the spreadsheet and/or the Dashboard?

    Nope. No can do. Because...

    The tsp.gov website uses flash control to display the percentages. (You know - those fancy pie charts. They must have hired that work out because that presentation is sooo different from the rest of the website!) If the L-Fund distribution values were to be found in an existing table or database that I could access I might have given it a shot. I thought about gathering the data by looking at the pie charts... for each fund... for each three month period... for the next... how many years??? Yes, I thought about that for all of about five seconds!

    You'll just have to break down your L-Fund distribution yourself.

    Thanks for your question. Ed.

  8.  
  9. #29

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Quote Originally Posted by Frixxxx View Post
    Your post on 350z's thread

    is NOT the TSPlookup "I fund" results I am seeing on the spreadsheet.


    What am I missing?

    Nevermind....estimate....it's estimating
    Better today - yes? TSPLookup had a Final Estimate of .-350 at 11:18 CDT. The actual EAFE final was -.366. That's close enough for government work!

  10.  
  11. #30

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Infrequently Asked Question of the Day


    #6 - What formula(s) are you using to project the account balance?

    Excel has a worksheet function named Future Value (FV). It works like this:

    ________________________________

    FV - Returns the future value of an investment based on periodic, constant payments and a constant interest rate.

    Syntax - FV(rate,nper,pmt,pv,type)

    Rate is the interest rate per period.

    Nper is the total number of payment periods in an annuity.

    Pmt is the payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.

    Pv is the present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument.

    Type is the number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.
    ________________________________

    That burned a few brain cells!

    Thanks for your question. Ed.

  12.  
  13. #31

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Infrequently Asked Question of the Day


    #7 - When I rename the file or save it as a different filename other than TSPLookup2.xls, the Dashboard doesn't work. Why is that?

    It's related to the fact that the Dashboard is a non-modal form and can be on top of any application. When you are entering your share prices in the Dashboard, the "focus" must be on TSPLookup2.xls.

    I tried numerous methods - the most obvious one being the Excel VBA property "ThisWorkbook", but the only way I could successfully get the focus of/on the workbook when the Dashboard was not on top of the workbook was to activate the workbook by its unique filename - like this:

    Code:
    If ActiveWorkbook.Name <> ("TSPLookup2.xls") Then
            Application.ScreenUpdating = False
            Application.Windows("TSPLookup2.xls").Activate
    End If
    If the file is not named TSPLookup2.xls then it cannot be activated. That's why you can't rename it. Also, even though I turned off the ScreenUpdating, you'll still see a "blink" when you are entering numbers when the Dashboard is on top of anything other than the workbook. The blink happens because the program is (very quickly) switching back and forth between applications.

    Fascinating stuff - huh?

    Thanks for your question. Ed.

  14.  
  15. #32

    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!
    fabijo - wish you WOULD write this app in C++. Would be nice to get rid of the Excel requirement all together. I've got Excel 2000 (which tsplookup doesn't support) and plan to soon convert to the Opensource spreadsheet (named Calc I think? or whatever they call it) and eliminate Excel all together.

    Anyway, anytime we can eliminate Microsoft in the path, that's a GOOD thing IMO. Let me know if you ever make a stab at it. I might do it some day but too many projects going on now. By the time I get 'round to it, my old age dementia problems will have taken over, oh well.

  16.  
  17. #33

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Quote Originally Posted by ayla View Post
    fabijo - wish you WOULD write this app in C++. Would be nice to get rid of the Excel requirement all together. I've got Excel 2000 (which tsplookup doesn't support) and plan to soon convert to the Opensource spreadsheet (named Calc I think? or whatever they call it) and eliminate Excel all together.

    Anyway, anytime we can eliminate Microsoft in the path, that's a GOOD thing IMO. Let me know if you ever make a stab at it. I might do it some day but too many projects going on now. By the time I get 'round to it, my old age dementia problems will have taken over, oh well.
    We're you directing this to me?

    Try using TSPLookup in Excel 2000. It has been reported that it will work in Excel 2000 on a PC running XP. There's nothing in TSPLookup that shouldn't work in 2000. It should work. But I tested it on a box running Win98 and it didn't work. You'll just have to try it to know if it will work or not.

    I don't know C++. I know some Fortran, VMS, and linux/unix and that's about it. Secondly, if the program was in C++ and compiled into an executable, most government employees would not be able to run it on their work PC - or email it for that matter.

    Can't please everyone!

    Ed.

  18.  
  19. #34

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    EAFE final of -.139 today. TSPLookup had that EXACT number at the close (12:15 EDT.) Hit it right on the nose! Amazing!!!

  20.  
  21. #35

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    Infrequently Asked Question of the Day


    #8I noticed you updated the file yesterday. I downloaded it but I don’t see any changes. What changed?

    Not much.

    1) I added two hyperlinks down in the disclaimer; one to the TSPLookup webpage here at TSPTalk and one to the place where I bought the icons (the link is part of the licensing agreement.)

    2) In the About form, I added a link to the webpage here.

    3) Reworked the code for the way it was determining if the USM hadn’t opened yet. I thought I might have to revisit this - and I did.

    4) I cleaned up some code. What can I say – I’m a perfectionist.

    The basics are the same. Get the updated version at your leisure.

    Thanks for your question. Ed.

  22.  
  23. #36

    Default Re: TSPLookup - Introduction, Comments & Questions Thread

    How do I download file? Thanks for your input.

    Ed


  24.  
Page 3 of 13 FirstFirst 12345 ... 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