TSPLookup - Introduction, Comments & Questions Thread

[jayhawker]

TSPLookup users:

Looks like we're having trouble getting the EFD quote from bloomberg.com this morning. The quote is still here - in the same place as usual - but we're not successfully getting to that page every time. I suspect bloomberg is tweaking their website this morning. Not to worry. It'll fix itself. Just keep updating and eventually you'll get the quote.

Ed.

 

[jayhawker]

TSPLookup users:

...Yahoo states the symbol ^FCHI (France's CAC 40) is no longer valid. That's absurd! What idiot is in charge at Yahoo finance???

Ed.

It was changed to FCE.NX without the little ^

Yahoo has changed the France symbol back to ^FCHI! :blink:

I have updated TSPLookup.

The ^STI quote for Singapore is not available at this time. From Wikipedia:

"The Singapore Exchange, London's FTSE Group, and Singapore Press Holdings announced on 6 June 2007 that the Straits Times Index will be set for a major overhaul by the end of 2007. The number of component stocks will be reduced from 50 to 30 and at the same time, 18 new indices will be created. It is known that the new STI indices would be published on the FTSE website beginning September. The announcement stated that the revamped STI and the current STI will be displayed together then, until the switchover in December.

On 10 January 2008, the new indices became active, albeit to much confusion across the market. The introduction of such indices has been poorly implemented in the indices themselves are no longer displayed on the SGX web site, and they are no longer supplied on their live data feeds to brokers."

http://en.wikipedia.org/wiki/Straits_Times_Index

Thanks for using TSPLookup!

Ed.

 

[jayhawker]

An updated version of TSPLookup is available for download.

I fixed the S Fund quote from Yahoo and the currency quotes from ino.

Ed.

 

[jdubya]

At times, the webmaster of tsp.gov will insert an informational banner on the share price page. This usually happens a few days before a holiday - reminding tsp participants that share prices won't be updated on the upcoming holiday. When in effect, this changes the location of the share price table that TSPLookup retrieves. While I planned ahead for this and TSPLookup handled it okay this past holiday, it wasn't quite perfect. So, I fixed it.

Ed,

If I may ask, how do you account for this in your coding when TSPLookup retrieves the share prices?

 

[jayhawker]

Ed,

If I may ask, how do you account for this in your coding when TSPLookup retrieves the share prices?

I use two web queries that places the data in two different places on a data sheet. The first query retrieves the share price table its from usual location, and then I check to see if the data is actually retrieved. If not, then I run another web query the retrieves the next table below. In a third location, I simply check which has valid values. To place data in the main page and the userform, I use the data from this third location.

Ed.

 

[jdubya]

Thanks for the reply, Ed.

You have a great program.

 

[jayhawker]

I fixed a problem with the S Fund quote.

Click on the link in my signature to download the updated file.

Thanks,

Ed.

 

[jayhawker]

I fixed a problem with the I Fund results from mscibarra.com.

Click on the link in my signature to download the updated file.

Thanks,

Ed.

 

[Fivetears]

Anyone still have a working copy of this? Perhaps something new?
I started getting 1004 Run-time errors a couple days ago.

The copy below has the same problem:
http://workingmansblog.com/TSP/I_fund_lookup.xls
This one two:
http://www.tsptalk.com/mb/showpost.php?p=161350&postcount=35
I think they're related. :nuts:

 

[luv2read]

Anyone still have a working copy of this? Perhaps something new?
I started getting 1004 Run-time errors a couple days ago.

The copy below has the same problem:
http://workingmansblog.com/TSP/I_fund_lookup.xls
This one two:
http://www.tsptalk.com/mb/showpost.php?p=161350&postcount=35
I think they're related. :nuts:

See this post. ChemEng is checking on it.

http://www.tsptalk.com/mb/showpost.php?p=165250&postcount=157

 

[Fivetears]

I'm getting program script 1004 Run-time errors L2R. I normally ran it after 7pm to cut and paste into my Excel market graphing spreadsheet. I guess I'm back to the "horse and carriage" key punching activity. It was very good while it lasted CE, if it can't be fixed.
Thanks.

See this post. ChemEng is checking on it.
http://www.tsptalk.com/mb/showpost.php?p=165250&postcount=157

 

[jayhawker]

I updated TSPLookup today. I updated the country composition percentages of the I Fund and reordered them from highest to lowest. No, they haven't changed recently... I just happened to notice. Sorry, I've been busy!

Click on the link in my signature to download the updated file.

Thanks,

Ed.

 

[nnuut]

By the way, Jayhawker we really appreciate you keeping this valuable tool updated for our use. You are one of many that make this a GREAT place to learn and beat the system, it's all about MAKING MONEY and you help a lot!!
Thanks
Norman

 

[jayhawker]

By the way, Jayhawker we really appreciate you keeping this valuable tool updated for our use. You are one of many that make this a GREAT place to learn and beat the system, it's all about MAKING MONEY and you help a lot!!
Thanks
Norman

Norman, thanks for the kind words.

I haven't been around here be much because I truly have been busy. I'm working for HQ now so I've got multiple projects in the works and I'm traveling a lot. But I do try to catch up with the non-premium posts once a week.

Ed.

 

[jayhawker]

I updated TSPLookup again today. I fixed an error in postulating the FV amount (I Fund Fair Valuation.) I suppose this has been broken since about 4/8/08 when mscibarra.com changed their table. I made an update at that time for that table change but didn't notice that the FV calculation was also affected. Anyway, the FV should be correct again.

Click on the link in my signature to download the updated file.

Thanks,

Ed.

 

[jayhawker]

I updated TSPLookup today. The share prices are now shown carried out to four decimal places.

Click on the link on my signature to download the updated file.

Thanks,

Ed.

 

[tsptalk]

Still a great utility! Sending another donation. Who's with me?

 

[jayhawker]

I updated TSPLookup today.

An error in getting the EFD quote from bloomberg.com has been fixed.

Ed.

 

[luv2read]

Hi,

First I want to say how valuable tsplookup and Ifund lookup are and thank you for providing them, and keeping them in working order!

I downloaded the updated TSPLOOKUP yesterday. I ran it between 11-12, then again at the end of the day. I ran it again this morning - of course this early there are no F, C, S results showing, but there are results for I Fund. It is in the RED. I still had the earlier version on my desktop and had accidentally clicked that one first, and it is in the GREEN. I also use your I fund tracker. All three give wildly differing results when run. I fund results at 6:08 this morning:

pre-8/4 (6/4 version i think) tsplookup version today's estimate = 21.54 up .32
8/4 tsplookup updated version today's estimate = 20.8374 down -0.3806
I fund lookup = 21.27 (6:08 estimate: +1 cent from market change PLUS +6 cents from dollar change EQUALS +6 cents)

I don't know why the three spreadsheets are calculating this differently. If it's not too much trouble could you please verify which is correct? TIA!

 

[jayhawker]

Thanks for your question. Sorry for my tardy response.

After the fact, I can't say why there may have been a discrepency in the two versions of TSPLookup. ("I Fund Lookup" is ChemEng's spreadsheet.
I don't have anything to do with it.)

Looking at past results, the I Fund was down about 32 cents on 8/6, so I'd have to conclude that the current version of TSPLookup was the most correct.

TSPLookup gets actual quotes; the F, C, and S from yahoo and the I from bloomberg. Rarely, these quotes are wrong at the source.

Ed.