Part 2. Changing Frequency and Units
Step by Step Guide: How to change Frequency & Units
01. To create a pipeline, click on Create Pipeline at the top right corner. Select a name and a repository for it, then choose Yahoo Finance Fetch. Select the Ticker you what to. In our example, we will choose GOOC
02. Adding the Change Frequency step to select your daily data and convert it to either monthly, quarterly, or yearly data. In this example, we will select the Close column and we will change the frequency by selecting a formula for monthly data.
When going from a lower frequency to a higher frequency (i.e. monthly to daily) you have to select from the 8 interpolation options: Repeat the value, linear interpolation, quadratic, cubic, polynomial, and piecewise, Splines and Krogh interpolation.
Alternatively, when going from higher to lower (I,e. monthly to quarterly) there are 6 options: average all the values, sum, select the min or max, or the last and first.
03. To Change the units of a dataset, we need to use the Apply Country Trasform. It will recognize the frequency of your dataset, and the available options will depend on it. The usual options include changing the unit to constant prices, percentage of GDP, dollars, or per capita.
For this example, we will remove the effect of inflation on prices: