General

Por Subíndices

Subíndices Total

Por Entidad Federativa

Alphacast Dashboards 

Alphacast

Indice de Competitividad Estatal

Overview

Global: Currency Composition of Official Foreign Exchange Reserves (COFER)

Historical Returns

Returns vs Benchmark

Single Asset Returns

Argentina: FCIs Portfolio Analysis

Interest Rates

Exchange Rate

BCRA Balance

Banking System

Monetary Aggregates

ROFEX

Public Securities Held by Banks

Argentina: Monetary & FX 

By Field

By Company

By Basin

Mexico: Oil Production

Por firma

Por firma y subtipo de seguro

Indicadores por firma

Balance por firma

Argentina: Seguros

# 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


Market's performances

FX-related charts

Markets and Bond-Implicit rates

MAVSA

Mutual Funds Industry

Repo BYMA

Treasury Auctions

Argentina: Financial Markets

Overview 

Soybean

Soybean Meal

Soybean Oil

Corn

Wheat

USA: CFTC Commitments of Traders

By Region

Demand

Generation

Prices

Seasonality by Industry

Seasonality by Province

Natural Gas Consumption

Mineral Carbon Consumption

Fuel Oil Consumption

Gas Oil Consumption

International Trade

Argentina: Electricity

Latest Report

Projections Over Time

Median & Central tendencies

Confidence Intervals

Participant's distribution

Risk Weightings

Uncertainty Assessments

United States: FOMC - Summary of Economic Projections

Summary

Job Openings

Total Separations

Hires

Quits

 Layoffs & Discharges

Other Separations

Establishment Size

United States: Job Openings & Labor Turnover Survey (JOLTS)

Personal Income & Its Disposition

Personal Consumption Expenditures

Real Wages & Salaries 

Real Earnings

United States: Personal Income & Real Earnings

Holders of US Treasury Securities

Net US Sales to Foreigners

Net US Purchases from Foreigners

TIC Historical Overall Net Inflows

TIC Historical Data by Holdership

Liabilities to All Foreign Residents

United States: Treasury International Capital (TIC) System

Incidencia

Victimización

Percepción

México: Seguridad  

Treasury Securities

Stripped Form Treasury Securities

Debt Subject to Limit

United States: Monthly Statement of the Public Debt

Receipts and Outlays

Deficit Financing or Surplus Disposition

Trust Fund Impact on Budget Results and Investment Holdings

Investments of Federal Government Accounts in Federal Securities

United States: Monthly Treasury Statement

National Accounts 

Incidence by component 

Activity Leading Indicator

Industrial Production

Construction

Headline & Core

Food & Housing Inflation

 Inflation Expectations

Unemployment Rate

Fiscal

Debt

Current Account

Confidence Indexes

G7 & China: Main Indicators

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)

Rendimientos

Rendimientos Ranking

AUMs

AUMs por activo

Flujos

Flujos tabla

Flujos tabla detalle

Portfolio Analysis por Categoria

Portfolio Analysis por FCI

Argentina: Fondos Comunes de Inversion

Volumen mensual

Argentina: MAVSA

Deposits Composition

Private Deposits 

Private Loans Composition

Argentina: Deposits & Loans

Long Term Rates

Spreads

United States: Treasury Rates

Operating Cash Balance

Public Debt Issues & Redemptions

Income Tax Refunds Issued

Deposits & Withdrawals of Operating Cash

United States: Daily Treasury Statement

# ARG - Dólar: Resumen de Mercado

