TSPLookup - Introduction, Comments & Questions Thread

[AIF]

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.

 

[merlin]

NIce app Jayhawker.

 

[jayhawker]

The FV value will update when the updated EAFE value is queried from mscibarra.com. While the new EAFE value is usually available at that website around 15:00 ET, the query won't get the new value until the web page defaults to the current date. This usually happens at about 19:00 ET.

And... :embarrest:

I have to have the updated TSP share prices too! Basically, I'm taking what the actual change in the EAFE was and factoring what the share price change equates to. Then I check the actual change in the TSP share price for the day. IF the difference is more than .03 cents, then I conclude that there was an FV. So... the correct answer to your question is about 20:00 ET. Both the new EAFE and the new TSP share prices are usually available to query at that time.

(Good thing I put good comments to myself in this thing... otherwise I'd soon forget how it works!) :blink:

Ed.

 

[jayhawker]

Ed, thanks for all the hard work you put into this. Really nice tool!

When does the FV calculation update? Right now it says -.13 but I'm assuming that is for yesterday.

That's right, the -13 shown today is yesterday's FV (correction.) The FV value shown is after the fact (meaning, I'm not making any attempt to predict an FV.) There either was an FV or there was not.

The FV value will update when the updated EAFE value is queried from mscibarra.com. While the new EAFE value is usually available at that website around 15:00 ET, the query won't get the new value until the web page defaults to the current date. This usually happens at about 19:00 ET.

Thanks for the question. And thanks!

Ed.

 

[charmed855]

Ed, thanks for all the hard work you put into this. Really nice tool!

When does the FV calculation update? Right now it says -.13 but I'm assuming that is for yesterday.

 

[nnuut]

Downloaded your spreadsheet today, a real piece of work, thanks for all of your hard work!
Norman

 

[jayhawker]

I updated the file at the link at 12:30 PM ET today. There was an error in a value in the Dashboard. The beta-testers (my usually very capable co-workers) have been duly admonished!

If you downloaded the file before Monday 12:30 PM ET, please download it again to get the latest. It won't happen again!

I would like to post the file here on the message board but at just 200kb it is too large to be allowed. So, again, if you want TSPLookup and can't get to the download page, send me a PM here or an email.

Remember to delete your share prices and/or your Account Growth Projection values BEFORE you pass the application on to others. You probably don't want others to see those values!

Thanks,

Ed.

 

[jayhawker]

The download site I stored the file on is blocked here at work. Honestly, I did not anticipate that! It may be blocked at your work also.

If you want the file and can't get to the download site, shoot me an email to "tsplookup at hotmail dot com" and I'll send it to you.

Thanks,

Ed.

 

[jayhawker]

Thats fine. Heres another link to a message on these boards regarding the same thing. http://www.tsptalk.com/mb/showpost.php?p=85132&postcount=255



Isnt that the same thing every phishing email/keylogging application says?

Ok, you've got me there. :suspicious:

The difference - at least to me - is that I am the author and I'm the one saying so.

Technically, a user can open the application and NOT enable the macros. The user can look around, page down and read additional information and read the disclaimer. They will see my full name. Any user who works for the USPS (as I do) can look up my .gov email address on their ACE workstation in Outlook.

ChemEng, you're concerns have been duly noted. Thank you. All: if you have any concerns whatsoever - don't use the application. Simple as that.

Now seems like a good time to acknowledge that this message board is the most civil board I visit. Rarely is there animosity, backbiting, insults and the like that you see on other message boards. I think it's a credit to Tom, and a credit to the civility and maturity of US Government employees.

Ed.

 

[ChemEng]

I won't argue with that statement (although I do question the sentiment.)

Thats fine. Heres another link to a message on these boards regarding the same thing. http://www.tsptalk.com/mb/showpost.php?p=85132&postcount=255

The macros in the application are totally safe to run on any PC.

Isnt that the same thing every phishing email/keylogging application says?

 

[jayhawker]

Anyone that loads a macro without being able to see the VBA that it contains is foolish.

I won't argue with that statement (although I do question the sentiment.) However, as the author, I have the right to control the VBA. And, as a Government employee, I would be a fool to include any spyware/malware or other evil code.

The macros in the application are totally safe to run on any PC.

Ed.

 

[ChemEng]

Anyone that loads a macro without being able to see the VBA that it contains is foolish.

 

[nnuut]

Happy Sunday Jayhawker!! This looks really neat, Who came up with this JEWEL? Gotta try it!!:toung:

 

[jayhawker]

TSPLookup​

Introduction, Comments & Questions​

All,

Allow me to introduce you to TSPLookup. TSPLookup is a Microsoft® Excel application that has/does the following:

• Gets the market quotes for the TSP F, C and S Fund quotes.
• Gets the market quotes for the foreign markets that comprise the EAFE / I Fund
• Gets the currency quotes for the Big Five currencies.
• Gets the market quotes for up to 12 Yahoo symbols of your choosing.
• Estimates the EAFE / I Fund.
• TSP Account Growth Projection feature.
• A Dashboard that provides:
  • A quick view of the markets.
  • A view of your TSP portfolio. You may enter the number of TSP shares you own and then view today’s estimates and the previous days’ results.
  • The TSP Share Prices for the past 15 market days.
  • Another access to the Account Growth Projection feature.

Download TSPLookup v1.0 (TSPLookup1.zip) via the link in my signature.

• Click the link to go to the download page.
• Download the file
• Save the zipfile on your local hard drive.
• Double click the zipfile to unzip it.
• Select TSPLookup1.xls, extract it and save on your local hard drive.
• Double click TSPLookup1.xls to open it in Excel.
• (The file will be a bit slow to load the first time it is opened on a different PC. Subsequent openings on the same PC will be quite quick.)

Will TSPLookup work on your PC?

• The application was written in Excel 2002 and will work in 2002 all later versions (2003, 2007)
• WILL NOT work in previous versions (Excel 95, 97, 2000 - sorry!)
• Contains macros and you MUST enable the macros.
• A high-speed Internet connection (cable, T1 or better) is recommended.
• Completely safe for use at work and home.

TSPLookup is free for you to use, however, I encourage you to support the application with a donation through PayPal®. If you like and use the application, please donate. And, please share TSPLookup with your co-workers and other TSP participants!

Well… that’s about it for the introduction! I’ll post any updates in this thread. Feel free to post your comments or questions here. Also, you may send me a PM or write to me at tsplookup@hotmail.com .

Enjoy!

Ed.

Here are some pictures.

• This is TSPLookup with the built-in Help comments shown:

• You can have the Dashboard on top of TSPLookup...

• or you can have it top of a different workbook (or any Windows application!)

• Here's the Account Growth Projection feature:

Enjoy!

Ed.