Alphacast Quick Tips

Step 1. Getting the URL link from the dataset or pipeline In the dataset, click on the Download button. Select the TSV format and choose Copy Link Alternatively, you can use the Data Snapshot link from any pipeline. Remember to choose the TSV link. Step 2. Integrating with Excel Open Excel on your Mac, go to the Data tab in the top menu bar. Click on Get Data (Power Query) and Select Get Data (Power Query) from the dropdown menu. Choose data source: Blank query from the options In the Connect to the data source tab, you need to paste the dataset URL and then run the following query. After that, press Next to visualize the table. Csv.Document(Web.Contents("https://api.alphacast.io/datasets/[datasetId]/data?apiKey=[YourAPIKEY]&$format=csv")) Finally, set up your table by selecting the first row as headers. Step 3. There is no step 3. Enjoy!

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" by selecting "usddaily", "usdmonthly" or whatever corresponds to the frequency and/or CCL_daily to convert to CCL. Important: This operation uses the "Country" field to identify the country and know which currency to use. In the case of the official currencies, use this reference dataset for the conversion, and in the case of the Argentine CCL...

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 from Census. Anyone who has also tried to seasonally adjust in Excel knows that it is cumbersome. Just for reference, about the reasons why it is important to deseasonalize the series for the analysis of the situation I wrote this article a while ago. Deseasonalize with Pipelines in Alphacast is very easy and includes only 4 steps: Fetch dataset Filter the columns we want to use (this is not strictly necessary) Step "Apply Transform", choosing the "Seasonal Adjustment" option Chart, download, or publish the dataset As an example, Let's see how to deseasonalize the Monthly Estimator of Economic Activity of Mexico -> This data and Argentina's EMAE -> This...