Fuente en este [Pipeline](https://www.alphacast.io/pipelines/2022-8-24-Wqlrqq/view)

### **Ultima cotización / Histórico / Cotización a precios constantes**

@chart https://www.alphacast.io/p/marianosanchez/charts/cotizacion-dolar-11713?tab=chart&stackMode=absolute&year=latest

@chart https://www.alphacast.io/p/marianosanchez/charts/dolar-argentina-7053?tab=chart&stackMode=absolute&year=latest&time=2020-04-28..latest

@chart https://www.alphacast.io/p/marianosanchez/charts/tipos-de-cambio-precios-constantes-7108?tab=chart&stackMode=absolute&year=latest&time=2016-01-01..2022-07-01&country=ARG-1~ARG-6~ARG-4~ARG-5~ARG-7~ARG-3

### **Variacion diaria / Month-to-Date / Year-to-Date**

@chart https://www.alphacast.io/p/marianosanchez/charts/cotizacion-dolar:-1d-var-percent-11714?tab=chart&year=latest&stackMode=absolute

@chart https://www.alphacast.io/p/marianosanchez/charts/cotizacion-dolar:-mtd-var-percent-11718?tab=chart&year=latest&stackMode=absolute

@chart https://www.alphacast.io/p/marianosanchez/charts/cotizacion-dolar:-ytd-var-percent-11719?tab=chart&year=latest&stackMode=absolute


Dolares constantes

Argentina: Mercado Cambiario

Consumer Price Index

Core Consumer Price Index

Interest Rate

Gross Domestic Product

Fiscal Result

Trade Balance

Argentina: BCRA Market Expectations Survey

Historical Price & Volume

Fundamentals

Yield Curves

Relevant charts

Fundamental Comparatives

Snapshot Performance

Argentina: Fixed Income

Production

Global: USDA Outlook - Agro

---

Excel and Google Sheets allow you to add data from various sources. Below, we show you how to integrate Alphacast datasets into both tools.

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

### <ins>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

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/ab9fc845-fda6-4547-80e0-74902c63cbcc/image.png)

Select the **XLSX** format to integrate into Excel, and choose <ins>**Copy Link**</ins>

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/bb92f3d2-5817-48f5-8331-24ed83af4ac1/image.png)
*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*

### <ins>From a Pipeline</ins>

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.

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/bcde0b34-128d-48b5-80e1-07735db95477/image.png)

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/1efcfaa9-8f1c-43d3-a0da-205059d62ebd/image.png)

## 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! 

![chrome_uyIGgkuxvn.gif](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/b66c14d5-b77e-404e-9686-a0a6d80fed82/chrome_uyIGgkuxvn.gif)

When new data is updated, you just need to click on **Refresh**
![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/6e207204-d55b-4af2-bef7-aa46af0ec0cc/image.png)
 
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":
![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/201ddf64-24d9-4674-8382-75423528bc48/image.png)

The important setting is this one:
![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/2d7861b0-5873-44bb-9dbe-9342ea454e32/image.png)

### Google Sheets
It is VERY easy to connect any Alphacast dataset to Google Sheets and leave it connected to update itself.
 In Google Sheets type =IMPORTDATA() and paste the URL (the one copied earlier) inside the formula.


```
=IMPORTDATA("LINK CSV")
```


![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/40e4d156-4f0d-4807-9310-5a7e371dac13/image.png)

Change the format of the date column to date.

![image.png](https://alphacast-images.s3.us-west-2.amazonaws.com/next-s3-uploads/4a5026c4-0572-47b8-bc02-d7e343fd378b/image.png)

If the regional settings of your spreadsheet are in Spanish, you have to type =IMPORTDATA() and paste the URL (the one you copied earlier) inside the formula, and add ;",";"en-US" at the end.

```
=IMPORTDATA("LINK CSV";",";"en-US")
```


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


Alphacast Quick Tips

How to integrate Alphacast with Excel and Google Sheets

Vista General

Categorías

Divisiones

Expectativas

Precios Mayoristas

Precios Alimentos

Costos Construcción

Precios Seleccionados

Chile: Inflación

# Argentina's Fiscal dynamics Dashboard

### Take a look  at our [Argentina Macro Dashboard](https://www.alphacast.io/p/marianosanchez/insights/2022-5-2-YgOUGX) as well

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

@chart https://www.alphacast.io/p/alphacast/charts/total-income-vs-primary-expenditure-11650

@chart https://www.alphacast.io/p/alphacast/charts/fiscal-result:-primary-vs-total-5520

@chart https://www.alphacast.io/p/alphacast/charts/cumulative-primary-balance-11657

@chart https://www.alphacast.io/p/alphacast/charts/primary-expenditure-detail-11652

@chart https://www.alphacast.io/p/alphacast/charts/total-income-detail-11660

@chart https://www.alphacast.io/p/alphacast/charts/mecon-tax-revenue-11659