Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Quicken & S&P 500 Index Fund help needed
Old 01-07-2015, 05:16 PM   #1
Thinks s/he gets paid by the post
SumDay's Avatar
Join Date: Aug 2012
Posts: 1,678
Quicken & S&P 500 Index Fund help needed

My 401(k) is administered by Mercer. Last night when I downloaded my investment updates, my 401(k) increased by approximately 10 fold.
I was ready to retire this morning. Alas, it's a fluke.

There's a new S&P 500 Fund they rolled out in December (and moved money into it out of another fund they closed), and when I log onto my account via Mercer's website, it says the close today is $9.67, and there is no ticker symbol. However, when my account downloads to Quicken, it's entering the actual S&P close today, which was 2,025. Quicken is recognizing the ticker symbol as INX, even though Mercer isn't sending one. I called them today, and they were ZERO help since Quicken is a "third party product".

How do I fix this? Sorry, if I didn't explain well. I'll check back to answer questions. Thanks in advance.

SumDay is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 01-07-2015, 05:20 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 24,762
If there is no ticker the only solution that I know of is to input the prices manually.

If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.

Retired Jan 2012 at age 65/35/0 AA
pb4uski is offline   Reply With Quote
Old 01-07-2015, 09:27 PM   #3
Thinks s/he gets paid by the post
Join Date: Jul 2005
Posts: 4,074
I like to enter 401k-only funds as a comparable retail fund, with the number of shares determined by the total value of the fund. Then biweekly I adjust the number of shares to true up Quicken with the 401k value. If you have a good match it only takes a small fraction of a share to match total values. If you don't have a good match it's probably easier just to enter your own prices.
Animorph is offline   Reply With Quote
Old 01-09-2015, 04:02 AM   #4
Recycles dryer sheets
Join Date: Nov 2011
Posts: 126
I have this issue with a couple of no-symbol funds in my 401K. Annoying, but I just update manually in Quicken.
523HRR is offline   Reply With Quote
Old 01-09-2015, 07:48 AM   #5
Recycles dryer sheets
Aeowyn's Avatar
Join Date: Jan 2011
Location: Scotts Hill, TN
Posts: 105
Are you using the auto download feature or are you pulling a "Web Connect File" and importing it into Quicken?

If you are using the auto update feature, you should see if you can create a "Web Connect File" from your 401K plan (usually if they auto update Quicken, they also have a way to create this file).

Anyway once you have a web connect file, it is a text file that you can open up and take a look at. You could then search for the "INX" symbol to make sure they aren't sending it. Next I would search for the price that it is supposed to be (e.g. 9.67 or what ever the current price is). Once you locate the fund, you can see what type of information they are sending in.

I guess one of the first things to do is actually see what "Ticker" quicken has for the fund. Does Quicken have they symbol "INX" associated to it? If so, remove it. If you have verified that "INX" is not in the web connect file, you could try to import it and see if you can associate the fund coming in from your 401K with the fund you already have in Quicken for it.

Another option would be to modify your fund in Quicken to a "dummy" ticker symbol and then edit the web connect file and put in a that dummy ticker symbol for the fund. In my 401k web connect file, it has a line above the fund price of <TICKER>XXXXX</TICKER>. Of course you may need to do this each time you upload the file. But maybe as long as quicken has the ID coming in from the 401K for the fund associated correctly with the fund in Quicken it will be OK

There is a "uniqueid" coming in from the web connect file I get from my 401K for each fund. I'm pretty sure this ID is associated in Quicken. After looking at what is in the web connect file, as a last resort you might also try removing the fund in Quicken and see if the web connect file will load it back in correctly.

So I guess my questions are:
  • In Quicken, what ticker symbol is assigned
  • In Web Connect file, what ticker <TICKER> is assigned (if any)
  • In Web Connect file, is there a <UNIQUEID> assigned for the fund
  • If there is a <UNIQUEID> assigned - when you search the web connect file for this uniqueid can you ever find a place in the file that has this ID associated with a <TICKER> line?
If there is no UNIQUEID, I'm not sure anything can be done. But I would think as long as there is a UNIQUEID there is hope that it can be associated with the fund in Quicen.

Now that I've said all this - you could just try putting in a dummy ticker in Quicken for the fund and then and then just try to load in the data from the 401K plan (how ever you usually do). If the fund comes in as a new fund, say you want to associate it to the one you already have in Quicken. Then I would verify that it didn't change the dummy Ticker you set.
Quit my J.O.B to become a farmer/rancher - December 2011
Now working part time from home on contract to support prior employer.
Aeowyn is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Growth Fund or 500 Index dougie790 FIRE and Money 6 06-03-2009 09:48 AM
SPY vs Vanguard 500 index fund For IRA godoftrading Other topics 4 07-22-2008 08:59 AM
Approximate Vanguard Total Stock Market Index with S&P 500 and other fund(s)? Dude FIRE and Money 17 02-18-2007 08:25 PM
Where can I find S&P 500 Index returns? Telly FIRE and Money 10 10-23-2006 06:06 PM
CY 2005 Rtn. - S&P500 vs. 500 Index Funds Telly FIRE and Money 5 01-07-2006 04:02 PM

» Quick Links

All times are GMT -6. The time now is 05:57 AM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2020, vBulletin Solutions, Inc.