How to integrate Alphacast with Excel?

Excel allows adding data from different sources. Here you can find an alternative way to embed data into Excel, by using our TSV data source:

When you navigate through Datasets in Alphacast, you will find a Download link. If you filter variables, download links will consider variables selection, and only filtered variables will be downloaded. You will now find an option to download Tab Separated Values (TSV), which can make it easier to embed data into Excel:

Right-click on the TSV, CSV, or Excel Download link, and choose "Copy Link Address". You will notice the URL already has your personal api_key, and should not be shared publicly with other users, outside your team.

image.png

Within any pipeline, you can create a Data Snapshot to get a Download Link for the data up to that point.

Use that link and follow Step 2

image.png

image.png

Step 2. Now go to Excel, select Get Data -> From Other Sources -> From Web, and enter the URL you copied from the Alphacast website.

The Excel team published a super easy video, describing how to do it:


How to connect Alphacast data to Google Sheets?

It is VERY easy to connect any Alphacast dataset to Google Sheets and leave it connected to update itself.

Step 1. Find the data that interests you.

For example, the following dataset has the blue dollar of Argentina

https://www.alphacast.io/datasets/5288

Step 2. Filter the information you want to use. Google Sheet limits the information that can be downloaded to a maximum, so it is convenient to apply the filters you need.

image.png

Step 3. In Download press the right button where it says CSV and copy the address.

image.png

It will look like this

https://api.alphacast.io/datasets/5288/data?apiKey=YOUR_API_KEY&%24filter=%27Date%27+ge+2021-12-01T03%3A00%3A00.000Z&$format=csv

Step 4. In google sheets type +IMPORTDATA() and paste the URL the URL you copied earlier.

image.png

Step 5. Change the format of the date column to date

image.png

Step 6. There is no step 6. Enjoy!

Luciano Cohan

Written by

Luciano Cohan

Co-Fundador de Alphacast. Ex Subsecretario de Programación Macroeconómica. Data Science. Creando una plataforma para el trabajo colaborativo en economías

Related insights

  • Read more...

    How to integrate Alphacast with Excel for Mac?

    You will need the complete URL for the dataset that you want to integrate, which you can find by clicking the Download button and then copying (not downloading!) the URL attached to a TSV file.

    !

  • Read more... alphacast_logo_1.png

    8 amazing econdashboards you cannot miss!

    Stop spending your day copying & pasting data from sources that frequently change their formats, and get your charts updated right away.

    Dashboards are updated every day with the most recent data. Remember that you can copy and clone everything you see on those dashboards. Create your charts or pipelines to transform

  • Read more...

    How can I create a basic dashboard?

    Here you will find some examples that will be useful when building your own dashboard

    Saving charts on your clipboard

    Before you start creating your first dashboard, it's useful you preselect the charts that you want to work with using the clipboard. The clipboard allows you to have all the charts

  • Read more...

    A short guide to Argentina's Mutual Funds Industry Analysis

    In this short tutorial, we will guide you on calculating ranks of YTD Total Returns for different funds and management companies.

    Alphacast hosts a number of daily updated datasets of Argentinas Mutual Funds Industry. Two weeks ago we began publishing detailed datasets for based on CAFCI daily reports, mostly in

  • Read more...

    A short guide to Argentina's Financial and Monetary Data

    There are more than 2.000 datasets in Alphacast, and there are plenty of hidden gems. This is a short "Must see" guide for those interested in Argentina's financial and monetary data.

    **Would you like to know more?