Alphcast
byMiguel Saez
- 1 minute to read

How to integrate Alphacast with Excel for Mac

In the dataset, click on the Download button. Select the XLSX format and choose Copy Link

image.png

Alternatively, you can use the Data Snapshot link from any pipeline. Remember to choose the XLSX link.

Step 2. Integrating with Excel

Open Excel on your Mac, go to the Data tab in the top menu bar.

Click on Get Data (Power Query) and Select Get Data (Power Query) from the dropdown menu.

image.png

Choose data source: Blank query from the options

image.png

In the Connect to the data source tab, you need to paste the dataset URL and then run the following query. After that, press Next to visualize the table.

Excel.Workbook(Web.Contents("XLSX link"))

Alternatively, you may choose to use a CSV Link provided by Alphacast. To do so, you should use:

Csv.Document(Web.Contents("CSV link"))

image.png

Finally, set up your table by selecting the first row as headers. image.png

Step 3. There is no step 3. Enjoy!

Related insights

  • byluciano
    - 2 minutes to read

    Read more...

    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

    From a Dataset

    First, filter the information you want to use from the Filter Data section and select the variables you need.

  • byluciano
    - 1 minute to read

    Read more...

    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

    1. Select ("Fetch") the dataset and its columns
    2. "Apply transform"
  • byluciano
    - 1 minute to read

    Read more...

    How is a Time Series seasonally adjusted?

    Removing seasonality from time series is always complicated and laborious. The standard deseasonalization method is X-13ARIMA-SEATS or some other version of the methodologies maintained by the United States Census Bureau. Denationalizing usually includes using some application such as Eviews, Demetra or Stata or Python, combining it with the files that are downloaded

  • byluciano
    - 3 minutes to read

    Read more...

    How to merge the content of two datasets?

    Surely in your usual work with data, you needed to join several data sources and if your calculation tool is Excel you may solve it with some combination of the VLOOKUP, HLOOKUP, and/or MATCH formulas. Excel is a great solution in many cases, but it can be difficult in some scenarios.