QUICKEN PREMIER 2005

Sort by newest Sort by date
Rod

Rod

Well-known member
imported post

I just purchased Quicken Premier 2005.

Does anyone else have this?

I would appreciate any tips/tricks in helping me to utilize this with the TSP.

Thank you & God Bless:^
 
imported post

Rod,

I've used Quicken Deluxe (about the same thing as far as investing part of the program) for 10 years, and I too will search as well and would like to know how to integrate TSP and Quicken as well. I've never tried to do this and have just been manually typing in the prices. Way too time consuming.
 
imported post

GOOD G-D MAN!!

Don't you all know this übergeek is ALL ABOUT convenience and automation and anything that provides me max info with more goof-off time!?

Yes, let me know if you have problems/need clarificationwith the Quicken dealie. Ima pretty up the web site one O these days. (I would add it to Tom's site, but dunno if putting another task onto his SQL server would be a good idea. O course, DUH! we don't have to use HIS, he can use mine! DurrRRRrrrrr...hey Tom, I'll throw you some code soon.)

I just got back into a collectible card game that I haven't played in 8 years and it's pretty time consuming....putting my new acquisitions into a database now (for max info now and max playtime later).
 
imported post

K, after you get your account set up in Quicken, you should have individual securities setup called TSP_XX, where _ is the letter of the fund (C/S/I/F/G).

Then you download share prices from this link. http://www.techalchemy.net/TSP/tsp.php

While on the investments screen, click File | Import |Import Prices.



There is an intermittent bug...the price update gets wonky once in a while (you will see +30% gain in one day); once I fix that, there will be a link to it on TSPtalk.


Any questions? Does everybody know how to do this who wants to do it?

Also, does the import work with Micro$oft Money?
 
imported post

Hi, I'm using Quicken H&B Premier 2004. I have followed your directions, best I can tell, to import prices into the security. I created securities using the TSP_XX format. I saved from your website in a notepad file named 'TSP Price History.txt', using the dates for 1/3 to 1/28/05. Just this year.

Anyway, I try to import the file and it says 'No valid prices to import'.

I'm not sure what I'm doing wrong or what to try next. Can you help me please?

I do appreciate your efforts and can't believe TSP won't modernize for us.

Lou
 
imported post

Rolo wrote:
K, after you get your account set up in Quicken, you should have individual securities setup called TSP_XX, where _ is the letter of the fund (C/S/I/F/G).

Then you download share prices from this link. http://www.techalchemy.net/TSP/tsp.php

While on the investments screen, click File | Import |Import Prices.
Click to expand...


Rolo, thanks, but still no luck. Same problem regardless of downloading and importing 1 date, 5 dates, or entire history. Same error message. Also, do you know what the default folder is that Quicken looks for this file in? Getting old having to paste and copy the entire path as it is quite long!

Thanks again for your efforts, I am very excited at the prospect of getting this up and running!

Lou
 
imported post

Just a thought: Do you think it matters in which order I created the securities? I created them in this order: C, G, F, S, I, using the TSP_XX format.

LOu
 
imported post

I just got it to work! I screwed up, I named the securities, but never named the actual ticker symbol! DOH!

Lou
 
imported post

Hi Lou,

No, it doesn't matter which order you created them. What, exactly, are you clicking in Quicken to import the prices?

Be sure to be on the Investing Center screen (the one that shows all your holdings, watchlist, daily gains, etc.). Then click on File | Import | Import Prices.

Yesterday, the data were horked a bit; it is OK now. I haven't had time to kill that elusive bug yet. (Day 3 in my new house...most of my stuff still in boxes!)
 
imported post

Hey Rolo,

I am importing it properly, however, the dates are screwy. I downloaded June 2, 2003 to Dec 31, 2003. The I Fund was $12.90 on Dec 31, 2003. In Quicken, it shows the price history as $12.90 for all dates, June 3 - Dec 31, 2003. Also, the 'as of' date in Quicken always shows whatever date I input when I do the download. Finally, do you know what the default directory is for Quicken when it looks for the TSPprices file? I ask so I don't have to put the path in everytime I do the download.

Thanks for your help!

Lou
 
imported post

Rolo,

I finally got it to import prices! I had to sort in reverse order as I saved it, most recent date at the top.

Now what?

I will import all of my transanctions and see just how I can manipulate this data.

Thanks again!

Lou
 
imported post

Oh, I think that may be the intermittent bug. A succeeding import should correct it. I need to fix that (still moving in).

Is everything working?
 
imported post

Rolo wrote:
Is everything working?
Click to expand...
Yes, everything is working as far as showing the price history. That is very cool, thank you!

As far as me being able to manipulate the data...well, that is a different story. Allow me to ramble:

To start with, I have used Quicken since 1992, I'm pretty familiar with it. I usually upgrade about every 2 to 3 versions. I am currently using 2004 H & B Premier. I have never really done a lot with my TSP tracking other than every paycheck it automatically sends my contribution and the matching to the TSP account. Then, at the end of each quarter I would put an entry in that update the account to match the ending balance shown on my statement. Essentially, the update amount would be the gain or loss of the account for the quarter. That is all I have done with Quicken with respect to my TSP. Until now.

Now, I created a spreadsheet in Fall of 2003 that I use to track the TSP funds. In a nutshell, I use formulas to tell me which fund (C, S, or I) is the 'most undervalued' or the 'least overvalued'. I don't fool with the F Fund and the G Fund is never overvalued. I compare the closing price of the fund to it's average price. I have a formula that computes it's average price by giving more weight to more recent data. I then move 100% of my money, every day if neccessary, to the most undervalued fund. If all 3 (C, S, I) are overvalued I move to the least overvalued. If all 3 are overvalued by 1.45% or more, I move to the G Fund.

Is this working? Two weeks ago my answer would bea resounding 'YES!'. Now, I doubt my math. According to my spreadsheet, by making every move recommended, my rate of return since June 2, 2003 would be 77.46%. $100 would now be $177.46. I have not always followed the spreadsheet due to testing, emotions, etc. My spreadsheet math shows my personal/actual rate of return since June 2, 2003 as 29.85%. I believe I have adequately allowed for the 1 day delay in moving funds. As I do the quick math in my head and add my contributions and the matching to my balance and then factor in my RoR for the last year, the numbers don't add up. At least I don't think they do. Hencewith, the reason for my doubts.

Now to my point: I am wanting Quicken to verify my math for me. Unfortunately, I don't seem to be able to manipulate the data in Quicken like I want. I have input every transaction I have made. Quicken seems to show my RoR based on when I bought the current security (fund) and compares it to todays value. For instance, I have been in and out of the C Fund many times this last year and a half. Quicken doesn't show me how I have done with my moves because I currently have a zero balance in the C Fund. I'm sure that I am doing something wrong, but I don't know what. I just want Quicken to tell me what my rate of return is for any given period based on my daytrading my TSP and always going 100% to one fund on my trades. I suspect it is because I have not diversified to all 5 Funds that it is not giving me the data I want. Who knows?

Any ideas? Anyone? I am happy to share my tracking spreadsheet, but it is quite large, over 1 meg in size.

Thanks for listening/reading.

Lou
 
imported post

Yes, Quicken, in the Investing Center, tells you your gain from your cost-basis.

Use the reports, subtotal by account, to get your IRR for a given time period, or use those $ figures to calculate your actual gain.

Use the attached spreadsheet to enter your fund transfers.

Zip your spreadsheet, that should make it small enough to post.
 
imported post

Rolo wrote:
Yes, Quicken, in the Investing Center, tells you your gain from your cost-basis.

Use the reports, subtotal by account, to get your IRR for a given time period, or use those $ figures to calculate your actual gain.

Use the attached spreadsheet to enter your fund transfers.

Zip your spreadsheet, that should make it small enough to post.
Click to expand...
Actually, what I am finding is that Quicken only tells you your gain based on when you purchased the fund. For instance, I purchased 21,409.902 shares of G Fund on January 27, 2005,at $10.72 per share. The shares are now worth $10.73 each. Quicken reports a gain of $214.10, TOTAL. And that is with me setting the dates to include all dates. It does NOT show what the total, overall gain for my TSP account is. It bases it's gain on when the currently held security was purchased. I want it to say how much of my TSP value is contributions and how much is gains. It should be able to break it down like that as the money that has gone into the account in Quicken shows as either '_401Contrib' or '_401EmployerContrib'. Or should I be using different categories to track the cash IN to Quicken?

Thank you for the spreadsheet, I understand how to put the data in there, but what do you do with the spreadsheet after the data is entered? Do you copy and paste it to Quicken somehow?

As far as attaching my file, it is 290kb zipped. The limit is 102kb. :(

Lou
 
You must log in or register to reply here.

Similar threads

J
When to withdraw (public safety retiree)
Replies
13
Views
330
nasa1974
nasa1974
evilanne
Unrelated business taxable income (UBTI) & IRAs
Replies
0
Views
110
evilanne
evilanne
tsptalk
  • Article Article
Bullish momentum meets stubborn resistance
Replies
0
Views
106
tsptalk
tsptalk
P
Negative Adjustment Earnings
Replies
3
Views
316
nasa1974
nasa1974
D
Small Withdrawal Tax Amount?
Replies
8
Views
5K
evilanne
evilanne
Back
Top