Evolución de la Capacidad Prestable en Dólares

Alphacast

FX Market

Global Outlook

Country Deep Dive

Daily REER

Global Map

Regional Trends

Methodology

Alphacast Real Effective Exchange Rate (REER)

Global Real Effective Exchange Rates (REER) Dashboard

Vista General

Data Histórica

Categorías

Divisiones

Expectativas

IPCBA

Precios Mayoristas

Precios Seleccionados

Costo Construcción

Canasta Básica

Alphacast Dashboards 

Argentina: Inflación Dashboard

General

Historical Price & Volume

Fundamentals

Yield Curves

Relevant charts

Fundamental Comparatives

Snapshot Performance

Argentina: Fixed Income

Interest Rates

Exchange Rate

BCRA Balance

Banking System

Monetary Aggregates

ROFEX

Public Securities Held by Banks

Argentina: Monetary & FX 

Tables

LAC Economic Update

# Argentina's Fiscal Dashboard

## Tax Revenue

@chart https://charts.alphacast.io/p/alphacast/argentina-macro-basics/mecon---payroll-activity-trade-related-taxes?tab=chart&year=latest

@chart https://charts.alphacast.io/p/alphacast/argentina-macro-basics/fiscal-argentina-tax-revenue-by-tax?tab=chart&stackMode=absolute&year=latest

## Fiscal Expenditure, Income, and results

@chart https://charts.alphacast.io/p/alphacast/argentina-macro-basics/argentina-fiscal-result?tab=chart&stackMode=absolute&year=latest

@chart https://charts.alphacast.io/p/alphacast/argentina-macro-basics/ingresos-totales-y-gasto-primario?tab=chart&stackMode=absolute&year=latest&time=2017-05-01..latest

@chart https://charts.alphacast.io/p/alphacast/argentina-macro-basics/primary-expenditure-detail-consatan-prices-sa?tab=chart&stackMode=absolute&year=latest

@chart https://charts.alphacast.io/p/seido/seido-macro-dashboards/transfers-to-treasury-?tab=chart&stackMode=absolute&year=latest

## Debt management & Profile

@chart https://charts.alphacast.io/p/seido/macro-research/fiscal-argentina-cumulative-rollover-rate?tab=chart&stackMode=absolute&year=latest&time=2021-01-18..latest

@chart https://charts.alphacast.io/p/seido/macro-research/fiscal-argentina-debt-auctions-results?tab=chart&stackMode=absolute&year=latest&time=earliest..latest

@chart https://charts.alphacast.io/p/seido/macro-research/argentina-public-net-debt-profile-2021-22-ars?tab=chart&stackMode=absolute&year=latest 

@chart https://charts.alphacast.io/p/seido/macro-research/argentina-public-net-debt-profile-2021-22-ars-stacked?tab=chart&stackMode=absolute&year=latest&time=2022-03-01..latest

@chart https://charts.alphacast.io/p/seido/macro-research/fiscal---argentina---debt-auctions---monthly-forecast?tab=chart&stackMode=absolute&year=latest


Tax Revenue

Fiscal Expenditure, Income, and Results

Debt Management & Profile

Argentina: Fiscal Trends

 Argentina: Precios Mayoristas vs Salarios

Data Reciente

Resumen Histórico

Desagregado por Producto

Desagregado por Socio Comercial

Desagregado por Producto (mensual)

Desagregado por Socio Comercial (mensual)

México: Comercio Exterior

By Maturity

By Interest Rate

By Credit Rating

Mexico Debt Securities Holdings

Line Charts

Bar Chart

Area Charts

Scatter Plots

Combined Charts

Pie Charts

Annotations

Maps

Decks

AI Summary

Charts and Maps Library

Precios

Precios Alimentos 

Precios al Productor y de la Construcción

Expectativas de Inflación 

Salarios

Combustibles

Vivienda

México: Inflación

Cotizaciones 

Comercialización

DJVE

Liquidación U$S

Camiones arribados

Stock granos

Fletes

Molienda

Exportaciones

Producción 

Argentina: Sector Agropecuario

Card Consumption

Card and Cash Consumption

Investment

External Sector

Sectoral Activity

