May 2016:
March 2014:

Friday, April 24, 2020

Adding quarterly DPI



I can add quarterly DPI as the first series,
but I'm not able to add it as the second series.
I'm not done trying, but that's what I find so far.


I'm trying to get DPI, the quarterly series, the one that goes back to 1947:


(I'm only showing the upper part of the FRED window.)

I typed dpi into the FRED Search Box.  Three options came up: Two for Debt Service and one for DPI. I selected the last of these. Here's what I got:


(Again, only the upper part of the window is shown.)

I got the monthly series DSPI. The one that goes back to 1959. Not what I wanted.

If there was a chance for me to select which version of DPI I wanted, I didn't see it.

//

Okay. Try again. On a new FRED page, I search for dpi, but don't select anything, and press ENTER. I get two series for Debt Service and one for DPI, the monthly one again, but this time there is "1 other format" available -- the quarterly series that I'm looking for:


I clicked the one other format ("Quarterly...") and got the series I was looking for.

Okay, we're off to a good start.

Now, I want to add the quarterly DPI again, as the second series. Or actually, the problem came up because I started with some other series, then tried to add the quarterly DPI series as the second series for my calculation. Let's try that now.

I've got Total Currency and Deposits Including Money Market Fund Shares for the Household sector in a FRED graph already. But it is given as Percent of DPI and I want it in Billions. No problem, right? Multiply by DPI and divide by 100. So now I have to bring in the DPI series.

As you have seen, getting the monthly DPI series (DSPI) is no problem. And yes, FRED will automatically convert the monthly data to quarterly for me. But it only gives me data back to 1959, which means I lose all the information from the early and mid-1950s. And I find this unacceptable. So, here we are.






I type dpi in the "Add" field and three series are offered: TDSP, CDSP, and DSPI. The last of these is the monthly version of  DPI, the series I want.

If I type DPI (upper-case) in the "Add" field I get the same three series.

If I type disposable in the "Add" field I get a long list, including Debt Service series, Real DPI series, a Personal Saving series, a Net Worth series, and two DPI series -- the monthly one DSPI, and (last on the list) the annual series A067RC1A027NBEA.

But I still don't get the quarterly DPI series with the series name DPI.

Must be an oversight.

//

Here's the problem: I can add quarterly DPI as the first series, but I'm not able to add it as the second series.

No comments: