Miguel Saez

@masaez

One of the guys building Alphacast. Hope you enjoy it!

Joined
March 2021

masaez's insights

  • masaez

     - 1 minute to read

    Importing data on Excel for Mac

    chart

    Step 1. Getting the URL link from the dataset or pipeline In the dataset, click on the Download button. Select the TSV format and choose Copy Link Alternatively, you can use the Data Snapshot link from any pipeline. Remember to choose the TSV 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. Choose data source: Blank query from the options 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. Csv.Document(Web.Contents("https://api.alphacast.io/datasets/[datasetId]/data?apiKey=[YourAPIKEY]&$format=csv")) Finally, set up your table by selecting the first row as headers. Step 3. There is no step 3. Enjoy!

  • masaez

     - 1 minute to read

    Supporting internal links

    This is a link This is a link to a second header To a First Header Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum To a Second Header Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est...

  • masaez

     - 1 minute to read

    Links

    link link 2 Sample Another sample more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more more...

  • masaez

     - 1 minute to read

    How to create your insights

    chart

    Basic insights can be created by combining headers, charts, and images. Headers can be included by using #, ##, ###, Alphacast charts can be included by using '@chart' and '@Ncharts' Images can be inserted using the icon in the toolbar above Explore the toolbar for more options: Bold, Italic, Underline, ~Striketgeough~ and more. This is an Example Insight to paste an interactive chart, write '@chart' and find your chart and copy everything in the URL after https://charts.alphacast.io/grapher/ To add multiple charts use the command '@Ncharts" and paste multiple charts separated by a space Insights are created with Markdown language. For a full reference of markdown, features see here...

  • masaez

     - 2 minutes to read

    Alphacast Friday Update - January 14th, 2022

    chart

    As we presented in our previous update, we kept working on our new pipelines engine. We have now reached features parity with our previous engine, so we are ready to start testing internally before we launch it to everyone. In this update, we are showing how some of the new features compare with our previous ones, and we hope you will find the new experience easier (and more fun) to use: Pipeline Migrations We have automated the migration of our previous pipelines definitions. This means that once we launch the new pipelines platform, you will be able to edit your previously created pipelines, and extend them with new features included in the new platform (such as merge dataset). As an example, check the "lineal combination" definition in our previous admin tool: Compared to the "Calculate Variable" step, with the given calculation already migrated: Datasets search When creating a pipeline, you usually need to indicate where data will come from, and where it should go to. In the past, you would need to remember in which repository your dataset was stored, in order to select it: We are now using our Search Engine, and as you start typing the name of...

  • masaez

     - 3 minutes to read

    Alphacast Friday Update - January 7th, 2022

    chart

    Happy New Year! 2021 was great. In December, we took a couple of days to work on planning for 2022, and we are already at full speed working on new features. Check out our latest updates: New Pipelines Editor We are working on a new Pipelines Editor. This is a really ambitious project, that will change dramatically the way data can be processed within the platform. You will be able to create complex and powerful pipelines, process, merge, transform the data. Apply models, forecasting methods, and even create your own pythonic scripts. So here are a few first peaks at the editor. Stay tuned! Merge Datasets Probably the most requested feature we had from many customers. Alphacast already saves a lot of work to our users by providing easy access to financial and economic data. But combining data in Excel is still a lot of work, and you need to deal with multiple sheets or files at the same time. The new pipeline editor allows to merge with a given Dataset, allowing to indicate how the matching should be done. Calculate Variables Our current pipelines editor allows defining simple linear combinations between variables within a dataset. We have taken a...

  • masaez

     - 3 minutes to read

    Alphacast Friday Update - September 3rd

    chart

    Hi friends! This was an exciting week with lots of updates on multiple fronts. As we remain focused on our upcoming Marketplace release, we also have other news to share: Webinars: It's a wrap! We are super grateful for the community response we had with our first Webinars series. We had almost 400 people registered to the series, and all videos are available for on-demand view. We want to thank our dev-economists rockstars Lionel, Juani, and Macarena for pushing an extra mile to deliver these series: Webinar #1: https://youtu.be/EjJAnpDmJdI Datasets, Charts, transformations and Dashboards. Webinar #2 : https://youtu.be/FQIte7hb0Es Integrating Alphacast with R. Webinar #3: https://youtu.be/yT8RoIFAy7Y Integrating Alphacast with Python. Webinar #4: https://youtu.be/Qhwp8J2uOMU Data Scrapping, transforming data with Alphacast API & Power BI Integration New Profile Views As we keep working to roll out the Alphacast Marketplace, we have updated users' and teams' profile views to highlight our partners' branding. Link sharing for repository access You can now invite colleagues to your repositories by exchanging invite links. If its a new user, the person will be invited to create an account, and will then be granted access to the repository: New API Coming Up next week Some of our Marketplace partners...

  • masaez

     - 2 minutes to read

    Alphacast Friday Update - August 27th

    Another week is coming to an end. We had a great response to our Beta Testing call for the Marketplace. We don't want to overhype but big players already confirmed to be part of it. On top of that, let us share some other great news. Webinars, Brazil, and ALPHATON We had our third Webinar in the Cycle "Automatizing Economic Analysis" this time about integration with Python, APIs, pipelines, and transformations. Miguel Saez had an open architecture discussion showing some working of our data engine. First Webinar 1: https://youtu.be/EjJAnpDmJdI Second Webinar 2: https://youtu.be/FQIte7hb0Es Third Webinar 3: https://youtu.be/yT8RoIFAy7Y Next week we will have the last webinar about scraping data from the web to complete the automatization process. What's down the road? We are working on a round of Webinars in Brazil with our College Lucas Costa from Brasilia and.....THE ALPHATHON! Pipeline Editor As we showed in the Webinar, the pipeline editor is almost ready for production. You can create new datasets from any dataset applying transformations to the original data, and the new dataset will be automatically updated every time the original data is updated either by alphacast or by yourself. You can even create pipelines from datasets created with pipelines...