BBVA High Frequency Data

# *Hands On*: How to use Alphacast to monitor SME financing?

By [Francisco Fernandez](https://www.alphacast.io/p/franciscofernandez) 

---

## [More Alphacast Highlights available at this link](https://www.alphacast.io/repositories/alphacast-highlights-5090/insights)

---

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](https://www.alphacast.io/datasets/markets-argentina-mavsa-cdp-echeq-endorsed-12822) 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 "pipeline", and it is given a name and a location. The name is up to you, but it should be convenient and easy to find - for making changes or troubleshooting, even if it is public. The location simply determines whether the dataset is public (visible to all users) or private (visible to users with access) - this is relevant especially if you want other users to be able to edit it. 

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/fcf88a08-3b98-493f-848e-e304eb1d380a/image.png)

The second step is to **select the dataset**. It is available [here](https://www.alphacast.io/pipelines/2022-9-2-aSBuyZ/view), and first no variable is filtered, as it is organized by entities. It is not recommended, if available, to use "raw data" versions of the datasets, as they are not organized or processed. 

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/032fc2d0-971e-421d-a349-9604b1ee8ed9/image.png)

The third step is the most complex; it involves calculating a variable corresponding to the **Plazo** (term) of each ECHEQ. For this, a chained conditional formula is used: if the term is greater than, less than, and/or equal to a certain duration, it is named as that duration. For example, the first *if statement* (if(@Plazo<=30, '<30d',...) means "if the term is less than or equal to 30 (days), the variable is named '<30d'"; what follows is if the term is not of that duration, which is several chained conditionals for each desired duration. 

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/6bb9a1c5-8c3d-4278-b2b1-a0c67efd2bd0/image.png)

The next step is to **filter columns**; not all of the original dataset is of interest. In this case, all are used except "vencimiento" (maturity), which is not an analysis dimension you want to use. 

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/2fd932ae-5d22-4741-a877-575d689948d5/image.png)

Next, we go to **regroup entities**. The objective in this step is to reclassify the usage variables according to the term variable used; first "maturity" is selected as the filter, and then a form of regrouping is applied to the rest of the variables in the dataset - such that the sorting by entity occurs on the basis of *maturity* and not on the basis of, for example, currency. 

Now, the dataset has the desired format; it is possible, then, to use it for analysis and to plot the relationships between variables. A first option is to **calculate the term in days** and then verify its relationship with the average rate; the way to do this is as follows:

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/2cfbe125-7c76-40d5-bcbf-1e51ebbd1651/image.png)

Finally, a chart of this relationship may be created:

@chart https://www.alphacast.io/p/alphacast/charts/mavsa-echeq-discount-guaranteed-by-sgr-18999?tab=chart&stackMode=absolute&year=latest&time=latest&country=121-150d~151-180d~181-210d~211-240d~241-270d~270-300d~31-60d~301-330d~61-90d~91-120d~%3C30d~%3E331d

The next step is to work with the entities again, so that the data can be presented in a more appropriate way for the next chart to be worked on. The transformation is analogous to the previous one, but in the opposite direction - so that you "ungroup" by time frame and regroup the bulk of the checks. In this way, the following chart is created:

@chart https://www.alphacast.io/p/alphacast/charts/mavsa-echeq-discount-guaranteed-by-sgr-19006?tab=chart&stackMode=absolute&year=latest&country=undefined-0~undefined-1~undefined-2~undefined-3

