Vista general

por Cuenca

por Provincia

por Empresa

Alphacast Sample Repo

Alphacast

Argentina: Oil & Gas - Producción de Gas

Total Mercado

Cuotas x Trimestre

RKN x Producto (prima neta)

Peer Group

Resultado Tecnico

Sample Seguros

Summary

Job Openings

Total Separations

Hires

Quits

 Layoffs & Discharges

Other Separations

Establishment Size

Alphacast Dashboards 

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

Overview

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

Vista General

por Producto

por Origen/Destino

Argentina: Oil & Gas - Mercado Externo Crudo y Derivados

National Accounts 

Incidence by component 

Activity Leading Indicator

Industrial Production

Construction

Headline & Core

Food & Housing Inflation

 Inflation Expectations

Monetary Aggregates

Interest Rates

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

Cuenca

Gasoducto

Provincia

Distribuidora

Usuario

Rama de Actividad

Argentina: Oil & Gas - Transporte de Gas

Petróleo - por Cuenca

por Yacimiento

Gas - por Cuenca

Argentina: Oil & Gas - Reservas de Petróleo y Gas

Concepto

Objetivo

Empresa

Área de Concesión

Argentina: Oil & Gas - Pozos Perforados y Terminados

Mensual

Anual

Argentina: Oil & Gas - Actividad de Fractura Petróleo y Gas

Argentina: Oil & Gas - Precios de Gas Natural

Internacionales & Locales

Argentina: Oil & Gas - Precios de Petróleo Crudo

Datos diarios

por Localidad

Argentina: Oil & Gas - Precios en Surtidores

General

Productos Gaseosos en M m3

Productos Líquidos en m3

Productos Líquidos en Ton

Argentina: Oil & Gas - Venta de hidrocarburos

Argentina: Oil & Gas - Mercado Externo Gas natural y GNL 

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

Export Statements

Farmer Selling Table

Crushing

Agro Dashboard (Beta)

BBVA Seguros (Sinensup)

# 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

Exchange Rate

BCRA Balance

Banking System

ROFEX

Public Securities Held by Banks

Argentina: Monetary & FX 

Volumen mensual

Argentina: MAVSA

Por firma

Por firma y subtipo de seguro

Indicadores por firma

Balance por firma

Argentina: Seguros

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

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

Alphacast

@alphacast

Alphacast

@alphacast

Argentina: Oil & Gas - Producción de Gas

Sample Seguros

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

United States: Personal Income & Real Earnings

United States: Treasury International Capital (TIC) System

Real Earnings

México: Seguridad

United States: Monthly Statement of the Public Debt

United States: Monthly Treasury Statement

Argentina: Oil & Gas - Mercado Externo Crudo y Derivados

Alphacast

@alphacast

Alphacast

@alphacast

alphacast's insights

Argentina: Oil & Gas - Producción de Gas

Sample Seguros

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

United States: Personal Income & Real Earnings

United States: Treasury International Capital (TIC) System

Real Earnings

México: Seguridad

United States: Monthly Statement of the Public Debt

United States: Monthly Treasury Statement

Argentina: Oil & Gas - Mercado Externo Crudo y Derivados