Pipeline's Steps Library


- Data Sources

- Dataset Transforms

- Basic Arithmetics

- Finance

- Publish data

Data Sources

Fetch Dataset: This step allows you to choose the dataset to which the sequence of pipeline steps can be added. This step is already predefined and is usually the first step of a pipeline Learn More

Fetch Yahoo Finance: Yahoo Finance has information on hundreds of thousands of financial assets, stocks, bonds, ETFs, Indices, which are now easily accessible using Alphacast pipelines. Learn More

Fetch FRED: If you work with economic data you probably know FRED, the massive database created by the US Federal Reserve Bank of Saint Louis, that claims to have 816,000 US and international time series from 108 sources. You can now access all that data directly into Alphacast, using Alphacast pipelines.. Learn More

Dataset Transforms

Select Columns: This step allows to filter columns and reduce the number of data to be processed in the following step. The variable selector will show the data up to that point in the pipeline. Learn More

Rename Columns: the user can choose the name for each column by filling in the blank space to the right, or keeping the original name by leaving the space blank. Learn More

Regroup Entities: this step allows the user to remove an entity and regroup the data by the remaining ones selecting the formula to deal with the aggregation. Similar to "Group By" in other data frameworks such as Pandas or SQL. Learn More

Change Frequency: 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. When doing so the user has to select the aggregation formula if moving from higher to a lower frequency - such as average or end of the period - or the interpolation formula if moving from lower to higher, such as linear interpolation or splines. Learn More

Merge with Dataset: users can combine datasets through common entities. You can choose which and how the entities will match and the type of matching i.e. if there is no entity match, they can keep the data from the first dataset, the second, or both datasets, or if there is a match, only that data will remain in the pipeline Learn More

Wide to Long / Long to Wide: If you work with data you probably have come to the scenario where you have found the data you need but not in the shape that you need. A typical example is when data that should be row values are columns or otherwise, a situation that can not be solved by simply transposing the data. "Wide to Long" and "Long to Wide" steps are useful to solve this. Learn More

Append: Append is used to combine datasets with the same structure one on top of the other. Say, for example, that you have data for different months or years in different datasets and you need to combine them into a single dataset.

Basic Arithmetics

Calculate Variables: here the user will be able to perform different types of arithmetic, trigonometric and other functions on the variables of the previously selected dataset. For this, it is necessary to mention the name of the variable with the symbol @ and then type the name of the column.

Learn more here Full list of Available Functions

Apply Transform: In this step, the user will be able to make changes to the original data depending on the frequency of the data and combine the different transformations. Some of them make it possible to change the data from current prices to constant prices, deseasonalize time series, change from local currency to dollars, or even express them as a percentage of GDP or per capita. Variations can also be made month over month, year over year, the sum of 12 months, variations a year ago, and many more

Financial Analysis

Technical Analysis: With this step* users can estimate 130 metrics for Technical Analysis of financial assets, Metrics include a number of cycles, momentum, volatility, and volume Indicators, standard overlap studies, pattern recognition techniques, or statistics functions.Learn More

Debt Sustainability Analysis*. Alphacast has integrated into its platform a Debt Sustainability Analysis (DSA) Tool. Basically, this tool can help you forecast the Debt/GDP ratio of a country, taking into account specific characteristics such as growth, inflation, interest rates on domestic and foreign debt, exchange rate depreciation, and primary surplus. The tool also applies shocks to generate a fan-chart style chart so it can account for uncertainty in the forecasts. Click here to learn more

Portfolio Stats and Tear Sheets Calculator. Alphacast pipelines can be used to design and test portfolio and trading strategies. With the "Portfolio Analysis" Step on the pipeline editor, you can create tear-sheets from daily returns and also dynamic rolling stats for different timeframes. Learn More Here

Publish data

Publish to Dataset: allows the user to choose the name of the dataset and the repository where it will be stored

Luciano Cohan

Written by

Luciano Cohan

Co-Fundador de Alphacast. Ex Subsecretario de Programación Macroeconómica. Data Science. Creando una plataforma para el trabajo colaborativo en economías

Related insights

  •

    How to integrate Alphacast with Excel for Mac?

    You will need the complete URL for the dataset that you want to integrate, which you can find by clicking the Download button and then copying (not downloading!) the URL attached to a TSV file.


  • Read more... alphacast_logo_1.png

    8 amazing econdashboards you cannot miss!

    Stop spending your day copying & pasting data from sources that frequently change their formats, and get your charts updated right away.

    Dashboards are updated every day with the most recent data. Remember that you can copy and clone everything you see on those dashboards. Create your charts or pipelines to transform

  •

    How can I create a basic dashboard?

    Here you will find some examples that will be useful when building your own dashboard

    Saving charts on your clipboard

    Before you start creating your first dashboard, it's useful you preselect the charts that you want to work with using the clipboard. The clipboard allows you to have all the charts

  •

    A short guide to Argentina's Mutual Funds Industry Analysis

    In this short tutorial, we will guide you on calculating ranks of YTD Total Returns for different funds and management companies.

    Alphacast hosts a number of daily updated datasets of Argentinas Mutual Funds Industry. Two weeks ago we began publishing detailed datasets for based on CAFCI daily reports, mostly in

  •

    A short guide to Argentina's Financial and Monetary Data

    There are more than 2.000 datasets in Alphacast, and there are plenty of hidden gems. This is a short "Must see" guide for those interested in Argentina's financial and monetary data.

    **Would you like to know more?