This procedure allows a simpler visualization of two key variables of interest for the understanding of the financial situation of Argentine SMEs. It can be extended to other types of ECHEQs also available in Alphacast - [guaranteed](https://www.alphacast.io/datasets/markets-argentina-mavsa-cdp-echeq-guaranteed-12823) and [not guaranteed](https://www.alphacast.io/datasets/markets-argentina-mavsa-cdp-echeq-non-guaranteed-12824) - with the same format and the same indications, so that creating, for example, a *dashboard* of SME ECHEQs would be trivial. The [MAVSA](https://www.alphacast.io/repositories/mercado-de-valores-argentino-s-a-masva-6587/datasets) repository, at the same time, has the three datasets already mentioned, and others for different means of financing, such as [Promissory notes](https://www.alphacast.io/datasets/markets-argentina-mavsa-pagare-endorsed-12826). 


Alphacast Quick Tips

Hands On: How to use Alphacast to monitor SMEs financing?

Alphacast Templates

Combiná datos de varias fuentes y países

Safety and Hygiene

People

Marketing

Hydrogeology

Supply Chain

Macroeconomic Context

Financial Investments

Alphacast CS - Demo

Vista general

por Cuenca

por Provincia

por Empresa

Alphacast Sample Repo

Argentina: Oil & Gas - Producción de Petróleo

Actividad

Producción & Consumo

Argentina: Construcción 

## Step 1. Getting the URL link from the dataset or pipeline

 In the dataset, click on the **Download** button. Select the **XLSX** format and choose **Copy Link**  

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/d621697c-cd7b-4ec3-9f61-0e73a5d08765/image.png)

Alternatively, you can use the **Data Snapshot** link from any pipeline. Remember to choose the **XLSX link.**

## Step 2. Integrating with Excel

**Open Exce**l 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.

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/34b3abb7-e863-42f3-b28a-0842038d5880/image.png)

