Alphacast Quick Tips

From a Dataset First, filter the information you want to use from the Filter Data section and select the variables you need. Then, click on the Download button Select the XLSX format to integrate into Excel, and choose Copy Link You will notice that the URL you copied already contains your personal API key, which should not be shared publicly or with users outside your team From a Pipeline Within any pipeline, you can create a Data Snapshot to get a Download Link for the data up to that point. Use the XLSX Download link and follow Step 2. Step 2. Integrating to Excel or Google Sheets Excel Now go to Excel, select Get Data > From Other Sources > From Web, and enter the URL you copied from the Alphacast website. The following GIF guides you through a successful Excel integration! When new data is updated, you just need to click on "Refresh". To ensure the date format is not lost during the update, make sure the "Preserve Cell Formatting" option is enabled. After you loaded the query into the sheet, go into the "Table Tools" tab and click "Properties": The important setting is this one: Google Sheets It...

In the dataset, click on the Download button. Select the XLSX format and choose Copy Link Alternatively, you can use the Data Snapshot link from any pipeline. Remember to choose the XLSX 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. Excel.Workbook(Web.Contents("XLSX link")) Alternatively, you may choose to use a CSV Link provided by Alphacast. To do so, you should use: Csv.Document(Web.Contents("CSV link")) Finally, set up your table by selecting the first row as headers. Step 3. There is no step 3....

By Francisco Fernandez More Alphacast Highlights available at this link The Argentine economy has a significant part of its production, employment, and consumption destined to Small and Medium Enterprises (SMEs). To understand their economic and financial situation, especially considering the scarcity of relevant high frequency official statistics, it is possible to use data on their financing. For this special segment of the economy, ECHEQs are fundamental - and Alphacast has a real-time updated Stock Market dataset of them, discriminating by maturity, asset type, and currency. The complexity of the dataset, in addition to the amount of data and variables available, makes it crucial to know how to process and analyze them. Therefore, in this hands-on guide, we will show how to filter the data, transform them, and present them graphically for their best use. For this, we will use the Alphacast pipeline engine to transform and plot data from guaranteed ECHEQs. Since the source is available in our database, the information is updated regularly and automatically, as soon as it is made public - both in the original dataset and in all uses. Step by step First, we start by creating a pipeline. This is simple: select "create new", then...