How to connect to STATA or Power BI?

Connecting Alphacast to other tools is really simple using the following steps

When you navigate through Datasets in Alphacast, you will find a Download link (you have to be logged in). 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 Comma Separated Values (CSV):

Screen Shot 2021-08-03 at 12.31.17 PM.png

Right click on the CSV 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.

It will look like this

THE_URL = https://api.alphacast.io/datasets/5288/data?apiKey=YOUR_API_KEY&format=csv

Connecting to STATA

Data can be connected to STATA with a single line

insheet using "THE_URL"

Connecting to Power BI

Integrating Alphacast with Power BI is straightforward. 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.

Once you have the corresponding URL, you should click on “Get Data”, and then “Web”. powerbi1.png

Then paste the corresponding URL and click “Accept”. powerbi2.png

If the data previsualization looks ok, click “Load”. Otherwise, you can make changes by clicking on “Transform Data”. powerbi3.png

Tip: Check out the decimal separator before trying to integrate Alphacast with Power BI. Alphacast uses English configuration but if your Power BI uses Spanish configuration, it can cause problems because it will interpret commas as a decimal separator and periods as thousand separator. To address this, go to Settings & Configuration and change the regional configuration. You can change this globally (for all Power BI files) or locally (for a specific file).

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...

    Creating tables with Pipelines

    Our Pipelines feature is a powerful tool which allows report automatization. Let's say, for example, that you want to create an insight which shows dynamics of Argentina FX rates and a table with latest data, including percent changes. Wait! Did you just say "a table"!?

    **With Pipelines you can transform datasets in multiple ways (for

  • Read more...

    How can I create a Portfolio Tear-Sheet?

    Alphacast pipelines can be used to design and test portfolio and trading strategies. With the "Porfolio Analysis" Step on the pipeline editor you can create tear-sheets from daily returns and also dynamic rolling stats for different timeframes.

    image.png

    Step 1. Load the data and calculate a daily return variable.

    You can