Choose data source: **Blank query** from the options

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/3301ed8b-2a2f-4558-b091-c48780c6add0/image.png)

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"))
```

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/08a34c5f-ef53-48af-b271-b58231500dfd/image.png)

Then, double-click on "Table" to open the data in the Power Query editor:
![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/56a9ff89-a075-4a79-8c2d-b6064f41ff46/image.png)

Finally, set up your table by selecting the **first row as headers.**
![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/2d6203f5-e7f3-44e1-b750-eea8575b48cd/image.png)

## Step 3. There is no step 3. Enjoy!

How to integrate Alphacast with Excel for Mac

Por Subíndices

Subíndices Total

Por Entidad Federativa

Indice de Competitividad Estatal

By Laboratory

By Brand

Precios de medicamentos

Energy

Grains

Metals

Overview

Global: Commodities

Historical Returns

Returns vs Benchmark

Single Asset Returns

Portfolio Analysis Dashboard by Asset Class

Balance Cambiario (BC)

BC - Por Sector

BC - Weight por Sector

Cuenta Corriente - Tablas

Cuenta Corriente - Graficos

Cuenta Financiera - Tablas

Cuenta Financiera - Graficos

Argentina: Mercado Único y Libre de Cambios (MULC)

Analytics portafolio

Modelo

by Car Type

by Insurer

by Insurer and Coverage

Argentina Car Insurance Price Monitoring

Argentina - Car Insurance Prices

Monitor de Trigo

# Argentina's Financial Markets Overview

## Other agro dashboards for Argentina: [Macro](https://www.alphacast.io/p/marianosanchez/insights/2022-5-2-YgOUGX) - [Mutual Funds ](https://www.alphacast.io/p/luciano/insights/2022-6-1-QrlHVe?utm_source=content&utm_medium=mail&utm_campaign=fci_argentina&utm_id=fci_argentina) - [Fiscal](https://www.alphacast.io/p/marianosanchez/insights/2022-7-1-azOLJP)

This dashboard was created with Alphacast. Alphacast hosts hundreds of Datasets to keep track of commodity markets. **Dashboards are updated every day with the most recent data.** Click on any chart to make it interactive, and clip it to add it to your own dashboards. You can also create your own charts or use pipelines to transform the data. Feel free to reuse everything at will.

### **Follow this [simple guide](https://www.alphacast.io/p/chia/insights/2022-7-4-LVTtYl) - or [video](https://www.youtube.com/watch?v=44CfbpD18IQ) - to learn how to create a dashboard**

## Market's performances

@chart https://www.alphacast.io/p/alphacast/charts/globals-boncers-ccl-s-p-merval-ccl-11846?tab=chart&year=latest&time=2021-10-27..latest

@chart https://www.alphacast.io/p/alphacast/charts/bonds-and-equity-ytd-11867?tab=chart&stackMode=absolute&year=latest

@chart https://www.alphacast.io/p/alphacast/charts/arg-vs-em-bonds-11848?tab=chart&year=latest&time=2020-12-31..latest

@chart https://www.alphacast.io/p/alphacast/charts/arg-vs-latam-equity-performance-11849

@chart https://www.alphacast.io/p/alphacast/charts/argentina-bonds-parities-11847?tab=chart&stackMode=absolute&year=latest&time=2020-09-15..latest

@chart https://www.alphacast.io/p/alphacast/charts/arg-s-risk-premium-breakdown-11855

## FX-related charts

@chart https://www.alphacast.io/p/alphacast/charts/fx-rates-ytd-11878?tab=chart&stackMode=absolute&year=latest

@chart https://www.alphacast.io/p/alphacast/charts/currencies-ytd-11874?tab=chart&year=latest&stackMode=absolute

@chart https://www.alphacast.io/p/alphacast/charts/fx-premiums-11892?tab=chart&year=latest&stackMode=absolute

@chart https://www.alphacast.io/p/marianosanchez/charts/reservas-netas-nir-meta-fmi-11631?tab=chart&stackMode=absolute&time=earliest..2022-12-31&region=World

@chart https://www.alphacast.io/p/alphacast/charts/bcra-fx-intervention-ytd-11843?tab=chart&year=latest&time=2021-12-20..latest

@chart https://www.alphacast.io/p/alphacast/charts/bcra-futures-position-11842?tab=chart&year=latest&stackMode=absolute

@chart https://www.alphacast.io/p/alphacast/charts/rofex-mae-total-open-interest-11844?tab=chart&stackMode=absolute&year=latest&time=2018-07-01..latest

## Markets and Bond-Implicit rates

@chart https://www.alphacast.io/p/alphacast/charts/argentina-market-implicit-inflation-11851?tab=chart&stackMode=absolute&year=latest&time=2021-02-18..latest

@chart https://www.alphacast.io/p/alphacast/charts/bcra-s-rem-inflation-expectations-11852?tab=chart&stackMode=absolute&year=latest&time=2020-11-30..latest

@chart https://www.alphacast.io/p/alphacast/charts/rofex-and-bond-s-implicit-fx-depreciation-rate-11853?tab=chart&stackMode=absolute&year=latest&time=2021-09-29..latest

@chart https://www.alphacast.io/p/alphacast/charts/argentina-boncers-forwards-rate-11854?tab=chart&stackMode=absolute&year=latest&time=2021-07-23..latest

@chart https://www.alphacast.io/p/alphacast/charts/nominal-interest-rates-11890?tab=chart&stackMode=absolute&year=latest&time=2019-12-27..latest 

@chart https://www.alphacast.io/p/alphacast/charts/argentina-nominal-interest-rates-vs-inflation-11901?tab=chart&year=latest&stackMode=absolute

## Mutual Funds Industry

@chart https://www.alphacast.io/p/alphacast/charts/assets-under-managment-total-industry-11664?tab=chart&stackMode=absolute&year=latest

@chart https://www.alphacast.io/p/alphacast/charts/change-in-aum-price-and-suscription-effect-10979?tab=chart&stackMode=absolute&year=latest&time=earliest..latest

@chart https://www.alphacast.io/p/alphacast/charts/subscriptions-per-category-10984?tab=chart&stackMode=absolute&year=latest&time=latest


Alphacast

@alphacast

Alphacast

@alphacast

Evolución de la Capacidad Prestable en Dólares

Global Real Effective Exchange Rates (REER) Dashboard

Argentina: Inflación Dashboard

Argentina: Fixed Income

Argentina: Monetary & FX

LAC Economic Update

Argentina: Fiscal Trends

Argentina: Precios Mayoristas vs Salarios

México: Comercio Exterior

Mexico Debt Securities Holdings

Alphacast

@alphacast

Alphacast

@alphacast

alphacast's insights

Evolución de la Capacidad Prestable en Dólares

Global Real Effective Exchange Rates (REER) Dashboard

Argentina: Inflación Dashboard

Argentina: Fixed Income

Argentina: Monetary & FX

LAC Economic Update

Argentina: Fiscal Trends

Argentina: Precios Mayoristas vs Salarios

México: Comercio Exterior

Mexico Debt Securities Holdings