Hands on: How to create Tables in Alphacast
By Florencia Hernández (fhernandez@alphacast.io) Find out more Alphacast Highlights here At Alphacast, we integrate automated pivot tables that can assist you in visualizing data and offering interactive content. Using this tool, you can summarize and analyze data series to make comparisons and easily identify patterns and trends among them with just a few clicks. Let's see how it works using stock market data as an example. The first step is to create a pipeline and do a Yahoo Finance Data Fetch incorporating the tickers we want to have in our table. As an example, we select some trending tickers. Prior to creating the table, you can transform, combine, and reshape the data. Before proceeding with the variable transformation, let's add one more step to keep only the Close column and remove the rest. As you can see, the data is daily, but if you wish, you can change the frequency using the change frequency step (see here) or perform any transformation that allows you to manipulate the data more easily (see Here). In this case, from the Apply Transform step, we will calculate the daily variation,7-day variation, and 30-day variation. Finally, we will filter the data to display the last...