Alphacast Quick Tips

By alphacast

Insights

Insights

How to convert a series to the official USD or Blue Chip Swap?

chart

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...

How is a Time Series seasonally adjusted?

chart

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...

How to merge the content of two datasets?

chart

Surely in your usual work with data, you needed to join several data sources and if your calculation tool is Excel you may solve it with some combination of the VLOOKUP, HLOOKUP, and/or MATCH formulas. Excel is a great solution in many cases, but it can be difficult in some scenarios. For example when... ...You have MANY rows. VLOOKUP can have performance issues and be very slow ...you need to search more than one field to combine the data ...the position of rows or columns changes ...you only need the data that is in both datasets ...some of the data sources change the number of rows and you have to copy or adjust the formulas. With Alphacast you can use pipelines to combine datasets and keep them connected. Step 1. Choose a data source To merge two datasets, first click the Create new button and choose pipeline. Once there use Fetch dataset to select the required dataset. You can also begin the process by clicking "Transform data" in the dataset you want to merge Step 2. Select the data source to "Merge" Then click Add step below and choose the option Merge with Dataset, there you select the dataset you...

See more

Pipelines

PipelineLast EditedEdit
Bitcoin Price11 months ago
See more