How to change the frequency of a dataset?
Each dataset has a frequency. They can be daily, weekly, monthly, quarterly, or yearly, This step is used to change that frequency and recalculate the values of the variables. With Change Frequency users can resample the time-frequency of the dataset moving from Daily to monthly, quarterly, and yearly back and forth.

Step 1. Create a pipeline and choose the data source
Step 2. add a "Change Sample Frequency" step. Once the step is selected the following Interface will appear. The system will automatically identify the input data frequency.

Step 3. Select the output data. This will define whether the step is an interpolation or Downscaling.
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.

These are examples of the different interpolation methods applied on the same input dataset.
Related insights
Read more...
Excel and Google Sheets allow you to add data from various sources. Below, we show you how to integrate Alphacast datasets into both tools.
Step 1. Getting the URL link from the dataset or pipeline
From a Dataset
First, filter the information you want to use from the Filter Data section and select the variables you need.
How to convert a series to the official USD or Blue Chip Swap?
The pipeline engine "Apply Transform" step incorporates a new transformation that allows changing the source unit: Convert to dollar official or to Blue Chip Swap (for Argentina only).
The pipeline is separated into Two steps
- Select ("Fetch") the dataset and its columns
- "Apply transform"
How is a Time Series seasonally adjusted?
Removing seasonality from time series is always complicated and laborious. The standard deseasonalization method is X-13ARIMA-SEATS or some other version of the methodologies maintained by the United States Census Bureau. Denationalizing usually includes using some application such as Eviews, Demetra or Stata or Python, combining it with the files that are downloaded