CPI table
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
CPI table
Until sometime this year, there was a nice table at the Bureau of Labor Statistics website (http://www.bls.gov) that gave the CPI-U for every month of every year. Each month the table was updated. I found it extremely helpful for a spreadsheet I maintain that computes the proper coupon payments for TIPS bonds and other inflation-linked stuff like some SPIAs (I'm suspicious of financial institutions, by nature).
My link to that seems to be broken and I cannot find the table anymore. Perhaps it was just too simple, having all that data available in a nice concise table, to have withstood the test of time. Can anyone tell me if the data might still be available in as neat a form ?
The table looked VERy much like this:
http://www.usinflationcalculator.com/in ... 3-to-2008/
... which I notice is current only through April 2014 (perhaps corresponding to the month that my other link became broken).
Thanks.
My link to that seems to be broken and I cannot find the table anymore. Perhaps it was just too simple, having all that data available in a nice concise table, to have withstood the test of time. Can anyone tell me if the data might still be available in as neat a form ?
The table looked VERy much like this:
http://www.usinflationcalculator.com/in ... 3-to-2008/
... which I notice is current only through April 2014 (perhaps corresponding to the month that my other link became broken).
Thanks.
Re: CPI table
You have to ignore all the other tables.Table Containing History of CPI-U U.S. All Items Indexes and Annual Percent Changes From 1913 to Present is now available in the CPI Detailed Report as Table 24
Since you are updating your own table, do your really need the data from 1913? Wouldn't the current year's data suffice?
Re: CPI table
You can always get the last few years worth: Go to databases, top picks
http://www.bls.gov/cpi/#data
http://www.bls.gov/cpi/#data
- nisiprius
- Advisory Board
- Posts: 52211
- Joined: Thu Jul 26, 2007 9:33 am
- Location: The terrestrial, globular, planetary hunk of matter, flattened at the poles, is my abode.--O. Henry
Re: CPI table
Is this what you want?
http://www.bls.gov/cpi/cpifiles/cpiai.txt
Hmmm... only through January 2014 though.
See also Bureau of Labor Statistics FTP Server Migration Crosswalk
http://www.bls.gov/cpi/cpifiles/cpiai.txt
Hmmm... only through January 2014 though.
See also Bureau of Labor Statistics FTP Server Migration Crosswalk
Last edited by nisiprius on Tue Aug 12, 2014 6:49 pm, edited 1 time in total.
Annual income twenty pounds, annual expenditure nineteen nineteen and six, result happiness; Annual income twenty pounds, annual expenditure twenty pounds ought and six, result misery.
Re: CPI table
Probably, except it stopped in January (it is dated 02-20-2014 after the January numbers were released).
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
Re: CPI table
Exactly, hence my problem.sscritic wrote:Probably, except it stopped in January (it is dated 02-20-2014 after the January numbers were released).
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
Re: CPI table
Yes, Table 24 actually has ALL the stuff the old link had. It's just that Table 24 is actually a bunch of different tables, and I only saw the one that has each year. Sigh. Thanks all.sscritic wrote:You have to ignore all the other tables.Table Containing History of CPI-U U.S. All Items Indexes and Annual Percent Changes From 1913 to Present is now available in the CPI Detailed Report as Table 24
Since you are updating your own table, do your really need the data from 1913? Wouldn't the current year's data suffice?
Re: CPI table
I went to tables. I clicked on CPI Detailed Report (tables 1-29) June 2014 (PDF). I scrolled to Table 24. The first page shows every month from 1913 to 1969. The next page shows the annual numbers for the same years. The next page shows every month from 1970 to June 2014. The next page shows annual numbers for 1970 through the first half of 2014.
I don't know what you see.
P.S. I still like databases, top picks.
I don't know what you see.
P.S. I still like databases, top picks.
Re: CPI table
I noticed that the link ( ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt ) was broken some time ago. You can still get it (as other posters have mentioned) but it isn't easy.
* Actually there is a 0.1 or 0.2 difference between the figures on my table and the ones on the BLS table for Feb 2000 - Aug 2000. This is because the BLS shows corrected figures; but I show the the uncorrected figures that were used in computing inflation adjustments for TIPS and I Bonds. (See this BLS web page for more info.)
- First go to the CPI Tables section of the BLS web site.
- Open the latest month's complete tables PDF file. E.g., CPI Detailed Report (tables 1-29) June 2014 (PDF).
- Scroll to table 24.
* Actually there is a 0.1 or 0.2 difference between the figures on my table and the ones on the BLS table for Feb 2000 - Aug 2000. This is because the BLS shows corrected figures; but I show the the uncorrected figures that were used in computing inflation adjustments for TIPS and I Bonds. (See this BLS web page for more info.)
- nisiprius
- Advisory Board
- Posts: 52211
- Joined: Thu Jul 26, 2007 9:33 am
- Location: The terrestrial, globular, planetary hunk of matter, flattened at the poles, is my abode.--O. Henry
Re: CPI table
I haven't had good luck at all exporting tables in PDF files into a spreadsheet. I'd tried selecting, copying, and pasting into a text editor but, well, let's just say it doesn't come out the way I expect. Do either of you have any tips?
Annual income twenty pounds, annual expenditure nineteen nineteen and six, result happiness; Annual income twenty pounds, annual expenditure twenty pounds ought and six, result misery.
Re: CPI table
PDF's are a pain. They are even making them so you can't copy and paste into the compose box.
However, for this particular question, I still like databases, top picks. Here are the first six months of this year, and it pastes perfectly, here and in a spreadsheet.
233.916 234.781 236.293 237.072 237.900 238.343
However, for this particular question, I still like databases, top picks. Here are the first six months of this year, and it pastes perfectly, here and in a spreadsheet.
233.916 234.781 236.293 237.072 237.900 238.343
Re: CPI table
The other nice thing about databases, top picks is that they have the 1967 = 100 series, which is used by one of my pensions in protecting me against loss of purchasing power. Most of the time, you only see 1982-84 = 100.
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
Re: CPI table
That's what I see. Like I said, Table 24 is actually 4 separate tables. I think what it actually is is two separate tables, but the width including the annual number would not fit in the page width, so it wraps like that; apparently it was too much trouble to scale so the width fits.sscritic wrote:I went to tables. I clicked on CPI Detailed Report (tables 1-29) June 2014 (PDF). I scrolled to Table 24. The first page shows every month from 1913 to 1969. The next page shows the annual numbers for the same years. The next page shows every month from 1970 to June 2014. The next page shows annual numbers for 1970 through the first half of 2014.
I don't know what you see.
It's still ridiculous, IMHO, that the information is not also available in the old concise format.
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
Re: CPI table
Bingo, we have a winner.#Cruncher wrote: Or you could refer to a table I update each month with the same figures [ * ] going back to 1961.
Yep, the uncorrected figures, in your table, are what we want I believe.This is because the BLS shows corrected figures; but I show the the uncorrected figures that were used in computing inflation adjustments for TIPS and I Bonds. (See this BLS web page for more info.)
Re: CPI table
I still don't get why you need an update for 1913 every month. The numbers really shouldn't be changing. Have the 1913 numbers changed once since the 1982-84 resetting?
If you already have the 101 years from 1913 to 2013, why do you need a repeat every month? I keep track of the CPI-W for the social security COLA. Each month, I add one number, I don't go all the way back and reenter all the numbers I already have. Color me confused.
If you already have the 101 years from 1913 to 2013, why do you need a repeat every month? I keep track of the CPI-W for the social security COLA. Each month, I add one number, I don't go all the way back and reenter all the numbers I already have. Color me confused.
Re: CPI table
I had th same problem, so I found this one.
http://inflationdata.com/Inflation/Cons ... oaded=true
1210
http://inflationdata.com/Inflation/Cons ... oaded=true
1210
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
Re: CPI table
You're entirely correct, of course, as I update my spreadsheet several times per year. But I don't update it every month, so it was nice to be able to retrieve one bookmarked link and all the data I DO need was there. Now, I have to go to the link for the CPI tables, then click (and wait for) the huge PDF file, and then search for Table 24; and of course I have to do this twice if the months since I've last updated my spreadsheet span two different years.sscritic wrote:I still don't get why you need an update for 1913 every month. The numbers really shouldn't be changing. Have the 1913 numbers changed once since the 1982-84 resetting?
And it IS cool to have all historical years' average CPI's in one place, do when dufuses say things like "so and so only cost X back when men were men" you can easily show that it was actually more expensive then than it is now (maybe).
Re: CPI table
Have you looked at databases, hot picks? Here is 2013 and the first half of 2014. It's easy to copy and paste.
The last three columns are Annual, Half1, and Half2, which is why 2014 only has data for the second of the three. [Make your window nice and wide]
Code: Select all
2013 230.280 232.166 232.773 232.531 232.945 233.504 233.596 233.877 234.149 233.546 233.069 233.049 232.957 232.366 233.548
2014 233.916 234.781 236.293 237.072 237.900 238.343 236.384
Re: CPI table
Start at http://www.bls.gov/data/home.htm, in the row "All Urban Consumers" click on "Top Picks"; click the box "All Items" and click "Retrieve data"; click "More Formatting Options"; under year range, change start to 1913 and change output type to text and click "Retrieve data". Now copy/paste the comma-delimited data to a .csv file and open it in Excel.RustyShackleford wrote:Until sometime this year, there was a nice table at the Bureau of Labor Statistics website (http://www.bls.gov) that gave the CPI-U for every month of every year. Each month the table was updated. I found it extremely helpful for a spreadsheet I maintain that computes the proper coupon payments for TIPS bonds and other inflation-linked stuff like some SPIAs (I'm suspicious of financial institutions, by nature).
My link to that seems to be broken and I cannot find the table anymore. Perhaps it was just too simple, having all that data available in a nice concise table, to have withstood the test of time. Can anyone tell me if the data might still be available in as neat a form ?
The table looked VERy much like this:
http://www.usinflationcalculator.com/in ... 3-to-2008/
... which I notice is current only through April 2014 (perhaps corresponding to the month that my other link became broken).
Thanks.
Re: CPI table
Yes, that's one of about 20 CPI series you can choose from that page. To choose other series you can go to the multi-screen option, Create Customized Tables, and step through the following six screens:sscritic in [url=http://www.bogleheads.org/forum/viewtopic.php?p=2153351#p2153351]this post[/url] wrote:The other nice thing about databases, top picks is that they have the 1967 = 100 series, ...
- Seasonally adjusted / Not seasonally adjusted
- Geographical Area
- Alternate (1967=100) / Current (1982-84=100)
- Screen to select the specific series, e.g., All Items, Food, Energy
- Monthly / Semi-annual
- Screen that lists the codes for your selected series which can be copied and pasted in some text document for later use
Not Seasonally Adjusted:
Code: Select all
CUUR0000SA0
CUUR0000SA0L1E
CUUR0000SAF1
CUUR0000SA0E
Code: Select all
CUSR0000SA0
CUSR0000SA0L1E
CUSR0000SAF1
CUSR0000SA0E
It's not necessary to go to the "More Formatting Options" page. You can change the date range right on the main display page. And to get it into an Excel file you have two easier choices:Bill M in previous post wrote:... click "More Formatting Options"; under year range, change start to 1913 and change output type to text and click "Retrieve data". Now copy/paste the comma-delimited data to a .csv file and open it in Excel.
- Click the link that says "Download .xlsx"
- Copy and paste directly from the HTML table (this is hard the first time, but easy once you get the hang of it):
- Move the mouse cursor immediately to the left of the "Y" in "Year" (it will change from a pointer to a vertical "I" bar) and click.
- Hold down the shift key and move the mouse cursor immediately to the right of the last number in the last row and click (the whole table should now be selected).
- Press Ctrl-C to copy the selection.
- Open an Excel file and press Ctrl-V to paste. With many browsers and versions of Excel the table elements will automatically be pasted properly into separate cells. But if this doesn't work, choose Excel's Paste Special option and experiment with the various choices (e.g., HTML, Text, Unicode Text).
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
Re: CPI table
Wow, ok, thanks for explaining all that. Series code CUUR0000SA0 is clearly the one I want: it gives the numbers used for computing TIPS inflation-factors, for inflation adjustments for my AIG SPIA, and for coupon payments for my Sallie-Mae bonds (ticker ISM and OSM).
Still though, looks like I have to go to data.bls.gov/cgi-bin/srgate, then paste in the code and click next, then click retrieve data. I was really hoping for a single link that I could bookmark.
Oh well, looks like the one #Cruncher provided will do the trick, as long as he faithfully updates it.
Still though, looks like I have to go to data.bls.gov/cgi-bin/srgate, then paste in the code and click next, then click retrieve data. I was really hoping for a single link that I could bookmark.
Oh well, looks like the one #Cruncher provided will do the trick, as long as he faithfully updates it.
Re: CPI table
Try this one.RustyShackleford wrote:I was really hoping for a single link that I could bookmark.
http://research.stlouisfed.org/fred2/data/CPIAUCNS.txt
Ron
Money is fungible |
Abbreviations and Acronyms
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
Re: CPI table
Thanks.Oicuryy wrote:Try this one.RustyShackleford wrote:I was really hoping for a single link that I could bookmark.
http://research.stlouisfed.org/fred2/data/CPIAUCNS.txt
Ron
Re: CPI table
For those interested, this is just one of many data series from the Federal Reserve Economic Data (FRED) web site maintained by the Federal Reserve Bank of St. Louis. You can get to it and see what else is available through the following path:Oicuryy wrote:Try this one. http://research.stlouisfed.org/fred2/data/CPIAUCNS.txt
- Go to the web page, FRED Categories
- Scroll down to the sixth group, Prices, and click Consumer Price Indexes (CPI and PCE)
- Click Not Seasonally Adjusted under "Consumer Price Index for All Urban Consumers: All Items"
- Click View Data at top of left sidebar (this is the link provided by Oicuryy)
Re: CPI table
I had the same issue, a simple link that used to work, and now I learned to go to databases, top picks as several folks explained.
May I ask a question to the OP though? Why do you care about monthly updates? Why not wait for the end of the year update?
May I ask a question to the OP though? Why do you care about monthly updates? Why not wait for the end of the year update?
- RustyShackleford
- Posts: 1682
- Joined: Thu Sep 13, 2007 12:32 pm
- Location: NC
Re: CPI table
Not sure if you refer to an EOY update of the monthly figures, or just an EOY figure. Either way, it's because various coupon payments are based on monthly figures and because I'd like to compute those payments without having to wait 'til year's end.siamond wrote: May I ask a question to the OP though? Why do you care about monthly updates? Why not wait for the end of the year update?