Luciano Cohan
@luciano
Co-Fundador de Alphacast. Ex Subsecretario de Programación Macroeconómica. Data Science. Creando una plataforma para el trabajo colaborativo en economías
Luciano Cohan
@luciano
Co-Fundador de Alphacast. Ex Subsecretario de Programación Macroeconómica. Data Science. Creando una plataforma para el trabajo colaborativo en economías
luciano's insights
Diverging paths ahead in global economy
~Major Advanced Economies (G7)~Other Advanced Economies)
As we move beyond the pandemic, economic growth rates have become less synchronized and have not yet recovered to pre-shock trends. While, for example, growth is strong in the USA, Latin America, or India, it is one step lower in some regions and countries such as China, and the Euro Area. Inflation Rates Comparison Global inflation surged during the pandemic recovery, but recent trends reveal varied inflation rates, with some countries managing to stabilize prices more effectively than others. The 0%-2% range of inflation in the past has now shifted to 2%-4%, even in Japan. Monetary Policy Divergence Monetary policies diverge as countries tailor their approaches to unique economic circumstances. For instance, the US is expected to cut rates, while Japan plans to raise rates by October. US Economic Performance The US economy has outperformed other developed markets, growing at or above trend. However, inflation, particularly driven by housing prices, remains a significant concern. European Economic Struggles Europe's economic performance has lagged, with weaker GDP and consumer spending. Climate change, demographics, and Brexit continue to hinder growth. Japan's Economic Prospects Japan is set to raise interest rates in October, driven by efforts to create domestic inflation and a virtuous cycle...
How to integrate Alphacast with Excel and Google Sheets
From a Dataset First of all, filter the information you want to use. Excel and Google Sheet limit the information that can be downloaded to a maximum, so it is convenient to apply the filters you need. Once you've done the filter, click on the Download button. Then select the format you want: TSV (for integrations with Excel for Mac), CSV, or Excel and choose Copy Link. You will notice the URL already has your personal API key (which should not be shared publicly with other 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! 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)...
How to convert a series to the official USD or Blue Chip Swap?
The pipeline engine "Apply Transform" step incorporates a new transformation that allows changing the source unit: Convert to dollar official or to Blue Chip Swap (for Argentina only). The pipeline is separated into Two steps Select ("Fetch") the dataset and its columns "Apply transform" by selecting "usddaily", "usdmonthly" or whatever corresponds to the frequency and/or CCL_daily to convert to CCL. Important: This operation uses the "Country" field to identify the country and know which currency to use. In the case of the official currencies, use this reference dataset for the conversion, and in the case of the Argentine CCL...
