![import tsp csv to quicken import tsp csv to quicken](https://www.jumsoft.com/wordpress/wp-content/uploads/2017/03/Import.png)
I have consolidated all the historical fund prices into one file- you only need to import one file and you should have all the historical prices for C,F,G,I,S all the way back to 2003. Note: "Import Prices" will only show up if you have clicked on "Investing Center" on the tool-bar on the left side of the screen. Import the file into Quicken under File-> Import -> Import Prices.If you want to do the whole procedure yourself, follow all steps below. Note: If you use my TSP files to import data into Quicken, disregard steps 6-9. If you want to use the automated method, use instructions below. Enter prices manually (which would take forever). Save the file as a CVS (comma delimited). Importing historical TSP prices into Quicken isn’t too hard.Make sure that the date (column B) is in the M/DD/YYYY format (right-click on column and choose correct format under “Format Cells.”). If you open one of the files below, it will make more sense or at least give you an example. Open a new spreadsheet and put the fund-symbol you used in Step 5 in column A.Cut and paste the quarter’s worth of data into Excel.If you want to use my files below, use these fund names: Change the Symbol to something easy to remember, but it can’t conflict with an existing security name (i.e.Find your account, and right click on it.Click on “Portfolio” on top tool-bar, if you aren’t already there.This will show all your investment and accounts. Click on “Investment Center” on left tool bar.Go into Quicken and create a new investment.Importing historical TSP prices into Quicken isn’t too hard. The down-and-dirty instructions are below. The complete howto/instructions and the file are located here Howto: TSP and Quicken. That’s where ConnectWise Manage comes in to save. That’s not a recipe for success in our book, or any for that matter. Key insight is missing, teams can’t communicate, and revenue falls through the cracks. The more systems you use to manage your TSP, the harder it is to run it smoothly. The file contains prices for all TSP funds from 2003-present. Showing 22 open source projects for 'csv to ofx qif'.
![import tsp csv to quicken import tsp csv to quicken](https://us.v-cdn.net/6031128/uploads/userpics/615/nQ8QUJYHA2Z6J.jpg)
I have posted the updated file that allows you to easily import TSP fund-prices into Quicken.